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