Table Detail Report

LH_F_HAPU_HST_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_HAPU_HST_METRICS
Definition: Fact table for Pressure Ulcer History Lighthouse Report
Table Type: ACTIVITY





Column Detail - LH_F_HAPU_HST_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.
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.
ASSESS_DAILY_IND DOUBLE Y Identifies patients with a risk assessment at least once per shift
AT_RISK_IND DOUBLE Y Identifies if the patient is at risk.
DEPART_DT_TM DATETIME Y The date/time on which the patient left the unit.
DEPART_UTC_DT_TM DATETIME Y The date/time on which the patient left the unit; normalized to GMT.
D_BUILDING_ID DOUBLE Y The building the patient spent time in.
D_FACILITY_ID DOUBLE Y The facility the patient spent time in.
D_NURSE_UNIT_ID DOUBLE Y The nurse unit the patient spent time in.
EDUCATION_IND DOUBLE Y Identifies if the at risk patient has had education documented.
ENCNTR_ID DOUBLE Y Identifies the encounter against which the quality measure is associated.
EXTRACT_DT_TM DATETIME Y The date/time that the program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
F_HAPU_HST_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_HAPU_HST_METRICS table.
HAPU_IND DOUBLE Y Identifies each HAPU
HEALTH_SYSTEM_ID DOUBLE Y 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.
IN_LOC_WIN_24H_IND DOUBLE Y Identifies if patient was in the unit in the first 24hrs
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LOGICAL_DOMAIN_ID DOUBLE Y 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.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PLAN_INITIATED_IND DOUBLE Y Identifies if the at risk patient has had an orderset or powerplan activated.
RISK_PRIOR_HAPU_IND DOUBLE Y Identifies patients that are at risk, had an incident documented, and were at risk prior to the incident.
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
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.



Relationship Detail - LH_F_HAPU_HST_METRICS


Child Column in LH_F_HAPU_HST_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID


LH_F_HAPU_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_HAPU_METRICS
Definition: This table is used to store metrics for the Lighthouse hospital acquired pressure ulcers prevention quality measure. This table is at the encounter grain based upon the HAPU prevention population definition.
Table Type: ACTIVITY





Column Detail - LH_F_HAPU_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.
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.
ASSESS_DAILY_IND DOUBLE Y Identifies if the patient was assessed for risk on a daily basis.
ASSESS_DT_TM DATETIME Y The date/time on which the patient was first assessed for risk.
ASSESS_UTC_DT_TM DATETIME Y The date/time on which the patient was first assessed for risk; normalized to GMT.
ASSESS_WIN_24H_IND DOUBLE Y Identifies if the patient was assessed for risk within 24 hours of admission.
AT_RISK_IND DOUBLE Y Identifies if the patient is at risk.
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 Y The building to which the patient was admitted.
D_ADMIT_DIAGNOSIS_ID DOUBLE N Describes the primary symptoms the patient was experiencing upon admission
D_ADMIT_FACILITY_ID DOUBLE Y The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE Y The nurse unit to which the patient was admitted.
D_ADMIT_PRSNL_ID DOUBLE N Identifies the physician responsible for the patient admission.
D_ADMIT_SRC_ID DOUBLE Y Identifies the place from which the patient came before being admitted.
D_DISCHARGE_BUILDING_ID DOUBLE Y The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE Y The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE Y The nurse unit from which the patient was discharged
D_ENCNTR_TYPE_ID DOUBLE Y Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table.
D_FIRST_HAPU_BUILDING_ID DOUBLE Y The building at which the first incident occurred.
D_FIRST_HAPU_FACILITY_ID DOUBLE Y The facility at which the first incident occurred.
D_FIRST_HAPU_NURSE_UNIT_ID DOUBLE Y The nurse unit at which the first incident occurred.
D_MED_SERVICE_ID DOUBLE Y 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_01_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_02_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_03_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_04_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_05_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_06_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_07_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_08_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_09_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_10_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_11_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_12_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_13_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_14_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_15_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_16_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_17_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_18_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_19_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_METRIC_20_ID DOUBLE N Identifies a metric associated with hospital acquired pressure ulcers. Foreign key to the lh_d_metric table.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON dimension.
D_PRIMARY_DIAGNOSIS_ID DOUBLE N Describes the primary symptoms the patient was experiencing at the time of the encounter.
D_PRIN_PROCEDURE_ID DOUBLE N Describes the principle procedure that was performed during the patient visit.
EDUCATION_IND DOUBLE Y Identifies if the at risk patient has had education documented.
ENCNTR_ID DOUBLE Y 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 program running the extracts was started. This field should be the same across all files and across all records within a file for a given extraction run. This time should be in UTC time.
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.
F_HAPU_METRICS_ID DOUBLE N Unique identifier for a hospital acquired pressure ulcer prevention population record.
HAPU_IND DOUBLE Y Identifies if an incident has been documented during the patient visit.
HEALTH_SYSTEM_ID DOUBLE Y 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.
HIGH_HAPU_STAGE_FLAG DOUBLE Y Identifies the highest stage of any hospital acquired pressure ulcer.
INCDNT_DT_TM DATETIME Y The date/time on which the incident first occurred for the patient.
INCDNT_UTC_DT_TM DATETIME Y The date/time on which the incident first occurred for the patient; normalized to GMT.
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.
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 Y Identifies the person associated with the quality measure. Foreign key to the PERSON table. Column not populated.
PLAN_INITIATED_IND DOUBLE Y Identifies if the at risk patient has had an orderset or powerplan activated.
POPULATION_IND DOUBLE Y Identifies if the patient is part of the population or not.
PREV_INCDNT_DT_TM DATETIME Y The date/time on which the previous incident took place.
PREV_INCDNT_UTC_DT_TM DATETIME Y The date/time on which the previous incident took place; normalized to GMT.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT
PU_UPON_ADMIT_IND DOUBLE N Identifies if the patient had a pressure ulcer at the time of admission.
RISK_DT_TM DATETIME Y The date/time on which the patient was first identified at risk.
RISK_PRIOR_HAPU_IND DOUBLE Y Identifies patients that are at risk had an incident documented and were at risk prior to the incident.
RISK_UTC_DT_TM DATETIME Y The date/time on which the patient was first identified at risk; normalized to GMT.
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.
VENT_ORDER_DT_TM DATETIME Y Identifies when the order for the ventilator was placed for the patient.
VENT_ORDER_UTC_DT_TM DATETIME Y Identifies when the order for the ventilator was placed for the patient, normalized to GMT.
VENT_STOP_DT_TM DATETIME Y Identifies when the order for ventilator was stopped for the patient.
VENT_STOP_UTC_DT_TM DATETIME Y Identifies when the order for ventilator was stopped for the patient (UTC time).



Relationship Detail - LH_F_HAPU_METRICS


Child Column in LH_F_HAPU_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_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_FIRST_HAPU_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_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_FIRST_HAPU_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_01_ID LH_D_METRIC D_METRIC_ID
D_METRIC_02_ID LH_D_METRIC D_METRIC_ID
D_METRIC_03_ID LH_D_METRIC D_METRIC_ID
D_METRIC_04_ID LH_D_METRIC D_METRIC_ID
D_METRIC_05_ID LH_D_METRIC D_METRIC_ID
D_METRIC_06_ID LH_D_METRIC D_METRIC_ID
D_METRIC_07_ID LH_D_METRIC D_METRIC_ID
D_METRIC_08_ID LH_D_METRIC D_METRIC_ID
D_METRIC_09_ID LH_D_METRIC D_METRIC_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_20_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
D_FIRST_HAPU_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


LH_F_HH_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_HH_METRICS
Definition: Fact table for Lighthouse Hand Hygiene metric
Table Type: ACTIVITY





Column Detail - LH_F_HH_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.
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COMPLIANT_FLAG DOUBLE Y Identifies if hand hygiene is compliant. 1: Yes,0: No,999: Missing
D_ISOLATION_ID DOUBLE N Identifies the type of isolation. Foreign key to the LH_D_ISOLATION table
D_METRIC_1_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_OBSRV_FACILITY_ID DOUBLE N The facility to which the patient was observed. Foreign key to the LH_D_FACILITY table
D_OBSRV_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was observed. Foreign key to the LH_D_NURSE_UNIT table
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
D_PROV_POSITION_ID DOUBLE N Identifies the observation provider position. Foreign key to the LH_D_PROV_POSITION table
D_PRSNL_ID DOUBLE N Identifies the observation personnel associated to the observation incident. Foreign key to the LH_D_PERSONNEL table
EKS_ADVSR_EVENT_ID DOUBLE N The lowest grain of the fact table. Primary key for EKS_ADVSR_EVENT table to uniquely define an advisor event.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated.
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.
FINGERNAIL_FLAG DOUBLE Y Identifies if hand hygiene is compliant with fingernail detail. 1: Yes,0: No,999: Missing
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
F_HH_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_F_HH_METRICS table.
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.
HYGIENE_METHOD_TXT VARCHAR(200) Y Various methods of hand hygiene. Example: Washed hands, alcohol rub used, Antimicrobial rub/wach used or None used
INTERVENTION_FLAG DOUBLE Y Hand hygiene intervention indicator. 1: Yes,0: No,999: Missing
INTERVENTION_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of intervention
ISOLATION_FLAG DOUBLE Y Identifies if patient is in isolation or not. 1: Yes,0: No,999: Missing
ISO_CART_FLAG DOUBLE Y Identifies if isolation cart/supplies is in place. 1: Yes,0: No,999: Missing
ISO_CART_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for isolation cart/supplies not in place
ISO_CORRECT_FLAG DOUBLE Y Identified if the isolation is correct for patient. 1: Yes,0: No,999: Missing
ISO_CORRECT_HAND_FLAG DOUBLE Y Identifies if correct hand hygiene is for isolation. 1: Yes,0: No,999: Missing
ISO_CORRECT_HAND_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for incorrect hand hygiene for isolation
ISO_CORRECT_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for isolation incorrect for patient
ISO_POLICY_FLAG DOUBLE Y Identifies if policy/procedures were followed. 1: Yes,0: No,999: Missing
ISO_POLICY_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for not following policy/procedures
ISO_PPE_FLAG DOUBLE Y Identifies is correct PPE is used. 1: Yes,0: No,999: Missing
ISO_PPE_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for incorrect PPE
ISO_SIGNAGE_FLAG DOUBLE Y Identifies if an appropriate signage is in place. 1: Yes,0: No,999: Missing
ISO_SIGNAGE_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for inappropriate signage in place
ISO_STAFF_FLAG DOUBLE Y Identifies if staff verbalizes PPE type for isolation. 1: Yes,0: No,999: Missing
ISO_STAFF_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for non staff verbalizes PPE type of isolation
ISO_VERBALIZE_FLAG DOUBLE Y Identifies if RB verbalizes reason is for isolation. 1: Yes,0: No,999: Missing
ISO_VERBALIZE_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of hand hygiene intervention for RN verbalizes not being reason for isolation
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain.
NHSN_OBS_ENV_FLAG DOUBLE Y Identifies if hand hygiene is compliant after environmental contact for NHSN. 1: Yes,0: No,999: Missing
NHSN_OBS_GOWN_FLAG DOUBLE Y Identifies if HCW is donned with gown and glove. 1: Yes,0: No,999: Missing
NHSN_OBS_PAT_FLAG DOUBLE Y Identifies if hand hygiene is compliant after patient contact for NHSN. 1: Yes,0: No,999: Missing
NONCOMPLIANCE_MASK DOUBLE Y The bit mask used to store a limited number of multi-valued responses of non compliance
OBSRV_BED_TXT VARCHAR(50) Y The bed from which the patient was observed
OBSRV_DT_TM DATETIME Y The date/time on which the patient was observed.
OBSRV_ROOM_TXT VARCHAR(50) Y The room in which the patient was observed
OBSRV_UTC_DT_TM DATETIME Y The date/time on which the patient was observed normalized to GMT.
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
POPULATION_IND DOUBLE Y Identifies patients that qualify for the base population for the Lighthouse metric.
RESUSCITATION_FLAG DOUBLE Y Identifies if patient resuscitation. 1: Yes,0: No,999: Missing
STD_OBS_ENTER_FLAG DOUBLE Y Identifies if hand hygiene is compliant after entering the room for standard observation. 1: Yes,0: No,999: Missing
STD_OBS_EXIT_FLAG DOUBLE Y Identifies if hand hygiene is compliant after exiting the room for standard observation. 1: Yes,0: No,999: Missing
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
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.
WHO_OBS_ASEPTIC_FLAG DOUBLE Y Identifies if hand hygiene is compliant before aseptic procedure for WHO. 1: Yes,0: No,999: Missing
WHO_OBS_A_PAT_FLAG DOUBLE Y Identifies if hand hygiene is compliant after patient contact for WHO. 1: Yes,0: No,999: Missing
WHO_OBS_B_PAT_FLAG DOUBLE Y Identifies if hand hygiene is compliant before patient contact for WHO. 1: Yes,0: No,999: Missing
WHO_OBS_ENV_FLAG DOUBLE Y Identifies if hand hygiene is compliant after environmental contact for WHO. 1: Yes,0: No,999: Missing
WHO_OBS_FLUID_FLAG DOUBLE Y Identifies if hand hygiene is compliant after body fluid exposure for WHO. 1: Yes,0: No,999: Missing



Relationship Detail - LH_F_HH_METRICS


Child Column in LH_F_HH_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_OBSRV_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_ISOLATION_ID LH_D_ISOLATION D_ISOLATION_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ISOLATION HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_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
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_OBSRV_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_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_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID
D_PROV_POSITION_ID LH_D_PROV_POSITION D_PROV_POSITION_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PROV_POSITION HEALTH_SYSTEM_SOURCE_ID


LH_F_HOP_AMI_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_HOP_AMI_METRICS
Definition: This table is used to store metrics for the Lighthouse Outpatient Chest Pain quality measure.
Table Type: ACTIVITY





Column Detail - LH_F_HOP_AMI_METRICS


Column Name Type Null? Definition
ACI_TRANSFER_DOC_IND DOUBLE Y Identifies if the transfer for acute coronary intervention is documented.
ACI_TRANSFER_IND DOUBLE Y Identifies if the patient was transferred for acute coronary intervention
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.
AMI_PRIN_DX_IND DOUBLE Y Identifies if the patient has a principal diagnosis of AMI
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.
ASPIRIN_RECD_DOC_IND DOUBLE Y Identifies if aspirin at arrival is documented.
ASPIRIN_RECD_IND DOUBLE Y Identifies if the patient received aspirin at arrival.
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. Foreign key to the CODE_VALUE table.
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_OP_16_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_OP_1_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_OP_2_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_OP_3A_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_OP_3B_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_OP_3C_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_OP_4_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_OP_5_METRIC_ID DOUBLE N Identifies the outpatient ami metric.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
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.
ELEV_ST_LBBB_DOC_IND DOUBLE Y Identifies if the patient had an elevated ST or LBBB documented.
ELEV_ST_LBBB_IND DOUBLE Y Identifies if the patient had an elevated ST or LBBB
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_16_IND DOUBLE Y Identifies if the patient is excluded from the measure.
EXCLUDE_1_IND DOUBLE Y Identifies if the patient was excluded from the quality measure.
EXCLUDE_3_IND DOUBLE Y Identifies if the patient was excluded from the quality measure.
EXCLUDE_4_IND DOUBLE Y Identifies if the patient was excluded from the quality measure.
EXCLUDE_5_IND DOUBLE Y Identifies if the patient was excluded from the quality measure.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIB_ADMIN_DT_TM DATETIME Y Identifies the date/time of fibrinolytic administration.
FIB_ADMIN_FLAG DOUBLE Y Identifies if the patient has fibrinolytic administration
FIB_ADMIN_UTC_DT_TM DATETIME Y Identifies the date/time of fibrinolytic administration; normalized to GMT.
FIB_DELAY_REASON_DOC_IND DOUBLE Y Identifies if the fibrinolytic delay reason is documented.
FIB_DELAY_REASON_IND DOUBLE Y FIB_DELAY_REASON_IND column
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
F_HOP_AMI_METRICS_ID DOUBLE N Unique identifier for the lighthouse outpatient chest pain
HEALTH_SYSTEM_ID DOUBLE N Unique number assigned by Health Facts. Typically the universal Cerner assigned client id of the health system
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Unique number assigned by Critical Outcomes Local Warehouse. Typically the universal Cerner assigned client id of the sending health system.
HOP_VERSION DOUBLE Y Identifies the version of HOP for which the row qualifies.
INIT_ECG_READ_DT_TM DATETIME Y The date/time of the initial ecg reading.
INIT_ECG_READ_UTC_DT_TM DATETIME Y The date/time of the initial ecg reading; normalized to GMT.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the 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.
NO_ASPIRIN_REASON_DOC_IND DOUBLE Y Identifies patients that did not have a valid reason documented for not receiving aspirin at arrival.
NO_ASPIRIN_REASON_IND DOUBLE Y Identifies patients that did not have a valid reason documented for not receiving aspirin at arrival.
NO_FIB_CARD_SHOCK_IND DOUBLE Y Identifies patients that did not have fibrinolytics administered due to cardiogenic shock.
NO_FIB_CONTRA_IND DOUBLE Y Identifies patients that did not have fibrinolytics administered due to a documented contraindication.
NO_FIB_DOC_IND DOUBLE Y Identifies if the reason for not administering fibrinolytic therapy is documented.
NO_FIB_NO_CONTRA_IND DOUBLE Y Identifies patients that did not have fibrinolytics administered and there is not a documented reason.
NUMERATOR_16_IND DOUBLE Y Identifies if the patient qualifies for the measure
NUMERATOR_2_IND DOUBLE Y Identifies if the patient qualified for the quality measure.
NUMERATOR_3A_IND DOUBLE Y Identifies if the patient qualified for the quality measure.
NUMERATOR_3B_IND DOUBLE Y Identifies if the patient qualified for the quality measure.
NUMERATOR_3C_IND DOUBLE Y Identifies if the patient qualified for the quality measure.
NUMERATOR_4_IND DOUBLE Y Identifies if the patient qualified for the quality measure.
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
POPULATION_1_IND DOUBLE Y Identifies patients that qualify for the base outpatient ami population (op-1, op-2, op-3)
POPULATION_2_IND DOUBLE Y Identifies patients that qualify for the base outpatient ami population (op-4, op-5)
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT.
PROB_CHEST_PAIN_DOC_IND DOUBLE Y Identifies if probable chest pain is documented.
PROB_CHEST_PAIN_IND DOUBLE Y Identifies if the patient has probable chest pain.
REJECT_16_IND DOUBLE Y Identifies if the patient is rejected from the measure.
REJECT_1_IND DOUBLE Y Identifies if the patient was rejected from the quality measure.
REJECT_3_IND DOUBLE Y Identifies if the patient was rejected from the quality measure.
REJECT_4_IND DOUBLE Y Identifies if the patient was rejected from the quality measure.
REJECT_5_IND DOUBLE Y Identifies if the patient was rejected from the quality measure.
TROPONIN_ORDER_IND DOUBLE Y Identifies patient has troponin orders
TROPONIN_RESULT_DT_TM DATETIME Y The date/time of the initial receive troponin result.
TROPONIN_RESULT_UTC_DT_TM DATETIME Y The date/time of the initial receive troponin result.;normalized to GMT.
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 Y The date and time the row was last inserted or updated.
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.



Relationship Detail - LH_F_HOP_AMI_METRICS


Child Column in LH_F_HOP_AMI_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
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
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_OP_16_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_1_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_2_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_3A_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_3B_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_3C_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_4_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_5_METRIC_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
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
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_HOP_SURG_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_F_HOP_SURG_METRICS
Definition: This table is used to store metrics for the Lighthouse Outpatient Surgery quality measure.
Table Type: ACTIVITY





Column Detail - LH_F_HOP_SURG_METRICS


Column Name Type Null? Definition
ABX_SELECT_GOAL_IND DOUBLE Y Identifies if the patient received the appropriate antibiotic.
ABX_TIMING_GOAL_IND DOUBLE Y Identifies patients that received antibiotics within the appropriate time frame.
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 was admitted; normalized to GMT.
CLINICAL_TRIAL_DOC_IND DOUBLE Y Identifies if clinical trial has been documented.
CLINICAL_TRIAL_EXCL_IND DOUBLE Y Identifies if the patient is part of a clinical trial.
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. Foreign key to the CODE_VALUE table.
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_OP_6_METRIC_ID DOUBLE N Identifies the outpatient surgery metric.
D_OP_7_METRIC_ID DOUBLE N Identifies the outpatient surgery metric.
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
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.
EXCLUDE_6_IND DOUBLE Y Identifies if the patient has been rejected from the quality measure.
EXCLUDE_7_IND DOUBLE Y Identifies if the patient has been rejected from the quality measure.
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 the record was first loaded into the table.
F_HOP_SURG_METRICS_ID DOUBLE N Unique identifier for the lighthouse outpatient surgery metrics
GAST_REPLACEMENT_IND DOUBLE Y Identifies patients with a PEG replacement.
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.
HOP_VERSION DOUBLE Y Identifies the version of HOP for which the row qualifies.
INFECTION_PRIOR_DOC_IND DOUBLE Y Identifies if infection prior to procedure has been documented.
INFECTION_PRIOR_EXCL_IND DOUBLE Y Identifies if the patient had an infection prior to anesthesia.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the 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.
NO_ABX_RECD_DOC_IND DOUBLE Y Identifies if antibiotics received has been documented.
NO_ABX_RECD_IND DOUBLE Y Identifies if no antibiotic was received.
NUMERATOR_6_IND DOUBLE Y Identifies if the patient qualifies for the quality measure.
NUMERATOR_7_IND DOUBLE Y Identifies if the patient qualifies for the quality measure.
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
POPULATION_IND DOUBLE Y Identifies patients that qualify for the base outpatient surgery population (OP-6, OP-7)
PRE_EXISTING_COND_IND DOUBLE Y Identifies if there was a pre-existing condition.
PRIN_PROCEDURE_DT_TM DATETIME Y The date/time on which the principle procedure was performed.
PRIN_PROCEDURE_UTC_DT_TM DATETIME Y The date/time on which the principle procedure was performed; normalized to GMT.
REJECT_6_IND DOUBLE Y Identifies if the patient has been rejected from the quality measure.
REJECT_7_IND DOUBLE Y Identifies if the patient has been rejected from the quality measure.
SURG_CANCEL_EXCL_IND DOUBLE Y Identifies if the surgery was cancelled.
SURG_TYPE_GAST_IND DOUBLE Y Identifies patients with a gastrostomy surgery type.
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_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.



Relationship Detail - LH_F_HOP_SURG_METRICS


Child Column in LH_F_HOP_SURG_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
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
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_OP_6_METRIC_ID LH_D_METRIC D_METRIC_ID
D_OP_7_METRIC_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
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
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