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 |