Table Detail Report

LH_E_PC_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_PC_METRICS
Definition: This table is used to store PC metrics from the Lighthouse eMeasure. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_PC_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.
ACTIVE_LABOR_DT_TM DATETIME Y Identifies when active labor occurred
ACTIVE_LABOR_UTC_DT_TM DATETIME Y Identifies when active labor occurred normalized to GMT
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.
BIRTH_REASON_IND DOUBLE Y Identifies if the inpatient encounter reason was birth
BREAST_MILK_IND DOUBLE Y Identifies if breast milk was given
CLASSICAL_CSECTION_PRIOR_IND DOUBLE Y Identifies if a classical C-section was performed
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
CSECTION_DT_TM DATETIME Y Identifies when and if a C-section was performed
CSECTION_UTC_DT_TM DATETIME Y Identifies when and if a C-section was performed normalized to GMT
DELIVERY_PROC_DT_TM DATETIME Y Identifies when then delivery procedure was performed
DELIVERY_PROC_UTC_DT_TM DATETIME Y Identifies when then delivery procedure was performed normalized to GMT
DEN_EXCEPTION_5A_IND DOUBLE Y Identifies if the patient is a denominator exception for PC05a
DEN_EXCEPTION_5_IND DOUBLE Y Identifies if the patient is a denominator exception for PC05
DIETARY_INTAKE_IND DOUBLE Y Identifies if there was dietary intake other than breast milk given
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_OTHER_HOSP_IND DOUBLE Y Identifies if the patient was discharged to another hospital
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 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_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ELECT_DELIV_39_WKS_DX_IND DOUBLE Y Identifies if there was a diagnosis justifying elective delivery prior to 39 weeks
ELECT_DELIV_END_PRIOR_IND DOUBLE Y Identifies if the diagnosis justifying elective delivery prior to 39 weeks ended prior to the start of the inpatient encounter
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y Identifies if the patient is excluded for PC01
EXCLUDE_5A_IND DOUBLE Y Identifies if the patient is excluded for PC05a
EXCLUDE_5_IND DOUBLE Y Identifies if the patient is excluded for PC05
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.
GALACTOSEMIA_DX_IND DOUBLE Y Identifies if there was a diagnosis of galactosemia
GEST_AGE_37_38_WKS_IND DOUBLE Y Identifies if the gestational age is 37-38 weeks
GEST_AGE_38_WKS_IND DOUBLE Y Identifies if the gestational age is 38 weeks
GEST_AGE_DT_TM DATETIME Y Identifies when the gestational age documentation was completed
GEST_AGE_LESS_37_WKS_IND DOUBLE Y Identifies if the gestational age is less than 37 weeks
GEST_AGE_MORE_37_WKS_IND DOUBLE Y Identifies if the gestational age was more than 37 weeks
GEST_AGE_UNKNOWN_IND DOUBLE Y Identifies if the gestational age was unknown
GEST_AGE_UTC_DT_TM DATETIME Y Identifies when the gestational age documentation was completed normalized to GMT
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_E_PC_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PC_METRICS table.
LIVEBORN_BORN_IN_HOSP_IND DOUBLE Y Identifies if there is a diagnosis of liveborn born in hospital
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.
MATERNAL_RES_BREAST_MILK_IND DOUBLE Y Identifies if there was a maternal reason for not giving breast milk
MEDICAL_INDUCTION_LABOR_IND DOUBLE Y Identifies if there was an medical induction of labor
MYOMECTOMY_PRIOR_IND DOUBLE Y Identifies if a myomectomy procedure was performed prior to inpatient encounter
NICU_LOC_IND DOUBLE Y Identifies if the patient was in a NICU location during their inpatient encounter
NUMERATOR_1_IND DOUBLE Y Identifies if the patient is in the numerator for PC01
NUMERATOR_5A_IND DOUBLE Y Identifies if the patient is in the numerator for PC05a
NUMERATOR_5_IND DOUBLE Y Identifies if the patient is in the numerator for PC05
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARENTERAL_INFUSION_IND DOUBLE Y Identifies if parenteral infusion occurred
PARENTERAL_REFUSAL_IND DOUBLE Y Identifies if there was a parenteral refusal for giving breast milk
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility
PAT_EXPIRED_IND DOUBLE Y Identifies if the patient expired
PAYER_CODE_TXT VARCHAR(20) Y identifies the payer code value that is associated to the patient for QRDA file payer information.
POPULATION_1_IND DOUBLE Y Identifies if the encounter qualifies for the PC-01 Population
POPULATION_5_IND DOUBLE Y Identifies if the encounter qualifies for the PC-05/PC-05a Population
RES_DX_PERF_UTERUS_IND DOUBLE Y Identifies if there was a resolve problem of perforation of uterus
RES_DX_UTERINE_WINDOW_IND DOUBLE Y Identifies if there was a resolve problem of uterine window
REX_DX_UTERINE_RUPTURE_IND DOUBLE Y Identifies if there was a resolve problem of uterine rupture
SINGLE_LIVEBORN_IND DOUBLE Y Identifies if there is a diagnosis of a single liveborn newborn in hospital
SINGLE_LIVE_BIRTH_IND DOUBLE Y Identifies if there is a diagnosis of a single live birth
SROM_DT_TM DATETIME Y Identifies when a spontaneous rupture of membranes occurred
SROM_UTC_DT_TM DATETIME Y Identifies when a spontaneous rupture of membranes occurred 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.
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_E_PC_METRICS


Child Column in LH_E_PC_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
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_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
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_PN_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_PN_METRICS
Definition: This table is used to store Pneumonia metrics from the Lighthouse eMeasure. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_PN_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_FLAG DOUBLE Y Identifies where the patient was transferred from
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
ANY_INFECTION_DX_DT_TM DATETIME Y Identifies the end date/time of the diagnosis of any infection on the encounter
ANY_INFECTION_DX_UTC_DT_TM DATETIME Y Identifies the end date/time of the diagnosis of any infection on the encounter normalized to GMT
BRONCHIECTASIS_IND DOUBLE Y Identifies if there is a diagnosis of bronchiectasis that occurred before the inpatient encounter started
CHEST_CT_DT_TM DATETIME Y Identifies the date/time of the chest CT
CHEST_CT_NORMAL_DT_TM DATETIME Y Identifies the date/time of the chest CT normal reading
CHEST_CT_NORMAL_UTC_DT_TM DATETIME Y Identifies the date/time of the chest CT normal reading normalized to GMT
CHEST_CT_UTC_DT_TM DATETIME Y Identifies the date/time of the chest CT normalized to GMT
CHEST_XRAY_DT_TM DATETIME Y Identifies the date/time of the chest X-Ray
CHEST_XRAY_NORMAL_DT_TM DATETIME Y Identifies the date/time of the chest X-Ray normal reading
CHEST_XRAY_NORMAL_UTC_DT_TM DATETIME Y Identifies the date/time of the chest X-Ray normal reading normalized to GMT
CHEST_XRAY_UTC_DT_TM DATETIME Y Identifies the date/time of the chest X-Ray normalized to GMT
CHRONIC_BRONCHITIS_DX_IND DOUBLE Y Identifies if there is a diagnosis of Chronic Bronchitis that occurred before the inpatient encounter started
CLINICAL_TRIAL_IND DOUBLE Y Identifies if the patient was enrolled in a clinical trial
CMO_DT_TM DATETIME Y Identifies the date/time of comfort measures only
CMO_UTC_DT_TM DATETIME Y Identifies the date/time of comfort measures only normalized to GMT
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
COPD_DX_IND DOUBLE Y Identifies if there is a diagnosis of COPD that occurred before the inpatient encounter started
CORTICOSTEROIDS_DT_TM DATETIME Y Identifies the first administration of IV, IM or PO corticosteroids
CORTICOSTEROIDS_UTC_DT_TM DATETIME Y Identifies the first administration of IV, IM or PO corticosteroids normalized to GMT
CYSTIC_FIBROSIS_IND DOUBLE Y Identifies if there is a diagnosis of cystic fibrosis
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 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.
D_PRIN_DX_ID DOUBLE N Identifies the principal diagnosis code of the encounter
ED_ARRIVAL_DT_TM DATETIME Y Identifies when the patient arrived in the ED
ED_ARRIVAL_UTC_DT_TM DATETIME Y Identifies when the patient arrived in the ED normalized to GMT
ED_DEPART_DT_TM DATETIME Y Identifies when the patient left the ED
ED_DEPART_UTC_DT_TM DATETIME Y Identifies when the patient left the ED normalized to GMT
ED_ENCNTR_ID DOUBLE N Identifies the emergency encounter
EMPHYSEMA_DX_IND DOUBLE Y Identifies if there is a diagnosis of Emphysema that occurred before the inpatient encounter started
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y Identifies if the encounter is considered Excluded for Population 1
EXCLUDE_2_IND DOUBLE Y Identifies if the encounter is considered Excluded for Population 2
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.
FRACISELLA_DX_DT_TM DATETIME Y Identifies the date/time of the Fracisella diagnosis
FRACISELLA_DX_UTC_DT_TM DATETIME Y Identifies the date/time of the Fracisella diagnosis normalized to GMT
HCAP_IND DOUBLE Y Identifies if there is an active diagnosis of HCAP
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.
HEMO_PERI_DIALYSIS_IND DOUBLE Y Identifies if there was a procedure performed: hemodialysis or peritoneal dialysis
ICU_ARRIVAL_DT_TM DATETIME Y Identifies when the patient arrived in the ICU
ICU_ARRIVAL_UTC_DT_TM DATETIME Y Identifies when the patient arrived in the ICU normalized to GMT
ICU_DEPART_DT_TM DATETIME Y Identifies when the patient left the ICU
ICU_DEPART_UTC_DT_TM DATETIME Y Identifies when the patient left the ICU normalized to GMT
IMMUNOCOMPROMISED_COND_IND DOUBLE Y Identifies if there is a diagnosis active for: Immunocompromised Conditions
IMMUNOCOMPROMISED_THER_IND DOUBLE Y Identifies if there is a diagnosis active for: Immunocompromised Therapies
IMMUNODEFICIENT_COND_IND DOUBLE Y Identifies if there is an active diagnosis of immunodeficient conditions
IMMUNOSUPPRESSSIVE_MED_IND DOUBLE Y Identifies if there is a medication active for Immunosuppressives
INTERSTITIAL_LUNG_DX_IND DOUBLE Y Identifies if there is a diagnosis of Interstitial Lung Disease that occurred before the inpatient encounter started
IV_AMINOGLYCOSIDES_DT_TM DATETIME Y Identifies the first administration of IV Aminoglycosides
IV_AMINOGLYCOSIDES_UTC_DT_TM DATETIME Y Identifies the first administration of IV Aminoglycosides normalized to GMT
IV_ANTIPSEU_QUIN_DT_TM DATETIME Y Identifies the first administration date/time of IV Antipseudomonal Quinolones
IV_ANTIPSEU_QUIN_UTC_DT_TM DATETIME Y Identifies the first administration date/time of IV Antipseudomonal Quinolones normalized to GMT
IV_ANTIPSUEDOMONAL_DT_TM DATETIME Y Identifies the first administration of IV Antipneumoccal/Antipseudomonal medications
IV_ANTIPSUEDOMONAL_UTC_DT_TM DATETIME Y Identifies the first administration of IV Antipneumoccal/Antipseudomonal medications normalized to GMT
IV_BETA_LACTAM_DT_TM DATETIME Y Identifies the first administration of IV beta lactam
IV_BETA_LACTAM_UTC_DT_TM DATETIME Y Identifies the first administration of IV beta lactam normalized to GMT
IV_IM_AZTREONAM_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams
IV_IM_AZTREONAM_UTC_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams normalized to GMT
IV_IM_BETA_LACTAMS_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams
IV_IM_BETA_LACTAMS_UTC_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams normalized to GMT
IV_IM_PO_ANTIMIC_MED_DT_TM DATETIME Y Identifies the date/time that IV/IM/PO Antimicrobial medication was administered
IV_IM_PO_ANTIMIC_MED_UTC_DT_TM DATETIME Y Identifies the date/time that IV/IM/PO Antimicrobial medication was administered normalized to GMT
IV_MACROLIDES_DT_TM DATETIME Y Identifies the first administration of IV Macrolides
IV_MACROLIDES_UTC_DT_TM DATETIME Y Identifies the first administration of IV Macrolides normalized to GMT
IV_PO_LEVOFLOXACIN_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams
IV_PO_LEVOFLOXACIN_UTC_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams normalized to GMT
IV_PO_MACROLIDES_DT_TM DATETIME Y Identifies the first administration of IV/PO Macrolides
IV_PO_MACROLIDES_UTC_DT_TM DATETIME Y Identifies the first administration of IV/PO Macrolides normalized to GMT
IV_PO_QUINOLONES_DT_TM DATETIME Y Identifies the first administration date/time of IV /PO Quinolones
IV_PO_QUINOLONES_UTC_DT_TM DATETIME Y Identifies the first administration date/time of IV/PO Quinolones normalized to GMT
IV_PO_TETRACYCLINE_DT_TM DATETIME Y Identifies the first administration of IV/PO tetracycline
IV_PO_TETRACYCLINE_UTC_DT_TM DATETIME Y Identifies the first administration of IV/PO tetracycline normalized to GMT
IV_QUINOLONES_DT_TM DATETIME Y Identifies the first administration of IV Quinolones
IV_QUINOLONES_UTC_DT_TM DATETIME Y Identifies the first administration of IV Quinolones normalized to GMT
IV_TETRACYCLINE_DT_TM DATETIME Y Identifies the first administration of IV tetracycline
IV_TETRACYCLINE_UTC_DT_TM DATETIME Y Identifies the first administration of IV tetracycline normalized to GMT
IV_TIGECYCLINE_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams
IV_TIGECYCLINE_UTC_DT_TM DATETIME Y Identifies the first administration of IV/IM Beta Lactams normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_E_PN_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PN_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.
MED_ALLERGY_BETA_LACTAMS_IND DOUBLE Y Identifies if the patient has a medication allergy to Beta Lactams
NEUTROPHIL_500_IND DOUBLE Y Identifies if there is a lab test >= 500 for Neutrophil Count
NON_ICU_ARRIVAL_DT_TM DATETIME Y Identifies when the patient arrived in a non-ICU location
NON_ICU_ARRIVAL_UTC_DT_TM DATETIME Y Identifies when the patient arrived in a non-ICU location normalized to GMT
NON_ICU_DEPART_DT_TM DATETIME Y Identifies when the patient left the non-ICU location
NON_ICU_DEPART_UTC_DT_TM DATETIME Y Identifies when the patient left the non-ICU location normalized to GMT
NOT_IN_DEN_1_IND DOUBLE Y Identifies if the encounter is considered Not In Denominator for Population 1
NOT_IN_DEN_2_IND DOUBLE Y Identifies if the encounter is considered Not In Denominator for Population 2
NUMERATOR_1_IND DOUBLE Y Identifies if the encounter is considered in the Numerator for Population 1
NUMERATOR_2_IND DOUBLE Y Identifies if the encounter is considered in the Numerator for Population 2
ORGAN_TRANSPLANT_IND DOUBLE Y Identifies if there was a procedure performed for Organ Transplant
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) N identifies the payer code value that is associated to the patient for QRDA file payer information.
PN_DX_IND DOUBLE Y Identifies if the there was a diagnosis of Pneumonia on the encounter
POPULATION_IND DOUBLE Y Identifies if the patient is in the population for the Pneumonia Metric
PRESUMPTIVE_PN_DX_DT_TM DATETIME Y Identifies the date/time of a diagnosis of presumptive pneumonia
PRESUMPTIVE_PN_DX_ED_IND DOUBLE Y Identifies if the encounter had a presumptive PN diagnosis associated to the ED encounter.
PRESUMPTIVE_PN_DX_INPT_IND DOUBLE Y Identifies if the encounter had a presumptive PN diagnosis associated to the Inpatient encounter
PRESUMPTIVE_PN_DX_UTC_DT_TM DATETIME Y Identifies the date/time of a diagnosis of presumptive pneumonia normalized to GMT
PRINCIPAL_PN_DX_IND DOUBLE Y Identifies if the final, principal diagnosis for the encounter is Pneumonia
PRINCIPAL_RESP_FAIL_DX_IND DOUBLE Y Identifies if the final, principal diagnosis for the encounter is Respiratory Failure
PRINCIPAL_SEPTICEMIA_DX_IND DOUBLE Y Identifies if the final, principal diagnosis for the encounter is Septicemia
PROLONGED_QT_DX_IND DOUBLE Y Identifies if there is a diagnosis of prolonged QT on the encounter
RESPIRATORY_INFECTION_DX_IND DOUBLE Y Identifies if there is a diagnosis of respiratory infection on the encounter
RESTRICTIVE_LUNG_DX_IND DOUBLE Y Identifies if there is a diagnosis of Restrictive Lung Disease that occurred before the inpatient encounter started
STRUCTURAL_LUNG_DX_IND DOUBLE Y Identifies if there is a diagnosis of Structural Lung Disease that occurred before the inpatient encounter started
SYSTEMIC_STERIOD_MED_IND DOUBLE Y Identifies if there is a medication active for Systemic Steroids
TRACHEOSTOMY_IND DOUBLE Y Identifies if there was a procedure performed: tracheostomy
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.
VENTILATOR_IND DOUBLE Y Identifies if there was a procedure performed: ventilator
WOUND_CARE_IND DOUBLE Y Identifies if there was a wound care intervention performed



Relationship Detail - LH_E_PN_METRICS


Child Column in LH_E_PN_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_PRIN_DX_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_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_SCIP_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_SCIP_METRICS
Definition: This table is used to store SCIP metrics from the Lighthouse eMeasure. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_SCIP_METRICS


Column Name Type Null? Definition
ACH_DISCH_DT_TM DATETIME Y Identifies the date/time that the patient was discharged from the acute care facility
ACH_DISCH_UTC_DT_TM DATETIME Y Identifies the date/time that the patient was discharged from the acute care facility normalized to GMT
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.
ACUTE_CARE_LOS_3_DAYS_IND DOUBLE Y Identifies if the length of stay at the acute care facility was >= 3 days
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.
AMINOGLYCOSIDES_DT_TM DATETIME Y Identifies the date/time that aminoglycosides were ordered
AMINOGLYCOSIDES_UTC_DT_TM DATETIME Y Identifies the date/time that aminoglycosides were ordered normalized to GMT
ANESTHESIA_END_DT_TM DATETIME Y Identifies the end date/time of anesthesia
ANESTHESIA_END_UTC_DT_TM DATETIME Y Identifies the end date/time of anesthesia normalized to GMT
ANESTHESIA_PROC_DT_TM DATETIME Y Identifies the date/time of the procedure that required anesthesia
ANESTHESIA_PROC_UTC_DT_TM DATETIME Y Identifies the date/time of the procedure that required anesthesia normalized to GMT
ANESTHESIA_START_DT_TM DATETIME Y Identifies the start date/time of anesthesia
ANESTHESIA_START_UTC_DT_TM DATETIME Y Identifies the start date/time of anesthesia normalized to GMT
ANTIMIC_IV_IM_PO_DT_TM DATETIME Y Identifies if the patient had an Antimicrobial medication administered via IV, IM or PO
ANTIMIC_IV_IM_PO_UTC_DT_TM DATETIME Y Identifies if the patient had an Antimicrobial medication administered via IV, IM or PO normalized to GMT
AZTREONAM_DT_TM DATETIME Y Identifies the date/time that aztreonam was ordered
AZTREONAM_UTC_DT_TM DATETIME Y Identifies the date/time that aminoglycosides were ordered normalized to GMT
BETA_LACTAM_ALLERGY_IND DOUBLE Y Identifies if there is a documented allergy for beta lactams
CARDIAC_VALVE_SURGERY_IND DOUBLE Y Identifies if there was a cardiac valve surgery during the inpatient encounter
CARDIC_VASCULAR_ABX_DT_TM DATETIME Y Identifies the date/time that cardiac or vascular antibiotics were ordered
CARDIC_VASCULAR_ABX_UTC_DT_TM DATETIME Y Identifies the date/time that cardiac or vascular antibiotics were ordered normalized to GMT
CATH_REMOVE_DT_TM DATETIME Y Identifies the start date/time of a suprapubic catheter
CATH_REMOVE_UTC_DT_TM DATETIME Y Identifies the start date/time of a suprapubic catheter normalized to GMT
CHRONIC_WOUND_CARE_IND DOUBLE Y Identifies if there is an intervention performed for Chronic Wound Care
CLINDAMYCIN_DT_TM DATETIME Y Identifies the date/time that clindamycin was ordered
CLINDAMYCIN_UTC_DT_TM DATETIME Y Identifies the date/time that clindamycin was ordered normalized to GMT
CLINICAL_TRIAL_IND DOUBLE Y Identifies if the patient is a clinical trial participant
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEFIB_DEVICE_DT_TM DATETIME Y Identifies the date/time that the pacemaker or implantable defibrillator device was applied
DEFIB_DEVICE_UTC_DT_TM DATETIME Y Identifies the date/time that the pacemaker or implantable defibrillator device was applied normalized to GMT
DEFIB_PROC_DT_TM DATETIME Y Identifies the date/time that the pacemaker or implantable defibrillator procedure was performed
DEFIB_PROC_UTC_DT_TM DATETIME Y Identifies the date/time that the pacemaker or implantable defibrillator procedure was performed normalized to GMT
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.
DIURETICS_IND DOUBLE Y Identifies if the patient had diuretics ordered within 2 days of SCIP major surgery
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_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_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.
ERYTHROMYCIN_DT_TM DATETIME Y Identifies the date/time that ERYTHROMYCIN was ordered
ERYTHROMYCIN_UTC_DT_TM DATETIME Y Identifies the date/time that aminoglycosides were ordered normalized to GMT
EXCLUDE_9_IND DOUBLE N Identifies if the encounter is Excluded for Inf-9
EXCLUDE_INF_1_1_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 1
EXCLUDE_INF_1_2_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 2
EXCLUDE_INF_1_3_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 3
EXCLUDE_INF_1_4_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 4
EXCLUDE_INF_1_5_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 5
EXCLUDE_INF_1_6_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 6
EXCLUDE_INF_1_7_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 7
EXCLUDE_INF_1_8_IND DOUBLE N Identifies if the encounter is excluded for Inf-1 Subpopulation 8
EXCLUDE_INF_2_1_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 1
EXCLUDE_INF_2_2_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 2
EXCLUDE_INF_2_3_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 3
EXCLUDE_INF_2_4_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 4
EXCLUDE_INF_2_5_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 5
EXCLUDE_INF_2_6_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 6
EXCLUDE_INF_2_7_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 7
EXCLUDE_INF_2_8_IND DOUBLE N Identifies if the encounter is excluded for Inf-2 Subpopulation 8
EXPIRED_DT_TM DATETIME Y Identifies the date/time that the patient expired
EXPIRED_UTC_DT_TM DATETIME Y Identifies the date/time that the patient expired normalized to GMT
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.
GEN_NEURAXIAL_IND DOUBLE Y Identifies if there was evidence of a surgery procedure requiring general or neuraxial anesthesia
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.
HEMO_PERI_DIALYSIS_IND DOUBLE Y Identifies if the patient has had a procedure of Hemodialysis or Peritoneal Dialysis within 1 year of the procedure
HYSTERECTOMY_ABX_DT_TM DATETIME Y Identifies the date/time that hysterectomy antibiotics were ordered
HYSTERECTOMY_ABX_UTC_DT_TM DATETIME Y Identifies the date/time that hysterectomy antibiotics were ordered normalized to GMT
HYST_QUINOLONES_DT_TM DATETIME Y Identifies the date/time that hysterectomy/colon quinolones were ordered
HYST_QUINOLONES_UTC_DT_TM DATETIME Y Identifies the date/time that hysterectomy/colon quinolones were ordered normalized to GMT
ICU_LOC_IND DOUBLE Y Identifies if the patient was in an ICU location within 2 days of having SCIP Major Surgery
INDWELL_CATH_END_DT_TM DATETIME Y Identifies the end date/time of the indwelling urinary catheter
INDWELL_CATH_END_UTC_DT_TM DATETIME Y Identifies the end date/time of the indwelling urinary catheter normalized to GMT
INDWELL_CATH_START_DT_TM DATETIME Y Identifies the start date/time of the indwelling urinary catheter
INDWELL_CATH_START_UTC_DT_TM DATETIME Y Identifies the start date/time of the indwelling urinary catheter normalized to GMT
INFECTION_DX_DT_TM DATETIME Y Identifies the date/time of the diagnosis of any infection
INFECTION_DX_UTC_DT_TM DATETIME Y Identifies the date/time of the diagnosis of any infection normalized to GMT
INOTROPIC_IND DOUBLE Y Identifies if the patient had inotropic and vasopressor agents given within 2 days of SCIP major surgery
INTERMITTENT_CATH_DT_TM DATETIME Y Identifies the start date/time of an intermittent catheter
INTERMITTENT_CATH_UTC_DT_TM DATETIME Y Identifies the start date/time of an intermittent catheter normalized to GMT
IV_ANTIMICROBIAL_DT_TM DATETIME Y Identifies the date/time that IV Antimicrobial were ordered
IV_ANTIMICROBIAL_UTC_DT_TM DATETIME Y Identifies the date/time that IV Antimicrobial were ordered normalized to GMT
IV_ARTH_COLON_ABX_DT_TM DATETIME Y Identifies the date/time that IV Arthroplasty/Colon Antibiotics was ordered
IV_ARTH_COLON_ABX_UTC_DT_TM DATETIME Y Identifies the date/time that IV Arthroplasty/Colon Antibiotics was ordered normalized to GMT
IV_COLON_ABX_DT_TM DATETIME Y Identifies the date/time that IV Colon Antibiotics was ordered
IV_COLON_ABX_UTC_DT_TM DATETIME Y Identifies the date/time that IV Colon Antibiotics was ordered normalized to GMT
IV_ERTAPENEM_ABX_DT_TM DATETIME Y Identifies the date/time that IV Ertapenem was ordered
IV_ERTAPENEM_ABX_UTC_DT_TM DATETIME Y Identifies the date/time that IV Ertapenem was ordered normalized to GMT
IV_METRONIDAZOLE_DT_TM DATETIME Y Identifies the date/time that IV metronidazole was ordered
IV_METRONIDAZOLE_UTC_DT_TM DATETIME Y Identifies the date/time that IV metronidazole was ordered normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LH_E_SCIP_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_SCIP_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, if you assign clients a logical_domain_id, this would allow you to store data for multiple clients on this table.
MRSA_DX_IND DOUBLE Y Identifies if there is an active diagnosis of MRSA colonization or infection
NEOMYCIN_DT_TM DATETIME Y Identifies the date/time that NEOMYCIN was ordered
NEOMYCIN_UTC_DT_TM DATETIME Y Identifies the date/time that aminoglycosides were ordered normalized to GMT
NOT_IN_DEN_INF_1_1_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 1
NOT_IN_DEN_INF_1_2_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 2
NOT_IN_DEN_INF_1_3_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 3
NOT_IN_DEN_INF_1_4_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 4
NOT_IN_DEN_INF_1_5_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 5
NOT_IN_DEN_INF_1_6_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 6
NOT_IN_DEN_INF_1_7_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 7
NOT_IN_DEN_INF_1_8_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-1 Subpopulation 8
NOT_IN_DEN_INF_2_1_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 1
NOT_IN_DEN_INF_2_2_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 2
NOT_IN_DEN_INF_2_3_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 3
NOT_IN_DEN_INF_2_4_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 4
NOT_IN_DEN_INF_2_5_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 5
NOT_IN_DEN_INF_2_6_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 6
NOT_IN_DEN_INF_2_7_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 7
NOT_IN_DEN_INF_2_8_IND DOUBLE N Identifies if the encounter is not in denominator for Inf-2 Subpopulation 8
NOT_IN_DEN_INF_9_IND DOUBLE N Identifies if the encounter is Not in Denominator for Inf-9
NO_CATH_MED_REASON_DT_TM DATETIME Y Identifies when it was documented that a catheter wasn't given due to a medical reason
NO_CATH_MED_REASON_UTC_DT_TM DATETIME Y Identifies when it was documented that a catheter wasn't given due to a medical reason normalized to GMT
NUMERATOR_9_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-9
NUMERATOR_INF_1_1_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 1
NUMERATOR_INF_1_2_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 2
NUMERATOR_INF_1_3_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 3
NUMERATOR_INF_1_4_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 4
NUMERATOR_INF_1_5_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 5
NUMERATOR_INF_1_6_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 6
NUMERATOR_INF_1_7_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 7
NUMERATOR_INF_1_8_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-1 Subpopulation 8
NUMERATOR_INF_2_1_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 1
NUMERATOR_INF_2_2_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 2
NUMERATOR_INF_2_3_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 3
NUMERATOR_INF_2_4_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 4
NUMERATOR_INF_2_5_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 5
NUMERATOR_INF_2_6_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 6
NUMERATOR_INF_2_7_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 7
NUMERATOR_INF_2_8_IND DOUBLE N Identifies if the encounter is in the numerator for Inf-2 Subpopulation 8
NURSING_HOME_DISCH_DT_TM DATETIME Y Identifies the date/time that the patient was discharged from a nursing home or extended care facility
NURSING_HOME_DISCH_UTC_DT_TM DATETIME Y Identifies the date/time that the patient was discharged from a nursing home or extended care facility normalized to GMT
NURSING_HOME_IND DOUBLE Y Identifies if the admission source for the encounter was a nursing home or extended care facility
ORAL_METRONIDAZOLE_DT_TM DATETIME Y Identifies the date/time that ORAL_METRONIDAZOLE was ordered
ORAL_METRONIDAZOLE_UTC_DT_TM DATETIME Y Identifies the date/time that aminoglycosides were ordered normalized to GMT
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PARALYTIC_AGENT_IND DOUBLE Y Identifies if the patient had paralytic agents given within 2 days of SCIP major surgery
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.
PHYSICAN_REQUEST_IND DOUBLE Y Identifies if vancoymicin was ordered at the request of a physician
POPULATION_IND DOUBLE Y Identifies if the patient is in the population for the SCIP Metric
PRINCIPAL_PROC_FLAG DOUBLE N Identifies the principal procedure during the inpatient encounter
PRIN_DX_INFECTION_IND DOUBLE Y Identifies if the principal diagnosis was infection
PRIN_PROC_CSECTION_IND DOUBLE Y Identifies if the principal procedure performed during the inpatient encounter was a C-Section
PRIOR_INPT_1_YEAR_IND DOUBLE Y Identifies if the patient has had an inpatient encounter within the previous year
PROCEDURE_DT_TM DATETIME Y Identifies when the procedure started
PROCEDURE_UTC_DT_TM DATETIME Y Identifies when the procedure started normalized to GMT
QUINOLONES_DT_TM DATETIME Y Identifies the date/time that quinolones were ordered
QUINOLONES_UTC_DT_TM DATETIME Y Identifies the date/time that quinolones were ordered normalized to GMT
SCIP_MAJOR_SURG_IND DOUBLE Y Identifies if the principal procedure performed during the encounter was a SCIP Major Surgical Procedure
SUPRAPUBIC_CATH_DT_TM DATETIME Y Identifies the start date/time of a suprapubic catheter
SUPRAPUBIC_CATH_UTC_DT_TM DATETIME Y Identifies the start date/time of a suprapubic catheter normalized to GMT
SURGERY_END_DT_TM DATETIME Y Identifies when surgery ended
SURGERY_END_UTC_DT_TM DATETIME Y Identifies when surgery ended normalized to GMT
SURGERY_START_DT_TM DATETIME Y Identifies when surgery started
SURGERY_START_UTC_DT_TM DATETIME Y Identifies when surgery started normalized to GMT
TRANS_FROM_ACUTE_CARE_IND DOUBLE Y Identifies if the patient was transferred from an Acute Care Hospital
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.
URETHRA_IND DOUBLE Y Identifies if the anatomical structure was urethra for the catheter
URINARY_DIVERSION_IND DOUBLE Y Identifies if there was a finding of urinary division during a physical exam more than 1 minute after surgery started
URINARY_DIVERSION_PROC_IND DOUBLE Y Identifies if there was a procedure for urinary diversion
URO_PROC_IND DOUBLE Y Identifies if the principal procedure during the inpatient encounter was a urological procedure with need for a catheter
VANCOMYCIN_DT_TM DATETIME Y Identifies the date/time that vancomycin were ordered
VANCOMYCIN_UTC_DT_TM DATETIME Y Identifies the date/time that vancomycin were ordered normalized to GMT



Relationship Detail - LH_E_SCIP_METRICS


Child Column in LH_E_SCIP_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
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_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
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_STEMI_2023_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures STEMI ED 2023 Metrics
Definition: Stores data gathered by the LH_E_STEMI_2023 script.
Table Type: ACTIVITY





Column Detail - LH_E_STEMI_2023_METRICS


Column Name Type Null? Definition
ACTIVE_BLEEDING_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ACTIVE_BLEEDING_OR_BLEEDING_DIATHESIS_EXCLUDING_MENSES
ACTIVE_BLEEDING_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ACTIVE_BLEEDING_OR_BLEEDING_DIATHESIS_EXCLUDING_MENSES
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.
ACTIVE_PEP_ULC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ACTIVE_PEPTIC_ULCER
ACTIVE_PEP_ULC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ACTIVE_PEPTIC_ULCER
ALLERGY_TO_THROM_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ALLERGY_TO_THROMBOLYTICS
ALLERGY_TO_THROM_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ALLERGY_TO_THROMBOLYTICS
ANTICOAG_MED_ORAL_DT_TM DATETIME Y Order active dt/tm for qualifying medication order for value set 'ANTICOAGULANT_MEDICATIONS_ORAL'
ANTICOAG_MED_ORAL_ORD_DETAIL VARCHAR(100) Y Order details for qualifying medication order for value set 'ANTICOAGULANT_MEDICATIONS_ORAL'
AORTIC_DIS_RUP_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for AORTIC_DISSECTION_AND_RUPTURE
AORTIC_DIS_RUP_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for AORTIC_DISSECTION_AND_RUPTURE
CARDIO_ARREST_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for CARDIOPULMONARY_ARREST
CARDIO_ARREST_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for CARDIOPULMONARY_ARREST
CEREBRAL_VASC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for CEREBRAL_VASCULAR_LESION
CEREBRAL_VASC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for CEREBRAL_VASCULAR_LESION
CLOSED_HEAD_FAC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for CLOSED_HEAD_AND_FACIAL_TRAUMA
CLOSED_HEAD_FAC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for CLOSED_HEAD_AND_FACIAL_TRAUMA
DEMENTIA_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for DEMENTIA
DEMENTIA_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for DEMENTIA
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
DISCH_ACUTE_CARE_IND DOUBLE Y Indicates if patient was discharged to Acute care facility
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_1_ID DOUBLE N Dimension ID for STEMI ED 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.
ED_LOC_END_DT_TM DATETIME Y The end of the emergency location.
ED_LOC_START_DT_TM DATETIME Y The start of the emergency location.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
ENDO_INTUBATION_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for ENDOTRACHEAL_INTUBATION
ENDO_INTUBATION_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for ENDOTRACHEAL_INTUBATION
EXCLUDE_IND DOUBLE Y Identifies if the encounter is Excluded for STEMI
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.
FT_ADMIN_DT_TM DATETIME Y Identifies the date/time Fibrinolytic therapy medication was administered
FT_ADMIN_ORD_DETAIL VARCHAR(100) Y Order details for qualifying medication order for value set 'FIBRINOLYTIC_THERAPY'
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.
INTRAC_INTRAS_SURG_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for INTRACRANIAL_OR_INTRASPINAL_SURGERY
INTRAC_INTRAS_SURG_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for INTRACRANIAL_OR_INTRASPINAL_SURGERY
IPP_IND DOUBLE Y Indicates the encounter within the initial patient population
ISCHEMIC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ISCHEMIC_STROKE
ISCHEMIC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ISCHEMIC_STROKE
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_STEMI_2023_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_STEMI_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.
MAJOR_SURG_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for MAJOR_SURGICAL_PROCEDURE
MAJOR_SURG_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for MAJOR_SURGICAL_PROCEDURE
MALIGNANT_INTRA_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for MALIGNANT_INTRACRANIAL_NEOPLASM_GROUP
MALIGNANT_INTRA_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for MALIGNANT_INTRACRANIAL_NEOPLASM_GROUP
MECH_CIRC_DEVICE_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for MECHANICAL_CIRCULATORY_ASSIST_DEVICE
MECH_CIRC_DEVICE_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for MECHANICAL_CIRCULATORY_ASSIST_DEVICE
NEURO_IMP_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for NEUROLOGIC_IMPAIRMENT
NEURO_IMP_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for NEUROLOGIC_IMPAIRMENT
NUM_IND DOUBLE Y Identifies if the encounter is in the Numerator for STEMI
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.
PAT_EXPIRED_IND DOUBLE Y Indicates if patient exipred
PERC_CORO_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for PERCUTANEOUS_CORONARY_INTERVENTION
PERC_CORO_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for PERCUTANEOUS_CORONARY_INTERVENTION
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.
PREGNANCY_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for PREGNANCY
PREGNANCY_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for PREGNANCY
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
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.
STEMI_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for STEMI
STEMI_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for STEMI
THROM_MED_ADV_EVENT_IND DOUBLE Y Identifies if there was any adverse reaction to Allergy for not giving Thrombolytic meds
THROM_MED_ALLERGY_IND DOUBLE Y Identifies if there was a Allergy Reason for not giving Thrombolytic meds
TIME_ZONE_TXT VARCHAR(100) 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.



Relationship Detail - LH_E_STEMI_2023_METRICS


Child Column in LH_E_STEMI_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_1_ID LH_D_METRIC D_METRIC_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_STEMI_2024_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures STEMI ED 2024 Metrics
Definition: Stores data gathered by the LH_E_STEMI_2024 script.
Table Type: ACTIVITY





Column Detail - LH_E_STEMI_2024_METRICS


Column Name Type Null? Definition
ACTIVE_BLEEDING_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ACTIVE_BLEEDING_OR_BLEEDING_DIATHESIS_EXCLUDING_MENSES
ACTIVE_BLEEDING_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ACTIVE_BLEEDING_OR_BLEEDING_DIATHESIS_EXCLUDING_MENSES
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.
ACTIVE_PEP_ULC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ACTIVE_PEPTIC_ULCER
ACTIVE_PEP_ULC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ACTIVE_PEPTIC_ULCER
ALLERGY_TO_THROM_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ALLERGY_TO_THROMBOLYTICS
ALLERGY_TO_THROM_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ALLERGY_TO_THROMBOLYTICS
ANTICOAG_MED_ORAL_DT_TM DATETIME Y Order active dt/tm for qualifying medication order for value set 'ANTICOAGULANT_MEDICATIONS_ORAL'
ANTICOAG_MED_ORAL_ORD_DETAIL VARCHAR(100) Y Order details for qualifying medication order for value set 'ANTICOAGULANT_MEDICATIONS_ORAL'
AORTIC_DIS_RUP_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for AORTIC_DISSECTION_AND_RUPTURE
AORTIC_DIS_RUP_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for AORTIC_DISSECTION_AND_RUPTURE
CARDIO_ARREST_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for CARDIOPULMONARY_ARREST
CARDIO_ARREST_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for CARDIOPULMONARY_ARREST
CEREBRAL_VASC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for CEREBRAL_VASCULAR_LESION
CEREBRAL_VASC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for CEREBRAL_VASCULAR_LESION
CLOSED_HEAD_FAC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for CLOSED_HEAD_AND_FACIAL_TRAUMA
CLOSED_HEAD_FAC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for CLOSED_HEAD_AND_FACIAL_TRAUMA
DEMENTIA_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for DEMENTIA
DEMENTIA_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for DEMENTIA
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
DISCH_ACUTE_CARE_IND DOUBLE Y Indicates if patient was discharged to Acute care facility
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_1_ID DOUBLE N Dimension ID for STEMI ED 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.
ED_LOC_END_DT_TM DATETIME Y The end of the emergency location.
ED_LOC_START_DT_TM DATETIME Y The start of the emergency location.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
ENDO_INTUBATION_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for ENDOTRACHEAL_INTUBATION
ENDO_INTUBATION_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for ENDOTRACHEAL_INTUBATION
EXCLUDE_IND DOUBLE Y Identifies if the encounter is Excluded for STEMI
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.
FT_ADMIN_DT_TM DATETIME Y Identifies the date/time Fibrinolytic therapy medication was administered
FT_ADMIN_ORD_DETAIL VARCHAR(100) Y Order details for qualifying medication order for value set 'FIBRINOLYTIC_THERAPY'
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.
INTRAC_INTRAS_SURG_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for INTRACRANIAL_OR_INTRASPINAL_SURGERY
INTRAC_INTRAS_SURG_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for INTRACRANIAL_OR_INTRASPINAL_SURGERY
IPP_IND DOUBLE Y Indicates the encounter within the initial patient population
ISCHEMIC_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for ISCHEMIC_STROKE
ISCHEMIC_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for ISCHEMIC_STROKE
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_STEMI_2024_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_STEMI_2024_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.
MAJOR_SURG_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for MAJOR_SURGICAL_PROCEDURE
MAJOR_SURG_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for MAJOR_SURGICAL_PROCEDURE
MALIGNANT_INTRA_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for MALIGNANT_INTRACRANIAL_NEOPLASM_GROUP
MALIGNANT_INTRA_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for MALIGNANT_INTRACRANIAL_NEOPLASM_GROUP
MECH_CIRC_DEVICE_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for MECHANICAL_CIRCULATORY_ASSIST_DEVICE
MECH_CIRC_DEVICE_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for MECHANICAL_CIRCULATORY_ASSIST_DEVICE
NEURO_IMP_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for NEUROLOGIC_IMPAIRMENT
NEURO_IMP_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for NEUROLOGIC_IMPAIRMENT
NUM_IND DOUBLE Y Identifies if the encounter is in the Numerator for STEMI
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.
PAT_EXPIRED_IND DOUBLE Y Indicates if patient exipred
PERC_CORO_PROC_DT_TM DATETIME Y Identifies the documentation time on procedure for PERCUTANEOUS_CORONARY_INTERVENTION
PERC_CORO_PROC_NOMEN VARCHAR(50) Y Identifies the documentation code procedure for PERCUTANEOUS_CORONARY_INTERVENTION
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.
PREGNANCY_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for PREGNANCY
PREGNANCY_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for PREGNANCY
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
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.
STEMI_DX_DT_TM DATETIME Y Identifies the documentation time on diagnosis for STEMI
STEMI_DX_NOMEN VARCHAR(50) Y Identifies the documentation code diagnosis for STEMI
THROM_MED_ADV_EVENT_IND DOUBLE Y Identifies if there was any adverse reaction to Allergy for not giving Thrombolytic meds
THROM_MED_ALLERGY_IND DOUBLE Y Identifies if there was a Allergy Reason for not giving Thrombolytic meds
TIME_ZONE_TXT VARCHAR(100) 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.



Relationship Detail - LH_E_STEMI_2024_METRICS


Child Column in LH_E_STEMI_2024_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_1_ID LH_D_METRIC D_METRIC_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