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