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 |