Table Detail Report

LH_CNT_IC_MED_ADMIN_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lh_Cnt_Ic_Med_Admin_Event
Definition: Stores the records of Medication administration event
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_MED_ADMIN_EVENT


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.
CATALOG_CD DOUBLE N The order catalog of the administered order
CREATE_DT_TM DATETIME Y The date and time the row is created
ENCNTR_ID DOUBLE N The encounter which the order is associated with
EVENT_ID DOUBLE N The ID of the clinical event associated to this medication admin event.
FACILITY_CD DOUBLE N The facility of the user is using to enter medication admin event
LH_CNT_IC_MED_ADMIN_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_MED_ADMIN_EVENT table.
NURSE_UNIT_CD DOUBLE N The nurse unit of the user is using to enter medication admin event
ORDER_ID DOUBLE N The ID of the order associated to this med admin event
ROUTE_CD DOUBLE N The route of the administered order
TEMPLATE_ORDER_ID DOUBLE N Order Id for the template order.
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.
VERIFICATION_DT_TM DATETIME Y The date and time the administration of the order took place



Relationship Detail - LH_CNT_IC_MED_ADMIN_EVENT


Child Column in LH_CNT_IC_MED_ADMIN_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORDER_ID ORDERS ORDER_ID
TEMPLATE_ORDER_ID ORDERS ORDER_ID


LH_CNT_IC_MICRO_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_MICRO_EVENT
Definition: This table will contain a list of microbiology events to be displayed in the LabID MDRO/CDI Report
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_MICRO_EVENT


Column Name Type Null? Definition
BODY_SITE_CD DOUBLE N Body_site_cd for the body site location of specimen collection.
CATALOG_CD DOUBLE N Cd for the microbiology/serology order.
COLLECTED_BED_CD DOUBLE N Stores code value of the bed where the sample is collected.
COLLECTED_DT_TM DATETIME Y DT_TM of the specimen collection.
COLLECTED_FAC_CD DOUBLE N Stores code value of the facility where the sample is collected.
COLLECTED_LOC_CD DOUBLE N Location_cd for the location in which the specimen was collected.
COLLECTED_ROOM_CD DOUBLE N Stores code value of the room where the sample is collected.
CREATED_DT_TM DATETIME N Stores date time when the row is created.
ENCNTR_ID DOUBLE N Encntr_id for the encounter in which the specimen was collected.
ENC_TYPE_CD DOUBLE N Encntr_type_cd of the encounter during specimen collection.
EVENT_CD DOUBLE N Cd for the associated serology event.
EVENT_ID DOUBLE N Event_ID for the microbiology event on clinical_event.
LH_CNT_IC_MICRO_EVENT_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_MICRO_EVENT table.
MDRO_CAT_ID DOUBLE N Id for the associated MDRO category on the br_mdro_cat table.
ORGANISM_CD DOUBLE N Cd for the organism associated with the micro event.
REFERRED_EVENT_ID DOUBLE N Event_id for the referred susceptibility event.
SPECIMEN_TYPE_CD DOUBLE N Specimen_type_cd for the collected specimen source.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_CNT_IC_MICRO_EVENT


Child Column in LH_CNT_IC_MICRO_EVENT(FK) Parent Table Name Parent Column Name
Parents: MDRO_CAT_ID BR_MDRO_CAT BR_MDRO_CAT_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID


LH_CNT_IC_NHSN_CODE



Column Section Top of Page


Table-level Detail

Description: LH_CNT_IC_NHSN_CODE
Definition: Lighthouse reference table for Infection Control that stores the NHSN code value information for CDA components submitted to NHSN>
Table Type: REFERENCE





Column Detail - LH_CNT_IC_NHSN_CODE


Column Name Type Null? Definition
CODE_MEANING VARCHAR(200) N The unique identifier of the NHSN commit
CODE_SYSTEM VARCHAR(200) Y The code system of the NHSN code value.
CODE_SYSTEM_NAME VARCHAR(200) Y The display name of the code system of the NHSN code value.
CODE_TXT VARCHAR(100) Y The actual NHSN code value to be used within the CDA
CODE_TYPE VARCHAR(200) Y The type of the NHSN code value.
DISPLAY_NAME VARCHAR(200) Y The display name of the NHSN code value.
LH_CNT_IC_NHSN_CODE_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_NHSN_CODE 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.


LH_CNT_IC_NHSN_TEMPLATE



Column Section Top of Page


Table-level Detail

Description: LH_CNT_IC_NHSN_TEMPLATE
Definition: Lighthouse reference table for Infection Control that stores the Template IDs of CDA components submitted to NHSN>
Table Type: REFERENCE





Column Detail - LH_CNT_IC_NHSN_TEMPLATE


Column Name Type Null? Definition
LH_CNT_IC_NHSN_TEMPLATE_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_NHSN_TEMPLATE table.
TEMPLATE_IDENT VARCHAR(200) Y The template ID to be submitted to included in the CDA being sent to NHSN.
TEMPLATE_MEANING VARCHAR(200) N The unique identifier used to identify the correct template row.
TEMPLATE_NAME VARCHAR(200) Y The name of the template being included in the CDA.
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.


LH_CNT_IC_PATIENT_DEVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_CNT_IC_PATIENT_DEVICE
Definition: This table stores information about medical devices hooked up to the patient
Table Type: ACTIVITY





Column Detail - LH_CNT_IC_PATIENT_DEVICE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
CE_DYNAMIC_LABEL_ID DOUBLE N Unique, generated primary key for ce_dynamic_label table.
DISCONTINUE_DT_TM DATETIME Y The date/time the LTD was discontinued.
ESTIMATED_DATE_IND DOUBLE N Indicator to determine if the inserted date/time is estimated or not. 0=not estimated, 1 = estimated
LH_CNT_IC_PATIENT_DEVICE_ID DOUBLE N Unique generated number that identifies a single row on the LH_CNT_IC_PATIENT_DEVICE table.
LH_CNT_IC_PATIENT_POP_ID DOUBLE N Foreign key to lh_cnt_ic_patient_pop.
LINE_DISPLAY VARCHAR(255) Y The line inserted into the patient. Ex: Artificial Airway, Chest Tube #1, Central Line IV
LINE_INSERTED_DT_TM DATETIME Y The date/time the line was inserted
LINE_TYPE_DISPLAY VARCHAR(255) Y The type of line inserted into the patient. Ex: Tunneled, over the needle
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 - LH_CNT_IC_PATIENT_DEVICE


Child Column in LH_CNT_IC_PATIENT_DEVICE(FK) Parent Table Name Parent Column Name
Parents: CE_DYNAMIC_LABEL_ID CE_DYNAMIC_LABEL CE_DYNAMIC_LABEL_ID
LH_CNT_IC_PATIENT_POP_ID LH_CNT_IC_PATIENT_POP LH_CNT_IC_PATIENT_POP_ID