Table Detail Report

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


LH_E_STROKE_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_E_STROKE_METRICS
Definition: This table is used to store Stroke metrics from the Lighthouse eMeasure. This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_E_STROKE_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.
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.
ANTICOAG_DISCH_IND DOUBLE Y Identifies patients who had an anticoagulant prescribed at discharge
ANTICOAG_MED_ALLERGY_IND DOUBLE Y Identifies patients with a Medication Allergy to Anticoagulant
ANTICOAG_MED_REASON_IND DOUBLE Y Identifies patients with a Medical Reason for Not Giving Anticoagulant
ANTICOAG_PATIENT_REFUSAL_IND DOUBLE Y Identifies patients who refuse Anticoagulant
ANTITHROM_AD_PAT_REF_IND DOUBLE N Identifies that there was a patient refusal contraindication in administering antithrombotics
ANTITHROM_DISCH_IND DOUBLE Y Identifies patients with Antithrombotic Prescribed At Discharge
ANTITHROM_MED_AD_RES_IND DOUBLE N Identifies that there was a medical contraindication in administering antithrombotics
ANTITHROM_MED_ALLERGY_IND DOUBLE Y Identifies patients with a Medication Allergy to Antithrombotics
ANTITHROM_MED_REASON_IND DOUBLE Y Identifies patients with a Medical Reason for Not Giving Antithrombotics
ANTITHROM_PATIENT_REFUSAL_IND DOUBLE Y Identifies patients who refuse antithrombotics
ANTITHROM_THERAPY_DT_TM DATETIME Y Identifies the first time antithrombotic therapy was administered for the patient
ANTITHROM_THERAPY_UTC_DT_TM DATETIME Y Identifies the first time antithrombotic therapy was administered for the patient normalized to GMT
ATRIAL_ABLATION_PRIOR_IND DOUBLE Y Identifies patients who had atrial ablation prior to their inpatient encounter
ATRIAL_FIB_FLUTTER_IND DOUBLE Y Identifies patients who had an atrial fibrillation/flutter documented
BASELINE_STATE_DT_TM DATETIME Y Date/Time of the first documented baseline state for the patient
BASELINE_STATE_UTC_DT_TM DATETIME Y Date/Time of the first documented baseline state for the patient normalized to GMT
CAROTID_INTERVENTION_IND DOUBLE Y Identifies patients with a principle procedure of Carotid Intervention
COMMUNICATION_REFUSAL_IND DOUBLE Y Identifies patients who refuse communication
COMM_MRN_TXT VARCHAR(50) Y Identifies the community medical record number of the patient.
DEN_EXCEPTION_10_IND DOUBLE Y Identifies patients who are a denominator exception (stage 2)
DEN_EXCEPTION_2_IND DOUBLE Y Identifies patients who are a denominator exception (stage 2)
DEN_EXCEPTION_3_IND DOUBLE Y Identifies patients who are a denominator exception (stage 2)
DEN_EXCEPTION_4_IND DOUBLE Y Identifies patients who are a denominator exception (stage 2)
DEN_EXCEPTION_5_IND DOUBLE Y Identifies patients who are a denominator exception (stage 2)
DEN_EXCEPTION_6_IND DOUBLE Y Identifies patients who are a denominator exception (stage 2)
DEN_EXCEPTION_8_IND DOUBLE Y Identifies patients who are a denominator exception (stage 2)
DISCHARGE_DISPOSITION_FLAG DOUBLE Y Identifies the patient's discharge disposition
DISCHARGE_DT_TM DATETIME Y The date/time on which the patient was discharged.
DISCHARGE_UTC_DT_TM DATETIME Y The date/time on which the patient was discharged normalized to GMT.
D_ADMIT_BUILDING_ID DOUBLE N The building to which the patient was admitted.
D_ADMIT_FACILITY_ID DOUBLE N The facility to which the patient was admitted.
D_ADMIT_NURSE_UNIT_ID DOUBLE N The nurse unit to which the patient was admitted.
D_ADMIT_SRC_ID DOUBLE N Identifies the place from which the patient came before being admitted.
D_ADMIT_TYPE_ID DOUBLE N Indicates the circumstances under which the patient was admitted.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter.
D_BR_CCN_ID DOUBLE N CMS Certification Number.
D_BR_HCO_ID DOUBLE N Healthcare organization Number.
D_DISCHARGE_BUILDING_ID DOUBLE N The building from which the patient was discharged
D_DISCHARGE_FACILITY_ID DOUBLE N The facility from which the patient was discharged
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N The nurse unit from which the patient was discharged
D_DISCH_DISP_ID DOUBLE N Defines the discharge disposition of the encounter.
D_ENCNTR_TYPE_ID DOUBLE N Categorizes the encounter into a logical group or type.
D_MED_SERVICE_ID DOUBLE N The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others.
D_METRIC_1_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_2_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_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_METRIC_5_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_6_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_METRIC_7_ID DOUBLE N Identifies the metric identifier for the Lighthouse metric
D_PERSON_ID DOUBLE N The person that qualified for the quality metric.
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 through the ED for ED-1 and ED-2
ED_LOC_IND DOUBLE Y Identifies the patient an ED patient at the facility
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
EXCLUDE_SG1_10_IND DOUBLE Y Identifies patients excluded for the measure (stage 1)
EXCLUDE_SG1_2_IND DOUBLE Y Identifies patients excluded for the measure (stage 1)
EXCLUDE_SG1_3_IND DOUBLE Y Identifies patients excluded for the measure (stage 1)
EXCLUDE_SG1_4_IND DOUBLE Y Identifies patients excluded for the measure (stage 1)
EXCLUDE_SG1_5_IND DOUBLE Y Identifies patients excluded for the measure (stage 1)
EXCLUDE_SG1_6_IND DOUBLE Y Identifies patients excluded for the measure (stage 1)
EXCLUDE_SG1_8_IND DOUBLE Y Identifies patients excluded for the measure (stage 1)
EXCLUDE_SG2_10_IND DOUBLE Y Identifies patients excluded for the measure (stage 2)
EXCLUDE_SG2_2_IND DOUBLE Y Identifies patients excluded for the measure (stage 2)
EXCLUDE_SG2_3_IND DOUBLE Y Identifies patients excluded for the measure (stage 2)
EXCLUDE_SG2_4_IND DOUBLE Y Identifies patients excluded for the measure (stage 2)
EXCLUDE_SG2_5_IND DOUBLE Y Identifies patients excluded for the measure (stage 2)
EXCLUDE_SG2_6_IND DOUBLE Y Identifies patients excluded for the measure (stage 2)
EXCLUDE_SG2_8_IND DOUBLE Y Identifies patients excluded for the measure (stage 2)
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FINANCIAL_NBR_TXT VARCHAR(50) Y The financial number alias associated to the encounter.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
HEMORRHAGIC_STK_DX_IND DOUBLE Y Identifies patients with a Principal Diagnosis code of Hemorrhagic Stroke
ISCHEMIC_STK_DX_IND DOUBLE Y Identifies patients with a Principal Diagnosis code of Ischemic Stroke
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
LDL_RESULT_DT_TM DATETIME Y Identifies the date/time that the qualifying LDL was documented
LDL_RESULT_IND DOUBLE Y Identifies patients who have a qualifying LDL-c Result within the specified timeframe
LDL_RESULT_UTC_DT_TM DATETIME Y Identifies the date/time that the qualifying LDL was documented normalized to GMT
LDL_RESULT_VALUE DOUBLE Y Identifies the qualifying LDL value
LH_E_STROKE_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_E_STROKE_METRICS table.
LIPID_LOWERING_PRIOR_IND DOUBLE Y Identifies patients who had a lipid lowering agent before the specified timeframe
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.
NEURO_SYMPTOMS_DT_TM DATETIME Y Identifies the first date/time that Neurologic Symptoms of Stroke were documented
NEURO_SYMPTOMS_UTC_DT_TM DATETIME Y Identifies the first date/time that Neurologic Symptoms of Stroke were documented normalized to GMT
NIH_STROKE_DT_TM DATETIME Y Date/Time of the first documented instance of a NIH Scale = 0 Result for the patient
NIH_STROKE_UTC_DT_TM DATETIME Y Date/Time of the first documented instance of a NIH Scale = 0 Result for the patient normalized to GMT
NOT_IN_DEN_10_IND DOUBLE Y Identifies patients who are not in denominator (stage 2)
NOT_IN_DEN_2_IND DOUBLE Y Identifies patients who are not in denominator (stage 2)
NOT_IN_DEN_3_IND DOUBLE Y Identifies patients who are not in denominator (stage 2)
NOT_IN_DEN_4_IND DOUBLE Y Identifies patients who are not in denominator (stage 2)
NOT_IN_DEN_5_IND DOUBLE Y Identifies patients who are not in denominator (stage 2)
NOT_IN_DEN_6_IND DOUBLE Y Identifies patients who are not in denominator (stage 2)
NOT_IN_DEN_8_IND DOUBLE Y Identifies patients who are not in denominator (stage 2)
NUMERATOR_10_IND DOUBLE Y Identifies patients in the numerator for the measure
NUMERATOR_2_IND DOUBLE Y Identifies patients in the numerator for the measure
NUMERATOR_3_IND DOUBLE Y Identifies patients in the numerator for the measure
NUMERATOR_4_IND DOUBLE Y Identifies patients in the numerator for the measure
NUMERATOR_5_IND DOUBLE Y Identifies patients in the numerator for the measure
NUMERATOR_6_IND DOUBLE Y Identifies patients in the numerator for the measure
NUMERATOR_8_IND DOUBLE Y Identifies patients in the numerator for the measure
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
PALL_CARE_ORDER_IND DOUBLE Y Identifies patients with a Palliative Care order
PALL_CARE_PERFORM_IND DOUBLE Y Identifies patients with Palliative Care Performed
PALL_CARE_START_DT_TM DATETIME Y The earliest documented month- day- and year of the start of palliative care
PALL_CARE_START_UTC_DT_TM DATETIME Y The earliest documented month- day- and year of the start of palliative care normalized to GMT.
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 value that is associated to the patient for QRDA file payer information.
REHAB_MED_REASON_IND DOUBLE Y Identifies patients who had a medical reason for rehab services
REHAB_ORDER_IND DOUBLE Y Identifies patients who had a rehab services order placed
REHAB_PATIENT_REFUSAL_IND DOUBLE Y Identifies patients who refused rehab services
RISK_ASSESS_DT_TM DATETIME Y Date/Time of the first risk assessment
RISK_ASSESS_UTC_DT_TM DATETIME Y Date/Time of the first risk assessment normalized to GMT
STATIN_MED_ALLERGY_IND DOUBLE Y Identifies patients with a Medication Allergy to Statin
STATIN_MED_DISCH_IND DOUBLE Y Identifies patient who had Statin Medication prescribed at Discharge
STATIN_MED_REASON_IND DOUBLE Y Identifies patients with a Medical Reason for Not Giving Statin
STATIN_PATIENT_REFUSAL_IND DOUBLE Y Identifies patients who refuse Statin
STROKE_EDUCATION_MASK DOUBLE Y Identifies which education items the patient received
TPA_MED_NOT_DONE_DT_TM DATETIME Y Date/Time of the first documented Instance of reason for the tPA medication not done
TPA_MED_NOT_DONE_UTC_DT_TM DATETIME Y Date/Time of the first documented Instance of reason for the tPA medication not done normalized to GMT
TPA_THERAPY_DT_TM DATETIME Y Date/Time of the most recent t-PA Therapy
TPA_THERAPY_UTC_DT_TM DATETIME Y Date/Time of the most recent t-PA Therapy normalized to GMT
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.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated.
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.



Relationship Detail - LH_E_STROKE_METRICS


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