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