Table Detail Report
LH_E_EHDI_2019_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_EHDI_2019_METRICS |
Definition: | Stores data gathered by the LH_E_EHDI_2019 program. |
Table Type: | ACTIVITY |
Column Detail - LH_E_EHDI_2019_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | Identifies the discharge disposition of the encounter |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_METRIC_1A_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_IND | DOUBLE | Y | Identifies if the record is excluded for the metric |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
IP_ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LEFT_SCREEN_PASS_REFER_TXT | VARCHAR(10) | Y | The result of newborn hearing screen left (pass or refer) |
LH_E_EHDI_2019_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the table |
LIVE_BIRTH_DX_NOMEN | VARCHAR(60) | Y | The live birth diagnosis domenclature |
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_REASON_NB_LEFT_IND | DOUBLE | Y | Identifies if there was a medical reason for not performing a newborn hearing screening left |
MED_REASON_NB_RIGHT_IND | DOUBLE | Y | Identifies if there was a medical reason for not performing a newborn hearing screening right |
NUM_IND | DOUBLE | Y | Identifies if the record is the numerator for the metric |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PATIENT_DECEASED_IND | DOUBLE | Y | Indicates that the patient died during the encounter. |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | Ethnicity code system OID of the patient as per value set |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | Gender code system OID of the patient as per value set |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | Represents the patient's member or subscriber identifier coding system OID with respect to the payer |
PERSON_RACE_DESC | VARCHAR(300) | Y | The list of all of a patient's races |
RIGHT_SCREEN_PASS_REFER_TXT | VARCHAR(10) | Y | The result of newborn hearing screen right (pass or refer) |
SRC_UPDT_DT_TM | DATETIME | Y | Indicates the actual time when the row was inserted or updated at the source. This column is used only for date extraction and will not be populated on the client site. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed. This column is used only for date extraction and will not be populated on the client site. |
TIMEZONE_TXT | VARCHAR(100) | Y | ** OBSOLETE - NOT USED / DO NOT USE ** |
TIME_ZONE_TXT | VARCHAR(100) | Y | The timezone of the record. |
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_EHDI_2019_METRICS
Child Column in LH_E_EHDI_2019_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | 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_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_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_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1A_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_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 | |
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_GMCS_2024_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures Global Malnutrition 2024 Metrics |
Definition: | Stores data gathered by the LH_E_GMCS_2024 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_GMCS_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 GMCS 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. |
HOSP_DIET_REF_ORD_DT_TM | DATETIME | Y | Identifies the date/time of qualifying Intervention order |
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_GMCS_2024_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_GMCS_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. |
MALNUTRITION_DX_DT_TM | DATETIME | Y | Identifies the date/time of qualifying Malnutrition diagnosis |
MALNUTRITION_DX_NOMEN | VARCHAR(60) | Y | Identifies qualifying Malnutrition diagnosis code |
MAL_AT_RISK_ASSES_PERF_IND | DOUBLE | Y | Identifies whether there was a Malnutrition At Risk Assessment Performed |
MAL_NOT_AT_RISK_ASSES_PERF_IND | DOUBLE | Y | Identifies whether there was a Malnutrition Not At Risk Assessment Performed |
MAL_RISK_SCRNG_ASSES_PERF_IND | DOUBLE | Y | Identifies whether there was a Malnutrition Risk Screening Assessment Performed |
MEAS_OBS_1 | DOUBLE | Y | Encounters with Malnutrition Risk Screening and Identified Result |
MEAS_OBS_2 | DOUBLE | Y | Encounter with Nutrition Assessment and Identified Status |
MEAS_OBS_3 | DOUBLE | Y | Encounters with Malnutrition Diagnosis |
MEAS_OBS_4 | DOUBLE | Y | Encounters with Nutrition Care Plan |
NAS_MOD_MAL_ASSES_PERF_IND | DOUBLE | Y | Identifies whether there was a qualifying Assessment performed. |
NAS_NM_MAL_ASSES_PERF_IND | DOUBLE | Y | Identifies whether there was a qualifying Assessment performed. |
NAS_SEV_MAL_ASSES_PERF_IND | DOUBLE | Y | Identifies whether there was a qualifying Assessment performed |
NUTRITION_ASSES_PERF_IND | DOUBLE | Y | Identifies whether there was a Nutrition Assessment Performed |
NUTRI_CARE_PLAN_PERF_DT_TM | DATETIME | Y | Identifies the date/time of qualifying Intervention performed |
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. |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
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. |
TOTAL_MAL_COMP_SCORE_DEN | DOUBLE | Y | The total number of clinically eligible denominators. |
TOTAL_MAL_COMP_SCORE_MEAS_OBS | DOUBLE | Y | The sum of performed Measure Observations 1, 2, 3, and 4 |
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_GMCS_2024_METRICS
Child Column in LH_E_GMCS_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_HEARING_SCREEN_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_HEARING_SCREEN_METRICS |
Definition: | This table is used to store Hearing Screening metrics from the Lighthouse eMeasure. This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_E_HEARING_SCREEN_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted normalized to GMT. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged normalized to GMT. |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | Defines the discharge disposition of the encounter. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_IND | DOUBLE | Y | Identifies if the record is excluded for the metric |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
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. |
HEARING_EXAM_IND | DOUBLE | Y | Identifies if the patient had a hearing exam performed during the inpatient encounter |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LH_E_HEARING_SCREEN_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row in the table - PK |
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_REASON_HEARING_SCREEN_IND | DOUBLE | Y | Identifies if there was a medical reason for not performing a hearing screening |
MED_REASON_NB_LEFT_IND | DOUBLE | Y | Identifies if there was a medical reason for not performing a newborn hearing screening left |
MED_REASON_NB_RIGHT_IND | DOUBLE | Y | Identifies if there was a medical reason for not performing a newborn hearing screening right |
NB_HEARING_SCREEN_LEFT_IND | DOUBLE | Y | Identifies if the patient had a newborn hearing screen left performed during the inpatient encounter |
NB_HEARING_SCREEN_RIGHT_IND | DOUBLE | Y | Identifies if the patient had a newborn hearing screen right performed during the inpatient encounter |
NUMERATOR_IND | DOUBLE | Y | Identifies if the record is the numerator for the metric |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PASS_REFER_IND | DOUBLE | Y | Identifies if the result of the hearing screen result was Pass or Refer |
PATIENT_EXPIRED_IND | DOUBLE | Y | Identifies if the patient expired |
PAYER_CODE_TXT | VARCHAR(20) | Y | identifies the payer code value that is associated to the patient for QRDA file payer information. |
POPULATION_IND | DOUBLE | N | Identifies if the patient is in the population for the CAC Metric |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - LH_E_HEARING_SCREEN_METRICS
Child Column in LH_E_HEARING_SCREEN_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_MED_SERVICE_ID | LH_D_MED_SERVICE | D_MED_SERVICE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MED_SERVICE | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
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_HH_2023_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures Hypo/Hyperglycemia 2023 Metrics |
Definition: | Stores data gathered by the LH_E_HH_2023 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_HH_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. |
DEN_1_IND | DOUBLE | Y | Indicates record qualified for Hypoglycemia initial patient population/Denominator. |
DEN_2_IND | DOUBLE | Y | Indicates record qualified for Hyperglycemia initial patient population/Denominator. |
DIABETES_DX_NOMEN | VARCHAR(50) | Y | Nomenclature for diabetes diagnosis |
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 Hypoglycemia(HH-01) metric. |
D_METRIC_2_ID | DOUBLE | N | Dimension ID for Hyperglycemia(HH-02) 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. |
EXCLUDE_2_IND | DOUBLE | Y | Indicates record qualified for Hyperglycemia denom. exclusion population. |
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. |
GLUC_LAB_TEST_HH1_INIT_DT_TM | DATETIME | Y | Initial glucose lab result date/time for Hypoglycemia |
GLUC_LAB_TEST_HH1_INIT_TXT | VARCHAR(30) | Y | Initial glucose lab result value for Hypoglycemia |
GLUC_LAB_TEST_HH1_NEXT_DT_TM | DATETIME | Y | glucose lab result date/time for Hypoglycemia within 5 mins of prior lab |
GLUC_LAB_TEST_HH1_NEXT_TXT | VARCHAR(30) | Y | glucose lab result value for Hypoglycemia within 5 mins of prior lab |
GLUC_LAB_TEST_HH2_DAY_10_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 10 |
GLUC_LAB_TEST_HH2_DAY_10_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 10 |
GLUC_LAB_TEST_HH2_DAY_1_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 1 |
GLUC_LAB_TEST_HH2_DAY_1_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 1 |
GLUC_LAB_TEST_HH2_DAY_2_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 2 |
GLUC_LAB_TEST_HH2_DAY_2_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 2 |
GLUC_LAB_TEST_HH2_DAY_3_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 3 |
GLUC_LAB_TEST_HH2_DAY_3_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 3 |
GLUC_LAB_TEST_HH2_DAY_4_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 4 |
GLUC_LAB_TEST_HH2_DAY_4_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 4 |
GLUC_LAB_TEST_HH2_DAY_5_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 5 |
GLUC_LAB_TEST_HH2_DAY_5_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 5 |
GLUC_LAB_TEST_HH2_DAY_6_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 6 |
GLUC_LAB_TEST_HH2_DAY_6_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 6 |
GLUC_LAB_TEST_HH2_DAY_7_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 7 |
GLUC_LAB_TEST_HH2_DAY_7_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 7 |
GLUC_LAB_TEST_HH2_DAY_8_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 8 |
GLUC_LAB_TEST_HH2_DAY_8_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 8 |
GLUC_LAB_TEST_HH2_DAY_9_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 9 |
GLUC_LAB_TEST_HH2_DAY_9_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 9 |
GLUC_LAB_TEST_HH2_DENEX_DT_TM | DATETIME | Y | Any glucose lab result date/time for Hyperglycemia for Exclusion |
GLUC_LAB_TEST_HH2_DENEX_TXT | VARCHAR(30) | Y | Any glucose lab result for Hyperglycemia for exclusion |
GLUC_LAB_TEST_HH2_IPP_DT_TM | DATETIME | Y | Any glucose lab result date/time for Hyperglycemia with result >= 200 |
GLUC_LAB_TEST_HH2_IPP_TXT | VARCHAR(30) | Y | Any glucose lab result for Hyperglycemia with result >= 200 |
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. |
HYPO_SEV_HYPO_ADMIN_DT_TM | DATETIME | Y | The earliest date/time of medication administration documented for Hypoglycemics Severe Hypoglycemia Medications. |
HYPO_SEV_HYPO_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administered for Hypoglycemics Severe Hypoglycemia Medications |
HYPO_TREAT_MED_ADM_DT_TM | DATETIME | Y | The earliest date/time of medication administration documented for Hypoglycemics Treatment Medication. |
HYPO_TREAT_MED_ADM_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administered for Hypoglycemics Treatment Medication |
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_HH_2023_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_HH_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. |
MEAS_OBS_HH2_DEN | DOUBLE | Y | Number of eligible days in denominator for Hyperglycemia |
MEAS_OBS_HH2_NUM | DOUBLE | Y | Number of hyperglycemic event days in Numerator for Hyperglycemia |
NUM_1_IND | DOUBLE | Y | Indicates record qualified for Hypoglycemia numerator population. |
NUM_2_IND | DOUBLE | Y | Indicates record qualified for Hyperglycemia numerator population. |
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 | Y | The ID of the qualifying Observation encounter associated to the record. |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
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_HH_2023_METRICS
Child Column in LH_E_HH_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 | |
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 | |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
LH_E_HH_2024_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lighthouse eMeasures Hypo/Hyperglycemia 2024 Metrics |
Definition: | Stores data gathered by the LH_E_HH_2024 script. |
Table Type: | ACTIVITY |
Column Detail - LH_E_HH_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. |
DEN_1_IND | DOUBLE | Y | Indicates record qualified for Hypoglycemia initial patient population/Denominator. |
DEN_2_IND | DOUBLE | Y | Indicates record qualified for Hyperglycemia initial patient population/Denominator. |
DIABETES_DX_NOMEN | VARCHAR(50) | Y | Nomenclature for diabetes diagnosis |
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 Hypoglycemia(HH-01) metric. |
D_METRIC_2_ID | DOUBLE | N | Dimension ID for Hyperglycemia(HH-02) 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. |
EXCLUDE_2_IND | DOUBLE | Y | Indicates record qualified for Hyperglycemia denom. exclusion population. |
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. |
GLUC_LAB_TEST_HH1_INIT_DT_TM | DATETIME | Y | Initial glucose lab result date/time for Hypoglycemia |
GLUC_LAB_TEST_HH1_INIT_TXT | VARCHAR(30) | Y | Initial glucose lab result value for Hypoglycemia |
GLUC_LAB_TEST_HH1_NEXT_DT_TM | DATETIME | Y | glucose lab result date/time for Hypoglycemia within 5 mins of prior lab |
GLUC_LAB_TEST_HH1_NEXT_TXT | VARCHAR(30) | Y | glucose lab result value for Hypoglycemia within 5 mins of prior lab |
GLUC_LAB_TEST_HH2_DAY_10_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 10 |
GLUC_LAB_TEST_HH2_DAY_10_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 10 |
GLUC_LAB_TEST_HH2_DAY_1_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 1 |
GLUC_LAB_TEST_HH2_DAY_1_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 1 |
GLUC_LAB_TEST_HH2_DAY_2_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 2 |
GLUC_LAB_TEST_HH2_DAY_2_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 2 |
GLUC_LAB_TEST_HH2_DAY_3_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 3 |
GLUC_LAB_TEST_HH2_DAY_3_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 3 |
GLUC_LAB_TEST_HH2_DAY_4_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 4 |
GLUC_LAB_TEST_HH2_DAY_4_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 4 |
GLUC_LAB_TEST_HH2_DAY_5_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 5 |
GLUC_LAB_TEST_HH2_DAY_5_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 5 |
GLUC_LAB_TEST_HH2_DAY_6_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 6 |
GLUC_LAB_TEST_HH2_DAY_6_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 6 |
GLUC_LAB_TEST_HH2_DAY_7_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 7 |
GLUC_LAB_TEST_HH2_DAY_7_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 7 |
GLUC_LAB_TEST_HH2_DAY_8_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 8 |
GLUC_LAB_TEST_HH2_DAY_8_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 8 |
GLUC_LAB_TEST_HH2_DAY_9_DT_TM | DATETIME | Y | highest glucose lab result's dt/tm for Hyperglycemia on Day 9 |
GLUC_LAB_TEST_HH2_DAY_9_TXT | VARCHAR(30) | Y | highest glucose lab result for Hyperglycemia on Day 9 |
GLUC_LAB_TEST_HH2_DENEX_DT_TM | DATETIME | Y | Any glucose lab result date/time for Hyperglycemia for Exclusion |
GLUC_LAB_TEST_HH2_DENEX_TXT | VARCHAR(30) | Y | Any glucose lab result for Hyperglycemia for exclusion |
GLUC_LAB_TEST_HH2_IPP_DT_TM | DATETIME | Y | Any glucose lab result date/time for Hyperglycemia with result >= 200 |
GLUC_LAB_TEST_HH2_IPP_TXT | VARCHAR(30) | Y | Any glucose lab result for Hyperglycemia with result >= 200 |
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. |
HYPO_SEV_HYPO_ADMIN_DT_TM | DATETIME | Y | The earliest date/time of medication administration documented for Hypoglycemics Severe Hypoglycemia Medications. |
HYPO_SEV_HYPO_ADMIN_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administered for Hypoglycemics Severe Hypoglycemia Medications |
HYPO_TREAT_MED_ADM_DT_TM | DATETIME | Y | The earliest date/time of medication administration documented for Hypoglycemics Treatment Medication. |
HYPO_TREAT_MED_ADM_ORD_DETAIL | VARCHAR(100) | Y | Order details for qualifying medication administered for Hypoglycemics Treatment Medication |
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_HH_2024_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_HH_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. |
MEAS_OBS_HH2_DEN | DOUBLE | Y | Number of eligible days in denominator for Hyperglycemia |
MEAS_OBS_HH2_NUM | DOUBLE | Y | Number of hyperglycemic event days in Numerator for Hyperglycemia |
NUM_1_IND | DOUBLE | Y | Indicates record qualified for Hypoglycemia numerator population. |
NUM_2_IND | DOUBLE | Y | Indicates record qualified for Hyperglycemia numerator population. |
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 | Y | The ID of the qualifying Observation encounter associated to the record. |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
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_HH_2024_METRICS
Child Column in LH_E_HH_2024_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
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 | |
LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |