Table Detail Report

LH_E_ED_2017_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_ED_2016_METRICS
Definition: This table is used to store eMeasure ED Metrics for the 2016 reporting period. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_ED_2017_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.
DECISION_ADMIT_DT_TM DATETIME Y The earliest documented month, day, and year of the decision to admit.
DECISION_ADMIT_UTC_DT_TM DATETIME Y The earliest documented month, day, and year of the decision to admit normalized to GMT.
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 Identifies 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_METRIC_3_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_4_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
ED1_MEASUREMENT_VALUE DOUBLE N Identifies the ED Length of Stay (minutes) for ED-1
ED2_MEASUREMENT_VALUE DOUBLE N The amount of minutes between the decision to admit was placed and the ED Departure time (minutes) for ED-2
ED3_MEASUREMENT_VALUE DOUBLE N Identifies the ED Length of Stay (minutes) for ED-3
ED_ARRIVAL_DT_TM DATETIME Y Time the patient arrived the emergency department.
ED_ARRIVAL_UTC_DT_TM DATETIME Y Time the patient arrived the emergency department normalized to GMT.
ED_DEPART_DT_TM DATETIME Y Time the patient departed from the emergency department.
ED_DEPART_UTC_DT_TM DATETIME Y Time the patient departed from the emergency department normalized to GMT.
ED_ENCNTR_ID DOUBLE N Identifies the encounter is admitted throught the ED for ED-1 and ED-2
ED_LOC_END_DT_TM DATETIME Y Time patient left the emergency department location
ED_LOC_END_UTC_DT_TM DATETIME Y Time patient left the emergency department location normalized to GMT
ED_LOC_IND DOUBLE Y Identifies the patient an ED patient at the facility
ED_LOC_START_DT_TM DATETIME Y Time patient arrived the emergency department location
ED_LOC_START_UTC_DT_TM DATETIME Y Time patient arrived the emergency department location normalized to GMT
ED_POP_IND DOUBLE Y Identifies the ED encounter is qualified initial population for ED-3
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_1_IND DOUBLE Y Identifies patients excluded from ED-1
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from ED-2
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from ED-3
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_INS_NBR_TXT VARCHAR(50) Y The Medicare HIC number is the identification number given to a patient who is covered by Medicare
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_SET_DT_TM DATETIME Y The date of documentation of hospital settings
HOSP_SET_UTC_DT_TM DATETIME Y The utc date of documentation of hospital settings
HOSP_SVC_IND DOUBLE N Indicates if the encounter should be excluded from the population due to the visit type
INP_POP_IND DOUBLE Y Identifies the inptient encounter is qualified initial population for ED-1 and ED-2
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_ED_2017_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_ED_2017_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.
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
PAYER_CODE_TXT VARCHAR(20) Y Identifies the payer code for the encounter
PERSON_ETHNIC_CODE VARCHAR(50) Y Ethnicity code of the patient as per value set
PERSON_ETHNIC_CODE_DISPLAY VARCHAR(500) Y Ethnicity code system OID of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM VARCHAR(50) Y Ethnicity code display of the patient as per value set
PERSON_ETHNIC_CODE_SYSTEM_NAME VARCHAR(50) Y Ethnicity code system name of the patient as per value set
PERSON_GENDER_CODE VARCHAR(50) Y Gender code of the patient as per value set
PERSON_GENDER_CODE_DISPLAY VARCHAR(500) Y Gender code system OID of the patient as per value set
PERSON_GENDER_CODE_SYSTEM VARCHAR(50) Y Gender code display of the patient as per value set
PERSON_GENDER_CODE_SYSTEM_NAME VARCHAR(50) Y Gender code system name of the patient as per value set
PERSON_PAYER_CODE VARCHAR(50) Y Represents the patient's member or subscriber identifier with respect to the payer
PERSON_PAYER_CODE_DISPLAY VARCHAR(500) Y Represents the patient's member or subscriber identifier coding system OID with respect to the payer
PERSON_PAYER_CODE_SYSTEM VARCHAR(50) Y Represents the patient's member or subscriber identifier display with respect to the payer
PERSON_PAYER_CODE_SYSTEM_NAME VARCHAR(50) Y Represents the patient's member or subscriber identifier coding system name with respect to the payer
PERSON_RACE_CODE VARCHAR(50) Y Race code of the patient as per value set
PERSON_RACE_CODE_DISPLAY VARCHAR(500) Y Race code system OID of the patient as per value set
PERSON_RACE_CODE_SYSTEM VARCHAR(50) Y Race code display of the patient as per value set
PERSON_RACE_CODE_SYSTEM_NAME VARCHAR(50) Y Race code system name of the patient as per value set
PERSON_RACE_DESC VARCHAR(500) Y The list of all of a patient's races
PSYCH_MENTAL_HEALTH_IND DOUBLE Y Identifies patients with a mental disorder listed as their principle diagnosis
TIMEZONE_IDENT DOUBLE Y Identifies the timezone index number associated with the quality measure.
TRAN_ACH_IND DOUBLE Y Identifies patients trasnfer to Acute Care Hospital with 6 hours of current encounter discharged.
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. 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 N 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) 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. 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_ED_2017_METRICS


Child Column in LH_E_ED_2017_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
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
D_METRIC_4_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
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_ED_2018_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_ED_2018_METRICS
Definition: Stores data gathered by the LH_E_ED_2018 program.
Table Type: ACTIVITY





Column Detail - LH_E_ED_2018_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.
DECISION_TO_ADMIT_DT_TM DATETIME Y The time of the decision to admit to inpatient.
DECISION_TO_ADMIT_UTC_DT_TM DATETIME Y The time of the decision to admit to inpatient in UTC.
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
DISCHARGE_UTC_DT_TM DATETIME Y The end of the qualifying encounter in UTC.
DISCH_ACUTE_CARE_IND DOUBLE Y Indicates the patient was discharged to an acute care facility.
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 miscelleneous ED metric.
D_METRIC_1_ID DOUBLE N Dimension ID for ED-1 metric.
D_METRIC_2_ID DOUBLE N Dimension ID for ED-2 metric.
D_METRIC_3_ID DOUBLE N Dimension ID for ED-3 metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ED1_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-1.
ED1_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-1 measure population exclusion.
ED1_POP_IND DOUBLE Y Indicates record qualified for ED-1 population.
ED2_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-2.
ED2_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-2 measure population exclusion.
ED2_POP_IND DOUBLE Y Indicates record qualified for ED-2 population.
ED3_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-3.
ED3_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-3 measure population exclusion.
ED3_POP_IND DOUBLE Y Indicates record qualified for ED-3 population.
ED_ARRIVAL_DT_TM DATETIME Y The start of the emergency encounter.
ED_ARRIVAL_UTC_DT_TM DATETIME Y The start of the emergency encounter in UTC.
ED_DEPART_DT_TM DATETIME Y The end of the emergency encounter.
ED_DEPART_UTC_DT_TM DATETIME Y The end of the emergency encounter in UTC.
ED_ENCNTR_ID DOUBLE N The ID of the emergency encounter associated to the record.
ED_LOC_END_DT_TM DATETIME Y The end of the emergency location.
ED_LOC_END_UTC_DT_TM DATETIME Y The start of the emergency location in UTC.
ED_PSYCH_MENTAL_HEALTH_NOMEN VARCHAR(50) Y Nomenclature of mental health diagnosis during the emergency encounter.
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_INS_NBR_TXT VARCHAR(50) Y Primary Payer of the 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_SETTINGS_DT_TM DATETIME Y The time of the transfer from hospital setting.
HOSP_SETTINGS_UTC_DT_TM DATETIME Y The time of the transfer from hospital setting in UTC.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
IP_ADMIT_UTC_DT_TM DATETIME Y The start of the inpatient encounter in UTC.
IP_PSYCH_MENTAL_HEALTH_NOMEN VARCHAR(50) Y Nomenclature of mental health diagnosis during the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_ED_2018_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_ED_2018_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.
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.
PAT_EXPIRED_IND DOUBLE Y Indicates the patient expired.
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.
TIMEZONE_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_ED_2018_METRICS


Child Column in LH_E_ED_2018_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
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
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_ED_2019_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_ED_2019_METRICS
Definition: Stores data gathered by the LH_E_ED_2019 program.
Table Type: ACTIVITY





Column Detail - LH_E_ED_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.
DECISION_TO_ADMIT_DT_TM DATETIME Y The time of the decision to admit to inpatient.
DISCHARGE_DT_TM DATETIME Y The end of the qualifying encounter.
DISCH_ACUTE_CARE_IND DOUBLE Y Indicates the patient was discharged to an acute care facility.
D_ADMIT_BUILDING_ID DOUBLE N Dimension ID for admit building.
D_ADMIT_FACILITY_ID DOUBLE N Dimension ID for admit facility.
D_ADMIT_NURSE_UNIT_ID DOUBLE N Dimension ID for admit nurse unit.
D_ADMIT_SRC_ID DOUBLE N Dimension ID for admit source.
D_ADMIT_TYPE_ID DOUBLE N Dimension ID for admit type.
D_ATTEND_PRSNL_ID DOUBLE N Dimension ID for attending physician.
D_BR_CCN_ID DOUBLE N Dimension ID for CCN.
D_BR_HCO_ID DOUBLE N Dimension ID for HCO.
D_DISCHARGE_BUILDING_ID DOUBLE N Dimension ID for discharge building.
D_DISCHARGE_FACILITY_ID DOUBLE N Dimension ID for discharge facility.
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Dimension ID for discharge nurse unit.
D_DISCH_DISP_ID DOUBLE N Dimension ID for discharge disposition.
D_ENCNTR_TYPE_ID DOUBLE N Dimension ID for encounter type.
D_METRIC_1_ID DOUBLE N Dimension ID for ED-1 metric.
D_METRIC_2_ID DOUBLE N Dimension ID for ED-2 metric.
D_METRIC_3_ID DOUBLE N Dimension ID for ED-3 metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ED1_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-1.
ED1_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-1 measure population exclusion.
ED1_POP_IND DOUBLE Y Indicates record qualified for ED-1 population.
ED2_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-2.
ED2_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-2 measure population exclusion.
ED2_POP_IND DOUBLE Y Indicates record qualified for ED-2 population.
ED3_FIN_NBR_TXT VARCHAR(50) Y Primary Payer of the record.
ED3_IPP_IND DOUBLE Y Indicates record qualified for ED-3 population.
ED3_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-3.
ED3_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-3 measure population exclusion.
ED3_MEAS_POP_IND DOUBLE Y Indicates record qualified for ED-3 measure population.
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.
ED_LOC_END_DT_TM DATETIME Y The end of the emergency location.
ED_PSYCH_MENTAL_HEALTH_NOMEN VARCHAR(50) Y Nomenclature of mental health diagnosis during the emergency encounter.
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_SETTINGS_DT_TM DATETIME Y The time of the transfer from hospital setting.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
IP_PSYCH_MENTAL_HEALTH_NOMEN VARCHAR(50) Y Nomenclature of mental health diagnosis during the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_ED_2019_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_ED_2019_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.
OBS_SERVICES_DT_TM DATETIME Y The start date/time of Observation services order.
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.
PAT_DECEASED_IND DOUBLE Y Indicates the patient expired.
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.
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.
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_ED_2019_METRICS


Child Column in LH_E_ED_2019_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_ADMIT_SRC_ID LH_D_ADMIT_SRC D_ADMIT_SRC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_SRC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_TYPE_ID LH_D_ADMIT_TYPE D_ADMIT_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ADMIT_TYPE HEALTH_SYSTEM_SOURCE_ID
D_BR_CCN_ID LH_D_BR_CCN D_BR_CCN_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_CCN HEALTH_SYSTEM_SOURCE_ID
D_BR_HCO_ID LH_D_BR_HCO D_BR_HCO_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BR_HCO HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_BUILDING HEALTH_SYSTEM_SOURCE_ID
D_DISCH_DISP_ID LH_D_DISCH_DISP D_DISCH_DISP_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_DISCH_DISP HEALTH_SYSTEM_SOURCE_ID
D_ENCNTR_TYPE_ID LH_D_ENCNTR_TYPE D_ENCNTR_TYPE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_ENCNTR_TYPE HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
D_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_METRIC_1_ID LH_D_METRIC D_METRIC_ID
D_METRIC_2_ID LH_D_METRIC D_METRIC_ID
D_METRIC_3_ID LH_D_METRIC D_METRIC_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_METRIC HEALTH_SYSTEM_SOURCE_ID
D_ADMIT_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_E_ED_2020_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures ED 2020 Metrics
Definition: Stores data gathered by the LH_E_ED_2020 script.
Table Type: ACTIVITY





Column Detail - LH_E_ED_2020_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DECISION_TO_ADMIT_DT_TM DATETIME Y The time of the decision to admit to inpatient.
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_2_ID DOUBLE N Dimension ID for ED-2 metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ED2_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-2.
ED2_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-2 measure population exclusion.
ED2_POP_IND DOUBLE Y Indicates record qualified for ED-2 population.
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.
ED_LOC_END_DT_TM DATETIME Y The end of the emergency location.
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_SETTINGS_DT_TM DATETIME Y The time of the transfer from hospital setting.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
IP_PSYCH_MENTAL_HEALTH_NOMEN VARCHAR(50) Y Nomenclature of mental health diagnosis during the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_ED_2020_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_ED_2020_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
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_ED_2020_METRICS


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



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lighthouse eMeasures ED 2021 Metrics
Definition: Stores data gathered by the LH_E_ED_2021 script.
Table Type: ACTIVITY





Column Detail - LH_E_ED_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.
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_2_ID DOUBLE N Dimension ID for ED-2 metric.
D_PERSON_ID DOUBLE N Dimension ID for person data.
ED2_MEAS_OBS DOUBLE Y Identifies the ED Length of Stay (minutes) for ED-2.
ED2_MEAS_POP_EXCL_IND DOUBLE Y Indicates record qualified for ED-2 measure population exclusion.
ED2_POP_IND DOUBLE Y Indicates record qualified for ED-2 population.
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.
ED_EVAL_ADMIT_TO_IP_DT_TM DATETIME Y The time of the Assessment performed for ED_evaluation fpr Admit Inpatient
ED_LOC_END_DT_TM DATETIME Y The end of the emergency location.
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_SETTINGS_DT_TM DATETIME Y The time of the transfer from hospital setting.
IP_ADMIT_DT_TM DATETIME Y The start of the inpatient encounter.
IP_PSYCH_MENTAL_HEALTH_NOMEN VARCHAR(50) Y Nomenclature of mental health diagnosis during the inpatient encounter.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_E_ED_2021_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_ED_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.
ORD_DECISION_TO_ADMIT_DT_TM DATETIME Y The time of the order documented for decision to admit to inpatient.
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_ED_2021_METRICS


Child Column in LH_E_ED_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_2_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