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