Table Detail Report

LH_E_HYBRID_2024_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures HWR and HWM 2024 Metrics
Definition: Stores data gathered by the LH_E_HYBRID_2024 script.
Table Type: ACTIVITY





Column Detail - LH_E_HYBRID_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.
BICARB_LAB_RSLT_DT_TM DATETIME Y The date/time of the first bicarbonate lab test for the episode of care.
BICARB_LAB_RSLT_TXT VARCHAR(30) Y The result of the first bicarbonate lab test for the episode of care.
BODY_TEMP_RSLT_DT_TM DATETIME Y The date/time of the first body temperature recorded for the episode of care.
BODY_TEMP_RSLT_TXT VARCHAR(30) Y The result of the first body temperature recorded for the episode of care.
BODY_WGT_RSLT_DT_TM DATETIME Y The date/time of the first body weight recorded for the episode of care.
BODY_WGT_RSLT_TXT VARCHAR(30) Y The result of the first body weight recorded for the episode of care.
CREAT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first creatinine lab test for the episode of care.
CREAT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first creatinine lab test for the episode of care.
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 Identifies the metric identifier for the Lighthouse metric.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ED_ARRIVAL_DT_TM DATETIME Y The start of the emergency encounter.
ED_DEPART_DT_TM DATETIME Y The end of the emergency encounter.
ED_ENCNTR_ID DOUBLE N The ID of the emergency encounter associated to the record.
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.
GLUC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first glucose lab test for the episode of care.
GLUC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first glucose lab test for the episode of care.
HCT_LAB_RSLT_DT_TM DATETIME Y The date/time of the first hematocrit lab test for the episode of care.
HCT_LAB_RSLT_TXT VARCHAR(30) Y The result of the first hematocrit lab test for the episode of care.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HEART_RATE_RSLT_DT_TM DATETIME Y The date/time of the first heart rate recorded for the episode of care.
HEART_RATE_RSLT_TXT VARCHAR(30) Y The result of the first heart rate recorded for the episode of care.
HIC_MBI_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
HWM_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Mortality Measure.
HWM_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Mortality Measure.
HWR_IPP_IND DOUBLE Y Indicates that the encounter is in Initial population for Hybrid Re-admission Measure.
HWR_RESULT_IND DOUBLE Y Indicates that at least one of the results exists for Hybrid Re-admission Measure.
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_HYBRID_2024_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_HYBRID_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.
MEDICARE_ADV_CODE_DISPLAY VARCHAR(300) Y String to store payer display for Medicare Advantage type.
MEDICARE_FFS_CODE_DISPLAY VARCHAR(300) Y String to store payer display for Medicare Fee-For-Service type.
O2_SAT_RSLT_DT_TM DATETIME Y The date/time of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
O2_SAT_RSLT_TXT VARCHAR(30) Y The result of the first O2 saturation in arterial blood by pulse oximetry recorded for the episode of care.
OBS_SERV_ARRIVAL_DT_TM DATETIME Y The start of the observation encounter.
OBS_SERV_DEPART_DT_TM DATETIME Y The end of the observation encounter.
OBS_SERV_ENCNTR_ID DOUBLE N The ID of the observation services encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
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.
PLATELET_LAB_RSLT_DT_TM DATETIME Y The date/time of the first platelet count recorded for the episode of care.
PLATELET_LAB_RSLT_TXT VARCHAR(30) Y The result of the first platelet count recorded for the episode of care.
POTAS_LAB_RSLT_DT_TM DATETIME Y The date/time of the first potassium lab test for the episode of care.
POTAS_LAB_RSLT_TXT VARCHAR(30) Y The result of the first potassium lab test for the episode of care.
RESP_RATE_RSLT_DT_TM DATETIME Y The date/time of the first respiratory rate recorded for the episode of care.
RESP_RATE_RSLT_TXT VARCHAR(30) Y The result of the first respiratory rate recorded for the episode of care.
SBP_RSLT_DT_TM DATETIME Y The date/time of the first systolic blood pressure recorded for the episode of care.
SBP_RSLT_TXT VARCHAR(30) Y The result of the first systolic blood pressure recorded for the episode of care.
SCRIPT_VERSION DOUBLE Y The version number of the script that populated the row
SOD_LAB_RSLT_DT_TM DATETIME Y The date/time of the first sodium lab test for the episode of care.
SOD_LAB_RSLT_TXT VARCHAR(30) Y The result of the first sodium lab test for the episode of care.
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.
TIMEZONE_TXT VARCHAR(300) 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.
WBC_LAB_RSLT_DT_TM DATETIME Y The date/time of the first white blood cells count lab test for the episode of care.
WBC_LAB_RSLT_TXT VARCHAR(30) Y The result of the first white blood cells count lab test for the episode of care.



Relationship Detail - LH_E_HYBRID_2024_METRICS


Child Column in LH_E_HYBRID_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
D_METRIC_1_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_OPIOID_2021_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures Safe Use of Opioids 2021 Metrics
Definition: Stores data gathered by the LH_E_OPIOID_2021 script.
Table Type: ACTIVITY





Column Detail - LH_E_OPIOID_2021_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ALL_PRIM_SEC_CANCER_DT_TM DATETIME Y The date/time the diagnosis for All Primary and Secondary Cancer was given at.
ALL_PRIM_SEC_CANCER_NOMEN VARCHAR(50) Y Nomenclature of All Primary and Secondary Cancer diagnosis during the inpatient encounter.
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 Opioid metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
EXCLUDE_IND DOUBLE Y Indicates record qualified for Opioid 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.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IPP_IND DOUBLE Y Indicates record qualified for Opioid 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_OPIOID_2021_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_OPIOID_2021_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NUM_IND DOUBLE Y Indicates record qualified for Opioid numerator population.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PALL_HOSPICE_ORD_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention ordered.
PALL_HOSPICE_PERF_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention was performed as a clinical event.
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.
SCHED_IV_BENZ_DISCH_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule IV Benzodiazepines
SCHED_OP_DISCH_1_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
SCHED_OP_DISCH_2_DT_TM DATETIME Y The second earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
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_OPIOID_2021_METRICS


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



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures Safe Use of Opioids 2022 Metrics
Definition: Stores data gathered by the LH_E_OPIOID_2022 script.
Table Type: ACTIVITY





Column Detail - LH_E_OPIOID_2022_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ALL_PRIM_SEC_CANCER_DT_TM DATETIME Y The date/time the diagnosis for All Primary and Secondary Cancer was given at.
ALL_PRIM_SEC_CANCER_NOMEN VARCHAR(50) Y Nomenclature of All Primary and Secondary Cancer diagnosis during the inpatient encounter.
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 Opioid metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ENCNTR_ID DOUBLE N The ID of the qualifying encounter associated to the record.
EXCLUDE_IND DOUBLE Y Indicates record qualified for Opioid 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.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IPP_IND DOUBLE Y Indicates record qualified for Opioid 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_OPIOID_2022_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_OPIOID_2022_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NUM_IND DOUBLE Y Indicates record qualified for Opioid numerator population.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PALL_HOSPICE_ORD_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention ordered.
PALL_HOSPICE_PERF_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention was performed as a clinical event.
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.
SCHED_IV_BENZ_DISCH_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule IV Benzodiazepines
SCHED_IV_BENZ_DISCH_ORD_DETAIL VARCHAR(100) Y The order detail of discharged medicine for Schedule IV Benzodiazepines
SCHED_IV_BENZ_DISCH_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_IV_BENZODIAZEPINES'
SCHED_OP_DISCH_1_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
SCHED_OP_DISCH_1_ORD_DETAIL VARCHAR(100) Y The first order detail of discharged medication for Schedule II and III Opioid Medicine
SCHED_OP_DISCH_1_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
SCHED_OP_DISCH_2_DT_TM DATETIME Y The second earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
SCHED_OP_DISCH_2_ORD_DETAIL VARCHAR(100) Y The 2nd order detail of discharged medication for Schedule II and III Opioid Medicine
SCHED_OP_DISCH_2_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
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_OPIOID_2022_METRICS


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



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures Safe Use of Opioids 2023 Metrics
Definition: Stores data gathered by the LH_E_OPIOID_2023 script.
Table Type: ACTIVITY





Column Detail - LH_E_OPIOID_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.
ALL_PRIM_SEC_CANCER_DT_TM DATETIME Y The date/time the diagnosis for All Primary and Secondary Cancer was given at.
ALL_PRIM_SEC_CANCER_NOMEN VARCHAR(50) Y Nomenclature of All Primary and Secondary Cancer diagnosis during the inpatient encounter.
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 Opioid 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_IND DOUBLE Y Indicates record qualified for Opioid 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.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IPP_IND DOUBLE Y Indicates record qualified for Opioid 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_OPIOID_2023_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_OPIOID_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.
NUM_IND DOUBLE Y Indicates record qualified for Opioid 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 N The ID of the qualifying Observation encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PALL_HOSPICE_ORD_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention ordered.
PALL_HOSPICE_PERF_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention was performed as a clinical event.
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.
SCHED_IV_BENZ_DISCH_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule IV Benzodiazepines
SCHED_IV_BENZ_DISCH_ORD_DETAIL VARCHAR(100) Y Order details for qualifying discharge medication for value set 'SCHEDULE_IV_BENZODIAZEPINES'
SCHED_IV_BENZ_DISCH_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_IV_BENZODIAZEPINES'
SCHED_OP_DISCH_1_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
SCHED_OP_DISCH_1_ORD_DETAIL VARCHAR(100) Y Order details for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
SCHED_OP_DISCH_1_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
SCHED_OP_DISCH_2_DT_TM DATETIME Y The second earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
SCHED_OP_DISCH_2_ORD_DETAIL VARCHAR(100) Y Order details for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
SCHED_OP_DISCH_2_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
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_OPIOID_2023_METRICS


Child Column in LH_E_OPIOID_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
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_OPIOID_2024_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures Safe Use of Opioids 2024 Metrics
Definition: Stores data gathered by the LH_E_OPIOID_2024 script.
Table Type: ACTIVITY





Column Detail - LH_E_OPIOID_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.
ALL_PRIM_SEC_CANCER_DT_TM DATETIME Y The date/time the diagnosis for All Primary and Secondary Cancer was given at.
ALL_PRIM_SEC_CANCER_NOMEN VARCHAR(50) Y Nomenclature of All Primary and Secondary Cancer diagnosis during the inpatient encounter.
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 Opioid 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_IND DOUBLE Y Indicates record qualified for Opioid 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.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
IPP_IND DOUBLE Y Indicates record qualified for Opioid 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_OPIOID_2024_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_OPIOID_2024_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NUM_IND DOUBLE Y Indicates record qualified for Opioid 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 N The ID of the qualifying Observation encounter associated to the record.
ORG_MRN_TXT VARCHAR(50) Y Medical Record Number of the record.
PALL_HOSPICE_ORD_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention ordered.
PALL_HOSPICE_PERF_DT_TM DATETIME Y The date/time of Palliative or Hospice Care intervention was performed as a clinical event.
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.
SCHED_IV_BENZ_DISCH_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule IV Benzodiazepines
SCHED_IV_BENZ_DISCH_ORD_DETAIL VARCHAR(100) Y Order details for qualifying discharge medication for value set 'SCHEDULE_IV_BENZODIAZEPINES'
SCHED_IV_BENZ_DISCH_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_IV_BENZODIAZEPINES'
SCHED_OP_DISCH_1_DT_TM DATETIME Y The earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
SCHED_OP_DISCH_1_ORD_DETAIL VARCHAR(100) Y Order details for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
SCHED_OP_DISCH_1_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
SCHED_OP_DISCH_2_DT_TM DATETIME Y The second earliest date/time of medication discharge documented for Schedule II and III Opioid Medications
SCHED_OP_DISCH_2_ORD_DETAIL VARCHAR(100) Y Order details for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
SCHED_OP_DISCH_2_PHYSICIAN VARCHAR(100) Y Ordering physician who placed order for qualifying discharge medication for value set 'SCHEDULE_II_AND_III_OPIOID_MEDICATIONS'
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_OPIOID_2024_METRICS


Child Column in LH_E_OPIOID_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_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_1_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