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