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. |