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