Table Detail Report

LH_E_PCB_2024_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures PC Baby 2024 Metrics
Definition: Lighthouse eMeasures PC Baby 2024 Metrics.
Table Type: ACTIVITY





Column Detail - LH_E_PCB_2024_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.
BIRTH_WEIGHT DOUBLE Y The patient's birth weight (grams)
BREAST_MILK_DT_TM DATETIME Y The date/time of documentation of breast milk
CONGENITAL_MALFORMATIONS_NOMEN VARCHAR(60) Y Nomeclature of congenital malformations diagnosis
DIETARY_INTAKE_DT_TM DATETIME Y The date/time of documentation of dietary intake other than breastmilk documented
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
DISCH_ACUTE_CARE_IND DOUBLE Y Identifies if the patient was discharged to an acute care facility
DISCH_OTHER_HOSP_IND DOUBLE Y Identifies if the patient was discharged to another hospital
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_5_ID DOUBLE N Dimension ID for ED-2 metric.
D_METRIC_6_ID DOUBLE N Dimension ID for PC-06 metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
EXCLUDE_5_IND DOUBLE Y Identifies if the patient is excluded for PC05
EXCLUDE_6_IND DOUBLE Y Identifies if the patient is excluded for PC-06
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.
FETAL_CONDITIONS_NOMEN VARCHAR(60) Y Nomeclature of fetal conditions diagnosis
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.
GALACTOSEMIA_NOMEN VARCHAR(60) Y The nomenclature of galactosemia
GEST_AGE_BIRTH DOUBLE Y The patient's gestational age at birth (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.
ICU_LOC_CD DOUBLE N The location of Intensive Care Unit (NICU)
IPP_IND DOUBLE Y Identifies if the patient was in the PC05 Initial Patient Population
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_PCB_2024_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PCB_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.
MATERNAL_DRUG_USE_NOMEN VARCHAR(60) Y Nomeclature of maternal drug use diagnosis
MODERATE_BIRTH_TRAUMA_NOMEN VARCHAR(60) Y Nomeclature of moderate birth trauma diagnosis
MODERATE_COMP_IND DOUBLE Y Identifies if patient qualified for Numerator via moderate complications
MODERATE_RESP_COMP_NOMEN VARCHAR(60) Y Nomeclature of moderate respiratory complications diagnosis
MODERATE_RESP_COMP_PROC_DT_TM DATETIME Y The date/time when moderate respiratory complications procedure was performed
MODERATE_RESP_COMP_PROC_NOMEN VARCHAR(60) Y Nomeclature of moderate respiratory complications procedure
MOD_BIRTH_TRAUMA_LOS_NOMEN VARCHAR(60) Y Nomeclature of moderate birth trauma with LOS diagnosis
MOD_INFECTION_LOS_NOMEN VARCHAR(60) Y Nomeclature of moderate infection with LOS diagnosis
MOD_NEURO_COMP_LOS_PROC_DT_TM DATETIME Y The date/time when moderate neurological complications with LOS procedure was performed
MOD_NEURO_COMP_LOS_PROC_NOMEN VARCHAR(60) Y Nomeclature of moderate neurological complications with LOS procedure
MOD_RESP_COMP_LOS_PROC_DT_TM DATETIME Y The date/time when moderate respiratory complications with LOS procedure was performed
MOD_RESP_COMP_LOS_PROC_NOMEN VARCHAR(60) Y moderate respiratory complications with LOS procedure
MOD_RESP_COM_LOS_NOMEN VARCHAR(60) Y Nomeclature of moderate respiratory complications with LOS diagnosis
NEO_JAUNDICE_NOMEN VARCHAR(60) Y Nomeclature of neonatal jaundice diagnosis
NEO_SEVERE_INFECTION_NOMEN VARCHAR(60) Y Nomeclature of neonatal severe infection diagnosis
NEO_SEVERE_NEURO_COMP_NOMEN VARCHAR(60) Y Nomeclature of neo_severe_neuro_comp diagnosis
NEO_SEVERE_NEURO_PROC_DT_TM DATETIME Y The date/time when neonatal severe neurological procedure was performed
NEO_SEVERE_NEURO_PROC_NOMEN VARCHAR(60) Y Nomeclature of neonatal severe neurological procedure
NEO_SEVERE_RESP_COMP_NOMEN VARCHAR(60) Y Nomeclature of neo_severe_resp_comp diagnosis
NEO_SEVERE_RESP_PROC_DT_TM DATETIME Y The date/time when neonatal severe respiratory procedure was performed
NEO_SEVERE_RESP_PROC_NOMEN VARCHAR(60) Y Nomeclature of neonatal severe respiratory procedure
NEO_SEVERE_SEPTICEMIA_NOMEN VARCHAR(60) Y Nomeclature of neonatal severe septicemia diagnosis
NICU_LOC_CD DOUBLE N The location of Neonatal Intensive Care Unit (NICU)
NUM_5_IND DOUBLE Y Identifies if the patient is in the numerator for PC05
NUM_6_IND DOUBLE Y Identifies if the patient is in the numerator for PC-06
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
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.
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.
PHOTOTHERAPY_PROC_DT_TM DATETIME Y phototherapy procedure was performed
PHOTOTHERAPY_PROC_NOMEN VARCHAR(60) Y Nomeclature of phototherapy procedure
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
SEVERE_BIRTH_TRAUMA_NOMEN VARCHAR(60) Y Nomeclature of severe birth trauma diagnosis
SEVERE_COMP_IND DOUBLE Y Identifies if patient qualified for Numerator via severe complications
SEVERE_HYPO_ASPHYXIA_NOMEN VARCHAR(60) Y Nomeclature of severe_hypo_asphyxia diagnosis
SEVERE_SHOCK_AND_RES_NOMEN VARCHAR(60) Y Nomeclature of severe shock and resuscitation diagnosis
SEVERE_SHOCK_PROC_DT_TM DATETIME Y The date/time when severe_shock procedure was performed
SEVERE_SHOCK_PROC_NOMEN VARCHAR(60) Y Nomeclature of severe shock procedure
SINGLE_LIVEBORN_CESAREAN_NOMEN VARCHAR(60) Y Nomeclature of single liveborn cesarean diagnosis
SINGLE_LIVEBORN_VAGINAL_NOMEN VARCHAR(60) Y Nomeclature of single liveborn vaginal diagnosis
SINGLE_LIVE_BORN_NOMEN VARCHAR(60) Y The nomenclature of Single Liveborn Newborn in Hospital
SOCIAL_INDICATIONS_NOMEN VARCHAR(60) Y Nomeclature of social indications diagnosis
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.
TIME_ZONE_TXT VARCHAR(100) Y The timezone of the record in ""America/Chicago"" format.
TOTAL_PAREN_NUTRI_DT_TM DATETIME Y The date of administration of Total Parenteral Nutrition medication
TOTAL_PAREN_NUTRI_ORD_DETAIL VARCHAR(100) Y Order details for qualifying medication administration for Total Parenteral Nutrition.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - LH_E_PCB_2024_METRICS


Child Column in LH_E_PCB_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_5_ID LH_D_METRIC D_METRIC_ID
D_METRIC_6_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_E_PCM_2020_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures PC Mother 2020 Metrics
Definition: Stores data gathered by the LH_E_PC_MOM_2020 script.
Table Type: ACTIVITY





Column Detail - LH_E_PCM_2020_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.
ART_RUPTURE_MEMBRANE_NOMEN VARCHAR(60) Y The nomenclature of an artificial rupture of membranes
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
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_2_IND DOUBLE Y Identifies if the patient is Not in Denominator for PC02
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 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_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
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.
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
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_AGE_DELIVERY DOUBLE Y Any gestational age up to a day before delivery (weeks)
GRAVIDA_NBR DOUBLE Y The Gravida number (total number of pregnancies including the current one)
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_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_GEST_AGE_DELIVERY DOUBLE Y The patient's last gestational age before delivery (weeks)
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_PCM_2020_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PCM_2020_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
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
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.
PRETERM_BIRTH_NBR DOUBLE Y The number of previous preterm births
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
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



Relationship Detail - LH_E_PCM_2020_METRICS


Child Column in LH_E_PCM_2020_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
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_PCM_2021_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_E_PCM_2021_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.
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
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
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 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_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
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
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.
GRAVIDA_NBR DOUBLE Y The Gravida number (total number of pregnancies including the current one)
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_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_2021_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PCM_2021_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
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
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
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.
PRETERM_BIRTH_NBR DOUBLE Y The number of previous preterm births
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
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



Relationship Detail - LH_E_PCM_2021_METRICS


Child Column in LH_E_PCM_2021_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_E_PCM_2022_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_E_PCM_2022_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
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.
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_2022_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PCM_2022_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
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
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.
PLATELET_LAB_RSLT_DT_TM DATETIME Y The date/time of the first platelet count recorded for the episode of care.
PLATELET_LAB_RSLT_TXT VARCHAR(30) Y The result of the first platelet count recorded for the episode of care.
PRESENT_ON_ADMISSION_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 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_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 Diagnosis Code for Obstetrical VTE
RVA_OTHER_PREECLAMP_DX_NOMEN VARCHAR(60) Y 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
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_2022_METRICS


Child Column in LH_E_PCM_2022_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_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_PCM_2023_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - LH_E_PCM_2023_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.
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_2023_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_PCM_2023_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
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 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_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 Diagnosis Code for Obstetrical VTE
RVA_OTHER_PREECLAMP_DX_NOMEN VARCHAR(60) Y 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
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_2023_METRICS


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