Millennium Data Model Reports - 2026.1.01

• Home
• |
• Reports by Table
• |
• Table Report Help

Table Detail Report

LH_E_STROKE_2020_METRICS

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	LH_E_STROKE_2020_METRICS
Definition:	Stores data gathered by the LH_E_STROKE_2020 program.
Table Type:	ACTIVITY

Column Detail - LH_E_STROKE_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.
AC_DISCH_DT_TM	DATETIME	Y	The data/time of the anticoagulant discharge medication.
AC_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no anticoagulant therapy was documented.
AC_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for anticoagulant therapy was documented.
ATRIAL_ABLATION_PROC_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial ablation procedure was documented.
ATRIAL_ABLATION_PROC_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial ablation procedure.
ATRIAL_FIB_FLUTTER_DX_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial fibrillation/fultter diagnosis was documented.
ATRIAL_FIB_FLUTTER_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial fibrillation/fultter diagnosis.
AT_ADMIN_DT_TM	DATETIME	Y	Identifies the Antithrombotic administration within 1 day after hospitalization start.
AT_ADMIN_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_ADMIN_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_DISCH_DT_TM	DATETIME	Y	The data/time of the antithrombotic discharge medication.
AT_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no antithrombotic therapy was documented.
AT_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for antithrombotic therapy was documented.
AT_ORDER_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not ordering Antithrombotics within 1 day after hospitalization start
AT_ORDER_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after hospitalization start
CMO_ORDER_1D_DT_TM	DATETIME	Y	The date/time of the order for comfort measures within 1 day after the start of the hospitalization
CMO_ORDER_DT_TM	DATETIME	Y	The date/time of comfort measures order.
CMO_PERF_1D_DT_TM	DATETIME	Y	The date/time of the event for comfort measures within 1 day after the start of the hospitalization
CMO_PERF_DT_TM	DATETIME	Y	The data/time of comfort measures clinical event.
DEN_2_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-2
DEN_3_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-3
DEN_5_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-5
DEN_6_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-6
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	Identifies the metric identifier for the Lighthouse metric: STK-2
D_METRIC_3_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-3
D_METRIC_5_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-5
D_METRIC_6_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-6
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	Identifies the emergency encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENCNTR_ID	DOUBLE	N	The ID of the qualifying encounter associated to the record.
EXCEP_2_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-2
EXCEP_3_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-3
EXCEP_5_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-5
EXCEP_6_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-6
EXCLUDE_2_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-2
EXCLUDE_3_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-3
EXCLUDE_5_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-5
EXCLUDE_6_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-6
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.
HEMORRHAGIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of hemorrhagic stroke principal diagnosis.
INR_TXT	VARCHAR(100)	Y	Identifiesthe INR value documented for a Laboratory test performed
IPP_IND	DOUBLE	Y	Indicates the encounter within the initial patient population
IP_ADMIT_DT_TM	DATETIME	Y	The start of the inpatient encounter.
ISCHEMIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of ischemic stroke principal diagnosis.
LAST_PROCESS_DT_TM	DATETIME	Y	The date/time that the last ETL process started that updated this record.
LDL_RSLT_TXT	VARCHAR(100)	Y	Identifies if LDL result is documente and if yes, displays what value is documented.
LH_E_STROKE_2020_METRICS_ID	DOUBLE	N	Unique generated number that identifies a single row on the LH_E_STROKE_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.
NUM_2_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-2
NUM_3_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-3
NUM_5_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-5
NUM_6_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-6
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.
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.
STATIN_ALLERGY_IND	DOUBLE	Y	Identifies if there was a Allergy Reason for not giving Statins
STATIN_DISCH_DT_TM	DATETIME	Y	The date/time of the Statin prescribed at discharge
STATIN_DISCH_MED_RES_IND	DOUBLE	Y	Identifies if there was a Medical Reason for not giving Statins
STATIN_DISCH_PAT_REF_IND	DOUBLE	Y	Identifies if there was a Patient Refusal for not giving Statins
TICAG_ADMIN_1D_DT_TM	DATETIME	Y	Identifies the date/time Ticagrelor Administered was documented within 1 day of IP admit
TICAG_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time Ticagrelor Administered was documented
TIME_ZONE_TXT	VARCHAR(100)	Y	The timezone of the record in ""America/Chicago"" format.
TPA_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time of TPA Administered was documented
TPA_DIAG_DT_TM	DATETIME	Y	Identifies the most recent documentation of diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_DX_NOMEN	VARCHAR(50)	Y	Identifies the documentation code diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_PROC_DT_TM	DATETIME	Y	Identifies the most recent documentation of procedure for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
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_STROKE_2020_METRICS

	Child Column in LH_E_STROKE_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
	D_METRIC_3_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_5_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_6_ID	LH_D_METRIC	D_METRIC_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	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_STROKE_2021_METRICS

Column Section

Relationship Section

Top of Page

Table-level Detail

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

Column Detail - LH_E_STROKE_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.
AC_DISCH_DT_TM	DATETIME	Y	The data/time of the anticoagulant discharge medication.
AC_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no anticoagulant therapy was documented.
AC_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for anticoagulant therapy was documented.
ATRIAL_ABLATION_PROC_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial ablation procedure was documented.
ATRIAL_ABLATION_PROC_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial ablation procedure.
ATRIAL_FIB_FLUTTER_DX_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial fibrillation/fultter diagnosis was documented.
ATRIAL_FIB_FLUTTER_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial fibrillation/fultter diagnosis.
AT_ADMIN_DT_TM	DATETIME	Y	Identifies the Antithrombotic administration within 1 day after hospitalization start.
AT_ADMIN_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_ADMIN_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_DISCH_DT_TM	DATETIME	Y	The data/time of the antithrombotic discharge medication.
AT_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no antithrombotic therapy was documented.
AT_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for antithrombotic therapy was documented.
AT_ORDER_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not ordering Antithrombotics within 1 day after hospitalization start
AT_ORDER_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after hospitalization start
CMO_ORDER_1D_DT_TM	DATETIME	Y	The date/time of the order for comfort measures within 1 day after the start of the hospitalization
CMO_ORDER_DT_TM	DATETIME	Y	The date/time of comfort measures order.
CMO_PERF_1D_DT_TM	DATETIME	Y	The date/time of the event for comfort measures within 1 day after the start of the hospitalization
CMO_PERF_DT_TM	DATETIME	Y	The data/time of comfort measures clinical event.
DEN_2_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-2
DEN_3_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-3
DEN_5_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-5
DEN_6_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-6
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	Identifies the metric identifier for the Lighthouse metric: STK-2
D_METRIC_3_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-3
D_METRIC_5_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-5
D_METRIC_6_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-6
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	Identifies the emergency encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENCNTR_ID	DOUBLE	N	The ID of the qualifying encounter associated to the record.
EXCEP_2_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-2
EXCEP_3_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-3
EXCEP_5_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-5
EXCEP_6_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-6
EXCLUDE_2_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-2
EXCLUDE_3_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-3
EXCLUDE_5_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-5
EXCLUDE_6_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-6
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.
HEMORRHAGIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of hemorrhagic stroke principal diagnosis.
INR_TXT	VARCHAR(100)	Y	Identifiesthe INR value documented for a Laboratory test performed
IPP_IND	DOUBLE	Y	Indicates the encounter within the initial patient population
IP_ADMIT_DT_TM	DATETIME	Y	The start of the inpatient encounter.
ISCHEMIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of ischemic stroke principal diagnosis.
LAST_PROCESS_DT_TM	DATETIME	Y	The date/time that the last ETL process started that updated this record.
LDL_RSLT_TXT	VARCHAR(100)	Y	Identifies if LDL result is documente and if yes, displays what value is documented.
LH_E_STROKE_2021_METRICS_ID	DOUBLE	N	Unique generated number that identifies a single row on the LH_E_STROKE_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_2_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-2
NUM_3_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-3
NUM_5_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-5
NUM_6_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-6
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.
PC_AT_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication Administered was documented
PC_AT_DISCH_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication at Discharge was documented
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.
STATIN_ALLERGY_IND	DOUBLE	Y	Identifies if there was a Allergy Reason for not giving Statins
STATIN_DISCH_DT_TM	DATETIME	Y	The date/time of the Statin prescribed at discharge
STATIN_DISCH_MED_RES_IND	DOUBLE	Y	Identifies if there was a Medical Reason for not giving Statins
STATIN_DISCH_PAT_REF_IND	DOUBLE	Y	Identifies if there was a Patient Refusal for not giving Statins
TIME_ZONE_TXT	VARCHAR(100)	Y	The timezone of the record in ""America/Chicago"" format.
TPA_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time of TPA Administered was documented
TPA_DIAG_DT_TM	DATETIME	Y	Identifies the most recent documentation of diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_DX_NOMEN	VARCHAR(50)	Y	Identifies the documentation code diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_PROC_DT_TM	DATETIME	Y	Identifies the most recent documentation of procedure for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
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_STROKE_2021_METRICS

	Child Column in LH_E_STROKE_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
	D_METRIC_3_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_5_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_6_ID	LH_D_METRIC	D_METRIC_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	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_STROKE_2022_METRICS

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	LH_E_STROKE_2022_METRICS
Definition:	Stores data gathered by the LH_E_STROKE_2022 script.
Table Type:	ACTIVITY

Column Detail - LH_E_STROKE_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.
AC_DISCH_DT_TM	DATETIME	Y	The data/time of the anticoagulant discharge medication.
AC_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no anticoagulant therapy was documented.
AC_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for anticoagulant therapy was documented.
ATRIAL_ABLATION_PROC_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial ablation procedure was documented.
ATRIAL_ABLATION_PROC_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial ablation procedure.
ATRIAL_FIB_FLUTTER_DX_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial fibrillation/fultter diagnosis was documented.
ATRIAL_FIB_FLUTTER_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial fibrillation/fultter diagnosis.
AT_ADMIN_DT_TM	DATETIME	Y	Identifies the Antithrombotic administration within 1 day after hospitalization start.
AT_ADMIN_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_ADMIN_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_DISCH_DT_TM	DATETIME	Y	The data/time of the antithrombotic discharge medication.
AT_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no antithrombotic therapy was documented.
AT_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for antithrombotic therapy was documented.
AT_ORDER_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not ordering Antithrombotics within 1 day after hospitalization start
AT_ORDER_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after hospitalization start
CMO_ORDER_1D_DT_TM	DATETIME	Y	The date/time of the order for comfort measures within 1 day after the start of the hospitalization
CMO_ORDER_DT_TM	DATETIME	Y	The date/time of comfort measures order.
CMO_PERF_1D_DT_TM	DATETIME	Y	The date/time of the event for comfort measures within 1 day after the start of the hospitalization
CMO_PERF_DT_TM	DATETIME	Y	The data/time of comfort measures clinical event.
DEN_2_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-2
DEN_3_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-3
DEN_5_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-5
DEN_6_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-6
DISCHARGE_DT_TM	DATETIME	Y	The end of the qualifying encounter.
D_ADMIT_BUILDING_ID	DOUBLE	Y	Dimension ID for admit building.
D_ADMIT_FACILITY_ID	DOUBLE	Y	Dimension ID for admit facility.
D_ADMIT_NURSE_UNIT_ID	DOUBLE	Y	Dimension ID for admit nurse unit.
D_ADMIT_SRC_ID	DOUBLE	Y	Dimension ID for admit source.
D_ADMIT_TYPE_ID	DOUBLE	Y	Dimension ID for admit type.
D_ATTEND_PRSNL_ID	DOUBLE	Y	Dimension ID for attending physician.
D_BR_CCN_ID	DOUBLE	Y	Dimension ID for CCN.
D_BR_HCO_ID	DOUBLE	Y	Dimension ID for HCO.
D_DISCHARGE_BUILDING_ID	DOUBLE	Y	Dimension ID for discharge building.
D_DISCHARGE_FACILITY_ID	DOUBLE	Y	Dimension ID for discharge facility.
D_DISCHARGE_NURSE_UNIT_ID	DOUBLE	Y	Dimension ID for discharge nurse unit.
D_DISCH_DISP_ID	DOUBLE	Y	Dimension ID for discharge disposition.
D_ENCNTR_TYPE_ID	DOUBLE	Y	Dimension ID for encounter type.
D_METRIC_2_ID	DOUBLE	Y	Identifies the metric identifier for the Lighthouse metric: STK-2
D_METRIC_3_ID	DOUBLE	Y	Identifies the metric identifier for the Lighthouse metric: STK-3
D_METRIC_5_ID	DOUBLE	Y	Identifies the metric identifier for the Lighthouse metric: STK-5
D_METRIC_6_ID	DOUBLE	Y	Identifies the metric identifier for the Lighthouse metric: STK-6
D_PERSON_ID	DOUBLE	Y	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	Y	Identifies the emergency encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENCNTR_ID	DOUBLE	Y	The ID of the qualifying encounter associated to the record.
EXCEP_2_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-2
EXCEP_3_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-3
EXCEP_5_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-5
EXCEP_6_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-6
EXCLUDE_2_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-2
EXCLUDE_3_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-3
EXCLUDE_5_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-5
EXCLUDE_6_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-6
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	Y	Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID	DOUBLE	Y	Identifies the unique source within the delivery network responsible for supplying the data.
HEMORRHAGIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of hemorrhagic stroke principal diagnosis.
INR_TXT	VARCHAR(100)	Y	Identifiesthe INR value documented for a Laboratory test performed
IPP_IND	DOUBLE	Y	Indicates the encounter within the initial patient population
IP_ADMIT_DT_TM	DATETIME	Y	The start of the inpatient encounter.
ISCHEMIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of ischemic stroke principal diagnosis.
LAST_PROCESS_DT_TM	DATETIME	Y	The date/time that the last ETL process started that updated this record.
LDL_RSLT_TXT	VARCHAR(100)	Y	Identifies if LDL result is documente and if yes, displays what value is documented.
LH_E_STROKE_2022_METRICS_ID	DOUBLE	N	Unique generated number that identifies a single row on the LH_E_STROKE_2022_METRICS table.
LOGICAL_DOMAIN_ID	DOUBLE	Y	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_2_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-2
NUM_3_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-3
NUM_5_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-5
NUM_6_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-6
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	Y	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.
PC_AT_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication Administered was documented
PC_AT_DISCH_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication at Discharge was documented
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	Y	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.
STATIN_ALLERGY_IND	DOUBLE	Y	Identifies if there was a Allergy Reason for not giving Statins
STATIN_DISCH_DT_TM	DATETIME	Y	The date/time of the Statin prescribed at discharge
STATIN_DISCH_MED_RES_IND	DOUBLE	Y	Identifies if there was a Medical Reason for not giving Statins
STATIN_DISCH_PAT_REF_IND	DOUBLE	Y	Identifies if there was a Patient Refusal for not giving Statins
TIME_ZONE_TXT	VARCHAR(100)	Y	The timezone of the record in ""America/Chicago"" format.
TPA_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time of TPA Administered was documented
TPA_DIAG_DT_TM	DATETIME	Y	Identifies the most recent documentation of diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_DX_NOMEN	VARCHAR(60)	Y	Identifies the documentation code diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_PROC_DT_TM	DATETIME	Y	Identifies the most recent documentation of procedure for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
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_STROKE_2022_METRICS

	Child Column in LH_E_STROKE_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_2_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_3_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_5_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_6_ID	LH_D_METRIC	D_METRIC_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	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_STROKE_2023_METRICS

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	LH_E_STROKE_2022_METRICS
Definition:	Stores data gathered by the LH_E_STROKE_2023 script.
Table Type:	ACTIVITY

Column Detail - LH_E_STROKE_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.
AC_DISCH_DT_TM	DATETIME	Y	The data/time of the anticoagulant discharge medication.
AC_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no anticoagulant therapy was documented.
AC_DISCH_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying discharge medication for value set 'ANTICOAGULANT_THERAPY'
AC_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for anticoagulant therapy was documented.
ATRIAL_ABLATION_PROC_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial ablation procedure was documented.
ATRIAL_ABLATION_PROC_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial ablation procedure.
ATRIAL_FIB_FLUTTER_DX_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial fibrillation/fultter diagnosis was documented.
ATRIAL_FIB_FLUTTER_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial fibrillation/fultter diagnosis.
AT_ADMIN_DT_TM	DATETIME	Y	Identifies the Antithrombotic administration within 1 day after hospitalization start.
AT_ADMIN_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_ADMIN_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'ANTITHROMBOTIC_THERAPY'
AT_ADMIN_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_DISCH_DT_TM	DATETIME	Y	The data/time of the antithrombotic discharge medication.
AT_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no antithrombotic therapy was documented.
AT_DISCH_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'ANTITHROMBOTIC_THERAPY'
AT_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for antithrombotic therapy was documented.
AT_ORDER_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not ordering Antithrombotics within 1 day after hospitalization start
AT_ORDER_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after hospitalization start
CMO_ORDER_1D_DT_TM	DATETIME	Y	The date/time of the order for comfort measures within 1 day after the start of the hospitalization
CMO_ORDER_DT_TM	DATETIME	Y	The date/time of comfort measures order.
CMO_PERF_1D_DT_TM	DATETIME	Y	The date/time of the event for comfort measures within 1 day after the start of the hospitalization
CMO_PERF_DT_TM	DATETIME	Y	The data/time of comfort measures clinical event.
DEN_2_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-2
DEN_3_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-3
DEN_5_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-5
DEN_6_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-6
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	Identifies the metric identifier for the Lighthouse metric: STK-2
D_METRIC_3_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-3
D_METRIC_5_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-5
D_METRIC_6_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-6
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	Identifies the emergency encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENCNTR_ID	DOUBLE	N	The ID of the qualifying encounter associated to the record.
EXCEP_2_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-2
EXCEP_3_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-3
EXCEP_5_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-5
EXCEP_6_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-6
EXCLUDE_2_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-2
EXCLUDE_3_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-3
EXCLUDE_5_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-5
EXCLUDE_6_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-6
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.
HEMORRHAGIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of hemorrhagic stroke principal diagnosis.
INR_TXT	VARCHAR(100)	Y	Identifiesthe INR value documented for a Laboratory test performed
IPP_IND	DOUBLE	Y	Indicates the encounter within the initial patient population
IP_ADMIT_DT_TM	DATETIME	Y	The start of the inpatient encounter.
ISCHEMIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of ischemic stroke principal diagnosis.
LAST_PROCESS_DT_TM	DATETIME	Y	The date/time that the last ETL process started that updated this record.
LDL_RSLT_TXT	VARCHAR(100)	Y	Identifies if LDL result is documente and if yes, displays what value is documented.
LH_E_STROKE_2023_METRICS_ID	DOUBLE	N	Unique generated number that identifies a single row on the LH_E_STROKE_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_2_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-2
NUM_3_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-3
NUM_5_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-5
NUM_6_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-6
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.
PC_AT_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication Administered was documented
PC_AT_ADMIN_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'PHARMACOLOGICAL_CONTRAINDICATIONS_FOR_ANTITHROMBOTIC_THERAPY'
PC_AT_DISCH_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication at Discharge was documented
PC_AT_DISCH_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying discharge medication for value set 'PHARMACOLOGICAL_CONTRAINDICATIONS_FOR_ANTITHROMBOTIC_THERAPY'
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.
STATIN_ALLERGY_IND	DOUBLE	Y	Identifies if there was a Allergy Reason for not giving Statins
STATIN_DISCH_DT_TM	DATETIME	Y	The date/time of the Statin prescribed at discharge
STATIN_DISCH_MED_RES_IND	DOUBLE	Y	Identifies if there was a Medical Reason for not giving Statins
STATIN_DISCH_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying discharge medication for value set 'STATIN_GROUPER'
STATIN_DISCH_PAT_REF_IND	DOUBLE	Y	Identifies if there was a Patient Refusal for not giving Statins
TIME_ZONE_TXT	VARCHAR(100)	Y	The timezone of the record in ""America/Chicago"" format.
TPA_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time of TPA Administered was documented
TPA_ADMIN_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'THROMBOLYTIC_TPA_THERAPY'
TPA_DIAG_DT_TM	DATETIME	Y	Identifies the most recent documentation of diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_DX_NOMEN	VARCHAR(60)	Y	Identifies the documentation code diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_PROC_DT_TM	DATETIME	Y	Identifies the most recent documentation of procedure for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_PROC_NOMEN	VARCHAR(60)	Y	Identifies the documented procedure or clinical_Event code for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy.
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_STROKE_2023_METRICS

	Child Column in LH_E_STROKE_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_2_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_3_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_5_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_6_ID	LH_D_METRIC	D_METRIC_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	HEALTH_SYSTEM_SOURCE_ID	LH_D_METRIC	HEALTH_SYSTEM_SOURCE_ID
	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_STROKE_2024_METRICS

Column Section

Relationship Section

Top of Page

Table-level Detail

Description:	Lighthouse eMeasures STK 2024 Metrics
Definition:	Stores data gathered by the LH_E_STROKE_2024 script.
Table Type:	ACTIVITY

Column Detail - LH_E_STROKE_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.
AC_DISCH_DT_TM	DATETIME	Y	The data/time of the anticoagulant discharge medication.
AC_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no anticoagulant therapy was documented.
AC_DISCH_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying discharge medication for value set 'ANTICOAGULANT_THERAPY'
AC_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for anticoagulant therapy was documented.
ATRIAL_ABLATION_ASSES_PERF_IND	DOUBLE	Y	Identifies the prior documentation time of atrial ablation assessment performed on the qualifying patient.
ATRIAL_ABLATION_ASSES_PERF_TXT	VARCHAR(60)	Y	Identifies the prior documentation code of atrial ablation assessment performed on the qu.alifying patient
ATRIAL_ABLATION_PRIOR_DX_DT_TM	DATETIME	Y	Identifies the prior documentation time of atrial ablation diagnosis on the qualifying patient.
ATRIAL_ABLATION_PRIOR_DX_NOMEN	VARCHAR(50)	Y	Identifies the prior documentation code of atrial ablation diagnosis on the qualifying patient.
ATRIAL_ABLATION_PROC_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial ablation procedure was documented.
ATRIAL_ABLATION_PROC_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial ablation procedure.
ATRIAL_FIB_FLUTTER_DX_DT_TM	DATETIME	Y	The date/time the nomenclature of atrial fibrillation/fultter diagnosis was documented.
ATRIAL_FIB_FLUTTER_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of atrial fibrillation/fultter diagnosis.
AT_ADMIN_DT_TM	DATETIME	Y	Identifies the Antithrombotic administration within 1 day after hospitalization start.
AT_ADMIN_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_ADMIN_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'ANTITHROMBOTIC_THERAPY'
AT_ADMIN_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after hospitalization start
AT_DISCH_DT_TM	DATETIME	Y	The data/time of the antithrombotic discharge medication.
AT_DISCH_MED_RES_IND	DOUBLE	Y	Indicates medical reason for no antithrombotic therapy was documented.
AT_DISCH_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'ANTITHROMBOTIC_THERAPY'
AT_DISCH_PAT_REF_IND	DOUBLE	Y	Indicates patient refusal for antithrombotic therapy was documented.
AT_ORDER_MED_RES_IND	DOUBLE	Y	Identifies a Medical Reason for not ordering Antithrombotics within 1 day after hospitalization start
AT_ORDER_PAT_REF_IND	DOUBLE	Y	Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after hospitalization start
CMO_ORDER_1D_DT_TM	DATETIME	Y	The date/time of the order for comfort measures within 1 day after the start of the hospitalization
CMO_ORDER_DT_TM	DATETIME	Y	The date/time of comfort measures order.
CMO_PERF_1D_DT_TM	DATETIME	Y	The date/time of the event for comfort measures within 1 day after the start of the hospitalization
CMO_PERF_DT_TM	DATETIME	Y	The data/time of comfort measures clinical event.
DEN_2_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-2
DEN_3_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-3
DEN_5_IND	DOUBLE	Y	Identifies if the encounter is In Denominator for STK-5
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	Identifies the metric identifier for the Lighthouse metric: STK-2
D_METRIC_3_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-3
D_METRIC_5_ID	DOUBLE	N	Identifies the metric identifier for the Lighthouse metric: STK-5
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	Identifies the emergency encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ENCNTR_ID	DOUBLE	N	The ID of the qualifying encounter associated to the record.
EXCEP_2_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-2
EXCEP_3_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-3
EXCEP_5_IND	DOUBLE	Y	Identifies if the encounter is a Denominator Exception for STK-5
EXCLUDE_2_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-2
EXCLUDE_3_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-3
EXCLUDE_5_IND	DOUBLE	Y	Identifies if the encounter is Excluded for STK-5
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.
HEMORRHAGIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of hemorrhagic stroke principal diagnosis.
INR_TXT	VARCHAR(100)	Y	Identifiesthe INR value documented for a Laboratory test performed
IPP_IND	DOUBLE	Y	Indicates the encounter within the initial patient population
IP_ADMIT_DT_TM	DATETIME	Y	The start of the inpatient encounter.
ISCHEMIC_DX_NOMEN	VARCHAR(50)	Y	The nomenclature of ischemic stroke principal diagnosis.
LAST_PROCESS_DT_TM	DATETIME	Y	The date/time that the last ETL process started that updated this record.
LH_E_STROKE_2024_METRICS_ID	DOUBLE	N	Unique generated number that identifies a single row on the LH_E_STROKE_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_2_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-2
NUM_3_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-3
NUM_5_IND	DOUBLE	Y	Identifies if the encounter is in the Numerator for STK-5
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.
PC_AT_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication Administered was documented
PC_AT_ADMIN_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'PHARMACOLOGICAL_CONTRAINDICATIONS_FOR_ANTITHROMBOTIC_THERAPY'
PC_AT_DISCH_DT_TM	DATETIME	Y	Identifies the date/time Pharmacological contraindication at Discharge was documented
PC_AT_DISCH_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying discharge medication for value set 'PHARMACOLOGICAL_CONTRAINDICATIONS_FOR_ANTITHROMBOTIC_THERAPY'
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.
TPA_ADMIN_DT_TM	DATETIME	Y	Identifies the date/time of TPA Administered was documented
TPA_ADMIN_ORD_DETAIL	VARCHAR(100)	Y	Order details for qualifying medication administration for value set 'THROMBOLYTIC_TPA_THERAPY'
TPA_DIAG_DT_TM	DATETIME	Y	Identifies the most recent documentation of diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_DX_NOMEN	VARCHAR(60)	Y	Identifies the documentation code diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_PROC_DT_TM	DATETIME	Y	Identifies the most recent documentation of procedure for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy
TPA_PROC_NOMEN	VARCHAR(60)	Y	Identifies the documented procedure or clinical_Event code for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy.
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_STROKE_2024_METRICS

	Child Column in LH_E_STROKE_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_2_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_3_ID	LH_D_METRIC	D_METRIC_ID
	D_METRIC_5_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

Copyright © 2026 Oracle and/or its affiliates. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

Materials in this document pertain to Oracle Health, Oracle, Oracle Cerner, and Cerner Enviza which are all wholly-owned subsidiaries of Oracle Corporation.
Nothing in this document should be taken as indicating that any decisions regarding the integration of any EMEA Cerner and/or Enviza entities have been made where an integration has not already occurred.
Last Updated: January 26, 2026