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 |