Table Detail Report

LH_E_PCM_2024_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures PCM 2024 Metrics
Definition: Stores data gathered by the LH_E_PCM_2024 script.
Table Type: ACTIVITY





Column Detail - LH_E_PCM_2024_METRICS


Column Name Type Null? Definition
ABNORMAL_PRES_ASSESS_TXT VARCHAR(60) Y The result of an Abnormal Presentation Assessment.
ABNORMAL_PRES_DIAG_NOMEN VARCHAR(60) Y The nomenclature for an Abnormal Presentation diagnosis.
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.
BLOOD_TRANS_PROC_DT_TM DATETIME Y The date/time of Blood Transfusion Procedure.
BLOOD_TRANS_PROC_NOMEN VARCHAR(60) Y The nomenclature for Blood Transfusion Procedure.
CALC_GEST_AGE_DELIVERY DOUBLE Y Gestational age as calculated from the estimated and actual times of delivery (weeks)
CLASS_CSECTION_PROC_DT_TM DATETIME Y The date/time of a classical C-Section documented
CLASS_CSECTION_PROC_NOMEN VARCHAR(60) Y The nomenclature of a classical C-Section documented
COVID19_CONFIRMED_DX_DT_TM DATETIME Y The date/time of COVID 19 Confirmed diagnosis.
COVID19_CONFIRMED_DX_NOMEN VARCHAR(60) Y The nomenclature for COVID 19 Confirmed diagnosis.
COVID19_RESP_DX_DT_TM DATETIME Y The date/time of COVID 19 Related Respiratory Condition diagnosis.
COVID19_RESP_DX_NOMEN VARCHAR(60) Y The nomenclature for COVID 19 Related Respiratory Condition diagnosis.
COVID19_RESP_PROC_DT_TM DATETIME Y The date/time of COVID 19 Related Respiratory Condition procedure.
COVID19_RESP_PROC_NOMEN VARCHAR(60) Y The nomenclature for COVID 19 Related Respiratory Condition procedure.
CSECTION_PROC_NOMEN VARCHAR(60) Y The nomen of the C-Section procedure documented
DELIVERY_DATE_ESTIMATED_DT_TM DATETIME Y Identifies the estimated date/time for the delivery
DELIVERY_PROC_NOMEN VARCHAR(60) Y The nomenclature of the delivery procedure documented
DEN_1_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC01
DEN_2_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC02
DEN_7_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC07
DINOPROSTONE_DT_TM DATETIME Y The date/time Dinonprostone was administered during the inpatient encounter and prior to labor date/time
DINOPROSTONE_ORD_DETAIL VARCHAR(100) Y Order details for qualifying medication administration for Dinoprostone
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
D_ADMIT_BUILDING_ID DOUBLE N Dimension ID for admit building.
D_ADMIT_FACILITY_ID DOUBLE N Dimension ID for admit facility.
D_ADMIT_NURSE_UNIT_ID DOUBLE N Dimension ID for admit nurse unit.
D_ADMIT_SRC_ID DOUBLE N Dimension ID for admit source.
D_ADMIT_TYPE_ID DOUBLE N Dimension ID for admit type.
D_ATTEND_PRSNL_ID DOUBLE N Dimension ID for attending physician.
D_BR_CCN_ID DOUBLE N Dimension ID for CCN.
D_BR_HCO_ID DOUBLE N Dimension ID for HCO.
D_DISCHARGE_BUILDING_ID DOUBLE N Dimension ID for discharge building.
D_DISCHARGE_FACILITY_ID DOUBLE N Dimension ID for discharge facility.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Dimension ID for discharge nurse unit.
D_DISCH_DISP_ID DOUBLE N Dimension ID for discharge disposition.
D_ENCNTR_TYPE_ID DOUBLE N Dimension ID for encounter type.
D_METRIC_1_ID DOUBLE N Dimension ID for ED-1 metric.
D_METRIC_2_ID DOUBLE N Dimension ID for ED-2 metric.
D_METRIC_7_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric for PC-07
D_PERSON_ID DOUBLE N Dimension ID for person data.
ECTOPIC_PREGNANCY_DT_TM DATETIME Y The date/time of cornual ectopic pregnancy resolved priro to admission
ECTOPIC_PREGNANCY_NOMEN VARCHAR(60) Y The nomenclature of cornual ectopic pregnancy resolved priro to admission
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.
ELECT_DELIV_39_WKS_NOMEN VARCHAR(60) Y The nomenclature of the problem/diagnosis of elective delivery prior to 39 weeks
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
EST_GEST_AGE_DELIVERY DOUBLE Y Any estimated gestational age up to a day before delivery (weeks)
EXCLUDE_1_IND DOUBLE Y Identifies if the patient is excluded for PC01
EXCLUDE_2_IND DOUBLE Y Identifies if the patient is excluded for PC02
EXCLUDE_7_IND DOUBLE Y Identifies if the patient is excluded for PC07
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.
GEST_WKS_20_TO_42_DX_NOMEN VARCHAR(60) Y Diagnosis code that qualified for valueset 20 to 42 Plus Weeks Gestation.
GEST_WKS_37_TO_38_DX_NOMEN VARCHAR(60) Y Diagnosis code that qualified for valueset 37_to_38_weeks_gestation.
GEST_WKS_37_TO_42_DX_NOMEN VARCHAR(60) Y Diagnosis code that qualified for valueset 37 to 42 Plus Weeks Gestation.
GRAVIDA_NBR DOUBLE Y The Gravida number (total number of pregnancies including the current one)
HCT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first hematocrit lab test for the episode of care.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HEART_RATE_RSLT_DT_TM DATETIME Y The date/time of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_TXT VARCHAR(30) Y The result of the first heart rate recorded for the episode of care.
IPP_IND DOUBLE Y Identifies if the patient was in the PC Mother Population
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
LABOR_DT_TM DATETIME Y Identifies the date/time of labor
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_PCM_2024_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PCM_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.
MED_INDUCT_LABOR_NOMEN VARCHAR(60) Y The nomenclature of Medically induced labor
METROPLASTY_PROC_DT_TM DATETIME Y The nomenclature of Metroplasty procedure
METROPLASTY_PROC_NOMEN VARCHAR(60) Y The date/time of the Metroplasty Procedure
MYOMECTOMY_PROC_DT_TM DATETIME Y The date/time of the Myomectomy Procedure
MYOMECTOMY_PROC_NOMEN VARCHAR(60) Y The nomenclature of myomectomy documented
NUM_1_IND DOUBLE Y Identifies if the patient is in the numerator for PC01
NUM_2_IND DOUBLE Y Identifies if the patient is in the numerator for PC02
NUM_7_IND DOUBLE Y Identifies if the patient is in the numerator for PC07
NUM_7_STRATUM_1_IND DOUBLE Y Indicator to show if encounter meets Stratum-1 population for Numerator on PC-07 metrics
OBS_SERV_ARRIVAL_DT_TM DATETIME Y The start of the observation encounter.
OBS_SERV_DEPART_DT_TM DATETIME Y The end of the observation encounter.
OBS_SERV_ENCNTR_ID DOUBLE N The ID of the observation services encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
OXYTOCIN_DT_TM DATETIME Y The date/time Oxytocin was administered during the inpatient encounter and prior to labor date/time
OXYTOCIN_ORD_DETAIL VARCHAR(100) Y Order details for qualifying medication administration for Oxytocin.
PARITY_NBR DOUBLE Y The Parity Number (total number of previous pregnancies that lasted > 20 Weeks)
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.
PERF_OF_UTERUS_DT_TM DATETIME Y The date/time of the Perforation of the Uterus resolved prior to admission
PERF_OF_UTERUS_NOMEN VARCHAR(60) Y The nomenclature of Perforation of the Uterus resolved prior to admission
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.
PLACENTA_PREVIA_NOMEN VARCHAR(60) Y The nomenclature of a Placenta Previa diagnosis.
PRESENT_ON_ADMISSION_DESC VARCHAR(60) Y Code value description for Code Set 4002009
PRESENT_ON_ADMISSION_YOE_DESC VARCHAR(60) Y Code value description for Code Set 4002009
PRETERM_BIRTH_NBR DOUBLE Y The number of previous preterm births
RVA_ANEMIA_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Anemia
RVA_ASTHMA_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Asthma
RVA_AUTO_DISEASE_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Autoimmune Disease
RVA_BARIATRIC_SURG_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Bariatric Surgery
RVA_BLEEDING_DISORD_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Bleeding Disorder
RVA_BMI_DX_NOMEN VARCHAR(60) Y ***OBSOLETE***Diagnosis Code for BMI
RVA_CARDIAC_DISEASE_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Cardiac Disease
RVA_ECON_HOUSING_INS_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Economic Housing Instability
RVA_GASTROINT_DISEASE_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Gastrointestinal Disease
RVA_GEST_DIABETES_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Gestational Diabetes
RVA_HIV_DX_NOMEN VARCHAR(60) Y Diagnosis Code for HIV
RVA_HYPERTENSION_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Hypertension
RVA_LONG_TERM_ATG_USE_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Long Term Anticoagulant Use
RVA_MENTAL_HLTH_DIS_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Mental Health Disorder
RVA_MILD_PREECLAMP_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Mild or Moderate Preeclampsia
RVA_MORB_SEV_OBESITY_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Morbid Severe Obesity
RVA_MULTIPLE_PREG_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Multiple Pregnancy
RVA_NEUROMUSC_DISEASE_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Neuromuscular Disease
RVA_OBSTETRICAL_VTE_DX_NOMEN VARCHAR(60) Y ***OBSOLETE***Diagnosis Code for Obstetrical VTE
RVA_OTHER_PREECLAMP_DX_NOMEN VARCHAR(60) Y ***OBSOLETE***Diagnosis Code for Other Preeclampsia
RVA_PLACENTAL_ABRUP_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Placental Abruption
RVA_PLACENTAL_ACCRETA_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Placental Accreta Spectrum
RVA_PLACENTA_PREVIA_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Placenta Previa
RVA_PREEXISTING_DIAB_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Preexisting Diabetes
RVA_PRETERM_BIRTH_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Preterm Birth
RVA_PREVIOUS_CESAREAN_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Previous Cesarean
RVA_PULM_HYPERTENSION_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Pulmonary Hypertension
RVA_RENAL_DISEASE_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Renal Disease
RVA_SEVERE_PREECLAMP_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Severe Preeclampsia
RVA_SUBS_ABUSE_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Substance Abuse
RVA_THYROTOXICOSIS_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Thyrotoxicosis
RVA_VTE_IN_PREG_DX_NOMEN VARCHAR(60) Y Diagnosis Code for Venous Thromboembolism in Pregnancy
SBP_RSLT_DT_TM DATETIME Y The date/time of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_TXT VARCHAR(30) Y The result of the first systolic blood pressure recorded for the episode of care.
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
SEVERE_MAT_MORB_DX_DT_TM DATETIME Y The date/time of Severe Maternal Morbidity diagnosis.
SEVERE_MAT_MORB_DX_NOMEN VARCHAR(60) Y The nomenclature for Severe Maternal Morbidity diagnosis.
SEVERE_MAT_MORB_PROC_DT_TM DATETIME Y The date/time of Severe Maternal Morbidity Procedure.
SEVERE_MAT_MORB_PROC_NOMEN VARCHAR(60) Y The nomenclature for Severe Maternal Morbidity Procedure.
SINGLETON_DELIVERY_NOMEN VARCHAR(60) Y The nomenclature for a Singleton Delivery
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.
TERM_BIRTH_NBR DOUBLE Y The number of previous term births.
TIME_OF_DELIVERY_DT_TM DATETIME Y Identifies the date/time of the delivery
TIME_ZONE_TXT VARCHAR(100) Y The timezone of the record in ""America/Chicago"" format.
TRANS_CERCLAGE_DT_TM DATETIME Y The date/time of the Transabdominal Cerclage
TRANS_CERCLAGE_NOMEN VARCHAR(60) Y The nomenclature of Transabdominal Cerclage
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.
UTERINE_HORN_DT_TM DATETIME Y The date/time of the Uterine Horn procedure
UTERINE_HORN_NOMEN VARCHAR(60) Y The nomenclature of Uterine Horn procedure
UTERINE_RUPTURE_DT_TM DATETIME Y The date/time of the Uterine Rupture resolved prior to admission
UTERINE_RUPTURE_NOMEN VARCHAR(60) Y The nomenclature of uterine rupture resolved prior to admission
UTERINE_WINDOW_DT_TM DATETIME Y The date/time of the Uterine Window resolved prior to admission
UTERINE_WINDOW_NOMEN VARCHAR(60) Y The nomenclature of uterine window resolved prior to admissoin
WBC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first white blood cells count lab test for the episode of care.



Relationship Detail - LH_E_PCM_2024_METRICS


Child Column in LH_E_PCM_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
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_7_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_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_PC_2016_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_PC_2016_METRICS
Definition: This table is used to store eMeasure PC Metrics for the 2016 reporting period. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_PC_2016_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
ART_RUPTURE_MEMBRANE_IND DOUBLE Y Identifies if there was documentation of an artificial rupture of membranes
ART_RUPTURE_MEMB_PROC_NOMEN VARCHAR(50) Y Art Rupture_Membrane Procedure code or key from the source vocabulary
BIRTH_DOC_DT_TM DATETIME Y Identifies the date/time that the birth was documented
BIRTH_DOC_UTC_DT_TM DATETIME Y Identifies the date/time that the birth was documented normalized to GMT
BREAST_MILK_IND DOUBLE Y Identifies if there was documentation of breast milk
CLASS_CSECTION_PROC_CE_IND DOUBLE Y Identifies if there was a clinical event of a classical C-Section documented
CLASS_CSECTION_PROC_CS_IND DOUBLE Y Identifies if there was documentation of a classical C-Section via codeset 4002119
CLASS_CSECTION_PROC_IND DOUBLE Y Identifies if the patient had a classical C-Section documented as a procedure
CLASS_CSECTION_PROC_NOMEN VARCHAR(50) Y Class Csection Procedure code or key from the source vocabulary
COMPLICATION_LABOR_DX_IND DOUBLE Y Identifies if there was a complication mainly in the course of labor and delivery diagnosis documented
COMPLICATION_LABOR_DX_NOMEN VARCHAR(50) Y Complication Labor Diagnosis code or key from the source vocabulary
COMPLICATION_PREGNANCY_DX_IND DOUBLE Y Identifies if there was a complication mainly related to the pregnancy diagnosis documented
COMPLICATION_PREG_DX_NOMEN VARCHAR(50) Y Complication Pregnancy Diagnosis code or key from the source vocabulary
COMPLICATION_PUERPERIUM_DX_IND DOUBLE Y Identifies if there was a complication of the puerperium diagnosis documented
COMPLICATION_PUERP_DX_NOMEN VARCHAR(50) Y Complication Puerperium Diagnosis code or key from the source vocabulary
CSECTION_DT_TM DATETIME Y Identifies the date/time that the C-Section was documented
CSECTION_PROC_CE_IND DOUBLE Y Identifies if there was a C-Section procedure documented as a clinical event
CSECTION_PROC_CS_IND DOUBLE Y Identifies if there was a C-Section documented via codeset 4002119
CSECTION_PROC_IND DOUBLE Y Identifies if there was a C-Section procedure documented
CSECTION_PROC_NOMEN VARCHAR(50) Y Csection Procedure code or key from the source vocabulary
CSECTION_UTC_DT_TM DATETIME Y Identifies the date/time that the C-Section was documented normalized to GMT
DELIVERY_PROC_CE_IND DOUBLE Y Identifies if there was a delivery procedure documented as a clinical event
DELIVERY_PROC_IND DOUBLE Y Identifies if there was a delivery procedure documented
DELIVERY_PROC_NOMEN VARCHAR(50) Y Delivery Procedure code or key from the source vocabulary
DIETARY_INTAKE_IND DOUBLE Y Identifies if there was documentation of dietary intake other than breastmilk documented
DINOPROSTONE_IND DOUBLE Y Identifies if Dinonprostone was administered during the inpatient encounter and prior to labor date/time
DINOP_MED_ADMIN_DT_TM DATETIME Y Date/Time when Dinoprostone Med was Administered
DINOP_MED_ADMIN_UTC_DT_TM DATETIME Y Date/Time when Dinoprostone Med was Administered normalized to UTC
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISCH_OTHER_HOSP_IND DOUBLE Y Identifies if the patient was discharged to another hospital
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_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.
ECTOPIC_PREGANCY_DX_NOMEN VARCHAR(50) Y Ectopic Pregancy Diagnosis code or key from the source vocabulary
ECTOPIC_PREGNANCY_PRIOR_IND DOUBLE Y Identifies if there was a problem of cornual ectopic pregnancy resolved prior to admission
ELECT_DELIV_39_WKS_DX_IND DOUBLE Y Identifies if there was a diagnosis of a Condition possibly justifying elective delivery prior to 39 weeks
ELECT_DELIV_39_WKS_PROB_IND DOUBLE Y Identifies if there was a problem of a Condition possibly justifying elective delivery prior to 39 weeks
ELECT_DELIV_DX_END_PRIOR_IND DOUBLE Y Identifies if there was a diagnosis of a Condition possibly justifying elective delivery prior to 39 weeks which was resolved prior to admission
ELECT_DELIV_PROB_END_PRIOR_IND DOUBLE Y Identifies if there was a problem of a Condition possibly justifying elective delivery prior to 39 weeks which was resolved prior to admission
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_PC05A_IND DOUBLE Y Identifies if the patient is excluded for PC05a
EXCLUDE_PC05_IND DOUBLE Y Identifies if the patient is excluded for PC05
EXPIRED_IND DOUBLE Y Identifies if the patient expired while in the hospital
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FEEDING_INTENT_BREAST_IND DOUBLE Y Identifies if there was documentation of feeding intention breast
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GALACTOSEMIA_DX_IND DOUBLE Y Identifies if there was a diagnosis of galactosemia
GALACTOSEMIA_DX_NOMEN VARCHAR(50) Y Galactosemia Diagnosis code or key from the source vocabulary.
GALACTOSEMIA_PROB_IND DOUBLE Y Identifies if there was a problem of galactosemia
GEST_AGE_DELI_OVR37_DT_TM DATETIME Y Identifies the date/time that estimated gestational age over 37 weeks was documented
GEST_AGE_DELI_OVR37_UTC_DT_TM DATETIME Y Identifies the date/time that estimated gestational age over 37 weeks was documented normalized to GMT
GEST_AGE_OVER37_DT_TM DATETIME Y Identifies the date/time that estimated gestational age over 37 weeks was documented
GEST_AGE_OVER37_UTC_DT_TM DATETIME Y Identifies the date/time that estimated gestational age over 37 weeks was documented normalized to GMT
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LABOR_DT_TM DATETIME Y Identifies the date/time of labor
LABOR_UTC_DT_TM DATETIME Y Identifies the date/time of labor normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_PC_2016_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PC_2016_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_INDUCT_LABOR_PROC_CE_IND DOUBLE Y Identifies a procedure of Medically induced labor documented via a clinical event
MED_INDUCT_LABOR_PROC_IND DOUBLE Y Identifies a procedure of Medically induced labor
MED_INDUCT_LABOR_PROC_NOMEN VARCHAR(50) Y Med Induct_Labor Procedure code or key from the source vocabulary
MYOMECTOMY_PROC_CE_IND DOUBLE Y Identifies a procedure of myomectomy documented via a clinical event
MYOMECTOMY_PROC_IND DOUBLE Y Identifies a procedure of myomectomy documented
MYOMECTOMY_PROC_NOMEN VARCHAR(50) Y Myomectomy Procedure code or key from the source vocabulary
NICU_IND DOUBLE Y Identifies if the patient had ever been in the NICU during their stay
NORMAL_DELIVERY_DX_IND DOUBLE Y Identifies if there was a diagnosis of a normal delivery documented
NORMAL_DELIVERY_DX_NOMEN VARCHAR(50) Y Normal Delivery Diagnosis code or key from the source vocabulary
NOT_IN_DEN_1_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC01
NUMERATOR_1_IND DOUBLE Y Identifies if the patient is in the numerator for PC01
NUMERATOR_PC05A_IND DOUBLE Y Identifies if the patient is in the numerator for PC05a
NUMERATOR_PC05_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.
OXYTOCIN_IND DOUBLE Y Identifies if Oxytocin was administered during the inpatient encounter and prior to labor date/time
OXYTOCIN_MED_ADMIN_DT_TM DATETIME Y Date/Time when Oxytocin Med was Administered
OXYTOCIN_MED_ADMIN_UTC_DT_TM DATETIME Y Date/Time when Oxytocin Med was Administered normalized to UTC
PARENTERAL_NUTRI_CE_IND DOUBLE Y Identifies if there was a clinical event documented of parenteral infusion
PARENTERAL_NUTRI_PROC_IND DOUBLE Y Identifies if there was a procedure documented of parenteral infusion
PARENTERAL_NUTRI_PROC_NOMEN VARCHAR(50) Y Parenteral Nutrition Procedure code or key from the source vocabulary.
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 for the encounter
PC01_POP_IND DOUBLE Y Identifies if the patient was in the PC01 Population
PC05A_POP_IND DOUBLE Y Identifies if the patient was in the PC05a Population
PC05_POP_IND DOUBLE Y Identifies if the patient was in the PC05 Population
PERF_OF_UTERUS_RSLV_DX_NOMEN VARCHAR(50) Y Perforation Of_Uterus_Rslv Diagnosis code or key from the source vocabulary
PERF_OF_UTERUS_RSLV_PRIOR_IND DOUBLE Y Identifies if there was a problem of the Perforation of the Uterus resolved prior to admission
PERSON_ETHNIC_CODE VARCHAR(50) Y Ethnicity code of the patient as per value set
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(500) Y Ethnicity code system OID of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(50) Y Ethnicity code display of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(50) Y Ethnicity code system name of the patient as per value set
PERSON_GENDER_CODE VARCHAR(50) Y Gender code of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y Gender code system OID of the patient as per value set
PERSON_GENDER_CODE_SYSTEM VARCHAR(50) Y Gender code display of the patient as per value set
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(50) Y Gender code system name of the patient as per value set
PERSON_PAYER_CODE VARCHAR(50) Y Represents the patient's member or subscriber identifier with respect to the payer
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_PAYER_CODE_SYSTEM VARCHAR(50) Y Represents the patient's member or subscriber identifier display with respect to the payer
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the patient's member or subscriber identifier coding system name with respect to the payer
PERSON_RACE_CODE VARCHAR(50) Y Race code of the patient as per value set
PERSON_RACE_CODE_DISPLAY VARCHAR(500) Y Race code system OID of the patient as per value set
PERSON_RACE_CODE_SYSTEM VARCHAR(50) Y Race code display of the patient as per value set
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(50) Y Race code system name of the patient as per value set
SINGLE_LB_NB_CE_IND DOUBLE Y Identifies if the patient had a clinical event of Single Liveborn Newborn in Hospital
SINGLE_LB_NB_DX_IND DOUBLE Y Identifies if the patient had a diagnosis of Single Liveborn Newborn in Hospital
SINGLE_LIVE_BIRTH_CE_IND DOUBLE Y Identifies if the patient had a clinical event of Single Live Birth documented
SINGLE_LIVE_BIRTH_DX_NOMEN VARCHAR(50) Y Single Live Birth Diagnosis code or key from the source vocabulary.
SINGLE_LIVE_BIRTH_PROB_IND DOUBLE Y Identifies if the patient had a problem of Single Live Birth documented
SINGLE_LIVE_NB_DX_NOMEN VARCHAR(50) Y Single Liveborn Newborn Diagnosis code or key from the source vocabulary.
TIME_OF_DELIVERY_DT_TM DATETIME Y Identifies the date/time of the delivery
TIME_OF_DELIVERY_UTC_DT_TM DATETIME Y Identifies the date/time of the delivery normalized to GMT
TRANS_CERCLAGE_PROC_CE_IND DOUBLE Y Identifies a procedure of Transabdominal Cerclage via a clinical event
TRANS_CERCLAGE_PROC_IND DOUBLE Y Identifies a procedure of Transabdominal Cerclage
TRANS_CERCLAGE_PROC_NOMEN VARCHAR(50) Y Trans Cerclage Procedure code or key from the source vocabulary.
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.
UTERINE_RUPTURE_DX_NOMEN VARCHAR(50) Y Uterine Rupture Diagnosis code or key from the source vocabulary
UTERINE_RUPTURE_PRIOR_IND DOUBLE Y Identifies if there was a problem of uterine rupture resolved prior to admission
UTERINE_WINDOW_DX_NOMEN VARCHAR(50) Y Uterine Window Diagnosis code or key from the source vocabulary
UTERINE_WINDOW_PRIOR_IND DOUBLE Y Identifies if there was a problem of uterine window resolved prior to admission



Relationship Detail - LH_E_PC_2016_METRICS


Child Column in LH_E_PC_2016_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_PC_2017_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_PC_2017_METRICS
Definition: This table is used to store eMeasure PC Metrics for the 2017 reporting period. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_PC_2017_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
ART_RUPTURE_MEMBRANE_NOMEN VARCHAR(60) Y The nomenclature of an artificial rupture of membranes
BREAST_MILK_DT_TM DATETIME Y The date/time of documentation of breast milk
BREAST_MILK_UTC_DT_TM DATETIME Y The utc date/time of documentation of breast milk
CLASS_CSECTION_PROC_NOMEN VARCHAR(60) Y The nomenclature of a classical C-Section documented
CSECTION_PROC_NOMEN VARCHAR(60) Y The nomen of the C-Section procedure documented
DELIVERY_PROC_NOMEN VARCHAR(60) Y The nomenclature of the delivery procedure documented
DIETARY_INTAKE_DT_TM DATETIME Y The date/time of documentation of dietary intake other than breastmilk documented
DIETARY_INTAKE_UTC_DT_TM DATETIME Y The utc date/time of documentation of dietary intake other than breastmilk documented
DINOPROSTONE_DT_TM DATETIME Y The date/time Dinonprostone was administered during the inpatient encounter and prior to labor date/time
DINOPROSTONE_UTC_DT_TM DATETIME Y The utc date/time Dinonprostone was administered during the inpatient encounter and prior to labor date/time
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISCH_OTHER_HOSP_IND DOUBLE Y Identifies if the patient was discharged to another hospital
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_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_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ECTOPIC_PREGNANCY_NOMEN VARCHAR(60) Y The nomenclature of cornual ectopic pregnancy resolved priro to admission
ELECT_DELIV_39_WKS_NOMEN VARCHAR(60) Y The nomenclature of the problem/diagnosis of elective delivery prior to 39 weeks
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXPIRED_IND DOUBLE Y Identifies if the patient expired while in the hospital
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GALACTOSEMIA_NOMEN VARCHAR(60) Y The nomenclature of galactosemia
GEST_AGE_BIRTH DOUBLE Y The patient's gestational age at birth (weeks)
GEST_AGE_DELIVERY DOUBLE Y The patient's gestational age at delivery (weeks)
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HOSP_SVC_IND DOUBLE N Indicates if the encounter should be excluded from the population due to the visit type
LABOR_DT_TM DATETIME Y Identifies the date/time of labor
LABOR_UTC_DT_TM DATETIME Y Identifies the date/time of labor normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_PC_2017_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PC_2017_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_INDUCT_LABOR_NOMEN VARCHAR(60) Y The nomenclature of Medically induced labor
MYOMECTOMY_PROC_NOMEN VARCHAR(60) Y The nomenclature of myomectomy documented
NICU_LOC_CD DOUBLE N The location code of Neonatal Intensive Care Unit (NICU)
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OXYTOCIN_DT_TM DATETIME Y The date/time Oxytocin was administered during the inpatient encounter and prior to labor date/time
OXYTOCIN_UTC_DT_TM DATETIME Y The utc date/time Oxytocin was administered during the inpatient encounter and prior to labor date/time
PARENTERAL_NUTRI_NOMEN VARCHAR(60) Y The nomenclature parenteral nutrition
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 for the encounter
PC01_DEN_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC01
PC01_EXCLUDE_IND DOUBLE Y Identifies if the patient is excluded for PC01
PC01_IPP_IND DOUBLE Y Identifies if the patient was in the PC01 Population
PC01_NUM_IND DOUBLE Y Identifies if the patient is in the numerator for PC01
PC05_DEN_IND DOUBLE Y Identifies if the patient was in the PC05 Population
PC05_EXCLUDE_IND DOUBLE Y Identifies if the patient is excluded for PC05
PC05_NUM_IND DOUBLE Y Identifies if the patient is in the numerator for PC05
PERF_OF_UTERUS_NOMEN VARCHAR(60) Y The nomenclature of Perforation of the Uterus resolved prior to admission.
PERSON_ETHNIC_CODE VARCHAR(50) Y Ethnicity code of the patient as per value set
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(500) Y Ethnicity code system OID of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(50) Y Ethnicity code display of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(50) Y Ethnicity code system name of the patient as per value set
PERSON_GENDER_CODE VARCHAR(50) Y Gender code of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y Gender code system OID of the patient as per value set
PERSON_GENDER_CODE_SYSTEM VARCHAR(50) Y Gender code display of the patient as per value set
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(50) Y Gender code system name of the patient as per value set
PERSON_PAYER_CODE VARCHAR(50) Y Represents the patient's member or subscriber identifier with respect to the payer
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_PAYER_CODE_SYSTEM VARCHAR(50) Y Represents the patient's member or subscriber identifier display with respect to the payer
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the patient's member or subscriber identifier coding system name with respect to the payer
PERSON_RACE_CODE VARCHAR(50) Y Race code of the patient as per value set
PERSON_RACE_CODE_DISPLAY VARCHAR(500) Y Race code system OID of the patient as per value set
PERSON_RACE_CODE_SYSTEM VARCHAR(50) Y Race code display of the patient as per value set
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(50) Y Race code system name of the patient as per value set
PERSON_RACE_DESC VARCHAR(500) Y The list of all of a patient's races
SINGLE_LIVE_BIRTH_NOMEN VARCHAR(60) Y The nomenclature of Single Live Birth documented
SINGLE_LIVE_BORN_NOMEN VARCHAR(60) Y The nomenclature of Single Liveborn Newborn in Hospital
TIMEZONE_IDENT DOUBLE Y Identifies the timezone index number associated with the quality measure.
TIME_OF_DELIVERY_DT_TM DATETIME Y Identifies the date/time of the delivery
TIME_OF_DELIVERY_UTC_DT_TM DATETIME Y Identifies the date/time of the delivery normalized to GMT
TRANS_CERCLAGE_NOMEN VARCHAR(60) Y The nomenclature of Transabdominal Cerclage
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UTERINE_RUPTURE_NOMEN VARCHAR(60) Y The nomenclature of uterine rupture resolved prior to admission
UTERINE_WINDOW_NOMEN VARCHAR(60) Y The nomenclature of uterine window resolved prior to admissoin



Relationship Detail - LH_E_PC_2017_METRICS


Child Column in LH_E_PC_2017_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
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_PC_2018_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_PC_2018_METRICS
Definition: Stores data gathered by the LH_E_PC_2018 program.
Table Type: ACTIVITY





Column Detail - LH_E_PC_2018_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ART_RUPTURE_MEMBRANE_NOMEN VARCHAR(60) Y The nomenclature of an artificial rupture of membranes
BREAST_MILK_DT_TM DATETIME Y The date/time of documentation of breast milk
BREAST_MILK_UTC_DT_TM DATETIME Y The utc date/time of documentation of breast milk
CLASS_CSECTION_PROC_NOMEN VARCHAR(60) Y The nomenclature of a classical C-Section documented
CSECTION_PROC_NOMEN VARCHAR(60) Y The nomen of the C-Section procedure documented
DELIVERY_PROC_NOMEN VARCHAR(60) Y The nomenclature of the delivery procedure documented
DIETARY_INTAKE_DT_TM DATETIME Y The date/time of documentation of dietary intake other than breastmilk documented
DIETARY_INTAKE_UTC_DT_TM DATETIME Y The utc date/time of documentation of dietary intake other than breastmilk documented
DINOPROSTONE_DT_TM DATETIME Y The date/time Dinonprostone was administered during the inpatient encounter and prior to labor date/time
DINOPROSTONE_UTC_DT_TM DATETIME Y The utc date/time Dinonprostone was administered during the inpatient encounter and prior to labor date/time
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
DISCH_OTHER_HOSP_IND DOUBLE Y Identifies if the patient was discharged to another hospital
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_METRIC_0_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ECTOPIC_PREGNANCY_NOMEN VARCHAR(60) Y The nomenclature of cornual ectopic pregnancy resolved priro to admission
ELECT_DELIV_39_WKS_NOMEN VARCHAR(60) Y The nomenclature of the problem/diagnosis of elective delivery prior to 39 weeks
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXPIRED_IND DOUBLE Y Identifies if the patient expired while in the hospital
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GALACTOSEMIA_NOMEN VARCHAR(60) Y The nomenclature of galactosemia
GEST_AGE_BIRTH DOUBLE Y The patient's gestational age at birth (weeks)
GEST_AGE_DELIVERY DOUBLE Y The patient's gestational age at delivery (weeks)
HEALTH_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IP_ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
IP_ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted normalized to GMT.
LABOR_DT_TM DATETIME Y Identifies the date/time of labor
LABOR_UTC_DT_TM DATETIME Y Identifies the date/time of labor normalized to GMT
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_PC_2018_METRICS_ID DOUBLE N Unique generated number that identifies a sngle row on the table
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MED_INDUCT_LABOR_NOMEN VARCHAR(60) Y The nomenclature of Medically induced labor
MYOMECTOMY_PROC_NOMEN VARCHAR(60) Y The nomenclature of myomectomy documented
NICU_LOC_CD DOUBLE N The location of Neonatal Intensive Care Unit (NICU)
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OXYTOCIN_DT_TM DATETIME Y The date/time Oxytocin was administered during the inpatient encounter and prior to labor date/time
OXYTOCIN_UTC_DT_TM DATETIME Y The utc date/time Oxytocin was administered during the inpatient encounter and prior to labor date/time
PARENTERAL_NUTRI_NOMEN VARCHAR(60) Y The nomenclature parenteral nutrition
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.
PC01_DEN_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC01
PC01_EXCLUDE_IND DOUBLE Y Identifies if the patient is excluded for PC01
PC01_IPP_IND DOUBLE Y Identifies if the patient was in the PC01 Population
PC01_NUM_IND DOUBLE Y Identifies if the patient is in the numerator for PC01
PC05_DEN_IND DOUBLE Y Identifies if the patient was in the PC05 Population
PC05_EXCLUDE_IND DOUBLE Y Identifies if the patient is excluded for PC05
PC05_NUM_IND DOUBLE Y Identifies if the patient is in the numerator for PC05
PERF_OF_UTERUS_NOMEN VARCHAR(60) Y The nomenclature of Perforation of the Uterus resolved prior to admission
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y Ethnicity code system OID of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y Gender code system OID of the patient as per value set
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_RACE_DESC VARCHAR(300) Y The list of all of a patient's races
SINGLE_LIVE_BIRTH_NOMEN VARCHAR(60) Y The nomenclature of Single Live Birth documented
SINGLE_LIVE_BORN_NOMEN VARCHAR(60) Y The nomenclature of Single Liveborn Newborn in Hospital
TIMEZONE_TXT VARCHAR(100) Y The timezone of the record.
TIME_OF_DELIVERY_DT_TM DATETIME Y Identifies the date/time of the delivery
TIME_OF_DELIVERY_UTC_DT_TM DATETIME Y Identifies the date/time of the delivery normalized to GMT
TRANS_CERCLAGE_NOMEN VARCHAR(60) Y The nomenclature of Transabdominal Cerclage
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.
UTERINE_RUPTURE_NOMEN VARCHAR(60) Y The nomenclature of uterine rupture resolved prior to admission
UTERINE_WINDOW_NOMEN VARCHAR(60) Y The nomenclature of uterine window resolved prior to admissoin



Relationship Detail - LH_E_PC_2018_METRICS


Child Column in LH_E_PC_2018_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_0_ID LH_D_METRIC D_METRIC_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_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_PC_2019_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_PC_2019_METRICS
Definition: Stores data gathered by the LH_E_PC_2019 program.
Table Type: ACTIVITY





Column Detail - LH_E_PC_2019_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.
ART_RUPTURE_MEMBRANE_NOMEN VARCHAR(60) Y The nomenclature of an artificial rupture of membranes
BREAST_MILK_DT_TM DATETIME Y The date/time of documentation of breast milk
CLASS_CSECTION_PROC_NOMEN VARCHAR(60) Y The nomenclature of a classical C-Section documented
CSECTION_PROC_NOMEN VARCHAR(60) Y The nomen of the C-Section procedure documented
DELIVERY_PROC_NOMEN VARCHAR(60) Y The nomenclature of the delivery procedure documented
DEN_1_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC01
DEN_5_IND DOUBLE Y Identifies if the patient was in the PC05 Population
DIETARY_INTAKE_DT_TM DATETIME Y The date/time of documentation of dietary intake other than breastmilk documented
DINOPROSTONE_DT_TM DATETIME Y The date/time Dinonprostone was administered during the inpatient encounter and prior to labor date/time
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCH_OTHER_HOSP_IND DOUBLE Y Identifies if the patient was discharged to another hospital
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Identifies the discharge disposition of the encounter
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ECTOPIC_PREGNANCY_NOMEN VARCHAR(60) Y The nomenclature of cornual ectopic pregnancy resolved priro to admission
ELECT_DELIV_39_WKS_NOMEN VARCHAR(60) Y The nomenclature of the problem/diagnosis of elective delivery prior to 39 weeks
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_5_IND DOUBLE Y Identifies if the patient is excluded for PC05
EXPIRED_IND DOUBLE Y Identifies if the patient expired while in the hospital
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time that the first ETL process started that created this record.
GALACTOSEMIA_NOMEN VARCHAR(60) Y The nomenclature of galactosemia
GEST_AGE_BIRTH DOUBLE Y The patient's gestational age at birth (weeks)
GEST_AGE_DELIVERY DOUBLE Y The patient's gestational age at delivery (weeks)
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.
IPP_1_IND DOUBLE Y Identifies if the patient was in the PC01 Population
IP_ADMIT_DT_TM DATETIME Y The date/time on which the patient was admitted
LABOR_DT_TM DATETIME Y Identifies the date/time of labor
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_PC_2019_METRICS_ID DOUBLE N Unique generated number that identifies a sngle row on the table
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
MED_INDUCT_LABOR_NOMEN VARCHAR(60) Y The nomenclature of Medically induced labor
METROPLASTY_PROC_NOMEN VARCHAR(60) Y The nomenclature of Metroplasty procedure
MYOMECTOMY_PROC_NOMEN VARCHAR(60) Y The nomenclature of myomectomy documented
NICU_LOC_CD DOUBLE N The location of Neonatal Intensive Care Unit (NICU)
NUM_1_IND DOUBLE Y Identifies if the patient is in the numerator for PC01
NUM_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.
OXYTOCIN_DT_TM DATETIME Y The date/time Oxytocin was administered during the inpatient encounter and prior to labor date/time
PARENTERAL_NUTRI_NOMEN VARCHAR(60) Y The nomenclature parenteral nutrition
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.
PERF_OF_UTERUS_NOMEN VARCHAR(60) Y The nomenclature of Perforation of the Uterus resolved prior to admission
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(300) Y Ethnicity code system OID of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(300) Y Gender code system OID of the patient as per value set
PERSON_ID DOUBLE N The ID of the person associated to the record.
PERSON_PAYER_CODE_DISPLAY VARCHAR(300) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_RACE_DESC VARCHAR(300) Y The list of all of a patient's races
SINGLE_LIVE_BORN_NOMEN VARCHAR(60) Y The nomenclature of Single Liveborn Newborn in Hospital
SRC_UPDT_DT_TM DATETIME Y Indicates the actual time when the row was inserted or updated at the source. This column is used only for date extraction and will not be populated on the client site.
SRC_UPDT_SOURCE VARCHAR(50) Y This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed. This column is used only for date extraction and will not be populated on the client site.
TIME_OF_DELIVERY_DT_TM DATETIME Y Identifies the date/time of the delivery
TIME_ZONE_TXT VARCHAR(100) Y The timezone of the record.
TRANS_CERCLAGE_NOMEN VARCHAR(60) Y The nomenclature of Transabdominal Cerclage
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.
UTERINE_HORN_NOMEN VARCHAR(60) Y The nomenclature of Uterine Horn procedure
UTERINE_RUPTURE_NOMEN VARCHAR(60) Y The nomenclature of uterine rupture resolved prior to admission
UTERINE_WINDOW_NOMEN VARCHAR(60) Y The nomenclature of uterine window resolved prior to admissoin



Relationship Detail - LH_E_PC_2019_METRICS


Child Column in LH_E_PC_2019_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_5_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