OMF_ABSTRACT_DATA_ST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Stores abstract data relating to an encounter. |
Definition: | Stores abstract data relating to an encounter. Currently supports ProFile's abstract data. |
Table Type: | ACTIVITY |
Column Detail - OMF_ABSTRACT_DATA_ST
Column Name | Type | Null? | Definition |
---|---|---|---|
ABSTRACT_DATA_ID | DOUBLE | N | The unique identification number for the value of an abstract data element. |
ABSTRACT_DEF_CD | DOUBLE | N | The unique identifier for an abstract data element. |
ABSTRACT_FIELD_TYPE_CD | DOUBLE | N | Defines the data type of the abstract data element. |
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
BEG_EFFECTIVE_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
END_EFFECTIVE_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
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. |
VALUE_CD | DOUBLE | N | The code value that corresponds to the abstract data element (if the data type is codeset). Since it is abstract data, it can come from any code set. |
VALUE_DT_TM | DATETIME | Y | The date/time that corresponds to the abstract data element (if the data type is DATE). |
VALUE_FREE_TEXT | VARCHAR(255) | Y | The character string that corresponds to the abstract data element (if the data type is free text). |
VALUE_NUMBER | DOUBLE | Y | The number that corresponds to the abstract data element (if the data type is number or Boolean). |
VALUE_TZ | DOUBLE | Y | Time zone associated with the corresponding DT_TM column. |
Relationship Detail - OMF_ABSTRACT_DATA_ST
Child Column in OMF_ABSTRACT_DATA_ST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID |
OMF_ABSTRACT_DEF
Column Section | Top of Page |
Table-level Detail
Description: | Stores abstract data element definitions. |
Definition: | Stores abstract data element definitions. Currently supports ProFile's abstract data. |
Table Type: | REFERENCE |
Column Detail - OMF_ABSTRACT_DEF
Column Name | Type | Null? | Definition |
---|---|---|---|
ABSTRACT_DEF_CD | DOUBLE | N | The unique identifier for an abstract data element. |
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | The contributing source system for the abstract data element. |
INDICATOR_CD | DOUBLE | N | The PowerVision indicator defined for viewing of the abstract data element. |
OMF_FACT_IND | DOUBLE | Y | Defines whether the indicator is a dimension (0) or fact (1). |
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_ABSTRACT_SOURCE
Column Section | Top of Page |
Table-level Detail
Description: | OMF ABSTRACT SOURCE |
Definition: | Stores the contributor information for the abstract data. |
Table Type: | REFERENCE |
Column Detail - OMF_ABSTRACT_SOURCE
Column Name | Type | Null? | Definition |
---|---|---|---|
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | The contributing source system for the abstract data element. |
SOURCE_BEG_EFFECTIVE_COLUMN | VARCHAR(50) | Y | The ccl statement that defines the beginning effective date for the where clause used in the PowerVision view. |
SOURCE_CD_COLUMN | VARCHAR(50) | Y | The ccl statement that defines the group by column used in the select stmt for the PowerVision view. |
SOURCE_DISPLAY_COLUMN | VARCHAR(50) | Y | The ccl statement that defines the display column for the select stmt used in the PowerVision view. |
SOURCE_END_EFFECTIVE_COLUMN | VARCHAR(50) | Y | The ccl statement that defines the end effective date for the where clause used in the PowerVision view. |
SOURCE_TABLE | VARCHAR(50) | Y | The ccl statement that defines the from clause for the select stmt used in the PowerVision view. |
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_ABSTRACT_VIEW
Column Section | Top of Page |
Table-level Detail
Description: | OMF ABSTRACT VIEW |
Definition: | Stores the PowerVision views that contain abstract data. |
Table Type: | REFERENCE |
Column Detail - OMF_ABSTRACT_VIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
CONTRIBUTOR_SOURCE_CD | DOUBLE | N | The contributing source system for the abstract data element |
STR_SEQ | DOUBLE | Y | The sequence that applies to the from/where clause in omf_pv_view. |
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. |
VIEW_CD | DOUBLE | N | The corresponding PowerVision view in which abstract data is available for reporting. |
OMF_ABST_CODING_RELTN_ST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OMF ABST CODING RELTN ST |
Definition: | Stores coded data linked to abstract data from ProFile. |
Table Type: | ACTIVITY |
Column Detail - OMF_ABST_CODING_RELTN_ST
Column Name | Type | Null? | Definition |
---|---|---|---|
ABSTRACT_DEF_CD | DOUBLE | N | The unique identifier to the omf_abstract_def table. |
ABST_CODING_RELTN_ID | DOUBLE | N | The unique identifier for the omf_abst_coding_reltn_st |
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
NOMENCLATURE_ID | DOUBLE | N | The unique identifier to the nomenclature table. |
PARENT_ENTITY_ID | DOUBLE | N | The unique identifier for the diagnosis/nomenclature/drg. |
PARENT_ENTITY_NAME | VARCHAR(255) | Y | The table name associated with the parent_entity_id |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
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_ABST_CODING_RELTN_ST
Child Column in OMF_ABST_CODING_RELTN_ST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID |