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 |