Table Detail Report

LH_F_IC_ANTIBGRM_DTL



Column Section Top of Page


Table-level Detail

Description: LH_F_IC_ANTIBGRM_DTL
Definition: This fact table is used to store Infection Control Antibiogram Dtail Lighthouse Report.
Table Type: ACTIVITY





Column Detail - LH_F_IC_ANTIBGRM_DTL


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.
D_ANTIBIOTIC_ID DOUBLE N Identifies the antibiotic for microbiology susceptibility results
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.
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.
INTERPRETATION_RESULT VARCHAR(10) Y Identifies susceptibility interpretation of the particular antibiotic. (S, I, R..etc.)
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_F_IC_ANTIBGRM_DTL_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_IC_ANTIBGRM_DTL table.
LH_F_IC_ANTIBGRM_METRICS_ID DOUBLE N Unique identifier for the infection control antibiogram master.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
RESULT_DT_TM DATETIME Y The date and time of the results
RESULT_UTC_DT_TM DATETIME Y The date and time of the results; normalized to GMT.
SUSCEP_SEQ_NBR DOUBLE Y The sequence of the susceptibility results
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.


LH_F_IC_ANTIBGRM_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_F_IC_ANTIBGRM_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.
COLLECT_DT_TM DATETIME Y Date and time of the specimen source collected for the organism
COLLECT_UTC_DT_TM DATETIME Y Date and time of the specimen source collected for the organism; normalized to GMT.
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_COLL_BUILDING_ID DOUBLE N Identifies the building of specimen source collected for the organism.
D_COLL_ENCNTR_TYPE_ID DOUBLE N Identifies the encounter type 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_ORGANISM_ID DOUBLE N Identifies the reported organism
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
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 (from clinical_event) associated with the organism result.
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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_F_IC_ANTIBGRM_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_IC_ANTIBGRM_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.
MICRO_SEQ_NBR DOUBLE Y The sequence of the microbiology result; 0 if serology.
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
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_ANTIBGRM_METRICS


Child Column in LH_F_IC_ANTIBGRM_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_COLL_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_COLL_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_COLL_FACILITY_ID LH_D_FACILITY D_FACILITY_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
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_SOURCE_ID LH_D_SOURCE D_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_SOURCE HEALTH_SYSTEM_SOURCE_ID


LH_F_IC_HAI



Column Section Top of Page


Table-level Detail

Description: LH_F_IC_HAI
Definition: Infection control hospital associated infection metrics.
Table Type: ACTIVITY





Column Detail - LH_F_IC_HAI


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.
BSI_DEVICE_LATERALITY VARCHAR(100) Y The location/laterality of the device.
COLLECT_DT_TM DATETIME Y The specimen collection date/time associated with the infection.
COLLECT_LOCATION VARCHAR(255) Y The location of the patient at the time of the specimen collection.
COLLECT_UTC_DT_TM DATETIME Y The specimen collection date/time associated with the infection.
DEVICE_INSERT_DAYS DOUBLE Y The total number of days from device insertion to infection.
DEVICE_INSERT_DT_TM DATETIME Y The date/time on which the device associated with the HAI event was inserted.
DEVICE_INSERT_UTC_DT_TM DATETIME Y The date/time on which the device associated with the HAI event was inserted.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
EVENT_DT_TM DATETIME Y The date/time of the HAI event.
EVENT_LOCATION VARCHAR(255) Y The location of the patient at the time of the HAI event.
EVENT_UTC_DT_TM DATETIME Y The date/time of the HAI event.
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_HAI_ID DOUBLE N Unique identifier for the infection control HAI metrics.
F_IC_METRICS_ID DOUBLE N Unique identifier for the infection control metrics.
HAI_EVENT_ID DOUBLE N The clinical event associated with the HAI event.
HAI_SUBTYPE VARCHAR(100) Y Identifies the sub-type of infection.
HAI_TYPE VARCHAR(50) Y Identifies the type of infection.
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.
ORGANISM VARCHAR(255) Y The organisms associated with the HAI event.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
SPECIMEN_SOURCE VARCHAR(100) Y The specimen source for the HAI.
SSI_NHSN_PROC_DESC VARCHAR(50) Y The NHSN procedure code associated with the SSI infection.
SSI_ORGAN VARCHAR(100) Y The organ identified for the SSI infection type of organ/space.
SSI_PROC_CODE VARCHAR(50) Y The NHSN procedure code associated with the SSI infection.
SSI_PROC_DESC VARCHAR(100) Y The surgical procedure associated with the SSI infection.
SURGEON_NAME VARCHAR(100) Y The surgeon associated with the SSI infection.
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_HAI_DTL_METRICS



Column Section Top of Page


Table-level Detail

Description: LH_F_IC_HAI_DTL_METRICS
Definition: This table is used to store Infection Control HAI metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_F_IC_HAI_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.
COLLECT_DT_TM DATETIME Y Date/Time when the organism was collected
COLLECT_FACILITY_TXT VARCHAR(100) Y Where the patient was located when the specimen was collected
COLLECT_NURSE_UNIT_TXT VARCHAR(100) Y Where the patient was located when the specimen was collected
COLLECT_UTC_DT_TM DATETIME Y Date/Time when the organism was collected
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EVENT_DT_TM DATETIME Y Date/Time when the event occurred
EVENT_FACILITY_TXT VARCHAR(100) Y Where the event took place
EVENT_ID DOUBLE N ID of the Advisor Event. From the clinical_event table.
EVENT_NURSE_UNIT_TXT VARCHAR(100) Y Where the event took place
EVENT_UTC_DT_TM DATETIME Y Date/Time when the event occurred
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_CATEGORY_TXT VARCHAR(100) Y BSI/UTI/PN/SSI
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.
ICD9_CODE_DESC_TXT VARCHAR(100) Y SSI Only: ICD9 Procedure Code Description
ICD9_CODE_TXT VARCHAR(100) Y SSI Only: ICD9 Procedure Code
INSERT_DT_TM DATETIME Y BSI/UTI/PN Only: Line insertion date/time
INSERT_UTC_DT_TM DATETIME Y BSI/UTI/PN Only: Line insertion date/time
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_F_IC_HAI_DTL_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_IC_HAI_DTL_METRICS table.
LOCATION_LATERALITY_TXT VARCHAR(100) Y BSI/UTI/PN Only: Location and Laterality of Line (i.e. Hand R)
NBR_DAYS_INSERT_INFECT DOUBLE Y BSI/UTI/PN Only: Number of days from insertion of line to infection
ORGANISM_TXT VARCHAR(100) Y Organism Name
ORGAN_TYPE_TXT VARCHAR(100) Y SSI Only: Organ being operated on
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
SPECIFIC_HAI_TXT VARCHAR(100) Y Specific HAI (Central Line, Other, Procedure, etc.)
SPECIMEN_SOURCE_TXT VARCHAR(100) Y How the specimen was collected (i.e. Blood)
SSI_NHSN_PROC_TXT VARCHAR(100) Y COLO, HYST, KSPRO, HPRO, CBGC
SURGEON_NAME_TXT VARCHAR(100) Y SSI Only: Surgeon performing operation
UNIT_OF_ORIGIN_TXT VARCHAR(100) Y BSI/UTI/PN Only: Patient Location When Line was Inserted
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_HAI_ENCNTR_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_IC_HAI_ENCNTR_METRICS
Definition: This table is used to store Infection Control HAI metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_F_IC_HAI_ENCNTR_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_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.
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 normalized to GMT.
ASM_BACT_IND DOUBLE Y Indicates Asymptomatic Bacteremic Urinary Tract Infection
ASP_PN_IND DOUBLE Y Indicates Aspiration Pneumonia
CAUTI_IND DOUBLE Y Indicates Catheter Associated Urinary Tract Infection
CLABSI_IND DOUBLE Y Indicates patient had Central Line Associated Blood Stream Infection
CL_DAYS DOUBLE Y Total Central Line Days
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DIP_IND DOUBLE Y Indicates Deep Incisional Primary Infection
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.
DIS_IND DOUBLE Y Indicates Deep Incisional Secondary Infection
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_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_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_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 Identifies the person associated with the quality measure. Foreign key to the PERSON table.
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.
HAP_IND DOUBLE Y Indicates Hospital Acquired Pneumonia
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.
LCBI_IND DOUBLE Y Indicates Laboratory Confirmed Blood Infection
LH_F_IC_HAI_ENCNTR_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_IC_HAI_ENCNTR_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.
NBR_PROC DOUBLE Y Number of Procedures for this encounter
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OSI_IND DOUBLE Y Indicates Organ, Space Infection
OTHER_UTI_IND DOUBLE Y Indicates Other Urinary Tract Infection
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAT_DAYS DOUBLE Y Total Patient Days
POST_PROC_PN_IND DOUBLE Y Indicates Post Procedure Pneumonia
SEPSIS_IND DOUBLE Y Indicates Clinical Sepsis
SIP_IND DOUBLE Y Indicates Superficial Incisional Primary Infection
SIS_IND DOUBLE Y Indicates Superficial Incisional Secondary Infection
SUTI_IND DOUBLE Y Indicates Symptomatic Urinary Tract Infection
UC_DAYS DOUBLE Y Total Urinary Catheter Days
UL_DAYS DOUBLE Y Total Umbilical Line Days
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.
VAP_IND DOUBLE Y Indicates Ventilator Acquired Pneumonia
VENT_DAYS DOUBLE Y Total Ventilator Days



Relationship Detail - LH_F_IC_HAI_ENCNTR_METRICS


Child Column in LH_F_IC_HAI_ENCNTR_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_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_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_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_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_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
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
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID