Table Detail Report
FN_OMF_ENCNTR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | FirstNet OMF Encounter information |
Definition: | Contains basic patient information from FirstNet tracking tables. PowerVision subject areas can be built against the table |
Table Type: | ACTIVITY |
Column Detail - FN_OMF_ENCNTR
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. |
ARRIVE_REQ_EVT_DT_TM | DATETIME | Y | Arrival request event date and time from tracking_event |
ARRIVE_REQ_EVT_OMF_DT | DOUBLE | Y | Date portion of arrival event request date/time. Allows joining to OMF_DATE |
ARRIVE_REQ_EVT_OMF_TM | DOUBLE | Y | Time portion of arrival event request date/time. Allows joining to OMF_TIME |
BED_ASSIGN_COMP_EVT_DT_TM | DATETIME | Y | Bed assign event complete date and time from tracking_event |
BED_ASSIGN_COMP_EVT_OMF_DT | DOUBLE | Y | Date portion of bed assign event complete date/time. Allows joining to OMF_DATE |
BED_ASSIGN_COMP_EVT_OMF_TM | DOUBLE | Y | Time portion of bed assign event complete date/time. Allows joining to OMF_TIME |
CHECKIN_ACUITY_ID | DOUBLE | N | Foreign key to TRACK_REFERENCEColumn |
CHECKIN_DT_TM | DATETIME | Y | Date and time of patient checkin to ED |
CHECKIN_OMF_DT | DOUBLE | Y | Allows join to OMF_DATE |
CHECKIN_OMF_TM | DOUBLE | Y | Allows join to OMF_TIME |
CHECKOUT_ACUITY_ID | DOUBLE | N | Foreign key to TRACK_REFERENCEColumn |
CHECKOUT_DT_TM | DATETIME | Y | Date and time of patient checkout of ED |
CHECKOUT_OMF_DT | DOUBLE | Y | Allows join to OMF_DATE |
CHECKOUT_OMF_TM | DOUBLE | Y | Allows join to OMF_TIME |
DISCH_DIAG | VARCHAR(250) | Y | Diagnosis of patient at discharge |
DISPO_COMP_EVT_DT_TM | DATETIME | Y | Date and time of Disposition event complete |
DISPO_COMP_EVT_OMF_DT | DOUBLE | Y | Allows join to OMF_DATE |
DISPO_COMP_EVT_OMF_TM | DOUBLE | Y | Allows joining to OMF_TIME |
DISPO_REQ_EVT_DT_TM | DATETIME | Y | Date and time of disposition event request |
DISPO_REQ_EVT_OMF_DT | DOUBLE | Y | Allows joining to OMF_DATE |
DISPO_REQ_EVT_OMF_TM | DOUBLE | Y | Allows joining to OMF_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. |
FN_OMF_ENCNTR_ID | DOUBLE | N | Unique FirstNet OMF Encounter identifierColumn |
LOC_AMBULATORY_UNIT_CD | DOUBLE | N | Ambulatory location of patient |
LOC_BED_CD | DOUBLE | N | Bed location |
LOC_BED_GRP | DOUBLE | Y | Group number for bed location |
LOC_BUILDING_CD | DOUBLE | N | Building location of patient |
LOC_FACILITY_CD | DOUBLE | N | facility location of patient |
LOC_NURSE_UNIT_CD | DOUBLE | N | Nurse unit location of patient |
LOC_NURSE_UNIT_GRP | DOUBLE | Y | Nurse unit location group allows grouping of nurse units. |
LOC_ROOM_CD | DOUBLE | N | Room location of patient |
LOC_ROOM_GRP | DOUBLE | Y | Room location groupColumn |
MD_ASSESS_START_EVT_DT_TM | DATETIME | Y | Start date and time of doctor assessment event |
MD_ASSESS_START_EVT_OMF_DT | DOUBLE | Y | Allows joining to OMF_DATE |
MD_ASSESS_START_EVT_OMF_TM | DOUBLE | Y | Allows joining to OMF_TIME |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PRIMARY_CARE_PHYSICIAN_ID | DOUBLE | N | Person ID of patient's primary care physician |
PRIMARY_DOC_ID | DOUBLE | N | Patient's primary ED doctor's person ID |
PRIMARY_NURSE_ID | DOUBLE | N | Patient's primary nurse |
REG_COMP_EVT_DT_TM | DATETIME | Y | Registration event complete date/time from tracking_event table |
REG_COMP_EVT_OMF_DT | DOUBLE | Y | Allows joining to OMF_DATE |
REG_COMP_EVT_OMF_TM | DOUBLE | Y | Allows joining to OMF_TIME |
RN_ASSESS_START_EVT_DT_TM | DATETIME | Y | Nurse assessment event start date/time from tracking_event table |
RN_ASSESS_START_EVT_OMF_DT | DOUBLE | Y | Allows joining to OMF_DATE |
RN_ASSESS_START_EVT_OMF_TM | DOUBLE | Y | Allows joining to OMF_TIME |
SECONDARY_DOC_ID | DOUBLE | N | Patient's secondary ED doctor's person ID |
SECONDARY_NURSE_ID | DOUBLE | N | Patient's secondary ED nurse's person ID |
SPECIALTY_ID | DOUBLE | N | Patient categorization based on complaint or diagnosis |
TRACKING_GROUP_CD | DOUBLE | N | Tracking Group Code used to identify which tracking group this patient is currently checked into. |
TRACKING_ID | DOUBLE | N | Tracking IdentifierColumn |
TRIAGE_COMP_EVT_DT_TM | DATETIME | Y | Triage event complete date/time from tracking_event table. |
TRIAGE_COMP_EVT_OMF_DT | DOUBLE | Y | Allows joining to OMF_DATE |
TRIAGE_COMP_EVT_OMF_TM | DOUBLE | Y | Allows join to OMF_TIME |
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 - FN_OMF_ENCNTR
Child Column in FN_OMF_ENCNTR(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID | |
PRIMARY_CARE_PHYSICIAN_ID | PRSNL | PERSON_ID | |
PRIMARY_DOC_ID | PRSNL | PERSON_ID | |
PRIMARY_NURSE_ID | PRSNL | PERSON_ID | |
SECONDARY_DOC_ID | PRSNL | PERSON_ID | |
SECONDARY_NURSE_ID | PRSNL | PERSON_ID | |
TRACKING_ID | TRACKING_ITEM | TRACKING_ID | |
CHECKIN_ACUITY_ID | TRACK_REFERENCE | TRACKING_REF_ID | |
CHECKOUT_ACUITY_ID | TRACK_REFERENCE | TRACKING_REF_ID | |
SPECIALTY_ID | TRACK_REFERENCE | TRACKING_REF_ID |
MRU_FACT_COLLECTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Most Recently Used Fact Collection |
Definition: | A list of up to five separate MRU facts from code set 20325 segregated by MRU Area. |
Table Type: | REFERENCE |
Column Detail - MRU_FACT_COLLECTION
Column Name | Type | Null? | Definition |
---|---|---|---|
MRU_AREA_CD | DOUBLE | N | Mru area this fact collection is associated to |
MRU_FACT1_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT2_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT3_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT4_CD | DOUBLE | N | Names and meanings of data items used in MRU Selections |
MRU_FACT_COLLECTION_ID | DOUBLE | N | Primary key 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 - MRU_FACT_COLLECTION
Parent Column in MRU_FACT_COLLECTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | MRU_FACT_COLLECTION_ID | MRU_PRIMARY_FACT_EXTENSION | MRU_FACT_COLLECTION_ID |
MRU_LOOKUP_ED_DOC
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MRU Lookup Education Document |
Definition: | Provides the MRU framework a unique version independent identification for patient education instructions. |
Table Type: | REFERENCE |
Column Detail - MRU_LOOKUP_ED_DOC
Column Name | Type | Null? | Definition |
---|---|---|---|
CONTENT_SUPPLIER_CD | DOUBLE | N | Indicates the content supplier to resolve cross vendor duplicates of key_doc_id. |
MRU_LOOKUP_ED_DOC_ID | DOUBLE | N | Primary Key |
PAT_ED_RELTN_ID | DOUBLE | N | Patient Education instruction id. Only set if this references a custom instruction in which case content_suplier_cd is CUSTOM. |
SUPPLIER_KEY_ID_VALUE | DOUBLE | N | Number representing the supplier key 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 - MRU_LOOKUP_ED_DOC
Child Column in MRU_LOOKUP_ED_DOC(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PAT_ED_RELTN_ID | PAT_ED_RELTN | PAT_ED_RELTN_ID |
MRU_LOOKUP_FOLLOWUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MRU Lookup Follow-up |
Definition: | Provides the MRU framework with a unique identifier for follow-up visits. |
Table Type: | REFERENCE |
Column Detail - MRU_LOOKUP_FOLLOWUP
Column Name | Type | Null? | Definition |
---|---|---|---|
ADDRESS_ID | DOUBLE | N | %followup% |
CODED_FOLLOWUP_INTERVAL_CD | DOUBLE | N | Code value of a coded range for the follow-up time |
FOLLOWUP_DT_TM | DATETIME | Y | Date offset till the follow-up date |
FOLLOWUP_INTERVAL | DOUBLE | N | Numeric offset till the follow-up (within) date. |
FOLLOWUP_INTERVAL_UNITS_FLAG | DOUBLE | N | Indicates the units for the follow-up interval (0 for days, 1 for weeks). |
FOLLOWUP_TYPE_CD | DOUBLE | N | Indicates the follow-up type (clinic, provider, specialty). |
MRU_LOOKUP_FOLLOWUP_ID | DOUBLE | N | Primary Key |
PARENT_ENTITY_ID | DOUBLE | N | ID of a parent entity value |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Name of the parent entity for which data represents |
PHONE_ID | DOUBLE | N | %followup% |
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 - MRU_LOOKUP_FOLLOWUP
Child Column in MRU_LOOKUP_FOLLOWUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ADDRESS_ID | ADDRESS | ADDRESS_ID |
PHONE_ID | PHONE | PHONE_ID |
MRU_LOOKUP_ORDER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MRU Lookup Order |
Definition: | Provides the MRU framework a unique identifier for order catalog data |
Table Type: | REFERENCE |
Column Detail - MRU_LOOKUP_ORDER
Column Name | Type | Null? | Definition |
---|---|---|---|
MRU_LOOKUP_ORDER_ID | DOUBLE | N | Primary Key |
ORDER_SENTENCE_ID | DOUBLE | N | Order Sentence Id from ORDER_SENTENCE |
ORD_AS_FLAG | DOUBLE | N | Order Origination Flag (Normal, Prescription, etc.)0 |
SYNONYM_ID | DOUBLE | N | from Order Catalog Synonym table |
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 - MRU_LOOKUP_ORDER
Child Column in MRU_LOOKUP_ORDER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
ORDER_SENTENCE_ID | ORDER_SENTENCE | ORDER_SENTENCE_ID |