Table Detail Report
LH_E_ORAE_2024_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures Hospital-Harm ORAE 2024 Metrics |
Definition: | Stores data gathered by the LH_E_ORAE_2024 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_ORAE_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. |
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_0_ID | DOUBLE | N | Dimension ID for QRAE metric. |
D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the qualifying emergency encounter. |
ED_DEPART_DT_TM | DATETIME | Y | The end of the qualifying emergency encounter. |
ED_ENCNTR_ID | DOUBLE | N | The ID of the qualifying Emergency encounter associated to the record. |
ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
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. |
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 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_ORAE_2024_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_ORAE_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. |
NUM_IND | DOUBLE | Y | Identifies if the patient was in HH-ORAE Numerator |
OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the qualifying observation encounter. |
OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the qualifying observation encounter. |
OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the qualifying Observation encounter associated to the record. |
OPI_ALL_MED_ADMIN_DT_TM | DATETIME | Y | Order details for qualifying medication administration for Opioids All |
OPI_ALL_MED_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Opioids All |
OPI_ANTAG_MED_ADMIN_DT_TM | DATETIME | Y | Order date/time for qualifying medication administration for Opioids Antagonist |
OPI_ANTAG_MED_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administration for Opioids Antagonist |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
OR_END_DT_TM | DATETIME | Y | The time encounter facility location ends in OR |
OR_START_DT_TM | DATETIME | Y | The time encounter facility location starts in OR |
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. |
SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
TIME_ZONE_TXT | VARCHAR(100) | Y | The timezone of the record in ""America/Chicago"" format. |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_E_ORAE_2024_METRICS
Child Column in LH_E_ORAE_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_0_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_PCB_2020_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures PCB 2020 Metrics |
Definition: | Stores data gathered by the LH_E_PCB_2020 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_PCB_2020_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. |
BREAST_MILK_DT_TM | DATETIME | Y | The date/time of documentation of breast milk |
DEN_5_IND | DOUBLE | Y | Identifies if the patient was in the PC05 Population |
DIETARY_INTAKE_DT_TM | DATETIME | Y | The date/time of documentation of dietary intake other than breastmilk documented |
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_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 |
EXPIRED_IND | DOUBLE | Y | Identifies if the patient expired while in the hospital |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | 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. |
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_2020_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_PCB_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. |
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 |
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. |
SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
SINGLE_LIVE_BORN_NOMEN | VARCHAR(60) | Y | The nomenclature of Single Liveborn Newborn in Hospital |
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. |
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_2020_METRICS
Child Column in LH_E_PCB_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_5_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_PCB_2021_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures PC Baby 2021 Metrics |
Definition: | Stores data gathered by the LH_E_PCB_2021 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_PCB_2021_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 | Y | 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. |
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_2021_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_PCB_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. |
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. |
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_2021_METRICS
Child Column in LH_E_PCB_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_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_PCB_2022_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures PC Baby 2022 Metrics |
Definition: | Stores data gathered by the LH_E_PCB_2022 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_PCB_2022_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_2022_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_PCB_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. |
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. |
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_2022_METRICS
Child Column in LH_E_PCB_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_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_PCB_2023_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures PC Baby 2023 Metrics |
Definition: | Stores data gathered by the LH_E_PCB_2023 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_PCB_2023_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_2023_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_PCB_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. |
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_2023_METRICS
Child Column in LH_E_PCB_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_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 |