Table Detail Report

LH_E_HTN_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_HTN_METRICS
Definition: This table is used to storeHealthy Term Newborn metrics from the Lighthouse eMeasure. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_HTN_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_SOURCE_BIRTH_IND DOUBLE N Identifies if the admit source for the encounter was Birth
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
BIRTH_TRUAMA_INJURIES_IND DOUBLE N Identifies if there is an active diagnosis of birth trauma or injuries
CEREBRAL_PALSY_IND DOUBLE N Identifies if there is an active diagnosis of congenital or infantile cerebral palsy
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CONGENITAL_ANOMALIES_IND DOUBLE N Identifies if there is an active diagnosis of congenital anomalies
CPR_IND DOUBLE N Identifies if there was a procedure performed for CPR
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.
DISCH_OTHER_HOSP_IND DOUBLE N Identifies if there was a procedure performed for
DRUG_WITHDRAWAL_IND DOUBLE N Identifies if there is an active diagnosis of drug withdrawal syndrome
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_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
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 Defines the discharge disposition of the encounter.
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_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_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_IND DOUBLE N Identifies if the encounter is excluded for the HTN metric
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.
GASTROSTOMY_IND DOUBLE N Identifies if there was a procedure performed for gastrostomy
GAVAGE_FEEDING_IND DOUBLE N Identifies if there was a procedure performed for gavage feeding
GEST_AGE_MORE_37_WKS_IND DOUBLE N Identifies if the patient was at a gestational age of more than 37 weeks at birth
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.
HEMOLYTIC_DISEASE_IND DOUBLE N Identifies if there is an active diagnosis of hemolytic disease
HYDROPS_IND DOUBLE N Identifies if there is an active diagnosis of hydrops
HYPERBILIRUBINEMIA_IND DOUBLE N Identifies if there was an active diagnosis for hyperbilirubinemia
HYPERBILIRUBINEMIA_INPT_IND DOUBLE N Identifies if there was an active diagnosis for hyperbilirubinemia during the inpatient encounter
HYPOXIA_ASPHYXIA_IND DOUBLE N Identifies if there is an active diagnosis of hypoxia or asphyxia
IMPAIRED_FETAL_GROWTH_IND DOUBLE N Identifies if there is an active diagnosis of impaired fetal growth
INFECTION_IND DOUBLE N Identifies if there is an active diagnosis of infection
LARYNGEAL_STENOSIS_IND DOUBLE N Identifies if there is an active diagnosis of laryngeal stenosis
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_E_HTN_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_HTN_METRICS table.
LIVEBORN_BORN_HOSP_IND DOUBLE N Identifies if the patient had a diagnosis of liveborn born in hospital
LIVEBORN_BORN_HOSP_INPT_IND DOUBLE N Identifies if the patient had a diagnosis of liveborn born in hospital during the inpatient encounter
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.
NEONATAL_DEATH_IND DOUBLE N Identifies if there was a procedure performed for
NEUROLOGIC_COMPLICATIONS_IND DOUBLE N Identifies if there is an active diagnosis of neurologic complications
NEUROLOGIC_PROC_IND DOUBLE N Identifies if there was a procedure performed for neurologic procedure
NUMERATOR_IND DOUBLE N Identifies if the encounter is in the numerator for the HTN metric
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
PAYER_CODE_TXT VARCHAR(20) Y identifies the payer code value that is associated to the patient for QRDA file payer information.
PHOTOTHERAPY_IND DOUBLE N Identifies if there was a procedure performed for phototherapy
PLACENTA_ABRUPTION_IND DOUBLE N Identifies if there is an active diagnosis of newborn affected by placenta or abruption
POPULATION_IND DOUBLE Y Identifies if the patient is in the population for the Healthy Term Newborn Metric
RESPIRATORY_PROBLEMS_IND DOUBLE N Identifies if there is an active diagnosis of respiratory problems
RESPIRATORY_PROC_IND DOUBLE N Identifies if there was a procedure performed for respiratory procedure
SHOCK_COMPLICATIONS_IND DOUBLE N Identifies if there is an active diagnosis of shock and complications
SINGLE_LB_NB_HOSP_INPT_IND DOUBLE N Identifies if the patient had a diagnosis of single liveborn newborn born in hospital during inpatient encounter
SINGLE_LIVEBORN_NB_HOSP_IND DOUBLE N Identifies if the patient had a diagnosis of single liveborn newborn born in hospital
SINGLE_LIVE_BIRTH_IND DOUBLE N Identifies if the patient had a diagnosis of single live birth
SINGLE_LIVE_BIRTH_INPT_IND DOUBLE N Identifies if the patient had a diagnosis of single live birth during the inpatient encounter
SOCIAL_REASONS_IND DOUBLE N Identifies if there was an active diagnosis for social reasons
SOCIAL_REASONS_INPT_IND DOUBLE N Identifies if there was an active diagnosis for social reasons during the inpatient encounter
TPN_IND DOUBLE N Identifies if there was a procedure performed for TPN
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.
VENOUS_CATH_IND DOUBLE N Identifies if there was a procedure performed for arterial or umbilical venous cath



Relationship Detail - LH_E_HTN_METRICS


Child Column in LH_E_HTN_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_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO 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_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_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_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


LH_E_HWR_2018_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_HWR_2018_METRICS
Definition: Stores data gathered by the LH_E_HWR_2018 program.
Table Type: ACTIVITY





Column Detail - LH_E_HWR_2018_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.
BICARB_LAB_RSLT_DT_TM DATETIME Y The date/time of the first bicarbonate lab test for the episode of care.
BICARB_LAB_RSLT_TXT VARCHAR(30) Y The result of the first bicarbonate lab test for the episode of care.
BICARB_LAB_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first bicarbonate lab test for the episode of care.
BODY_TEMP_RSLT_DT_TM DATETIME Y The date/time of the first body temperature recorded for the episode of care.
BODY_TEMP_RSLT_TXT VARCHAR(30) Y The result of the first body temperature recorded for the episode of care.
BODY_TEMP_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first body temperature recorded for the episode of care.
BODY_WGT_RSLT_DT_TM DATETIME Y The date/time of the first body weight recorded for the episode of care.
BODY_WGT_RSLT_TXT VARCHAR(30) Y The result of the first body weight recorded for the episode of care.
BODY_WGT_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first body weight recorded for the episode of care.
CREAT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first creatinine lab test for the episode of care.
CREAT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first creatinine lab test for the episode of care.
CREAT_LAB_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first creatinine lab test for the episode of care.
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_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
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 Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_METRIC_0_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_PERSON_ID DOUBLE N The person that qualified for the quality metric.
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.
GLUC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first glucose lab test for the episode of care.
GLUC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first glucose lab test for the episode of care.
GLUC_LAB_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first glucose lab test for the episode of care.
HCT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first hematocrit lab test for the episode of care.
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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.
HEART_RATE_RSLT_DT_TM DATETIME Y The date/time of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_TXT VARCHAR(30) Y The result of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first heart rate recorded for the episode of care.
IP_ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
IP_ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_HWR_2018_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_HWR_2018_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.
NUMERATOR_IND DOUBLE Y Indicates that at least one of the results exists.
O2_SAT_RSLT_DT_TM DATETIME Y The date/time of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
O2_SAT_RSLT_TXT VARCHAR(30) Y The result of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
O2_SAT_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
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
PATIENT_IDENT VARCHAR(50) Y Identifies the earliest documented medical record number of the patient.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y Ethnicity code system OID of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y Gender code system OID of the patient as per value set
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_RACE_DESC VARCHAR(300) Y The list of all of a patient's races
POTAS_LAB_RSLT_DT_TM DATETIME Y The date/time of the first potassium lab test for the episode of care.
POTAS_LAB_RSLT_TXT VARCHAR(30) Y The result of the first potassium lab test for the episode of care.
POTAS_LAB_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first potassium lab test for the episode of care.
RESP_RATE_RSLT_DT_TM DATETIME Y The date/time of the first respiratory rate recorded for the episode of care.
RESP_RATE_RSLT_TXT VARCHAR(30) Y The result of the first respiratory rate recorded for the episode of care.
RESP_RATE_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first respiratory rate recorded for the episode of care.
SBP_RSLT_DT_TM DATETIME Y The date/time of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_TXT VARCHAR(30) Y The result of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first systolic blood pressure recorded for the episode of care.
SOD_LAB_RSLT_DT_TM DATETIME Y The date/time of the first sodium lab test for the episode of care.
SOD_LAB_RSLT_TXT VARCHAR(30) Y The result of the first sodium lab test for the episode of care.
SOD_LAB_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first sodium lab test for the episode of care.
TIMEZONE_TXT VARCHAR(100) Y The timezone of the record.
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.
WBC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_UTC_DT_TM DATETIME Y The utc date/time of the first white blood cells count lab test for the episode of care.



Relationship Detail - LH_E_HWR_2018_METRICS


Child Column in LH_E_HWR_2018_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_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO 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_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_METRIC_0_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_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


LH_E_HWR_2021_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures HWR 2021 Metrics
Definition: Stores data gathered by the LH_E_HWR_2021 script.
Table Type: ACTIVITY





Column Detail - LH_E_HWR_2021_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.
BICARB_LAB_RSLT_DT_TM DATETIME Y The date/time of the first bicarbonate lab test for the episode of care.
BICARB_LAB_RSLT_TXT VARCHAR(30) Y The result of the first bicarbonate lab test for the episode of care.
BODY_TEMP_RSLT_DT_TM DATETIME Y The date/time of the first body temperature recorded for the episode of care.
BODY_TEMP_RSLT_TXT VARCHAR(30) Y The result of the first body temperature recorded for the episode of care.
BODY_WGT_RSLT_DT_TM DATETIME Y The date/time of the first body weight recorded for the episode of care.
BODY_WGT_RSLT_TXT VARCHAR(30) Y The result of the first body weight recorded for the episode of care.
CREAT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first creatinine lab test for the episode of care.
CREAT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first creatinine lab test for the episode of care.
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
D_ADMIT_BUILDING_ID DOUBLE N Dimension ID for admit building.
D_ADMIT_FACILITY_ID DOUBLE N Dimension ID for admit facility.
D_ADMIT_NURSE_UNIT_ID DOUBLE N Dimension ID for admit nurse unit.
D_ADMIT_SRC_ID DOUBLE N Dimension ID for admit source.
D_ADMIT_TYPE_ID DOUBLE N Dimension ID for admit type.
D_ATTEND_PRSNL_ID DOUBLE N Dimension ID for attending physician.
D_BR_CCN_ID DOUBLE N Dimension ID for CCN.
D_BR_HCO_ID DOUBLE N Dimension ID for HCO.
D_DISCHARGE_BUILDING_ID DOUBLE N Dimension ID for discharge building.
D_DISCHARGE_FACILITY_ID DOUBLE N Dimension ID for discharge facility.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Dimension ID for discharge nurse unit.
D_DISCH_DISP_ID DOUBLE N Dimension ID for discharge disposition.
D_ENCNTR_TYPE_ID DOUBLE N Dimension ID for encounter type.
D_METRIC_0_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_PERSON_ID DOUBLE N Dimension ID for person data.
ED_ARRIVAL_DT_TM DATETIME Y The start of the emergency encounter.
ED_DEPART_DT_TM DATETIME Y The end of the emergency encounter.
ED_ENCNTR_ID DOUBLE N The ID of the emergency encounter associated to the record.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y Financial Number of the record.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GLUC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first glucose lab test for the episode of care.
GLUC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first glucose lab test for the episode of care.
HCT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first hematocrit lab test for the episode of care.
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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.
HEART_RATE_RSLT_DT_TM DATETIME Y The date/time of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_TXT VARCHAR(30) Y The result of the first heart rate recorded for the episode of care.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_HWR_2021_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_HWR_2021_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.
O2_SAT_RSLT_DT_TM DATETIME Y The date/time of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
O2_SAT_RSLT_TXT VARCHAR(30) Y The result of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
OBS_SERV_ARRIVAL_DT_TM DATETIME Y The start of the observation encounter.
OBS_SERV_DEPART_DT_TM DATETIME Y The end of the observation encounter.
OBS_SERV_ENCNTR_ID DOUBLE N The ID of the observation services encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PATIENT_IDENT VARCHAR(50) Y Identifies the earliest documented medical record number of the patient.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y String to store ethnicity display.
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y String to store gender display.
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y String to store payer display.
PERSON_RACE_DESC VARCHAR(300) Y String to store multiple races.
POTAS_LAB_RSLT_DT_TM DATETIME Y The date/time of the first potassium lab test for the episode of care.
POTAS_LAB_RSLT_TXT VARCHAR(30) Y The result of the first potassium lab test for the episode of care.
RESP_RATE_RSLT_DT_TM DATETIME Y The date/time of the first respiratory rate recorded for the episode of care.
RESP_RATE_RSLT_TXT VARCHAR(30) Y The result of the first respiratory rate recorded for the episode of care.
RESULT_IND DOUBLE Y Indicates that at least one of the results exists.
SBP_RSLT_DT_TM DATETIME Y The date/time of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_TXT VARCHAR(30) Y The result of the first systolic blood pressure recorded for the episode of care.
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
SOD_LAB_RSLT_DT_TM DATETIME Y The date/time of the first sodium lab test for the episode of care.
SOD_LAB_RSLT_TXT VARCHAR(30) Y The result of the first sodium lab test for the episode of care.
SRC_UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated to be preserved during extracts.
SRC_UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record to be preserved during extracts.
TIMEZONE_TXT VARCHAR(300) Y The timezone of the record in ""America/Chicago"" format.
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.
WBC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first white blood cells count lab test for the episode of care.



Relationship Detail - LH_E_HWR_2021_METRICS


Child Column in LH_E_HWR_2021_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_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO 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_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_METRIC_0_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_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


LH_E_HYBRID_2022_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures HWR and HWM 2022 Metrics
Definition: Stores data gathered by the LH_E_HYBRID_2022 script.
Table Type: ACTIVITY





Column Detail - LH_E_HYBRID_2022_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.
BICARB_LAB_RSLT_DT_TM DATETIME Y The date/time of the first bicarbonate lab test for the episode of care.
BICARB_LAB_RSLT_TXT VARCHAR(30) Y The result of the first bicarbonate lab test for the episode of care.
BODY_TEMP_RSLT_DT_TM DATETIME Y The date/time of the first body temperature recorded for the episode of care.
BODY_TEMP_RSLT_TXT VARCHAR(30) Y The result of the first body temperature recorded for the episode of care.
BODY_WGT_RSLT_DT_TM DATETIME Y The date/time of the first body weight recorded for the episode of care.
BODY_WGT_RSLT_TXT VARCHAR(30) Y The result of the first body weight recorded for the episode of care.
CREAT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first creatinine lab test for the episode of care.
CREAT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first creatinine lab test for the episode of care.
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
D_ADMIT_BUILDING_ID DOUBLE N Dimension ID for admit building.
D_ADMIT_FACILITY_ID DOUBLE N Dimension ID for admit facility.
D_ADMIT_NURSE_UNIT_ID DOUBLE N Dimension ID for admit nurse unit.
D_ADMIT_SRC_ID DOUBLE N Dimension ID for admit source.
D_ADMIT_TYPE_ID DOUBLE N Dimension ID for admit type.
D_ATTEND_PRSNL_ID DOUBLE N Dimension ID for attending physician.
D_BR_CCN_ID DOUBLE N Dimension ID for CCN.
D_BR_HCO_ID DOUBLE N Dimension ID for HCO.
D_DISCHARGE_BUILDING_ID DOUBLE N Dimension ID for discharge building.
D_DISCHARGE_FACILITY_ID DOUBLE N Dimension ID for discharge facility.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Dimension ID for discharge nurse unit.
D_DISCH_DISP_ID DOUBLE N Dimension ID for discharge disposition.
D_ENCNTR_TYPE_ID DOUBLE N Dimension ID for encounter type.
D_METRIC_0_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_PERSON_ID DOUBLE N Dimension ID for person data.
ED_ARRIVAL_DT_TM DATETIME Y The start of the emergency encounter.
ED_DEPART_DT_TM DATETIME Y The end of the emergency encounter.
ED_ENCNTR_ID DOUBLE N The ID of the emergency encounter associated to the record.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y Financial Number of the record.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GLUC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first glucose lab test for the episode of care.
GLUC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first glucose lab test for the episode of care.
HCT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first hematocrit lab test for the episode of care.
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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.
HEART_RATE_RSLT_DT_TM DATETIME Y The date/time of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_TXT VARCHAR(30) Y The result of the first heart rate recorded for the episode of care.
HWM_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Mortality Measure.
HWM_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Mortality Measure.
HWR_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Re-admission Measure.
HWR_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Re-admission Measure.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_HYBRID_2022_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_HYBRID_2022_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.
O2_SAT_RSLT_DT_TM DATETIME Y The date/time of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
O2_SAT_RSLT_TXT VARCHAR(30) Y The result of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
OBS_SERV_ARRIVAL_DT_TM DATETIME Y The start of the observation encounter.
OBS_SERV_DEPART_DT_TM DATETIME Y The end of the observation encounter.
OBS_SERV_ENCNTR_ID DOUBLE N The ID of the observation services encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PATIENT_IDENT VARCHAR(50) Y Identifies the earliest documented medical record number of the patient.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y String to store ethnicity display.
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y String to store gender display.
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y String to store payer display.
PERSON_RACE_DESC VARCHAR(300) Y String to store multiple races.
PLATELET_LAB_RSLT_DT_TM DATETIME Y The date/time of the first platelet count recorded for the episode of care.
PLATELET_LAB_RSLT_TXT VARCHAR(30) Y The result of the first platelet count recorded for the episode of care.
POTAS_LAB_RSLT_DT_TM DATETIME Y The date/time of the first potassium lab test for the episode of care.
POTAS_LAB_RSLT_TXT VARCHAR(30) Y The result of the first potassium lab test for the episode of care.
RESP_RATE_RSLT_DT_TM DATETIME Y The date/time of the first respiratory rate recorded for the episode of care.
RESP_RATE_RSLT_TXT VARCHAR(30) Y The result of the first respiratory rate recorded for the episode of care.
SBP_RSLT_DT_TM DATETIME Y The date/time of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_TXT VARCHAR(30) Y The result of the first systolic blood pressure recorded for the episode of care.
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
SOD_LAB_RSLT_DT_TM DATETIME Y The date/time of the first sodium lab test for the episode of care.
SOD_LAB_RSLT_TXT VARCHAR(30) Y The result of the first sodium lab test for the episode of care.
SRC_UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated to be preserved during extracts.
SRC_UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record to be preserved during extracts.
TIMEZONE_TXT VARCHAR(300) Y The timezone of the record in ""America/Chicago"" format.
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.
WBC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first white blood cells count lab test for the episode of care.



Relationship Detail - LH_E_HYBRID_2022_METRICS


Child Column in LH_E_HYBRID_2022_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_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO 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_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_METRIC_0_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_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
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


LH_E_HYBRID_2023_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures HWR and HWM 2023 Metrics
Definition: Stores data gathered by the LH_E_HYBRID_2023 script.
Table Type: ACTIVITY





Column Detail - LH_E_HYBRID_2023_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.
BICARB_LAB_RSLT_DT_TM DATETIME Y The date/time of the first bicarbonate lab test for the episode of care.
BICARB_LAB_RSLT_TXT VARCHAR(30) Y The result of the first bicarbonate lab test for the episode of care.
BODY_TEMP_RSLT_DT_TM DATETIME Y The date/time of the first body temperature recorded for the episode of care.
BODY_TEMP_RSLT_TXT VARCHAR(30) Y The result of the first body temperature recorded for the episode of care.
BODY_WGT_RSLT_DT_TM DATETIME Y The date/time of the first body weight recorded for the episode of care.
BODY_WGT_RSLT_TXT VARCHAR(30) Y The result of the first body weight recorded for the episode of care.
CREAT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first creatinine lab test for the episode of care.
CREAT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first creatinine lab test for the episode of care.
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
D_ADMIT_BUILDING_ID DOUBLE N Dimension ID for admit building.
D_ADMIT_FACILITY_ID DOUBLE N Dimension ID for admit facility.
D_ADMIT_NURSE_UNIT_ID DOUBLE N Dimension ID for admit nurse unit.
D_ADMIT_SRC_ID DOUBLE N Dimension ID for admit source.
D_ADMIT_TYPE_ID DOUBLE N Dimension ID for admit type.
D_ATTEND_PRSNL_ID DOUBLE N Dimension ID for attending physician.
D_BR_CCN_ID DOUBLE N Dimension ID for CCN.
D_BR_HCO_ID DOUBLE N Dimension ID for HCO.
D_DISCHARGE_BUILDING_ID DOUBLE N Dimension ID for discharge building.
D_DISCHARGE_FACILITY_ID DOUBLE N Dimension ID for discharge facility.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Dimension ID for discharge nurse unit.
D_DISCH_DISP_ID DOUBLE N Dimension ID for discharge disposition.
D_ENCNTR_TYPE_ID DOUBLE N Dimension ID for encounter type.
D_METRIC_0_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_PERSON_ID DOUBLE N Dimension ID for person data.
ED_ARRIVAL_DT_TM DATETIME Y The start of the emergency encounter.
ED_DEPART_DT_TM DATETIME Y The end of the emergency encounter.
ED_ENCNTR_ID DOUBLE N The ID of the emergency encounter associated to the record.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y Financial Number of the record.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GLUC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first glucose lab test for the episode of care.
GLUC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first glucose lab test for the episode of care.
HCT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first hematocrit lab test for the episode of care.
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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.
HEART_RATE_RSLT_DT_TM DATETIME Y The date/time of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_TXT VARCHAR(30) Y The result of the first heart rate recorded for the episode of care.
HWM_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Mortality Measure.
HWM_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Mortality Measure.
HWR_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Re-admission Measure.
HWR_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Re-admission Measure.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_HYBRID_2023_METRICS_ID DOUBLE Y Unique generated number that identifies a single row on the LH_E_HYBRID_2023_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.
O2_SAT_RSLT_DT_TM DATETIME Y The date/time of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
O2_SAT_RSLT_TXT VARCHAR(30) Y The result of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
OBS_SERV_ARRIVAL_DT_TM DATETIME Y The start of the observation encounter.
OBS_SERV_DEPART_DT_TM DATETIME Y The end of the observation encounter.
OBS_SERV_ENCNTR_ID DOUBLE N The ID of the observation services encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PATIENT_IDENT VARCHAR(50) Y Identifies the earliest documented medical record number of the patient.
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y String to store ethnicity display.
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y String to store gender display.
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y String to store payer display.
PERSON_RACE_DESC VARCHAR(300) Y String to store multiple races.
PLATELET_LAB_RSLT_DT_TM DATETIME Y The date/time of the first platelet count recorded for the episode of care.
PLATELET_LAB_RSLT_TXT VARCHAR(30) Y The result of the first platelet count recorded for the episode of care.
POTAS_LAB_RSLT_DT_TM DATETIME Y The date/time of the first potassium lab test for the episode of care.
POTAS_LAB_RSLT_TXT VARCHAR(30) Y The result of the first potassium lab test for the episode of care.
RESP_RATE_RSLT_DT_TM DATETIME Y The date/time of the first respiratory rate recorded for the episode of care.
RESP_RATE_RSLT_TXT VARCHAR(30) Y The result of the first respiratory rate recorded for the episode of care.
SBP_RSLT_DT_TM DATETIME Y The date/time of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_TXT VARCHAR(30) Y The result of the first systolic blood pressure recorded for the episode of care.
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
SOD_LAB_RSLT_DT_TM DATETIME Y The date/time of the first sodium lab test for the episode of care.
SOD_LAB_RSLT_TXT VARCHAR(30) Y The result of the first sodium lab test for the episode of care.
SRC_UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated to be preserved during extracts.
SRC_UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record to be preserved during extracts.
TIMEZONE_TXT VARCHAR(300) Y The timezone of the record in ""America/Chicago"" format.
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.
WBC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first white blood cells count lab test for the episode of care.



Relationship Detail - LH_E_HYBRID_2023_METRICS


Child Column in LH_E_HYBRID_2023_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_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO 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_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_METRIC_0_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_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
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID