Table Detail Report
LH_E_STROKE_2016_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_STROKE_2016_METRICS |
Definition: | This table is used to store eMeasure Stroke Metrics for the 2016 reporting period. This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_E_STROKE_2016_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_IND | DOUBLE | Y | Identifies if the patient had Anticoagulants prescribed at discharge |
AC_ORDER_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Anticoagulants |
AC_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Anticoagulants |
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. |
ATRIAL_ABLATION_ORDER_IND | DOUBLE | Y | Identifies if the patient had an Atrial Ablation order documented prior to the inpatient encounter |
ATRIAL_ABLATION_PROC_IND | DOUBLE | Y | Identifies if the patient had an Atrial Ablation procedure documented prior to the inpatient encounter |
ATRIAL_FIB_FLUTTER_DX_IND | DOUBLE | Y | Identifies if there was a qualifying Atrial Fibrillation/Flutter diagnosis documented |
ATRIAL_FIB_FLUTTER_PROB_IND | DOUBLE | Y | Identifies if there was a qualifying Atrial Fibrillation/Flutter problem documented |
AT_ADMIN_ED_DT_TM | DATETIME | Y | Identifies the first Antithrombotic administration after ED Arrival |
AT_ADMIN_ED_UTC_DT_TM | DATETIME | Y | Identifies the first Antithrombotic administration after ED Arrival normalized to GMT |
AT_ADMIN_IP_DT_TM | DATETIME | Y | Identifies the first Antithrombotic administration after Inpatient Admission |
AT_ADMIN_IP_UTC_DT_TM | DATETIME | Y | Identifies the first Antithrombotic administration after Inpatient Admission normalized to GMT |
AT_ADMIN_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after ED Arrival |
AT_ADMIN_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after Inpatient Admission |
AT_ADMIN_ND_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not Administering Antithrombotics (Not Done) within 1 day of ED Arrival |
AT_ADMIN_ND_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not Administering Antithrombotics (Not Done) within 1 day of Inpatient Admission |
AT_ADMIN_ND_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not Administering Antithrombotics (Not Done) within 1 day of ED Arrival |
AT_ADMIN_ND_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not Administering Antithrombotics (Not Done) within 1 day of Inpatient Admission |
AT_ADMIN_NG_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not Administering Antithrombotics (Not Given) within 1 day of ED Arrival |
AT_ADMIN_NG_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not Administering Antithrombotics (Not Given) within 1 day of Inpatient Admission |
AT_ADMIN_NG_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not Administering Antithrombotics (Not Given) within 1 day of ED Arrival |
AT_ADMIN_NG_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not Administering Antithrombotics (Not Given) within 1 day of Inpatient Admission |
AT_ADMIN_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after ED Arrival |
AT_ADMIN_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after Inpatient Admission |
AT_DISCH_IND | DOUBLE | Y | Identifies the ED Length of Stay (minutes) for ED-3 |
AT_ORDER_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Antithrombotics |
AT_ORDER_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Antithrombotics |
AT_ORDER_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after Inpatient Admission |
BASELINE_STATE_DT_TM | DATETIME | Y | Identifies the most recent, prior to ED admission, documentation of Baseline State |
BASELINE_STATE_ED_120_DT_TM | DATETIME | Y | Identifies the most recent, 120mins prior to ED admission, documentation of Baseline State |
BASELINE_STATE_UTC_DT_TM | DATETIME | Y | Identifies the most recent, prior to ED admission, documentation of Baseline State normalized to GMT |
BASELINE_STAT_ED_120_UTC_DT_TM | DATETIME | Y | Identifies the most recent, 120mins prior to ED admission, documentation of Baseline State normalized to GMT |
CMO_ORDER_ED_1D_IND | DOUBLE | Y | Identifies if there was an order for Comfort Measures within 1 day prior to ED Arrival |
CMO_ORDER_ED_293_IND | DOUBLE | Y | Indicates CMO ordered relative to the ED visit (293 value set) |
CMO_ORDER_ED_IND | DOUBLE | Y | Identifies the ED Length of Stay (minutes) for ED-1 |
CMO_ORDER_IP_1D_IND | DOUBLE | Y | Identifies if there was an event for comfort measures within one day prior to ED arrival date time on the qualifying ED encounter |
CMO_ORDER_IP_IND | DOUBLE | Y | Identifies if there was an order for comfort measures on the qualifying inpatient encounter |
CMO_PERF_ED_1D_IND | DOUBLE | Y | Identifies if there was an event for Comfort Measures within 1 day prior to ED Arrival |
CMO_PERF_ED_293_IND | DOUBLE | Y | Indicates CMO performed relative to the ED visit (293 value set) |
CMO_PERF_ED_IND | DOUBLE | Y | Identifies if there was an event for comfort measures on the ed encounter |
CMO_PERF_IP_1D_IND | DOUBLE | Y | Identifies if there was an event for comfort measures within one day prior to admit date time on the qualifying inpatient encounter |
CMO_PERF_IP_IND | DOUBLE | Y | Identifies if there was an event for comfort measures on the qualifying inpatient encounter |
COMM_PAT_REF_IND | DOUBLE | Y | Identifies if a patient refused Communication from provider on their inpatient encounter |
DEN_EXCEPTION_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-2 |
DEN_EXCEPTION_3_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-3 |
DEN_EXCEPTION_4_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-4 |
DEN_EXCEPTION_5_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-5 |
DEN_EXCEPTION_6_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-6 |
DIASTOLIC_BP_IND | DOUBLE | Y | Identifies a Diastolic BP Lab Test Result > 110 mmHg within 180 minutes of either Baseline State or Symptom Onset |
DISCHARGE_DISP_FLAG | DOUBLE | Y | Identifies the patient an ED patient at the facility.0-No Qualifing Documentation;1-Discharged to Another Hospital;2-Left Against Medical Advice;3-Discharged to Home for Hospice Care;4-Patient Expired;5-Discharged to Health Care Facility Hospice Care;6-Discharged to Home or Police Custody;7-Discharged to Rehab Facility |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged normalized to GMT. |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | Identifies the discharge disposition of the encounter |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_4_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_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. |
EDU_ACT_EMS_IND | DOUBLE | Y | Identifies documentation of Education: Activation of EMS |
EDU_FOLLOWUP_IND | DOUBLE | Y | Identifies documentation of Education: Follow-upafter Discharge |
EDU_PRESCRIBED_MEDS_IND | DOUBLE | Y | Identifies documentation of Education: Prescribed Medications |
EDU_RISK_FACTORS_IND | DOUBLE | Y | Identifies documentation of Education: Risk Factors |
EDU_SIGNS_SYMPTOMS_IND | DOUBLE | Y | Identifies documentation of Education: Warning Signs and Symptoms |
EDU_WRITTEN_INFO_IND | DOUBLE | Y | Identifies documentation of Education: Written Information Given |
ED_293_ARRIVAL_DT_TM | DATETIME | Y | The local arrival date of the ed visit (293 value set) |
ED_293_ARRIVAL_UTC_DT_TM | DATETIME | Y | The utc arrival date of the ed visit (293 value set) |
ED_293_DEPART_DT_TM | DATETIME | Y | The local depart date of the ed visit (293 value set) |
ED_293_DEPART_UTC_DT_TM | DATETIME | Y | The utc depart date of the ed visit (293 value set) |
ED_293_ENCNTR_ID | DOUBLE | Y | The encntr_id of the ed visit (293 value set) |
ED_ARRIVAL_DT_TM | DATETIME | Y | Time the patient departed from the emergency department. |
ED_ARRIVAL_UTC_DT_TM | DATETIME | Y | Time the patient departed from the emergency department normalized to GMT. |
ED_DEPART_DT_TM | DATETIME | Y | The earliest documented month, day, and year of the decision to admit. |
ED_DEPART_UTC_DT_TM | DATETIME | Y | The earliest documented month, day, and year of the decision to admit normalized to GMT. |
ED_ENCNTR_ID | DOUBLE | N | Time the patient arrived the emergency department. |
ED_LOC_IND | DOUBLE | Y | Time the patient arrived the emergency department normalized to GMT. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_10_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-10 |
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 |
EXCLUDE_8_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-8 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_INS_NBR_TXT | VARCHAR(50) | Y | The Medicare HIC number is the identification number given to a patient who is covered by Medicare |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HEMORRHAGIC_DX_IND | DOUBLE | Y | Identifies the ED encounter is qualified initial population for ED-3 |
INR_RESULT_IND | DOUBLE | Y | Identifies a INR Lab Test Result > 1.7 within 180 minutes of either Baseline State or Symptom Onset |
ISCHEMIC_DX_IND | DOUBLE | Y | Identifies the encounter is admitted through the ED for ED-1 and ED-2 |
IV_TPA_PROC_DT_TM | DATETIME | Y | Identifies the most recent documentation of intravenous administration of TPA. |
IV_TPA_PROC_UTC_DT_TM | DATETIME | Y | Identifies the most recent documentation of intravenous administration of TPA normalized to GMT. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDL_PERF_IND | DOUBLE | Y | Identifies if there was an LDL-c result documented |
LH_E_STROKE_2016_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_STROKE_2016_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. |
NIH_STROKE_0_IND | DOUBLE | Y | Identifies a NIH Stroke Scale Assessment = 0 within 180 minutes of either Baseline State or Symptom Onset |
NOT_IN_DEN_2_IND | DOUBLE | Y | Identifies if the encounter is Not In Denominator for STK-2 |
NOT_IN_DEN_3_IND | DOUBLE | Y | Identifies if the encounter is Not In Denominator for STK-3 |
NOT_IN_DEN_4_IND | DOUBLE | Y | Identifies if the encounter is Not In Denominator for STK-4 |
NOT_IN_DEN_5_IND | DOUBLE | Y | Identifies if the encounter is Not In Denominator for STK-5 |
NOT_IN_DEN_6_IND | DOUBLE | Y | Identifies if the encounter is Not In Denominator for STK-6 |
NOT_IN_DEN_8_IND | DOUBLE | Y | Identifies if the encounter is Not In Denominator for STK-8 |
NUMERATOR_10_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-10 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-2 |
NUMERATOR_3_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-3 |
NUMERATOR_4_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-4 |
NUMERATOR_5_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-5 |
NUMERATOR_6_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-6 |
NUMERATOR_8_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-8 |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PERSON_ETHNIC_CODE | VARCHAR(50) | Y | Ethnicity code of the patient as per value set |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(500) | Y | Ethnicity code system OID of the patient as per value set |
PERSON_ETHNIC_CODE_SYSTEM | VARCHAR(50) | Y | Ethnicity code display of the patient as per value set |
PERSON_ETHNIC_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Ethnicity code system name of the patient as per value set |
PERSON_GENDER_CODE | VARCHAR(50) | Y | Gender code of the patient as per value set |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(500) | Y | Gender code system OID of the patient as per value set |
PERSON_GENDER_CODE_SYSTEM | VARCHAR(50) | Y | Gender code display of the patient as per value set |
PERSON_GENDER_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Gender code system name of the patient as per value set |
PERSON_PAYER_CODE | VARCHAR(50) | Y | Represents the patient's member or subscriber identifier with respect to the payer |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(500) | Y | Represents the patient's member or subscriber identifier coding system OID with respect to the payer |
PERSON_PAYER_CODE_SYSTEM | VARCHAR(50) | Y | Represents the patient's member or subscriber identifier display with respect to the payer |
PERSON_PAYER_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Represents the patient's member or subscriber identifier coding system name with respect to the payer |
PERSON_RACE_CODE | VARCHAR(50) | Y | Race code of the patient as per value set |
PERSON_RACE_CODE_DISPLAY | VARCHAR(500) | Y | Race code system OID of the patient as per value set |
PERSON_RACE_CODE_SYSTEM | VARCHAR(50) | Y | Race code display of the patient as per value set |
PERSON_RACE_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Race code system name of the patient as per value set |
PLATELET_IND | DOUBLE | Y | Identifies a Platelet Lab Test Result < 100,000 within 180 minutes of either Baseline State or Symptom Onset |
POPULATION_IND | DOUBLE | Y | Identifies the inpatient encounter is qualified initial population for ED-1 and ED-2 |
PROTHROMBIN_IND | DOUBLE | Y | Identifies a Prothrombin Lab Test Result > 15 within 180 minutes of either Baseline State or Symptom Onset |
REHAB_ASSES_IP_IND | DOUBLE | Y | Identifies documentation of Rehabilitation Assessment during the inpatient encounter |
REHAB_PAT_REF_IND | DOUBLE | Y | Identifies documentation of Patient Refusal of Rehabilitation Assessment during the inpatient encounter |
REHAB_THERAPY_IP_IND | DOUBLE | Y | Identifies documentation of Rehabilitation Therapy during the inpatient encounter |
STATIN_DISCH_IND | DOUBLE | Y | Identifies if the patient had Statins prescribed at discharge |
STATIN_MED_ALLERGY_IND | DOUBLE | Y | Identifies if there was a Allergy Reason for not giving Statins |
STATIN_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Statins |
STATIN_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Statins |
SYMPTOM_ONSET_DT_TM | DATETIME | Y | Identifies the most recent, prior to ED admission, documentation of Symptom Onset |
SYMPTOM_ONSET_ED_120_DT_TM | DATETIME | Y | Identifies the most recent, 120mins prior to ED admission, documentation of Symptom Onset |
SYMPTOM_ONSET_ED_120_UTC_DT_TM | DATETIME | Y | Identifies the most recent, 120mins prior to ED admission, documentation of Symptom Onset normalized to GMT |
SYMPTOM_ONSET_UTC_DT_TM | DATETIME | Y | Identifies the most recent, prior to ED admission, documentation of Symptom Onset normalized to GMT |
SYSTOLIC_BP_IND | DOUBLE | Y | Identifies a Systolic BP Lab Test Result > 185 mmHg within 180 minutes of either Baseline State or Symptom Onset |
THROMBOPLASTIN_IND | DOUBLE | Y | Identifies a Partial Thromboplastin Time Lab Test Result > 40 seconds within 180 minutes of either Baseline State or Symptom Onset |
TPA_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time of TPA Administered was documented |
TPA_ADMIN_MED_RES_ED_IND | DOUBLE | Y | Identifies a Medical Reason for not administering TPA within ED encounter |
TPA_ADMIN_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering TPA within 1 day of Inpatient admit date time |
TPA_ADMIN_ND_MED_RES_ED_IND | DOUBLE | Y | Identifies a Medical Reason for not administering TPA within ED encounter (Not Done) |
TPA_ADMIN_ND_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering TPA within one day of inpatient admit date time (Not Done) |
TPA_ADMIN_ND_PAT_REF_ED_IND | DOUBLE | Y | Identifies a patient refusal for not administering (Not Done) TPA within 180 minutes after baseline state that occurs within 120 mins after ED arrival date time during ED encounter |
TPA_ADMIN_ND_PAT_REF_IP_IND | DOUBLE | Y | Identifies a patient refusal for not administering (Not Done) TPA within 180 minutes after baseline state that occurs within 120 mins after ED arrival date time during inpatient encounter |
TPA_ADMIN_NG_MED_RES_ED_IND | DOUBLE | Y | Identifies a Medical Reason for not administering TPA within ED encounter (Not Given) |
TPA_ADMIN_NG_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering TPA within one day of inpatient admit date time (Not Given) |
TPA_ADMIN_NG_PAT_REF_ED_IND | DOUBLE | Y | Identifies a patient refusal for not administering (Not Given) TPA within 180 minutes after baseline state that occurs within 120 mins after ED arrival date time during ED encounter |
TPA_ADMIN_NG_PAT_REF_IP_IND | DOUBLE | Y | Identifies a patient refusal for not administering (Not Given) TPA within 180 minutes after baseline state that occurs within 120 mins after ED arrival date time during inpatient encounter |
TPA_ADMIN_PAT_REF_IND | DOUBLE | Y | Identifies a patient refusal for not administering TPA within 180 minutes after baseline state that occurs within 120 mins after ED arrival date time |
TPA_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies the most recent administration of TPA normalized to GMT |
TPA_ORDER_MED_RES_ED_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering TPA within ED encounter |
TPA_ORDER_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering TPA within 1 day of Inpatient admit date time |
TPA_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies a patient refusal for not ordering TPA within 180 minutes after baseline state that occurs within 120 mins after ED arrival date time |
TPA_PROC_DT_TM | DATETIME | Y | Identifies the most recent documentation of administration of TPA |
TPA_PROC_UTC_DT_TM | DATETIME | Y | Identifies the most recent documentation of administration of TPA normalized to GMT |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | N | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_E_STROKE_2016_METRICS
Child Column in LH_E_STROKE_2016_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 |
LH_E_STROKE_2017_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_STROKE_2017_METRICS |
Definition: | This table is used to store eMeasure Stroke Metrics for the 2017 reporting period. |
Table Type: | ACTIVITY |
Column Detail - LH_E_STROKE_2017_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
AC_DISCH_DT_TM | DATETIME | Y | The date/time of the anticoagulant therapy medication discharge during inpatient encounter |
AC_DISCH_UTC_DT_TM | DATETIME | Y | The utc date/time of the anticoagulant therapy medication discharge during inpatient encounter |
AC_ORDER_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Anticoagulant therapy |
AC_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Anticoagulant therapy |
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. |
ATRIAL_ABLATION_PROC_NOMEN | VARCHAR(60) | Y | The nomenclature of the Atrial Ablation procedure documented prior to the inpatient encounter |
ATRIAL_FIB_FLUTTER_DX_NOMEN | VARCHAR(60) | Y | The nomenclature of the Atrial Fibrillation/Flutter diagnosis documented before or during inpatient encounter |
AT_ADMIN_1D_ED_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after ED Arrival |
AT_ADMIN_1D_ED_UTC_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after ED Arrival normalized to GMT |
AT_ADMIN_1D_IP_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after Inpatient Admission |
AT_ADMIN_1D_IP_UTC_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after Inpatient Admission normalized to GMT |
AT_ADMIN_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after ED Arrival |
AT_ADMIN_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after Inpatient Admission |
AT_ADMIN_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after ED Arrival |
AT_ADMIN_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after Inpatient Admission |
AT_DISCH_DT_TM | DATETIME | Y | The date/time of the antithrombotic medication discharge during inpatient encounter |
AT_DISCH_UTC_DT_TM | DATETIME | Y | The utc date/time of the antithrombotic medication discharge during inpatient encounter |
AT_ORDER_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Antithrombotics |
AT_ORDER_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Antithrombotics |
AT_ORDER_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after Inpatient Admission |
CMO_ORDER_1D_ED_DT_TM | DATETIME | Y | The date/time of the order for comfort measures within 1 day after the start of the qualifying ed encounter |
CMO_ORDER_1D_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures within 1 day after the start of the qualifying ed encounter |
CMO_ORDER_1D_IP_DT_TM | DATETIME | Y | The date/time of the order for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_ORDER_1D_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_ORDER_ED_DT_TM | DATETIME | Y | The date/time of the order for comfort measures on the qualifying ed encounter |
CMO_ORDER_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures on the qualifying ed encounter |
CMO_ORDER_IP_DT_TM | DATETIME | Y | The date/time of the order for comfort measures on the qualifying inpatient encounter |
CMO_ORDER_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures on the qualifying inpatient encounter |
CMO_PERF_1D_ED_DT_TM | DATETIME | Y | The date/time of the event for comfort measures within 1 day after the start of the qualifying ed encounter |
CMO_PERF_1D_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures within1 day after the start of the qualifying ed encounter |
CMO_PERF_1D_IP_DT_TM | DATETIME | Y | The date/time of the event for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_PERF_1D_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_PERF_ED_DT_TM | DATETIME | Y | The date/time of the event for comfort measures on the qualifying ed encounter |
CMO_PERF_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures on the qualifying ed encounter |
CMO_PERF_IP_DT_TM | DATETIME | Y | The date/time of the event for comfort measures on the qualifying inpatient encounter |
CMO_PERF_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures on the qualifying inpatient encounter |
COMM_PAT_REF_DESC | VARCHAR(60) | Y | The nomenclature of the patient refused Communication from provider on their inpatient encounter |
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 |
DEN_8_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for STK-8 |
DEN_EXCEPTION_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-2 |
DEN_EXCEPTION_3_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-3 |
DEN_EXCEPTION_5_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-5 |
DEN_EXCEPTION_6_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-6 |
DISCHARGE_DISP_DESC | VARCHAR(60) | Y | The discharge disposition of the encounter |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged normalized to GMT. |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | Identifies the discharge disposition of the encounter |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_4_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_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_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
EDU_ACT_EMS_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Activation of EMS |
EDU_FOLLOWUP_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Followup after Discharge |
EDU_PRESC_MED_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Prescribed Medications. |
EDU_RISK_FACTORS_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Risk Factors |
EDU_SIGNS_SYMPTOMS_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Warning Signs and Symptoms |
EDU_WRITTEN_INFO_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Written Information Given |
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 | The encounter id of the ED visit |
ED_LOC_IND | DOUBLE | Y | Indicates the ED visit occurred at an ED location |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_10_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-10 |
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 |
EXCLUDE_8_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-8 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_INS_NBR_TXT | VARCHAR(50) | Y | The Medicare HIC number is the identification number given to a patient who is covered by Medicare |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HEMORRHAGIC_DX_NOMEN | VARCHAR(60) | Y | The nomenclature of the diagnosis of hemorrhagic stroke |
HOSP_SVC_IND | DOUBLE | N | Indicates if the encounter should be excluded from the population due to the visit type |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
ISCHEMIC_DX_NOMEN | VARCHAR(60) | Y | The nomenclature of the diagnosis of ischemic stroke |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDL_PERF_IND | DOUBLE | Y | Identifies if there was an LDL-c result documented |
LH_E_STROKE_2017_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_STROKE_2017_METRICS table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NUMERATOR_10_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-10 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-2 |
NUMERATOR_3_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-3 |
NUMERATOR_5_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-5 |
NUMERATOR_6_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-6 |
NUMERATOR_8_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-8 |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PERSON_ETHNIC_CODE | VARCHAR(50) | Y | Ethnicity code of the patient as per value set |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(500) | Y | Ethnicity code system OID of the patient as per value set |
PERSON_ETHNIC_CODE_SYSTEM | VARCHAR(50) | Y | Ethnicity code display of the patient as per value set |
PERSON_ETHNIC_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Ethnicity code system name of the patient as per value set |
PERSON_GENDER_CODE | VARCHAR(50) | Y | Gender code of the patient as per value set |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(500) | Y | Gender code system OID of the patient as per value set |
PERSON_GENDER_CODE_SYSTEM | VARCHAR(50) | Y | Gender code display of the patient as per value set |
PERSON_GENDER_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Gender code system name of the patient as per value set |
PERSON_PAYER_CODE | VARCHAR(50) | Y | Represents the patient's member or subscriber identifier with respect to the payer |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(500) | Y | Represents the patient's member or subscriber identifier coding system OID with respect to the payer |
PERSON_PAYER_CODE_SYSTEM | VARCHAR(50) | Y | Represents the patient's member or subscriber identifier display with respect to the payer |
PERSON_PAYER_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Represents the patient's member or subscriber identifier coding system name with respect to the payer |
PERSON_RACE_CODE | VARCHAR(50) | Y | Race code of the patient as per value set |
PERSON_RACE_CODE_DISPLAY | VARCHAR(500) | Y | Race code system OID of the patient as per value set |
PERSON_RACE_CODE_SYSTEM | VARCHAR(50) | Y | Race code display of the patient as per value set |
PERSON_RACE_CODE_SYSTEM_NAME | VARCHAR(50) | Y | Race code system name of the patient as per value set |
PERSON_RACE_DESC | VARCHAR(500) | Y | The list of all of a patient's races |
REHAB_ASSES_IP_NOMEN | VARCHAR(60) | Y | The nomenclature of the documentation of Rehabilitation Assessment during the inpatient encounter |
REHAB_MED_RES_IND | DOUBLE | Y | Identifies documentation of Medical Reason of Rehabilitation Assessment during the inpatient encounter. |
REHAB_PAT_REF_IND | DOUBLE | Y | Identifies documentation of Patient Refusal of Rehabilitation Assessment during the inpatient encounter |
REHAB_THERAPY_IP_NOMEN | VARCHAR(60) | Y | The nomenclature of the documentation of Rehabilitation Therapy during the inpatient encounter |
STATIN_DISCH_DT_TM | DATETIME | Y | The date/time of the Statin prescribed at discharge |
STATIN_DISCH_UTC_DT_TM | DATETIME | Y | The utc date/time of the Statin prescribed at discharge |
STATIN_MED_ALLERGY_IND | DOUBLE | Y | Identifies if there was a Allergy Reason for not giving Statins |
STATIN_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Statins |
STATIN_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Statins |
TIMEZONE_IDENT | DOUBLE | Y | Identifies the timezone index number associated with the quality measure. |
TPA_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time of TPA Administered was documented |
TPA_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies the utc date/time of TPA Administered was documented |
TPA_PROC_DT_TM | DATETIME | Y | Identifies the most recent documentation of administration of TPA |
TPA_PROC_UTC_DT_TM | DATETIME | Y | Identifies the most recent documentation of administration of TPA 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. 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_2017_METRICS
Child Column in LH_E_STROKE_2017_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_MED_SERVICE_ID | LH_D_MED_SERVICE | D_MED_SERVICE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_MED_SERVICE | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_4_ID | LH_D_METRIC | D_METRIC_ID | |
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 | |
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_2018_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_STROKE_2018_METRICS |
Definition: | Stores data collected by lh_e_stroke_2018 program. |
Table Type: | ACTIVITY |
Column Detail - LH_E_STROKE_2018_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 date/time of the anticoagulant therapy medication discharge during inpatient encounter |
AC_DISCH_UTC_DT_TM | DATETIME | Y | The utc date/time of the anticoagulant therapy medication discharge during inpatient encounter |
AC_ORDER_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Anticoagulant therapy |
AC_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Anticoagulant therapy |
ATRIAL_ABLATION_PROC_NOMEN | VARCHAR(60) | Y | The nomenclature of the Atrial Ablation procedure documented prior to the inpatient encounter |
ATRIAL_FIB_FLUTTER_DX_NOMEN | VARCHAR(60) | Y | The nomenclature of the Atrial Fibrillation/Flutter diagnosis documented before or during inpatient encounter |
AT_ADMIN_1D_ED_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after ED Arrival |
AT_ADMIN_1D_ED_UTC_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after ED Arrival normalized to GMT |
AT_ADMIN_1D_IP_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after Inpatient Admission |
AT_ADMIN_1D_IP_UTC_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after Inpatient Admission normalized to GMT |
AT_ADMIN_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after ED Arrival |
AT_ADMIN_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after Inpatient Admission |
AT_ADMIN_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after ED Arrival |
AT_ADMIN_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after Inpatient Admission |
AT_DISCH_DT_TM | DATETIME | Y | The date/time of the antithrombotic medication discharge during inpatient encounter |
AT_DISCH_UTC_DT_TM | DATETIME | Y | The utc date/time of the antithrombotic medication discharge during inpatient encounter |
AT_ORDER_MED_RES_ED_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Antithrombotics |
AT_ORDER_MED_RES_IP_1D_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_PAT_REF_ED_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after ED Arrival |
AT_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Antithrombotics |
AT_ORDER_PAT_REF_IP_1D_IND | DOUBLE | Y | Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after Inpatient Admission |
CMO_ORDER_1D_ED_DT_TM | DATETIME | Y | The date/time of the order for comfort measures within 1 day after the start of the qualifying ed encounter |
CMO_ORDER_1D_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures within 1 day after the start of the qualifying ed encounter |
CMO_ORDER_1D_IP_DT_TM | DATETIME | Y | The date/time of the order for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_ORDER_1D_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_ORDER_ED_DT_TM | DATETIME | Y | The date/time of the order for comfort measures on the qualifying ed encounter |
CMO_ORDER_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures on the qualifying ed encounter |
CMO_ORDER_IP_DT_TM | DATETIME | Y | The date/time of the order for comfort measures on the qualifying inpatient encounter |
CMO_ORDER_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the order for comfort measures on the qualifying inpatient encounter |
CMO_PERF_1D_ED_DT_TM | DATETIME | Y | The date/time of the event for comfort measures within 1 day after the start of the qualifying ed encounter |
CMO_PERF_1D_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures within1 day after the start of the qualifying ed encounter |
CMO_PERF_1D_IP_DT_TM | DATETIME | Y | The date/time of the event for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_PERF_1D_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures within 1 day after the start of the qualifying inpatient encounter |
CMO_PERF_ED_DT_TM | DATETIME | Y | The date/time of the event for comfort measures on the qualifying ed encounter |
CMO_PERF_ED_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures on the qualifying ed encounter |
CMO_PERF_IP_DT_TM | DATETIME | Y | The date/time of the event for comfort measures on the qualifying inpatient encounter |
CMO_PERF_IP_UTC_DT_TM | DATETIME | Y | The utc date/time of the event for comfort measures on the qualifying inpatient encounter |
COMM_PAT_REF_DESC | VARCHAR(60) | Y | The nomenclature of the patient refused Communication from provider on their inpatient encounter |
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 |
DEN_8_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for STK-8 |
DEN_EXCEPTION_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-2 |
DEN_EXCEPTION_3_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-3 |
DEN_EXCEPTION_5_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-5 |
DEN_EXCEPTION_6_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-6 |
DISCHARGE_DISP_DESC | VARCHAR(60) | Y | The discharge disposition of the encounter |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged normalized to GMT. |
D_ADMIT_BUILDING_ID | DOUBLE | N | The building to which the patient was admitted. |
D_ADMIT_FACILITY_ID | DOUBLE | N | The facility to which the patient was admitted. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | The nurse unit to which the patient was admitted. |
D_ADMIT_SRC_ID | DOUBLE | N | Identifies the place from which the patient came before being admitted. |
D_ADMIT_TYPE_ID | DOUBLE | N | Indicates the circumstances under which the patient was admitted. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | Identifies the discharge disposition of the encounter |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_MED_SERVICE_ID | DOUBLE | N | The type or category of medical service that the patient is receiving in relation to their encounter. The category may be treatment type surgery general resources or others. |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_METRIC_4_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric |
D_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_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
EDU_ACT_EMS_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Activation of EMS |
EDU_FOLLOWUP_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Followup after Discharge |
EDU_PRESC_MED_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Prescribed Medications |
EDU_RISK_FACTORS_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Risk Factors |
EDU_SIGNS_SYMPTOMS_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Warning Signs and Symptoms |
EDU_WRITTEN_INFO_DESC | VARCHAR(60) | Y | The nomenclature of the documentation of Education: Written Information Given |
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 | The encounter id of the ED visit |
ED_LOC_IND | DOUBLE | Y | Indicates the ED visit occurred at an ED location |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_10_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-10 |
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 |
EXCLUDE_8_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-8 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_INS_NBR_TXT | VARCHAR(50) | Y | The Medicare HIC number is the identification number given to a patient who is covered by Medicare |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HEMORRHAGIC_DX_NOMEN | VARCHAR(60) | Y | The nomenclature of the diagnosis of hemorrhagic stroke |
HOSP_SVC_IND | DOUBLE | Y | Indicates if the encounter should be excluded from the population due to the visit type |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
IP_ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted |
IP_ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted normalized to GMT. |
ISCHEMIC_DX_NOMEN | VARCHAR(60) | Y | The nomenclature of the diagnosis of ischemic stroke |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDL_PERF_IND | DOUBLE | Y | Identifies if there was an LDL-c result documented |
LH_E_STROKE_2018_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_STROKE_2018_METRICS table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NUMERATOR_10_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-10 |
NUMERATOR_2_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-2 |
NUMERATOR_3_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-3 |
NUMERATOR_5_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-5 |
NUMERATOR_6_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-6 |
NUMERATOR_8_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-8 |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(500) | Y | Ethnicity code system OID of the patient as per value set |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(500) | Y | Gender code system OID of the patient as per value set |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(500) | Y | Represents the patient's member or subscriber identifier coding system OID with respect to the payer |
PERSON_RACE_DESC | VARCHAR(500) | Y | The list of all of a patient's races |
REHAB_ASSES_IP_NOMEN | VARCHAR(60) | Y | The nomenclature of the documentation of Rehabilitation Assessment during the inpatient encounter |
REHAB_MED_RES_IND | DOUBLE | Y | Identifies documentation of Medical Reason of Rehabilitation Assessment during the inpatient encounter |
REHAB_PAT_REF_IND | DOUBLE | Y | Identifies documentation of Patient Refusal of Rehabilitation Assessment during the inpatient encounter |
REHAB_THERAPY_IP_NOMEN | VARCHAR(60) | Y | The nomenclature of the documentation of Rehabilitation Therapy during the inpatient encounter |
STATIN_DISCH_DT_TM | DATETIME | Y | The date/time of the Statin prescribed at discharge |
STATIN_DISCH_UTC_DT_TM | DATETIME | Y | The utc date/time of the Statin prescribed at discharge |
STATIN_MED_ALLERGY_IND | DOUBLE | Y | Identifies if there was a Allergy Reason for not giving Statins |
STATIN_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Statins |
STATIN_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. |
TPA_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time of TPA Administered was documented |
TPA_ADMIN_UTC_DT_TM | DATETIME | Y | Identifies the utc date/time of TPA Administered was documented |
TPA_PROC_DT_TM | DATETIME | Y | Identifies the most recent documentation of administration of TPA |
TPA_PROC_UTC_DT_TM | DATETIME | Y | Identifies the most recent documentation of administration of TPA 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. 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_2018_METRICS
Child Column in LH_E_STROKE_2018_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_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 | |
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 |
LH_E_STROKE_2019_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_STROKE_2019_METRICS |
Definition: | Stores data gathered by the LH_E_STROKE_2019 program. |
Table Type: | ACTIVITY |
Column Detail - LH_E_STROKE_2019_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_NOMEN | VARCHAR(50) | Y | The nomenclature of atrial ablation procedure. |
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. |
COMM_PAT_REF_IND | DOUBLE | Y | Indicates the patient refused Communication from provider on their inpatient encounter |
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 |
DEN_8_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for STK-8 |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Identifies the final attending physician associated to the encounter. |
D_BR_CCN_ID | DOUBLE | N | CMS Certification Number. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | The building from which the patient was discharged |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | The facility from which the patient was discharged |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | The nurse unit from which the patient was discharged |
D_DISCH_DISP_ID | DOUBLE | N | Identifies the discharge disposition of the encounter |
D_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. |
D_METRIC_10_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric: STK-10 |
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_METRIC_8_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric: STK-8 |
D_PERSON_ID | DOUBLE | N | The person that qualified for the quality metric. |
EDU_ACT_EMS_DESC | VARCHAR(100) | Y | The nomenclature of the documentation of Education: Activation of EMS |
EDU_FOLLOWUP_DESC | VARCHAR(100) | Y | The nomenclature of the documentation of Education: Followup after Discharge |
EDU_PRESC_MED_DESC | VARCHAR(100) | Y | The nomenclature of the documentation of Education: Prescribed Medications |
EDU_RISK_FACTORS_DESC | VARCHAR(100) | Y | The nomenclature of the documentation of Education: Risk Factors |
EDU_SIGNS_SYMPTOMS_DESC | VARCHAR(100) | Y | The nomenclature of the documentation of Education: Warning Signs and Symptoms |
EDU_WRITTEN_INFO_DESC | VARCHAR(100) | Y | The nomenclature of the documentation of Education: Written Information Given |
ED_ARRIVAL_DT_TM | DATETIME | Y | The date/time of the emergency department arrival. |
ED_DEPART_DT_TM | DATETIME | Y | The date/time of the emergency department depart. |
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 | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
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_10_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-10 |
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 |
EXCLUDE_8_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-8 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | The financial number alias associated to the encounter. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEMORRHAGIC_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of hemorrhagic stroke principal diagnosis. |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
IP_ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted |
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_GT70_IND | DOUBLE | Y | Identifies if there was an LDL-c result >= 70 mg/dL documented. ** Obsolete Column ** |
LDL_PERF_IND | DOUBLE | Y | Identifies if there was an LDL-c result documented ** Obsolete Column ** |
LDL_RSLT_TXT | VARCHAR(100) | Y | Holds the result text for a documented LDL-c result. |
LH_E_STROKE_2019_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_STROKE_2019_METRICS table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NUM_10_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-10 |
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 |
NUM_8_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-8 |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number associated to the encounter. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | Gender code system OID of the patient as per value set |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | Represents the patient's member or subscriber identifier coding system OID with respect to the payer |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | Ethnicity code system OID of the patient as per value set |
PERSON_RACE_DESC | VARCHAR(300) | Y | The list of all of a patient's races |
REHAB_ASSES_MED_RES_IND | DOUBLE | Y | Identifies documentation of Medical Reason of Rehabilitation Assessment during the inpatient encounter |
REHAB_ASSES_NOMEN | VARCHAR(60) | Y | The nomenclature of the documentation of Rehabilitation Assessment during the inpatient encounter |
REHAB_ASSES_PAT_REF_IND | DOUBLE | Y | Identifies documentation of Patient Refusal of Rehabilitation Assessment during the inpatient encounter |
REHAB_MED_RES_IND | DOUBLE | Y | ** OBSOLETE COLUMN ** Identifies documentation of Medical Reason of Rehabilitation Assessment during the inpatient encounter |
REHAB_PAT_REF_IND | DOUBLE | Y | ** OBSOLETE COLUMN ** Identifies documentation of Patient Refusal of Rehabilitation Assessment during the inpatient encounter |
REHAB_THERAPY_MED_RES_IND | DOUBLE | Y | Identifies documentation of Medical Reason of Rehabilitation Therapy during the inpatient encounter. |
REHAB_THERAPY_NOMEN | VARCHAR(60) | Y | The nomenclature of the documentation of Rehabilitation Therapy during the inpatient encounter |
REHAB_THERAPY_PAT_REF_IND | DOUBLE | Y | Identifies documentation of Patient Refusal of Rehabilitation Therapy during the inpatient encounter. |
SRC_UPDT_DT_TM | DATETIME | Y | Indicates the actual time when the row was inserted or updated at the source. This column is used only for date extraction and will not be populated on the client site. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | This column is updated with the name of the source program that loaded these rows into this table in Quality Clearinghouse when the Power Insight extracts were executed. This column is used only for date extraction and will not be populated on the client site. |
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 name of the timezone for the record. For example, 'America / Chicago'. |
TPA_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time of TPA Administered was documented |
TPA_PROC_DT_TM | DATETIME | Y | Identifies the most recent documentation of administration of TPA |
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_2019_METRICS
Child Column in LH_E_STROKE_2019_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_10_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_5_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_6_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_8_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 | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |
LH_E_STROKE_2020_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_E_STROKE_2020_METRICS |
Definition: | Stores data gathered by the LH_E_STROKE_2020 program. |
Table Type: | ACTIVITY |
Column Detail - LH_E_STROKE_2020_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
AC_DISCH_DT_TM | DATETIME | Y | The data/time of the anticoagulant discharge medication. |
AC_DISCH_MED_RES_IND | DOUBLE | Y | Indicates medical reason for no anticoagulant therapy was documented. |
AC_DISCH_PAT_REF_IND | DOUBLE | Y | Indicates patient refusal for anticoagulant therapy was documented. |
ATRIAL_ABLATION_PROC_DT_TM | DATETIME | Y | The date/time the nomenclature of atrial ablation procedure was documented. |
ATRIAL_ABLATION_PROC_NOMEN | VARCHAR(50) | Y | The nomenclature of atrial ablation procedure. |
ATRIAL_FIB_FLUTTER_DX_DT_TM | DATETIME | Y | The date/time the nomenclature of atrial fibrillation/fultter diagnosis was documented. |
ATRIAL_FIB_FLUTTER_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of atrial fibrillation/fultter diagnosis. |
AT_ADMIN_DT_TM | DATETIME | Y | Identifies the Antithrombotic administration within 1 day after hospitalization start. |
AT_ADMIN_MED_RES_IND | DOUBLE | Y | Identifies a Medical Reason for not administering Antithrombotics (Event) within 1 day after hospitalization start |
AT_ADMIN_PAT_REF_IND | DOUBLE | Y | Identifies a Patient Refusal for not administering Antithrombotics (Event) within 1 day after hospitalization start |
AT_DISCH_DT_TM | DATETIME | Y | The data/time of the antithrombotic discharge medication. |
AT_DISCH_MED_RES_IND | DOUBLE | Y | Indicates medical reason for no antithrombotic therapy was documented. |
AT_DISCH_PAT_REF_IND | DOUBLE | Y | Indicates patient refusal for antithrombotic therapy was documented. |
AT_ORDER_MED_RES_IND | DOUBLE | Y | Identifies a Medical Reason for not ordering Antithrombotics within 1 day after hospitalization start |
AT_ORDER_PAT_REF_IND | DOUBLE | Y | Identifies a Patient Refusal for not ordering Antithrombotics within 1 day after hospitalization start |
CMO_ORDER_1D_DT_TM | DATETIME | Y | The date/time of the order for comfort measures within 1 day after the start of the hospitalization |
CMO_ORDER_DT_TM | DATETIME | Y | The date/time of comfort measures order. |
CMO_PERF_1D_DT_TM | DATETIME | Y | The date/time of the event for comfort measures within 1 day after the start of the hospitalization |
CMO_PERF_DT_TM | DATETIME | Y | The data/time of comfort measures clinical event. |
DEN_2_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for STK-2 |
DEN_3_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for STK-3 |
DEN_5_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for STK-5 |
DEN_6_IND | DOUBLE | Y | Identifies if the encounter is In Denominator for STK-6 |
DISCHARGE_DT_TM | DATETIME | Y | The end of the qualifying encounter. |
D_ADMIT_BUILDING_ID | DOUBLE | N | Dimension ID for admit building. |
D_ADMIT_FACILITY_ID | DOUBLE | N | Dimension ID for admit facility. |
D_ADMIT_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for admit nurse unit. |
D_ADMIT_SRC_ID | DOUBLE | N | Dimension ID for admit source. |
D_ADMIT_TYPE_ID | DOUBLE | N | Dimension ID for admit type. |
D_ATTEND_PRSNL_ID | DOUBLE | N | Dimension ID for attending physician. |
D_BR_CCN_ID | DOUBLE | N | Dimension ID for CCN. |
D_BR_HCO_ID | DOUBLE | N | Dimension ID for HCO. |
D_DISCHARGE_BUILDING_ID | DOUBLE | N | Dimension ID for discharge building. |
D_DISCHARGE_FACILITY_ID | DOUBLE | N | Dimension ID for discharge facility. |
D_DISCHARGE_NURSE_UNIT_ID | DOUBLE | N | Dimension ID for discharge nurse unit. |
D_DISCH_DISP_ID | DOUBLE | N | Dimension ID for discharge disposition. |
D_ENCNTR_TYPE_ID | DOUBLE | N | Dimension ID for encounter type. |
D_METRIC_2_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric: STK-2 |
D_METRIC_3_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric: STK-3 |
D_METRIC_5_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric: STK-5 |
D_METRIC_6_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric: STK-6 |
D_PERSON_ID | DOUBLE | N | Dimension ID for person data. |
ED_ARRIVAL_DT_TM | DATETIME | Y | The start of the emergency encounter. |
ED_DEPART_DT_TM | DATETIME | Y | The end of the emergency encounter. |
ED_ENCNTR_ID | DOUBLE | N | Identifies the emergency encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
ENCNTR_ID | DOUBLE | N | The ID of the qualifying encounter associated to the record. |
EXCEP_2_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-2 |
EXCEP_3_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-3 |
EXCEP_5_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-5 |
EXCEP_6_IND | DOUBLE | Y | Identifies if the encounter is a Denominator Exception for STK-6 |
EXCLUDE_2_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-2 |
EXCLUDE_3_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-3 |
EXCLUDE_5_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-5 |
EXCLUDE_6_IND | DOUBLE | Y | Identifies if the encounter is Excluded for STK-6 |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FINANCIAL_NBR_TXT | VARCHAR(50) | Y | Financial Number of the record. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time that the first ETL process started that created this record. |
HEALTH_SYSTEM_ID | DOUBLE | N | Identifies the delivery network responsible for supplying the data. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
HEMORRHAGIC_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of hemorrhagic stroke principal diagnosis. |
INR_TXT | VARCHAR(100) | Y | Identifiesthe INR value documented for a Laboratory test performed |
IPP_IND | DOUBLE | Y | Indicates the encounter within the initial patient population |
IP_ADMIT_DT_TM | DATETIME | Y | The start of the inpatient encounter. |
ISCHEMIC_DX_NOMEN | VARCHAR(50) | Y | The nomenclature of ischemic stroke principal diagnosis. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDL_RSLT_TXT | VARCHAR(100) | Y | Identifies if LDL result is documente and if yes, displays what value is documented. |
LH_E_STROKE_2020_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_E_STROKE_2020_METRICS table. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
NUM_2_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-2 |
NUM_3_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-3 |
NUM_5_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-5 |
NUM_6_IND | DOUBLE | Y | Identifies if the encounter is in the Numerator for STK-6 |
OBS_SERV_ARRIVAL_DT_TM | DATETIME | Y | The start of the observation encounter. |
OBS_SERV_DEPART_DT_TM | DATETIME | Y | The end of the observation encounter. |
OBS_SERV_ENCNTR_ID | DOUBLE | N | The ID of the observation services encounter associated to the record. |
ORG_MRN_TXT | VARCHAR(50) | Y | Medical Record Number of the record. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility. |
PATIENT_IDENT | VARCHAR(50) | Y | Identifies the earliest documented medical record number of the patient. |
PERSON_ETHNIC_CODE_DISPLAY | VARCHAR(300) | Y | String to store ethnicity display. |
PERSON_GENDER_CODE_DISPLAY | VARCHAR(300) | Y | String to store gender display. |
PERSON_ID | DOUBLE | N | The ID of the person associated to the record. |
PERSON_PAYER_CODE_DISPLAY | VARCHAR(300) | Y | String to store payer display. |
PERSON_RACE_DESC | VARCHAR(300) | Y | String to store multiple races. |
SCRIPT_VERSION | DOUBLE | Y | The version number of the script that populated the row |
SRC_UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated to be preserved during extracts. |
SRC_UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record to be preserved during extracts. |
STATIN_ALLERGY_IND | DOUBLE | Y | Identifies if there was a Allergy Reason for not giving Statins |
STATIN_DISCH_DT_TM | DATETIME | Y | The date/time of the Statin prescribed at discharge |
STATIN_DISCH_MED_RES_IND | DOUBLE | Y | Identifies if there was a Medical Reason for not giving Statins |
STATIN_DISCH_PAT_REF_IND | DOUBLE | Y | Identifies if there was a Patient Refusal for not giving Statins |
TICAG_ADMIN_1D_DT_TM | DATETIME | Y | Identifies the date/time Ticagrelor Administered was documented within 1 day of IP admit |
TICAG_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time Ticagrelor Administered was documented |
TIME_ZONE_TXT | VARCHAR(100) | Y | The timezone of the record in ""America/Chicago"" format. |
TPA_ADMIN_DT_TM | DATETIME | Y | Identifies the date/time of TPA Administered was documented |
TPA_DIAG_DT_TM | DATETIME | Y | Identifies the most recent documentation of diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy |
TPA_DX_NOMEN | VARCHAR(50) | Y | Identifies the documentation code diagnosis for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy |
TPA_PROC_DT_TM | DATETIME | Y | Identifies the most recent documentation of procedure for Intravenous or Intra-arterial Thrombolytic (tPA) Therapy |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - LH_E_STROKE_2020_METRICS
Child Column in LH_E_STROKE_2020_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_DISCH_DISP_ID | LH_D_DISCH_DISP | D_DISCH_DISP_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_DISCH_DISP | HEALTH_SYSTEM_SOURCE_ID | |
D_ENCNTR_TYPE_ID | LH_D_ENCNTR_TYPE | D_ENCNTR_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ENCNTR_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
D_DISCHARGE_FACILITY_ID | LH_D_FACILITY | D_FACILITY_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_FACILITY | HEALTH_SYSTEM_SOURCE_ID | |
D_METRIC_2_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_3_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_5_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_6_ID | LH_D_METRIC | D_METRIC_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_METRIC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
D_DISCHARGE_NURSE_UNIT_ID | LH_D_NURSE_UNIT | D_NURSE_UNIT_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_NURSE_UNIT | HEALTH_SYSTEM_SOURCE_ID | |
D_PERSON_ID | LH_D_PERSON | D_PERSON_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSON | HEALTH_SYSTEM_SOURCE_ID | |
D_ATTEND_PRSNL_ID | LH_D_PERSONNEL | D_PRSNL_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_PERSONNEL | HEALTH_SYSTEM_SOURCE_ID |