Table Detail Report

OMF_ENCNTR_ST_EXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Extenstion to the omf_encntr_st.
Definition: omf_encntr_st_ext
Table Type: ACTIVITY





Column Detail - OMF_ENCNTR_ST_EXT


Column Name Type Null? Definition
ADMIT_72H_LADMIT_IND DOUBLE Y Indicates whether or not the patient has been readmitted w/in 72 hours of a previous visit.
ADMIT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
BIRTH_DT_NBR DOUBLE Y The Julian date of the date on which the patient was born
BIRTH_MIN_NBR DOUBLE Y The minute of the date on which the patient was born
BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
CURR_PAT_LOC_ARRIVE_DT_NBR DOUBLE Y The Julian date of the date/time at which the patient arrived at the nurse unit
CURR_PAT_LOC_ARRIVE_MIN_NBR DOUBLE Y The minute of the date/time at which the patient arrived at the nurse unit.
CURR_PAT_LOC_ARRIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DAYS_NEXT_ED_VISIT DOUBLE Y The number of days to the next ER visit.
DEATH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
DISCH_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.
EXP_PM_DISCH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
ICD9_PRIN_PROC_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
LAST_IP_DISCH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
OTHER_INS_BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
OTHER_INS_BIRTH_DT_NBR DOUBLE Y The Julian date of the other health plan subscriber's birth date/time.
OTHER_INS_BIRTH_MIN_NBR DOUBLE Y The minute of the other health plan subscriber's birth date/time.
OTHER_INS_BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
OTHER_INS_END_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PRIM_INS_BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PRIM_INS_BIRTH_DT_NBR DOUBLE Y The Julian date of the primary health plan subscriber's birth date/time.
PRIM_INS_BIRTH_MIN_NBR DOUBLE Y The minute of the date of the primary health plan subscriber's birth date/time.
PRIM_INS_BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
PRIM_INS_END_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RETURN_ED_GT_72H_IND DOUBLE Y Indicates whether or not the patient returned to the ER in greater than 72 hours of a previous visit.
SEC_INS_BEG_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SEC_INS_BIRTH_DT_NBR DOUBLE Y The Julian date of the secondary health plan subscriber's birth date/time.
SEC_INS_BIRTH_MIN_NBR DOUBLE Y The minute of the date of the secondary health plan subscriber's birth date/time.
SEC_INS_BIRTH_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
SEC_INS_END_EFFECTIVE_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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.
VISIT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.



Relationship Detail - OMF_ENCNTR_ST_EXT


Child Column in OMF_ENCNTR_ST_EXT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ENCNTR_ID OMF_ENCNTR_ST ENCNTR_ID


OMF_ENCNTR_TYPE_HIST_ST



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF ENCNTR TYPE HIST ST
Definition: Stores the encounter type history by encounter.
Table Type: ACTIVITY





Column Detail - OMF_ENCNTR_TYPE_HIST_ST


Column Name Type Null? Definition
BEG_TRANSACTION_DT_NBR DOUBLE Y The Julian date number for the date that the person was changed to this encounter type.
BEG_TRANSACTION_DT_TM DATETIME Y The date/time on which the person was changed to this encounter type.
BEG_TRANSACTION_MIN_NBR DOUBLE Y The minute of the day that the person was changed to this encounter type.
BEG_TRANSACTION_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.
ENCNTR_LOC_HIST_ID DOUBLE N This is the value of the unique primary identifier of the encounter location history table. It is an internal system assigned number.
ENCNTR_TYPE_CD DOUBLE N The code value for the encounter type.
ENCNTR_TYPE_CLASS_CD DOUBLE N The encounter type grouping.
END_TRANSACTION_DT_NBR DOUBLE Y The Julian date for the date on which the person's encounter type was changed from this encounter type.
END_TRANSACTION_DT_TM DATETIME Y The date/time on which the person's encounter type was changed from this encounter type.
END_TRANSACTION_MIN_NBR DOUBLE Y The minute of the day at which the person's encounter type was changed from this encounter type.
END_TRANSACTION_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
NBR_BED_DAYS DOUBLE Y The number of bed days for a person by encounter type.
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_ENCNTR_TYPE_HIST_ST


Child Column in OMF_ENCNTR_TYPE_HIST_ST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


OMF_EXTRACT_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: OMF Extract Batch
Definition: Contains records that are currently being updated or inserted into the Care Profiling data repository.
Table Type: ACTIVITY





Column Detail - OMF_EXTRACT_BATCH


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.
ADDL_PARENT_ENTITY_ID DOUBLE Y Optional additional ID required to lookup data for repository insert/update
ADDL_PARENT_ENTITY_NAME VARCHAR(30) Y Optional additional item type that is referenced by ADDL_PARENT_ENTITY_ID (ORDER, ENCOUNTER, PERSON, CLINICAL_EVENT, CHARGE)
EXTRACT_TYPE_CD DOUBLE N The extract that is referenced by this row
OMF_EXTRACT_BATCH_ID DOUBLE N Unique, generated number that identifies a single row on the OMF_EXTRACT_BATCH table.
PARENT_ENTITY_ID DOUBLE N ID value for the item being updtated in the Care Profiling repository
PARENT_ENTITY_NAME VARCHAR(30) N The item type that is referenced by PARENT_ENTITY_ID (ORDER, ENCOUNTER, CLINICAL_EVENT, CHARGE)
PROCESS_FLAG DOUBLE N Describes the processing status of the item referenced by PARENT_ENTITY_ID.
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_EXTRACT_BATCH


Child Column in OMF_EXTRACT_BATCH(FK) Parent Table Name Parent Column Name
Parents: EXTRACT_TYPE_CD OMF_EXTRACT_TYPE EXTRACT_TYPE_CD


OMF_EXTRACT_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains the feeds for Care Profiling and the active status.
Definition: Contains the feeds for Care Profiling and the active status. The default is inactive; the feeds must be turned on by the project team when Care Profiling is installed.
Table Type: REFERENCE





Column Detail - OMF_EXTRACT_TYPE


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.
EXTRACT_TYPE_CD DOUBLE N The type of extract script referenced by this row.
LAST_EXTRACT_DT_TM DATETIME Y The last time a batch extract was completed for the extract referenced by EXTRACT_TYPE_CD
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_EXTRACT_TYPE




Parent Column in OMF_EXTRACT_TYPE (PK) Child Table Name Child Column Name
Children: EXTRACT_TYPE_CD OMF_EXTRACT_BATCH EXTRACT_TYPE_CD


OMF_FISCAL_DATE



Column Section Top of Page


Table-level Detail

Description: Contains the fiscal date data from the OMF general ledger interface.
Definition: omf_fiscal_date
Table Type: ACTIVITY





Column Detail - OMF_FISCAL_DATE


Column Name Type Null? Definition
FISCAL_PERIOD VARCHAR(2) Y The fiscal period on which the transaction occurred.
FISCAL_QUARTER VARCHAR(1) Y The fiscal quarter within which the transaction occurred.
FISCAL_YEAR VARCHAR(4) Y The fiscal year within which the transaction occurred.
FISCAL_YEAR_PERIOD VARCHAR(7) Y The year/period in which the transaction occurred.
FISCAL_YEAR_QUARTER VARCHAR(7) Y The fiscal year/qtr in which the transaction occurred.
OMF_FISCAL_DATE_ID DOUBLE N The unique identifier for the omf_fiscal_date table.
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.