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 |