Table Detail Report
LH_ABS_SPECIAL_SKIP_PARAM
Column Section | Top of Page |
Table-level Detail
Description: | lh_abs_special_skip_param |
Definition: | Holds parameters for special skip logic |
Table Type: | REFERENCE |
Column Detail - LH_ABS_SPECIAL_SKIP_PARAM
Column Name | Type | Null? | Definition |
---|---|---|---|
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CHECK_KEY | VARCHAR(30) | N | Identifier to link param to a given logical group |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
FIRST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was first loaded into the table. |
HEALTH_SYSTEM_SOURCE_ID | DOUBLE | N | Identifies the unique source within the delivery network responsible for supplying the data. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time the record was last loaded into the table. |
LH_ABS_SPECIAL_SKIP_PARAM_ID | DOUBLE | N | Unique generated number that identifies a single row on the lh_abs_special_skip_param 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. |
PARAM_TXT | VARCHAR(50) | N | This column holds a parameter that is used within the special skip logic for this type of check. |
QUALIFIER_TXT | VARCHAR(10) | Y | This column holds the logical check that the param is used for. At the moment this is limited to the following: "=", "!=", "<", ">". |
UPDT_CNT | DOUBLE | Y | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. |
UPDT_SOURCE | VARCHAR(50) | Y | The script name responsible for updating the record. |
UPDT_TASK | VARCHAR(50) | Y | The registered (assigned) task number for the process that inserted or updated the row. |
LH_ABS_STK_OP_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_STK_OP_METRICS |
Definition: | Stores information about Stroke Outpatient encounters |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_STK_OP_METRICS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted. |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ARRIVAL_DATE_TXT | VARCHAR(10) | Y | The earliest documented date the patient arrived at the hospital. User Entered (MM-DD-YYYY) Includes dashes. |
ARRIVAL_DT_TM | DATETIME | Y | The earliest documented date/time on which the patient arrived at the hospital. |
ARRIVAL_TIME_TXT | VARCHAR(5) | Y | The earliest documented time the patient arrived at the hospital. User Entered (Military format with or without colon, HH:MM). |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The earliest documented date/time on which the patient arrived at the hospital normalized to GMT. |
CMO_FLAG | DOUBLE | Y | Documentation of earliest physician/APN/PA of comfort measures only. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
COMPLETED_DT_TM | DATETIME | Y | The Date and Time at which the abstracted case was completed. |
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. |
DISC_DISP_TXT | VARCHAR(10) | Y | The patient's discharge disposition on the day of discharge. |
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. Foreign key to LH_D_BR_CCN. |
D_BR_HCO_ID | DOUBLE | N | Healthcare organization Number. Foreign key to LH_D_BR_HCO. |
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 | The conditions under which the patient left the facility at the time of discharge. Foreign key to LH_D_DISCH_DISP. |
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_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON. |
ED_DEPART_DATE_TXT | VARCHAR(10) | Y | Date the patient departed from the emergency department. User Entered (MM-DD-YYYY) Includes dashes. |
ED_DEPART_DT_TM | DATETIME | Y | Time the patient departed from the emergency department. |
ED_DEPART_TIME_TXT | VARCHAR(5) | Y | Time the patient departed from the emergency department. User Entered (Military forma with or without colon, HH:MM). |
ED_DEPART_UTC_DT_TM | DATETIME | Y | Time the patient departed from the emergency department normalized to GMT. |
EMCODE | VARCHAR(10) | Y | Identifies the patient E/M code documented. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_STK_OP1_IND | DOUBLE | Y | Identifies patients excluded from STK-OP-1. |
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 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. |
IV_THROM_FLAG | DOUBLE | Y | Documentation that IV alteplase was initiated at this hospital. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_ABS_STK_OP_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_STK_OP_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. |
LVO_FLAG | DOUBLE | Y | Documentation of a LVO in the medical record. |
MER_FLAG | DOUBLE | Y | Documentation in the medical record that the patient is eligible for MER therapy or a mechanical thrombectomy procedure. |
NUMERATOR_STK_OP1_IND | DOUBLE | Y | Identifies patients in mesure porpulation with measurement value for STK-OP-1. |
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. |
PAYMENT_SOURCE_FLAG | DOUBLE | Y | Identifies the source of payment for the encounter. |
PHYSICIAN_1_TXT | VARCHAR(50) | Y | First physician identifier. |
PHYSICIAN_2_TXT | VARCHAR(50) | Y | Second physician identifier. |
PRIN_DIAGNOSIS | VARCHAR(10) | Y | Identifies the principle diagnosis associated with the encounter. |
REJECT_STK_OP1_IND | DOUBLE | Y | Identifies patients rejected from STK-OP-1. |
SAMPLE_IND | DOUBLE | Y | Indicates if the case is sampled. |
STK_OP1B_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1b. |
STK_OP1C_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1c. |
STK_OP1D_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1d. |
STK_OP1E_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1e. |
STK_OP1F_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1f. |
STK_OP1G_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1g. |
STK_OP1H_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1h. |
STK_OP1I_IND | DOUBLE | Y | Identifies patients within stratum STK-OP-1i. |
STK_OP1_MEASUREMENT_VALUE | DOUBLE | N | Identifies the Median time from hospital arrival in the ED to transfer of another hospital. |
STK_OP1_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for stk_op1 obtained during the completion of abstraction. |
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_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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 reecord. |
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_ABS_STK_OP_METRICS
Child Column in LH_ABS_STK_OP_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 | |
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_ABS_STROKE_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_STROKE_METRICS |
Definition: | This table is used to store Stoke metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_STROKE_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. |
ADMIT_DT_TM | DATETIME | Y | The date/time on which the patient was admitted. |
ADMIT_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was admitted; normalized to GMT. |
ANTICOAG_DISC_IND | DOUBLE | Y | Anticoagulation therapy prescribed at hospital discharge. |
ANTITHR_DISC_IND | DOUBLE | Y | Antithrombotic therapy prescribed at hospital discharge. |
ARRIVAL_DATE_TXT | VARCHAR(10) | Y | The earliest documented date the patient arrived at the facility. User Entered (MM-DD-YYYY) Includes dashes |
ARRIVAL_DT_TM | DATETIME | Y | The earliest documented date/time on which the patient arrived at the facility. |
ARRIVAL_TIME_TXT | VARCHAR(5) | Y | The earliest documented date the patient arrived at the facility. User Entered (Military format with or without colon, HH:MM) |
ARRIVAL_UTC_DT_TM | DATETIME | Y | The earliest documented date/time on which the patient arrived at the facility normalized to GMT. |
ARRVL_MODE_IND | DOUBLE | Y | Indicates how did the patient arrive the hospital. |
ASSESS_REHAB_IND | DOUBLE | Y | The patient was assessed for and/or the patient received rehabilitation services during this hospitalization. |
ATRIAL_FIB_FLUTTER_IND | DOUBLE | Y | History of atrial fibrillation/flutter or current finding of atrial fibrillation/flutter documented in the medical record. |
CLINICAL_TRIAL_IND | DOUBLE | Y | During this hospital stay, the patient enrolled in a clinical trial in which patients with the same condition as the measure set were being studied |
CMO_FLAG | DOUBLE | Y | The earliest physician/APN/PA documentation of comfort measures only. |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
COMPLETED_DT_TM | DATETIME | Y | The Date and Time the abstracted case was completed |
CSTK01_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for CSTK-01 obtained during the completion of abstraction. |
CSTK03_REASON_TXT | VARCHAR(250) | Y | This filed stores the category reason for the cstk_03 measure |
CSTK04_REASON_TXT | VARCHAR(250) | Y | This filed stores the category reason for the cstk_04 measure |
CSTK05_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for the measure CSTK05 |
CSTK06_REASON_TXT | VARCHAR(250) | Y | This filed stores the category reason for the cstk_06 measure |
CSTK08_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for the measure CSTK08 |
CSTK09_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for the measure CSTK09 |
CSTK11_REASON_TXT | VARCHAR(250) | Y | This filed stores the category reason for the cstk_11 measure |
CSTK12_REASON_TXT | VARCHAR(250) | Y | This filed stores the category reason for the cstk_12 measure |
CSTK9_MEASUREMENT_VALUE | DOUBLE | Y | Stores Measurement Value for CSTK-09 sub-measure. |
CSTK_3A_IND | DOUBLE | Y | This field indicates if the encounter is in stratum A for CSTK-03 measure. |
CSTK_3B_IND | DOUBLE | Y | This field indicates if the encounter is in stratum B for CSTK-03 measure. |
CSTK_5A_IND | DOUBLE | Y | Indicates if the patients qualify for CSTK-5A sub-measure. |
CSTK_5B_IND | DOUBLE | Y | Indicates if the patients qualify for CSTK-5B sub-measure. |
CSTK_9A_IND | DOUBLE | Y | Indicates if the patients qualify for CSTK-9a sub-measure. |
CSTK_9B_IND | DOUBLE | Y | Indicates if the patients qualify for CSTK-9b sub-measure. |
DIRECT_ADMISSION_FLAG | DOUBLE | Y | Determines if patient was a direct admission to the hospital. |
DISCHARGE_DATE_TXT | VARCHAR(10) | Y | Date the patient encounter was discharged. User Entered (MM-DD-YYYY) Includes dashes. |
DISCHARGE_DT_TM | DATETIME | Y | The date/time on which the patient was discharged. |
DISCHARGE_TIME_TXT | VARCHAR(5) | Y | Time the patient encounter was discharged. User Entered (Military forma with or without colon, HH:MM). |
DISCHARGE_UTC_DT_TM | DATETIME | Y | The date/time on which the patient was discharged; normalized to GMT. |
DISC_DISP_FLAG | DOUBLE | Y | The patient's discharge disposition on the day of discharge. |
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 during the visit. |
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_ENCNTR_TYPE_ID | DOUBLE | N | Categorizes the encounter into a logical group or type. Foreign key to the CODE_VALUE table. |
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_10_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_11_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_12_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_13_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_14_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_15_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_16_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_17_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_18_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_19_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_1_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_20_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_METRIC_8_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_METRIC_9_ID | DOUBLE | N | Identifies the metric identifier for the Lighthouse metric. |
D_PERSON_ID | DOUBLE | N | Identifies the person associated with the quality measure. Foreign key to the PERSON table. |
EDU_DISCH_MEDS_IND | DOUBLE | Y | Written instructions or other documentation of educational material given to the patient/caregiver addressing all discharge medications. |
EDU_EMS_IND | DOUBLE | Y | Written instructions or other documentation of educational material given to the patient/caregiver addressing activation of the emergency medical system (EMS) if signs or symptoms of stroke occur. |
EDU_FOLLOWUP_IND | DOUBLE | Y | Written instructions or other documentation of educational material given to the patient/caregiver addressing follow-up with a physician/APN/PA after discharge. |
EDU_RISK_IND | DOUBLE | Y | Written instructions or other documentation of educational material given to the patient/caregiver addressing risk factors for stroke. |
EDU_SIGNS_SYM_IND | DOUBLE | Y | Wrtten instructions or other documentation of educational material given to the patient/caregiver addressing warning signs and symptoms of stroke. |
ED_PATIENT_IND | DOUBLE | Y | The patient an ED patient at the facility |
ELECTIVE_CAROTID_IND | DOUBLE | Y | This admission was for the sole purpose of performance of an elective carotid intervention |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
ENDO_VASC_RES_PROC_FLAG | DOUBLE | Y | Indicates if there is any documentation in the medical record that the first endovascular treatment procedure was initiated greater than 8 hours after arrival at this hospital |
EXCLUDE_10_IND | DOUBLE | Y | Identifies patients excluded from STK-10 |
EXCLUDE_10_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-10 for Meaningful Use |
EXCLUDE_1_IND | DOUBLE | Y | Identifies patients excluded from STK-1 |
EXCLUDE_1_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-1 for Meaningful Use |
EXCLUDE_2_IND | DOUBLE | Y | Identifies patients excluded from STK-2 |
EXCLUDE_2_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-2 for Meaningful Use |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from STK-3 |
EXCLUDE_3_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-3 for Meaningful Use |
EXCLUDE_4_IND | DOUBLE | Y | Identifies patients excluded from STK-4 |
EXCLUDE_4_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-4 for Meaningful Use |
EXCLUDE_5_IND | DOUBLE | Y | Identifies patients excluded from STK-5 |
EXCLUDE_5_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-5 for Meaningful Use |
EXCLUDE_6_IND | DOUBLE | Y | Identifies patients excluded from STK-6 |
EXCLUDE_6_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-6 for Meaningful Use |
EXCLUDE_8_IND | DOUBLE | Y | Identifies patients excluded from STK-8 |
EXCLUDE_8_MU_IND | DOUBLE | Y | Identifies patients excluded from STK-8 for Meaningful Use |
EXCLUDE_CSTK11_IND | DOUBLE | Y | This field indicates if the encounter is excluded for CSTK-11 measure. |
EXCLUDE_CSTK12_IND | DOUBLE | Y | This field indicates if the encounter is excluded for CSTK-12 measure. |
EXCLUDE_CSTK1_IND | DOUBLE | Y | Identifies patients excluded from CSTK-01. |
EXCLUDE_CSTK3_IND | DOUBLE | Y | This field indicates if the encounter is excluded for CSTK-03 measure. |
EXCLUDE_CSTK4_IND | DOUBLE | Y | This field indicates if the encounter is excluded for CSTK-04 measure. |
EXCLUDE_CSTK5_IND | DOUBLE | Y | identifies patients that is excluded from cstk-05. |
EXCLUDE_CSTK6_IND | DOUBLE | Y | This field indicates if the encounter is excluded for CSTK-06 measure. |
EXCLUDE_CSTK8_IND | DOUBLE | Y | identifies patients that is excluded from cstk-08. |
EXCLUDE_CSTK9_IND | DOUBLE | Y | identifies patients that is excluded from cstk-09. |
EXCLUDE_STK_VOL_1_IND | DOUBLE | Y | identifies patients that is excluded from stk_vol1. |
EXTRACT_DT_TM | DATETIME | Y | The date/time that the record was extracted from the source system. |
EXT_IV_THROM_REASON_FLAG | DOUBLE | N | Reason for extending the initiation of IV Thrombolytic flag. 0 - No; 1 - Yes; 999 - Missing |
FAIL_AT_TTHROM_FLAG | DOUBLE | Y | Identifies if mechanical thrombectomy procedure attempted but unsuccessful or aborted before removal of the LVO |
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 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. |
IA_MER_DT_TM | DATETIME | Y | Date associated with the time that IA alteplase or MER was initiated at the hospital |
IA_MER_TPA_DATE_TXT | VARCHAR(10) | Y | Date that IA alteplase or MER was initiated at the hospital |
IA_MER_TPA_TIME_TXT | VARCHAR(5) | Y | The time of IA alteplase or MER initiation |
IA_MER_UTC_DT_TM | DATETIME | Y | Date associated with the time that IA alteplase or MER was initiated at the hospital,normalized to GMT |
IA_ROUTE_TPA_FLAG | DOUBLE | Y | Indicates if there is a documentation that the route of alteplase administration was intra-arterial (IA) |
INIT_HSSP_DT_TM | DATETIME | Y | This field stores the date/time (Local) when the initial Hunt and Hess Scale was performed |
INIT_HSSP_UTC_DT_TM | DATETIME | Y | This field stores the date/time (UTC) when the initial Hunt and Hess Scale was performed |
INIT_ICH_DT_TM | DATETIME | Y | This field stores the date/time (Local) when the initial ICH Score was performed |
INIT_ICH_UTC_DT_TM | DATETIME | Y | This field stores the date/time (UTC) when the ICH Score was performed |
INIT_NIHSS_DATE_TXT | VARCHAR(10) | Y | Date the NIHSS score was first performed at this hospital. User Entered (MM-DD-YYYY) Includes dashes. |
INIT_NIHSS_DT_TM | DATETIME | Y | Date/Time the NIHSS score was first performed at this hospital. |
INIT_NIHSS_PERF_FLAG | DOUBLE | Y | Documentation that an initial NIHSS score was done at this hospital. |
INIT_NIHSS_TIME_TXT | VARCHAR(5) | Y | Time the NIHSS score was first performed at this hospital. User Entered (Military format with or without colon, HH:MM). |
INIT_NIHSS_UTC_DT_TM | DATETIME | Y | Date/Time the NIHSS score was first performed at this hospital normalized to GMT. |
INI_NIHSCR_LESS_FLAG | DOUBLE | Y | Indicates initial NIHSS score after hospital arrival less than 6 |
ISCHEMIC_WITH_PROC_IND | DOUBLE | Y | Identifies Ischemic patients with a procedure on Table 8.1a or Table 8.1b |
IV_THROM_DATE_TXT | VARCHAR(10) | Y | The date that IV thrombolytic therapy was initiated for this patient at this hospital. User Entered (MM-DD-YYYY) Includes dashes |
IV_THROM_DT_TM | DATETIME | Y | The date/time that IV thrombolytic therapy was initiated for this patient at this hospital. |
IV_THROM_IND | DOUBLE | Y | Documentation that IV thrombolytic therapy was initiated at this hospital. |
IV_THROM_TIME_TXT | VARCHAR(5) | Y | The time that IV thrombolytic therapy was initiated for this patient at this hospital. User Entered (Military format with or without colon, HH:MM) |
IV_THROM_UTC_DT_TM | DATETIME | Y | The date/time that IV thrombolytic therapy was initiated for this patient at this hospital normalized to GMT. |
LAST_KNOWN_WELL_DATE_TXT | VARCHAR(10) | Y | The date at which the patient was last known to be well or at his or her baseline state of health.User Entered (MM-DD-YYYY) Includes dashes |
LAST_KNOWN_WELL_DT_TM | DATETIME | Y | The date/time at which the patient was last known to be well or at his or her baseline state of health. |
LAST_KNOWN_WELL_IND | DOUBLE | Y | Documentation that the date and time of last known well was witnessed or reported. |
LAST_KNOWN_WELL_TIME_TXT | VARCHAR(5) | Y | The time at which the patient was last known to be well or at his or her baseline state of health.User Entered (Military format with or without colon, HH:MM) |
LAST_KNOWN_WELL_UTC_DT_TM | DATETIME | Y | The date/time at which the patient was last known to be well or at his or her baseline state of health normalized to GMT. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LDL_C_GTE_100_IND | DOUBLE | Y | The patient's highest LDL-cholesterol (LDL-c) level greater than or equal to 100 mg/dL in the first 48 hours or within 30 days prior to hospital arrival. |
LDL_C_MEASURED_IND | DOUBLE | Y | LDL-cholesterol (LDL-c) measured within the first 48 hours or 30 days prior to hospital arrival. |
LH_ABS_STROKE_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_STROKE_METRICS table. |
LIPID_LOWER_PRE_ARR_IND | DOUBLE | Y | Documentation that the patient was on a lipid-lowering medication prior to hospital arrival. |
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. |
NIHSS_IVTHROM_INI | VARCHAR(10) | Y | Stores the highest NIHSS Score Documented Within 36 Hours Following IV Alteplase Initiation |
NIHSS_SCORES | VARCHAR(10) | Y | Stores the last NIHSS score documented prior to initiation of IA alteplase or MER at this hospital |
NIHS_CLOS_IVTPA | VARCHAR(10) | Y | Stores the NIHSS Score Documented Closest to IV Alteplase Initiation |
NIMO_ADMIN_DT_TM | DATETIME | Y | This field stores the date/time (Local) when the nimodipine was administered at this hospital. |
NIMO_ADMIN_UTC_DT_TM | DATETIME | Y | This field stores the date/time (UTC) when the nimodipine was administered at this hospital. |
NI_HSS_TPA_MER_INI | VARCHAR(10) | Y | Stores the highest NIHSS Score Documented Within 36 Hours Following IA Alteplase or MER Initiation |
NO_ANTICOAG_REASON_IND | DOUBLE | Y | Documentation by a physician/advanced practice nurse/physician assistant (physician/APN/PA) or pharmacist in the medical record of a reason for not prescribing anticoagulation therapy at hospital discharge. |
NO_ANTITHR_REASON_IND | DOUBLE | Y | Documentation by a physician/advanced practice nurse/physician assistant (physician/APN/PA) or pharmacist in the medical record of a reason for not prescribing antithrombotic therapy at hospital discharge. |
NO_IV_THROM_REASON_IND | DOUBLE | Y | Documentation by a physician/advanced practice nurse/physician assistant (physician/APN/PA) or pharmacist in the medical record for not initiating IV thrombolytic. |
NO_STATIN_REASON_IND | DOUBLE | Y | Documentation of a reason for not prescribing a statin medication at discharge. |
NO_TPA_EOD2_REASON_IND | DOUBLE | Y | Documentation by a physician/advanced practice nurse/physician assistant (physician/APN/PA) or pharmacist in the medical record of a reason for not administering antithrombotic therapy by end of hospital day 2. |
NO_VTE_PROPH_REASON_IND | DOUBLE | Y | Documentation why prophylaxis was not administered at hospital admission. |
NUMERATOR_10_IND | DOUBLE | Y | Identifies patients that qualify for STK-10 |
NUMERATOR_10_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-10 for Meaningful Use |
NUMERATOR_1_IND | DOUBLE | Y | Identifies patients that qualify for STK-1 |
NUMERATOR_1_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-1 for Meaningful Use |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for STK-2 |
NUMERATOR_2_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-2 for Meaningful Use |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients that qualify for STK-3 |
NUMERATOR_3_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-3 for Meaningful Use |
NUMERATOR_4_IND | DOUBLE | Y | Identifies patients that qualify for STK-4 |
NUMERATOR_4_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-4 for Meaningful Use |
NUMERATOR_5_IND | DOUBLE | Y | Identifies patients that qualify for STK-5 |
NUMERATOR_5_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-5 for Meaningful Use |
NUMERATOR_6_IND | DOUBLE | Y | Identifies patients that qualify for STK-6 |
NUMERATOR_6_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-6 for Meaningful Use |
NUMERATOR_8_IND | DOUBLE | Y | Identifies patients that qualify for STK-8 |
NUMERATOR_8_MU_IND | DOUBLE | Y | Identifies patients that qualify for STK-8 for Meaningful Use |
NUMERATOR_CSTK11_IND | DOUBLE | Y | This field indicates if the encounter is in numerator for CSTK-11 measure. |
NUMERATOR_CSTK12_IND | DOUBLE | Y | This field indicates if the encounter is in numerator for CSTK-12 measure. |
NUMERATOR_CSTK1_IND | DOUBLE | Y | Identifies patients that qualify for CSTK-01. |
NUMERATOR_CSTK3_IND | DOUBLE | Y | This field indicates if the encounter is in numerator for CSTK-03 measure. |
NUMERATOR_CSTK4_IND | DOUBLE | Y | This field indicates if the encounter is in numerator for CSTK-04 measure. |
NUMERATOR_CSTK5_IND | DOUBLE | Y | identifies patients that qualify for cstk-05. |
NUMERATOR_CSTK6_IND | DOUBLE | Y | This field indicates if the encounter is in numerator for CSTK-06 measure. |
NUMERATOR_CSTK8_IND | DOUBLE | Y | identifies patients that qualify for cstk-08. |
NUMERATOR_CSTK9_IND | DOUBLE | Y | identifies patients that qualify for cstk-09. |
NUMERATOR_STK_VOL_1_IND | DOUBLE | Y | Identifies patients that qualify for stk_vol1. |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OTHR_ADMIT_DIAGNOSIS_LIST | VARCHAR(250) | Y | A comma separated list of admit diagnoses associated with the encounter. |
OTH_DIAGNOSIS_LIST | VARCHAR(250) | Y | A comma separated list of other diagnoses associated with the encounter. |
OTH_PROCEDURE_DATES_LIST | VARCHAR(275) | Y | A comma separated list of dates the other procedures associated with the encounter were performed. |
OTH_PROCEDURE_LIST | VARCHAR(250) | Y | A comma separated list of other procedures associated with the encounter. |
OTH_PROCEDURE_TIMES_LIST | VARCHAR(150) | Y | A comma separated list of times, the other procedures associated with the encounter were performed. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PAYMENT_SOURCE_FLAG | DOUBLE | Y | Identifies the source of payment for the encounter |
PHYSICIAN_1_TXT | VARCHAR(50) | Y | First physician identifier |
PHYSICIAN_2_TXT | VARCHAR(50) | Y | Second physician identifier |
POST_TICI_RPFS_GRD_IND | DOUBLE | Y | Indicates if there a documented TICI reperfusion gradepost-treatment |
POS_BRAIN_IMG_DATE_TXT | VARCHAR(10) | Y | Date of the positive brain image finding |
POS_BRAIN_IMG_DT_TM | DATETIME | Y | Date and time of the positive brain image finding |
POS_BRAIN_IMG_FLAG | DOUBLE | Y | Identifies if there is any positive finding on brain imaging of parenchymal hematoma, subarachnoid hemorrhage, and/or intraventricular hemorrhage following IV or IA alteplase therapy, or mechanical endovascular reperfusion therapy initiation |
POS_BRAIN_IMG_TIME_TXT | VARCHAR(5) | Y | Time of the positive brain image |
POS_BRAIN_IMG_UTC_DT_TM | DATETIME | Y | Date and time of the positive brain image finding,normalized to GMT |
PRIN_DIAGNOSIS | VARCHAR(10) | Y | Identifies the principle diagnosis associated with the encounter. |
PRIN_PROCEDURE | VARCHAR(10) | Y | Identifies the principle procedure associated with the encounter. |
PRIN_PROCEDURE_DATE_TXT | VARCHAR(10) | Y | The date on which the principle procedure was performed. |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_TIME_TXT | VARCHAR(5) | Y | The time at which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed; normalized to GMT |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
REASON_ORAL_FACTOR_IND | DOUBLE | Y | Holds the reason for oral factor xa response information. |
REJECT_10_IND | DOUBLE | Y | Identifies patients reject for STK-10 |
REJECT_1_IND | DOUBLE | Y | Identifies patients reject for STK-1 |
REJECT_2_IND | DOUBLE | Y | Identifies patients reject for STK-2 |
REJECT_3_IND | DOUBLE | Y | Identifies patients reject for STK-3 |
REJECT_4_IND | DOUBLE | Y | Identifies patients reject for STK-4 |
REJECT_5_IND | DOUBLE | Y | Identifies patients reject for STK-5 |
REJECT_6_IND | DOUBLE | Y | Identifies patients reject for STK-6 |
REJECT_8_IND | DOUBLE | Y | Identifies patients reject for STK-8 |
REJECT_CSTK11_IND | DOUBLE | Y | This field indicates if the encounter is rejected for CSTK-11 measure. |
REJECT_CSTK12_IND | DOUBLE | Y | This field indicates if the encounter is rejected for CSTK-12 measure. |
REJECT_CSTK1_IND | DOUBLE | Y | Identifies patients rejected from CSTK-01. |
REJECT_CSTK3_IND | DOUBLE | Y | This field indicates if the encounter is rejected for CSTK-03 measure. |
REJECT_CSTK4_IND | DOUBLE | Y | This field indicates if the encounter is rejected for CSTK-04 measure. |
REJECT_CSTK5_IND | DOUBLE | Y | identifies patients that is rejected from cstk_05. |
REJECT_CSTK6_IND | DOUBLE | Y | This field indicates if the encounter is rejected for CSTK-06 measure. |
REJECT_CSTK8_IND | DOUBLE | Y | identifies patients that is rejected from cstk_08. |
REJECT_CSTK9_IND | DOUBLE | Y | identifies patients that is rejected from cstk_09 |
REJECT_STK_VOL_1_IND | DOUBLE | Y | identifies patients that is rejected from Stk_vol_1. |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
SKIN_PUNCT_DATE_TXT | VARCHAR(10) | Y | Date of skin puncture at the hospital to access the arterial site selected for endovascular treatment of a cerebral artery occlusion |
SKIN_PUNCT_DT_TM | DATETIME | Y | Date associated with the time of skin puncture at this hospital to access the arterial site selected for endovascular treatment of a cerebral artery occlusion |
SKIN_PUNCT_FLAG | DOUBLE | Y | Indicates if there is any documentation of skin puncture at this hospital to access the arterial site selected for endovascular treatment of a cerebral artery occlusion |
SKIN_PUNCT_TIME_TXT | VARCHAR(5) | Y | Time of skin puncture at the hospital to access the arterial site selected for endovascular treatment of a cerebral artery occlusion |
SKIN_PUNCT_UTC_DT_TM | DATETIME | Y | Date associated with the time of skin puncture at this hospital to access the arterial site selected for endovascular treatment of a cerebral artery occlusion,normalized to GMT |
SKIP_PX_TM_RESP_IND | DOUBLE | Y | Identifies if the responses for PRINPXTM and OTHRPX#TM questions need to be skipped. |
STATIN_DISC_IND | DOUBLE | Y | Statin medication prescribed at discharge. |
STK10_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-10 obtained during the completion of abstraction. |
STK1_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-1 obtained during the completion of abstraction. |
STK2_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-2 obtained during the completion of abstraction. |
STK3_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-3 obtained during the completion of abstraction. |
STK4_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-4 obtained during the completion of abstraction. |
STK5_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-5 obtained during the completion of abstraction. |
STK6_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-6 obtained during the completion of abstraction. |
STK8_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for STK-8 obtained during the completion of abstraction. |
STRATUM_TITLE | VARCHAR(50) | N | The stratum title of the condition. Some examples would be Hemorrhagic and Ischemic. |
STROKE_VOL1_POP_IND | DOUBLE | Y | Indicates if patient is in population for Stroke_vol1 |
TICI_THROMB_PROC_DT_TM | DATETIME | Y | This field stores the date/time (Local) when the TICI 2B/3 was first documented during the mechanical thrombectomy procedure |
TICI_THROMB_PROC_UTC_DT_TM | DATETIME | Y | This field stores the date/time (UTC) when the TICI 2B/3 was first documented during the mechanical thrombectomy procedure |
TPA_ADMIN_IND | DOUBLE | Y | The patient received IV or IA thrombolytic (t-PA) therapy at the hospital or within 24 hours prior to arrival |
TPA_EOD2_IND | DOUBLE | Y | Antithrombotic therapy was administered by the end of hospital day 2. |
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_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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. |
VTE_PROPHYLAXIS_DATE_TXT | VARCHAR(10) | Y | Date the initial VTE prophylaxis administered after hospital admission.User Entered (MM-DD-YYYY) Includes dashes |
VTE_PROPHYLAXIS_DT_TM | DATETIME | Y | Date the initial VTE prophylaxis administered after hospital admission. |
VTE_PROPHYLAXIS_MASK | DOUBLE | Y | Type(s) of VTE prophylaxis documented in the medical record |
VTE_PROPHYLAXIS_UTC_DT_TM | DATETIME | Y | Date the initial VTE prophylaxis administered after hospital admission normalized to GMT. |
Relationship Detail - LH_ABS_STROKE_METRICS
Child Column in LH_ABS_STROKE_METRICS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | D_ADMIT_SRC_ID | LH_D_ADMIT_SRC | D_ADMIT_SRC_ID |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_SRC | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_TYPE_ID | LH_D_ADMIT_TYPE | D_ADMIT_TYPE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_ADMIT_TYPE | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_CCN_ID | LH_D_BR_CCN | D_BR_CCN_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_CCN | HEALTH_SYSTEM_SOURCE_ID | |
D_BR_HCO_ID | LH_D_BR_HCO | D_BR_HCO_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BR_HCO | HEALTH_SYSTEM_SOURCE_ID | |
D_ADMIT_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
D_DISCHARGE_BUILDING_ID | LH_D_BUILDING | D_BUILDING_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
HEALTH_SYSTEM_SOURCE_ID | LH_D_BUILDING | HEALTH_SYSTEM_SOURCE_ID | |
D_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_10_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_11_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_12_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_13_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_14_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_15_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_16_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_17_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_18_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_19_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_1_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_20_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 | |
D_METRIC_8_ID | LH_D_METRIC | D_METRIC_ID | |
D_METRIC_9_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 | |
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 | |
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_ABS_SUB_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_SUB_METRICS |
Definition: | This table is used to store SUB metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_SUB_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. |
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. |
ALCDRGDISORD_FLAG | DOUBLE | Y | Identifies the patient has a documentation on alcohol or drug use disorder |
ALCSTATUS_FLAG | DOUBLE | Y | Identifies the patient's alcohol use status. |
ALC_DRG_USE_STAT_COUN_FLAG | DOUBLE | Y | Holds the Alcohol or Drug Use Status Post Discharge - Counselling response information. 1 Was referred and is attending the referred addictions treatment. 2 Was referred and patient is not attending addictions treatment. 3 Was not referred to addictions treatment. 4 Refused to provide information relative to post discharge counseling attendance. 5 Not documented or unable to determine (UTD) from follow-up information collected. |
ALC_DRG_USE_STAT_MED_FLAG | DOUBLE | Y | Holds the Alcohol or Drug Use Status Post Discharge - Medication response information. 1 Was given a prescription and is taking medication post discharge for an alcohol or drug use disorder as prescribed. 2 Was given a prescription and is not taking medication post discharge for an alcohol or drug disorder as prescribed.; 3 Was not given a prescription for medication to treat an alcohol or drug use disorder. 4 Refused to provide information. 5 Not documented. |
ALC_USE_STAT_QUIT_FLAG | DOUBLE | Y | Holds the Alcohol Use Status Post Discharge - Quit Status response information. 1 Has quit or reduced their alcohol intake. 2 Has not quit or reduced their alcohol intake. 3 Not applicable, the patient does not use or does not have unhealthy alcohol use. 4 Refused to provide information relative to use status at the follow up contact. 5 Not documented or unable to determine (UTD) from follow-up information collected. |
BRFINTVTN_FLAG | DOUBLE | Y | Identifies if the patient receives a brief intervention prior to discharge. |
CMO_FLAG | DOUBLE | Y | Identifies if a patient was excluded due to an order for comfort measures. |
COGIMPAIR_FLAG | DOUBLE | Y | Identifies the patient has a documentation on cognitively impaired |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
COMPLETED_DT_TM | DATETIME | Y | The Date and Time the abstracted case was completed |
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. |
DISC_DISP_FLAG | DOUBLE | Y | The patient's discharge disposition on the day of discharge. |
DRG_USE_STAT_QUIT_FLAG | DOUBLE | Y | Holds the Drug Use Status Post Discharge - Quit Status response information. 1 Has quit using drugs. 2 Has not quit using drugs. 3 Not applicable, does not use drugs. 4 Refused to provide information relative to use status at the follow up contact. 5 Not documented or unable to determine (UTD) from follow-up information collected. |
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 | The conditions under which the patient left the facility at the time of discharge. |
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. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_1_IND | DOUBLE | Y | Identifies patients excluded from SUB-1 |
EXCLUDE_2A_IND | DOUBLE | Y | Identifies patients excluded from SUB-2a |
EXCLUDE_2_IND | DOUBLE | Y | Identifies patients excluded from SUB-2 |
EXCLUDE_3A_IND | DOUBLE | Y | Identifies patients excluded from SUB-3a |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from SUB-3 |
EXCLUDE_4_IND | DOUBLE | Y | Identifies patients excluded from SUB-4 |
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. |
FUCONTACTDT_DT_TM | DATETIME | Y | The date/time on which the follow-up contact was mad. |
FUCONTACTDT_TXT | VARCHAR(10) | Y | The date on which the follow-up contact was made with the discharged patient to assess tobacco or substance abuse post discharge |
FUCONTACTDT_UTC_DT_TM | DATETIME | Y | The date/time on which the follow-up contact was mad; normalized to GMT |
FUCONTACT_FLAG | DOUBLE | Y | Identifies the patient has a follow-up contact on alcohol, tobacco, or other drug use status within 30 days post discharge. |
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. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_ABS_SUB_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_SUB_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_1_IND | DOUBLE | Y | Identifies patients that qualify for SUB-1 |
NUMERATOR_2A_IND | DOUBLE | Y | Identifies patients that qualify for SUB-2a |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for SUB-2 |
NUMERATOR_3A_IND | DOUBLE | Y | Identifies patients that qualify for SUB-3a |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients that qualify for SUB-3 |
NUMERATOR_4_IND | DOUBLE | Y | Identifies patients that qualify for SUB-4 |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OTH_DIAGNOSIS_LIST | VARCHAR(500) | Y | A comma separated list of other diagnoses associated with the encounter. |
OTH_PROCEDURE_DATES_LIST | VARCHAR(500) | Y | A comma separated list of dates the other procedures associated with the encounter were performed. |
OTH_PROCEDURE_LIST | VARCHAR(500) | Y | A comma separated list of other procedures associated with the encounter. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PAYMENT_SOURCE_FLAG | DOUBLE | Y | Identifies the source of payment for the encounter |
PHYSICIAN_1_TXT | VARCHAR(50) | Y | First physician identifier. |
PHYSICIAN_2_TXT | VARCHAR(50) | Y | Second physician identifier. |
PRIN_DIAGNOSIS | VARCHAR(10) | Y | Identifies the principle diagnosis associated with the encounter. |
PRIN_PROCEDURE | VARCHAR(10) | Y | Identifies the principle procedure associated with the encounter. |
PRIN_PROCEDURE_DATE_TXT | VARCHAR(10) | Y | The date on which the principle procedure was performed. |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed; normalized to GMT |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
PSYCHSETNG_FLAG | DOUBLE | Y | identifies if there is a response for Psychiatric Care Setting. 0 = NO 1 = YES 999 = MISSING |
REFADDTX_FLAG | DOUBLE | Y | Identifies the patient has a referral for addictions treatment made prior to discharge |
REJECT_1_IND | DOUBLE | Y | Identifies patients reject for SUB-1 |
REJECT_2A_IND | DOUBLE | Y | Indicates the case was rejected for the 2A metric |
REJECT_2_IND | DOUBLE | Y | Identifies patients reject for SUB-2 |
REJECT_3A_IND | DOUBLE | Y | Indicates the case was rejected for the 3A metric |
REJECT_3_IND | DOUBLE | Y | Identifies patients reject for SUB-3 |
REJECT_4_IND | DOUBLE | Y | Identifies patients reject for SUB-4 |
RXALCDRGMED_FLAG | DOUBLE | Y | Identifies the patient has a FDA-approved medications for alcohol or drug disorder prescribed at discharge. |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
SUB_2A_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for SUB2A obtained during the completion of abstraction. |
SUB_2_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for SUB2 obtained during the completion of abstraction. |
SUB_3A_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for SUB3A obtained during the completion of abstraction. |
SUB_3_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for SUB3 obtained during the completion of abstraction. |
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_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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_ABS_SUB_METRICS
Child Column in LH_ABS_SUB_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_ABS_TOB_METRICS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | LH_ABS_TOB_METRICS |
Definition: | This table is used to store TOB metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain. |
Table Type: | ACTIVITY |
Column Detail - LH_ABS_TOB_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. |
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. |
CMO_FLAG | DOUBLE | Y | Identifies if a patient was excluded due to an order for comfort measures. |
COGIMPAIR_FLAG | DOUBLE | Y | Identifies the patient has a documentation on cognitively impaired |
COMM_MRN_TXT | VARCHAR(50) | Y | Identifies the community medical record number of the patient. |
COMPLETED_DT_TM | DATETIME | Y | The Date and Time the abstracted case was completed |
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. |
DISC_DISP_FLAG | DOUBLE | Y | The patient's discharge disposition on the day of discharge. |
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 | The conditions under which the patient left the facility at the time of discharge. |
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. |
ENCNTR_ID | DOUBLE | N | Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table. |
EXCLUDE_1_IND | DOUBLE | Y | Identifies patients excluded from TOB-1 |
EXCLUDE_2A_IND | DOUBLE | Y | Identifies patients excluded from TOB-2a |
EXCLUDE_2_IND | DOUBLE | Y | Identifies patients excluded from TOB-2 |
EXCLUDE_3A_IND | DOUBLE | Y | Identifies patients excluded from TOB-3a |
EXCLUDE_3_IND | DOUBLE | Y | Identifies patients excluded from TOB-3 |
EXCLUDE_4_IND | DOUBLE | Y | Identifies patients excluded from TOB-4 |
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. |
FUCONTACTDT_DT_TM | DATETIME | Y | The date/time on which the follow-up contact was mad. |
FUCONTACTDT_TXT | VARCHAR(10) | Y | The date on which the follow-up contact was made with the discharged patient to assess tobacco or substance abuse post discharge |
FUCONTACTDT_UTC_DT_TM | DATETIME | Y | The date/time on which the follow-up contact was mad; normalized to GMT |
FUCONTACT_FLAG | DOUBLE | Y | Identifies the patient has a follow-up contact on alcohol, tobacco, or other drug use status within 30 days post discharge. |
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. |
LAST_PROCESS_DT_TM | DATETIME | Y | The date/time that the last ETL process started that updated this record. |
LH_ABS_TOB_METRICS_ID | DOUBLE | N | Unique generated number that identifies a single row on the LH_ABS_TOB_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_1_IND | DOUBLE | Y | Identifies patients that qualify for TOB-1 |
NUMERATOR_2A_IND | DOUBLE | Y | Identifies patients that qualify for TOB-2a |
NUMERATOR_2_IND | DOUBLE | Y | Identifies patients that qualify for TOB-2 |
NUMERATOR_3A_IND | DOUBLE | Y | Identifies patients that qualify for TOB-3a |
NUMERATOR_3_IND | DOUBLE | Y | Identifies patients that qualify for TOB-3 |
NUMERATOR_4_IND | DOUBLE | Y | Identifies patients that qualify for TOB-4 |
ORG_MRN_TXT | VARCHAR(50) | Y | Identifies the medical record number of the patient. |
OTH_DIAGNOSIS_LIST | VARCHAR(500) | Y | A comma separated list of other diagnoses associated with the encounter. |
OTH_PROCEDURE_DATES_LIST | VARCHAR(500) | Y | A comma separated list of dates the other procedures associated with the encounter were performed. |
OTH_PROCEDURE_LIST | VARCHAR(500) | Y | A comma separated list of other procedures associated with the encounter. |
PARTITION_DT_TM | DATETIME | Y | The date/time the encounter was discharged from the facility |
PAYMENT_SOURCE_FLAG | DOUBLE | Y | Identifies the source of payment for the encounter |
PHYSICIAN_1_TXT | VARCHAR(50) | Y | First physician identifier. |
PHYSICIAN_2_TXT | VARCHAR(50) | Y | Second physician identifier. |
PRIN_DIAGNOSIS | VARCHAR(10) | Y | Identifies the principle diagnosis associated with the encounter. |
PRIN_PROCEDURE | VARCHAR(10) | Y | Identifies the principle procedure associated with the encounter. |
PRIN_PROCEDURE_DATE_TXT | VARCHAR(10) | Y | The date on which the principle procedure was performed. |
PRIN_PROCEDURE_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed. |
PRIN_PROCEDURE_UTC_DT_TM | DATETIME | Y | The date/time on which the principle procedure was performed; normalized to GMT |
PRS_TXT | VARCHAR(10) | Y | Identifies the Patient Reliability Score (PRS). |
PSYCHSETNG_FLAG | DOUBLE | Y | Identifies if there is a response for Psychiatric Care Setting. 0 - No, 1 - Yes, 999 - Missing. |
REFOPTOBCSNG_FLAG | DOUBLE | Y | Identifies the patient has a referral for Outpatient Tobacco Cessation Counseling. |
REJECT_1_IND | DOUBLE | Y | Identifies patients reject for TOB-1 |
REJECT_2A_IND | DOUBLE | Y | Indicates the case was rejected for the 2A metric |
REJECT_2_IND | DOUBLE | Y | Identifies patients reject for TOB-2 |
REJECT_3A_IND | DOUBLE | Y | Indicates the case was rejected for the 3A metric |
REJECT_3_IND | DOUBLE | Y | Identifies patients reject for TOB-3 |
REJECT_4_IND | DOUBLE | Y | Identifies patients reject for TOB-4 |
RSNNOTOBDC_FLAG | DOUBLE | Y | Identifies the patient has a documented reason for no tobacco cessation medication at discharge. |
RSNNOTOBSTAY_FLAG | DOUBLE | Y | Identifies that the patient receive one of the FDA-approved tobacco cessation medications during the hospital stay. |
RXTOBMED_FLAG | DOUBLE | Y | Identifies the patient has a prescription for an FDA-approved tobacco cessation medication at discharge. |
SAMPLE_IND | DOUBLE | Y | This case represent part of a sample |
TOBSTATUS_FLAG | DOUBLE | Y | Identifies the patient's tobacco use status |
TOBTXCOUNS_FLAG | DOUBLE | Y | Identifies the patient received practical counseling prior to discharge. |
TOBTXMED_FLAG | DOUBLE | Y | Identifies that the patient receive one of the FDA-approved tobacco cessation medications during the hospital stay. |
TOB_2A_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for TOB2A obtained during the completion of abstraction. |
TOB_2_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for TOB2 obtained during the completion of abstraction. |
TOB_3A_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for TOB3A obtained during the completion of abstraction. |
TOB_3_REASON_TXT | VARCHAR(250) | Y | Stores the category reason for TOB3 obtained during the completion of abstraction. |
TOB_USE_STAT_COUN_FLAG | DOUBLE | Y | Holds the Tobacco Use Status Post Discharge - Counseling response information. 1 Attending outpatient tobacco cessation counseling post discharge. 2 Not attending outpatient tobacco cessation counseling post discharge. 3 Refused to provide information relative to post discharge counseling attendance. 4 Not documented or unable to determine from follow-up information. |
TOB_USE_STAT_MED_FLAG | DOUBLE | Y | Holds the Tobacco Use Status Post Discharge - Medication response information. 1 Taking the recommended tobacco cessation medication post discharge. 2 Not taking the recommended tobacco cessation medication post discharge. 3 Refused to provide information relative to medication use post discharge. 4 Not documented or unable to determine from follow-up information. |
TOB_USE_STAT_QUIT_FLAG | DOUBLE | Y | Holds the Tobacco Use Status Post Discharge - Quit Status response information. 1 Has quit using tobacco products post discharge. 2 Has not quit using tobacco products post discharge. 3 Refused to provide information relative to use status at the follow up contact. 4 Not documented or unable to determine from follow-up information. |
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_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. 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_ABS_TOB_METRICS
Child Column in LH_ABS_TOB_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 |