Table Detail Report

LH_F_IC_ISOLATION



Column Section Top of Page


Table-level Detail

Description: LH_F_IC_ISOLATION
Definition: Infection control isolation metrics.
Table Type: ACTIVITY





Column Detail - LH_F_IC_ISOLATION


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.
BEG_DT_TM DATETIME Y The date/time on which the isolation period started for the location/type.
BEG_UTC_DT_TM DATETIME Y The date/time on which the isolation period started for the location/type.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
END_DT_TM DATETIME Y The date/time on which the isolation period ended for the location/type.
END_UTC_DT_TM DATETIME Y The date/time on which the isolation period ended for the location/type.
EXTRACT_DT_TM DATETIME Y The date/time the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
F_IC_ISOLATION_ID DOUBLE N Unique identifier for the infection control isolation metrics.
F_IC_METRICS_ID DOUBLE N Unique identifier for the infection control metrics.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
ISOLATION_TYPE_MASK DOUBLE Y The type of isolation within which the patient has been placed.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LOC_BED_CD DOUBLE N The location associated with the patient during the isolation period.
LOC_BUILDING_CD DOUBLE N The location associated with the patient during the isolation period.
LOC_FACILITY_CD DOUBLE N The location associated with the patient during the isolation period.
LOC_NURSE_UNIT_CD DOUBLE N The location associated with the patient during the isolation period.
LOC_ROOM_CD DOUBLE N The location associated with the patient during the isolation period.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.


LH_F_IC_MDRO_DTL_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_IC_MDRO_DTL_METRICS
Definition: This fact table is used to store Infection Control MDRO DTAIL Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_IC_MDRO_DTL_METRICS


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.
CAI_HAI_FLAG DOUBLE Y identify CAI or HAI
CDI_DESIGNATION_TXT VARCHAR(100) Y CDIFF Designation
COLLECT_DT_TM DATETIME Y Identifies the specimen source for the organism.
COLLECT_UTC_DT_TM DATETIME Y Identifies the specimen source for the organism; normalized to GMT.
D_BODY_SITE_ID DOUBLE N Identifies the specimen source for the organism.
D_COLL_BED_ID DOUBLE N Identifies the bed of specimen source collected for the organism.
D_COLL_BUILDING_ID DOUBLE N Identifies the building of specimen source collected for the organism.
D_COLL_FACILITY_ID DOUBLE N Identifies the facility of specimen source collected for the organism.
D_COLL_NURSE_UNIT_ID DOUBLE N Identifies the nurse unit of specimen source collected for the organism.
D_COLL_PREV_BED_ID DOUBLE N Identifies the bed location prior to the collection of the specimen source for the organism.
D_COLL_PREV_BUILDING_ID DOUBLE N Identifies the building location prior to the collection of the specimen source for the organism.
D_COLL_PREV_FACILITY_ID DOUBLE N Identifies the facility location prior to the collection of the specimen source for the organism.
D_COLL_PREV_NURSE_UNIT_ID DOUBLE N Identifies the nurse unit location prior to the collection of the specimen source for the organism.
D_COLL_PREV_ROOM_ID DOUBLE N Identifies the room location prior to the collection of the specimen source for the organism.
D_COLL_ROOM_ID DOUBLE N Identifies the room of specimen source collected for the organism.
D_ORGANISM_ID DOUBLE N Identifies the reported organism or serology
D_SOURCE_ID DOUBLE N Identifies the body site for the organism.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EVENT_ID DOUBLE N The event_id associated with the organism/serology result. From the clinical_event table.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HAI_DEVICE_LATERALITY VARCHAR(100) Y Identifies the laterality of the device.
HAI_DEVICE_LOCATION VARCHAR(100) Y Identifies the location of the device.
HAI_EVENT_ID DOUBLE N Identifies the clinical event of the HAI event
HAI_SUBTYPE VARCHAR(100) Y Identifies the specific HAI within the HAI type.
HAI_TYPE VARCHAR(50) Y Identifies the HAI type of infection (BSI, UTI, PN, SSI , MDRO CDI)
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_F_IC_MDRO_DTL_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_IC_MDRO_DTL_METRICS table.
MDRO_CAT_NAME VARCHAR(150) Y Identified the mdro category name which setting in bedrock .
MDRO_TYPE_FLAG DOUBLE Y Identifies the type of MDRO
MICRO_SEQ_NBR DOUBLE N The sequence of the microbiology result; 0 if serology.
ORGANISM_ENTITY_NAME VARCHAR(50) Y ORGANISM or SEROLOGY
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
UPDT_CNT DOUBLE Y 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 Y 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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y 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_F_IC_MDRO_DTL_METRICS


Child Column in LH_F_IC_MDRO_DTL_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_COLL_BED_ID LH_D_BED D_BED_ID
D_COLL_PREV_BED_ID LH_D_BED D_BED_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BED HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BED HEALTH_SYSTEM_SOURCE_ID
D_BODY_SITE_ID LH_D_BODY_SITE D_BODY_SITE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BODY_SITE HEALTH_SYSTEM_SOURCE_ID
D_COLL_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_COLL_PREV_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_COLL_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_COLL_PREV_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_COLL_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_COLL_PREV_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_ORGANISM_ID LH_D_ORGANISM D_ORGANISM_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ORGANISM HEALTH_SYSTEM_SOURCE_ID
D_COLL_PREV_ROOM_ID LH_D_ROOM D_ROOM_ID
D_COLL_ROOM_ID LH_D_ROOM D_ROOM_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ROOM HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ROOM HEALTH_SYSTEM_SOURCE_ID
D_SOURCE_ID LH_D_SOURCE D_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_SOURCE HEALTH_SYSTEM_SOURCE_ID


LH_F_IC_MDRO_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_IC_MDRO_METRICS
Definition: This fact table is used to store Infection Control MDRO Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_IC_MDRO_METRICS


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.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
CAI_TYPE_IND DOUBLE Y Identifies whether the encounter qualifies Community Associated Infection (CAI) Type
CDIFF_IND DOUBLE Y Identifies whether the encounter qualifies C Difficile MDRO
CD_1_IND DOUBLE Y Identifies whether the encounter qualifies client defined MDRO #1
CD_2_IND DOUBLE Y Identifies whether the encounter qualifies client defined MDRO #2
CD_3_IND DOUBLE Y Identifies whether the encounter qualifies client defined MDRO #3
CD_4_IND DOUBLE Y Identifies whether the encounter qualifies client defined MDRO #4
CD_5_IND DOUBLE Y Identifies whether the encounter qualifies client defined MDRO #5
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N The conditions under which the patient left the facility at the time of discharge.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_10_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_11_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_12_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_13_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_14_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_15_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_16_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_17_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_18_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_19_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_20_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_21_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_22_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_23_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_24_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_6_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_7_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_8_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_9_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
D_PREV_DISCH_BUILDING_ID DOUBLE N The building from which the patient was discharged from previous encounter
D_PREV_DISCH_FACILITY_ID DOUBLE N The facility from which the patient was discharged from previous encounter
D_PREV_DISCH_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged from previous encounter
D_PRIN_DIAGNOSIS_ID DOUBLE N Identifies the principle diagnosis associated with the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Identifies the principle procedure associated with the encounter.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
INPATIENT_TYPE_IND DOUBLE Y Identifies whether the encounter is inpatient.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_F_IC_MDRO_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_IC_MDRO_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MRSA_IND DOUBLE Y Identifies whether the encounter qualifies MRSA MDRO
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PREV_DISCH_DT_TM DATETIME Y The date/time on which the patient was discharged from previous encounter
PREV_DISCH_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged from previous encounter; normalized to GMT.
PREV_ENCNTR_ID DOUBLE N Identifies the patient's previous discharge encounter
PREV_INPATIENT_ENC_IND DOUBLE Y Identifies whether the previous encounter is inpatient type.
UPDT_CNT DOUBLE Y 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 Y 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_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y 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.
VRE_IND DOUBLE Y Identifies whether the encounter qualifies VRE MDRO



Relationship Detail - LH_F_IC_MDRO_METRICS


Child Column in LH_F_IC_MDRO_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_PREV_DISCH_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_PRIN_DIAGNOSIS_ID LH_D_DIAGNOSIS D_DIAGNOSIS_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DIAGNOSIS HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_PREV_DISCH_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_MED_SERVICE_ID LH_D_MED_SERVICE D_MED_SERVICE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_MED_SERVICE HEALTH_SYSTEM_SOURCE_ID
D_METRIC_10_ID LH_D_METRIC D_METRIC_ID
D_METRIC_11_ID LH_D_METRIC D_METRIC_ID
D_METRIC_12_ID LH_D_METRIC D_METRIC_ID
D_METRIC_13_ID LH_D_METRIC D_METRIC_ID
D_METRIC_14_ID LH_D_METRIC D_METRIC_ID
D_METRIC_15_ID LH_D_METRIC D_METRIC_ID
D_METRIC_16_ID LH_D_METRIC D_METRIC_ID
D_METRIC_17_ID LH_D_METRIC D_METRIC_ID
D_METRIC_18_ID LH_D_METRIC D_METRIC_ID
D_METRIC_19_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_20_ID LH_D_METRIC D_METRIC_ID
D_METRIC_21_ID LH_D_METRIC D_METRIC_ID
D_METRIC_22_ID LH_D_METRIC D_METRIC_ID
D_METRIC_23_ID LH_D_METRIC D_METRIC_ID
D_METRIC_24_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
D_METRIC_8_ID LH_D_METRIC D_METRIC_ID
D_METRIC_9_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_PREV_DISCH_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
D_PRIN_PROCEDURE_ID LH_D_PROCEDURE D_PROCEDURE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PROCEDURE HEALTH_SYSTEM_SOURCE_ID


LH_F_IC_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_IC_METRICS
Definition: Infection control metrics.
Table Type: ACTIVITY





Column Detail - LH_F_IC_METRICS


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.
ADMIT_BED_CD DOUBLE N Identifies the bed to which the patient was admitted.
ADMIT_BUILDING_CD DOUBLE N Identifies the building to which the patient was admitted.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted to the facility.
ADMIT_FACILITY_CD DOUBLE N Identifies the facility to which the patient was admitted.
ADMIT_NURSE_UNIT_CD DOUBLE N Identifies the nurse unit to which the patient was admitted.
ADMIT_ROOM_CD DOUBLE N Identifies the room to which the patient was admitted.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted to the facility.
ARRIVAL_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
ARRIVAL_UTC_DT_TM DATETIME Y The date/time on which the patient arrived at the facility.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged from the facility.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged from the facility.
DISC_BED_CD DOUBLE N Identifies the bed from which the patient was discharged.
DISC_BUILDING_CD DOUBLE N Identifies the building from which the patient was discharged.
DISC_FACILITY_CD DOUBLE N Identifies the facility from which the patient was discharged.
DISC_NURSE_UNIT_CD DOUBLE N Identifies the nurse unit from which the patient was discharged.
DISC_ROOM_CD DOUBLE N Identifies the room from which the patient was discharged.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
ENCNTR_TYPE_FLAG DOUBLE Y The type of encounter: 1=Inpatient, 2=Outpatient
EXTRACT_DT_TM DATETIME Y The date/time the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) N Identifies the financial number of the patient.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
F_IC_METRICS_ID DOUBLE N Unique identifier for the infection control metrics.
HAI_BSI_CL_CNT DOUBLE Y Identifies the number of central line related bloodstream infections.
HAI_BSI_CNT DOUBLE Y Identifies the number of bloodstream infections for the patient.
HAI_BSI_LAB_CNT DOUBLE Y Identifies the number of lab confirmed blood stream infections.
HAI_BSI_SEP_CNT DOUBLE Y Identifies the number of sepsis related bloodstream infections.
HAI_ON_ADMIT_IND DOUBLE Y Identifies if the patient had a hospital associated infection on admission.
HAI_PN_ASP_CNT DOUBLE Y Identifies the number of aspiration pneumonia infections.
HAI_PN_CNT DOUBLE Y Identifies the number of pneumonia infections for the patient.
HAI_PN_HAP_CNT DOUBLE Y Identifies the number of hospital associated pneumonia infections.
HAI_PN_PROC_CNT DOUBLE Y Identifies the number of procedure related pneumonia infections.
HAI_PN_VAP_CNT DOUBLE Y Identifies the number of ventilator associated pneumonia infections.
HAI_SSI_CNT DOUBLE Y Identifies the number of surgical site infections.
HAI_SSI_DIP_CNT DOUBLE Y Identifies the number of deep incision primary infections.
HAI_SSI_DIS_CNT DOUBLE Y Identifies the number of deep incision secondary infections.
HAI_SSI_ORGAN_CNT DOUBLE Y Identifies the number of organ/space infections.
HAI_SSI_SIP_CNT DOUBLE Y Identifies the number of superficial incision primary infections.
HAI_SSI_SIS_CNT DOUBLE Y Identifies the number of superficial incision secondary infections.
HAI_UTI_ASYMP_CNT DOUBLE Y Identifies the number of asymptomatic urinary tract infections.
HAI_UTI_CATH_CNT DOUBLE Y Identifies the number of catheter related urinary tract infections.
HAI_UTI_CNT DOUBLE Y Identifies the number of urinary tract infections for the patient.
HAI_UTI_OTHER_CNT DOUBLE Y Identifies the number of other urinary tract infections.
HAI_UTI_SYMP_CNT DOUBLE Y Identifies the number of symptomatic urinary tract infections.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
ISOLATION_IND DOUBLE Y Identifies if the patient was in isolation during their visit.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
ORGANISM_IND DOUBLE Y Identifies if the patient is to be included in the organism summary.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PERSON_ID DOUBLE N Identifiers the person against which the quality measure is associated.
REPORTABLE_CONDITION_IND DOUBLE Y Identifies if the patient had a reportable condition.
TB_COLLECT_BED_CD DOUBLE N Identifies the location of the patient when the TB specimen was collected.
TB_COLLECT_BUILDING_CD DOUBLE N Identifies the location of the patient when the TB specimen was collected.
TB_COLLECT_DT_TM DATETIME Y Identifies the date/time on which the tb specimen was collected.
TB_COLLECT_FACILITY_CD DOUBLE N Identifies the location of the patient when the TB specimen was collected.
TB_COLLECT_NURSE_UNIT_CD DOUBLE N Identifies the location of the patient when the TB specimen was collected.
TB_COLLECT_ROOM_CD DOUBLE N Identifies the location of the patient when the TB specimen was collected.
TB_COLLECT_UTC_DT_TM DATETIME Y Identifies the date/time on which the tb specimen was collected.
TB_EVENT_ID DOUBLE N Identifies the clinical event record associated with the TB result.
TB_FLAG DOUBLE Y Identifies if the patient had a positive result for TB.
TB_RESULT_DT_TM DATETIME Y Identifies the date/time of the positive result.
TB_RESULT_UTC_DT_TM DATETIME Y Identifies the date/time of the positive result.
TB_SPECIMEN_SOURCE_CD DOUBLE N Identifies the code value associated with the tb specimen source.
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 Y 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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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_F_IC_METRICS


Child Column in LH_F_IC_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID


LH_F_IC_ORG_SMRY



Column Section Top of Page


Table-level Detail

Description: LH_F_IC_ORG_SMRY
Definition: Infection control organism summary metrics.
Table Type: ACTIVITY





Column Detail - LH_F_IC_ORG_SMRY


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.
BODY_SITE_CD DOUBLE N The body site associated with the organism.
CAI_IND DOUBLE Y Community Associated Infection Indicator
CDI_DESIGNATION_FLAG DOUBLE Y The CDI Designation: 1=Recurrent, 2=Indeterminate, 3=CO-HC Facility Associated, 4=HO-HC Facility Associated, 5=Community Associated
COLLECT_BED_CD DOUBLE N The location of the patient at the time that the specimen was collected.
COLLECT_BUILDING_CD DOUBLE N The location of the patient at the time that the specimen was collected.
COLLECT_DT_TM DATETIME Y The date/time on which the specimen was collected.
COLLECT_FACILITY_CD DOUBLE N The location of the patient at the time that the specimen was collected.
COLLECT_NURSE_UNIT_CD DOUBLE N The location of the patient at the time that the specimen was collected.
COLLECT_PREV_BED_CD DOUBLE N The location of the patient just prior to the time that the specimen was collected.
COLLECT_PREV_BUILDING_CD DOUBLE N The location of the patient just prior to the time that the specimen was collected.
COLLECT_PREV_FACILITY_CD DOUBLE N The location of the patient just prior to the time that the specimen was collected.
COLLECT_PREV_NURSE_UNIT_CD DOUBLE N The location of the patient just prior to the time that the specimen was collected.
COLLECT_PREV_ROOM_CD DOUBLE N The location of the patient just prior to the time that the specimen was collected.
COLLECT_ROOM_CD DOUBLE N The location of the patient at the time that the specimen was collected.
COLLECT_UTC_DT_TM DATETIME Y The date/time on which the specimen was collected.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
EVENT_ID DOUBLE N The event identifier associated with the organism. From the clinical_event table.
EXTRACT_DT_TM DATETIME Y The date/time the record was extracted from the source system.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
F_IC_METRICS_ID DOUBLE N Unique identifier for the infection control metrics.
F_IC_ORG_SMRY_ID DOUBLE N Unique identifier for the infection control organism summary metrics.
HAI_IND DOUBLE Y Healthcare Associated Infection Indicator
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
MDRO_TYPE_FLAG DOUBLE Y The type of MDRO: 0=Non MDRO, 1=MDRO, 2=MRSA, 3=VRE, 4=CDIFF, 5=Other
MICRO_SEQ_NBR DOUBLE N The microbiology sequence number associated with the organism.
ORGANISM_CNT DOUBLE Y Identifies the number of organisms.
ORGANISM_ENTITY_ID DOUBLE N The unique identifier associated with the organism.
ORGANISM_ENTITY_NAME VARCHAR(50) Y Identifies whether the organism is part of a Serology or not.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
SPECIMEN_SOURCE_CD DOUBLE N The specimen source associated with the organism.
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_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) 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.