Table Detail Report

OMF_CFGRN_ITEM_SETNG



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Configuration Item Setting
Definition: Current option setting for each configuration item.
Table Type: REFERENCE





Column Detail - OMF_CFGRN_ITEM_SETNG


Column Name Type Null? Definition
CFGRN_ITEM_ID DOUBLE N The unique identifier for the configuration item.
CFGRN_ITEM_SETNG_ID DOUBLE N The system assigned unique identifier for the item setting.
CUR_ITEM_VALUE_TXT VARCHAR(255) N The current option value.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - OMF_CFGRN_ITEM_SETNG


Child Column in OMF_CFGRN_ITEM_SETNG(FK) Parent Table Name Parent Column Name
Parents: CFGRN_ITEM_ID OMF_CFGRN_ITEM CFGRN_ITEM_ID


OMF_CFGRN_SECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Configuration Section
Definition: The sections associated with items used to drive dynamic configuration/preference settings.
Table Type: REFERENCE





Column Detail - OMF_CFGRN_SECT


Column Name Type Null? Definition
CFGRN_DOMN_ID DOUBLE N The section's associated domain.
CFGRN_SECT_ID DOUBLE N The system assigned unique value for the section.
SECT_DESC_TXT VARCHAR(255) N The description of the section that will be displayed in the application.
SECT_NAME_TXT VARCHAR(255) N The unique description of the section.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - OMF_CFGRN_SECT


Child Column in OMF_CFGRN_SECT(FK) Parent Table Name Parent Column Name
Parents: CFGRN_DOMN_ID OMF_CFGRN_DOMN CFGRN_DOMN_ID




Parent Column in OMF_CFGRN_SECT (PK) Child Table Name Child Column Name
Children: CFGRN_SECT_ID OMF_CFGRN_ITEM CFGRN_SECT_ID


OMF_COMP_FACT



Column Section Top of Page


Table-level Detail

Description: OMF COMP FACT
Definition: Comparison facts used by PowerVision.
Table Type: ACTIVITY





Column Detail - OMF_COMP_FACT


Column Name Type Null? Definition
CF_INDICATOR_CD DOUBLE N Indicator_cd for the fact from the saved view being referred to. This can come from a number of code sets depending on the team developing the subject area - e.g. 14265.
CF_OMF_PV_ITEM_ID DOUBLE N ID in omf_pv_items of the saved view being referred to.
CF_SEQ1 DOUBLE Y Not currently used. Will be used if TAT comparison facts are allowed in PowerVision
CF_SEQ2 DOUBLE Y Not currently used. Will be used if TAT comparison facts are allowed in PowerVision
GRID_CD DOUBLE N Subject area which this comparison fact is displayed in. The subject area of the saved view which displays this as a comparison fact not the saved view in cf_omf_pv_item_id. Code set 14265 is sometimes used but will vary by which Cerner team created the subject area.
INDICATOR_CD DOUBLE N Comparison fact indicator. Code set 14265 is sometimes used but will vary by which Cerner team created the subject area.
NAME VARCHAR(50) Y Display name of the comparison fact.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
USER_ID DOUBLE N Users person_id who created the comparison fact.


OMF_EVENTS



Column Section Top of Page


Table-level Detail

Description: OMF EVENTS
Definition: List of events such as 'Order', 'Requested Collection', 'In Transit', 'In Lab'.
Table Type: REFERENCE





Column Detail - OMF_EVENTS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTUAL_TAT_STR VARCHAR(255) Y The request structure member that stores the actual TAT.
DESCRIPTION VARCHAR(80) Y Event description.
DETAIL_IND DOUBLE Y Indicates whether the clinical event is at the order or detail level. 0 = order level; 1 = detail level
EVENT_NUM DOUBLE N Unique id of event.
EVENT_SEQ DOUBLE Y Event order of occurrence.
EXP_TAT_STR VARCHAR(255) Y The request structure member that stores the actual TAT.
MONITOR_IND DOUBLE Y Not used.
PRODUCT_CD DOUBLE N Code value that identifies the type of transaction being processed.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


OMF_EXPAND_TYPE



Column Section Top of Page


Table-level Detail

Description: PowerVision info for allowing functions like max, min, etc. to be applied.
Definition: PowerVision info for allowing functions like max, min, etc. to be applied generically to facts.
Table Type: REFERENCE





Column Detail - OMF_EXPAND_TYPE


Column Name Type Null? Definition
DISPLAY VARCHAR(255) Y Name to display in Template list and to modify for column name - e.g. Maximum - changes display to Maximum of Revenue
GROUPBYSTR VARCHAR(255) Y Group by str used for DATE properties.
NAME VARCHAR(255) N Unique name for this expansion type.
STR VARCHAR(255) Y String to use replace on :IND: on. Will look like "avg(:IND:)".
TYPE VARCHAR(50) Y Type of expansions - e.g. Statistical, Date, etc.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.