Table Detail Report

LH_ABS_TR_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_TR_METRICS
Definition: Contains information for the Transition Record IPFQR condition
Table Type: ACTIVITY





Column Detail - LH_ABS_TR_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.
ADVANCE_FLAG DOUBLE Y Identifies if the transition record included advance directives. 0 - No, 1 - Yes, 999 - Missing.
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
CONTACT_24_7_FLAG DOUBLE Y Identifies if the transition record included 24-hour/7-day contact information. 0 - No, 1 - Yes, 999 - Missing.
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.
DISCHDX_FLAG DOUBLE Y Identifies if the transition record include the principal diagnosis at discharge. 0 - No, 1 - Yes, 999 - Missing.
DISC_DISP_FLAG DOUBLE Y The discharge disposition on the day of discharge. 1 - Home, 2 - Hospice - Home, 3 - Hospice - Health Care Facility, 4 - Acute Care Facility, 5 - Other Health Care Facility, 6 - Expired, 7 - Left Against Medical Advice/AMA, 8 - Not Documented or UTD, 999 - Missing.
DISC_PROV_FLAG DOUBLE Y Indicates if transition record was discussed with patient/care giver or if its unable to determine. 1 - Yes, 2 - No, 3 - Unable to determine, 999 - Missing.
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 the LH_D_BR_CCN
D_BR_HCO_ID DOUBLE N Healthcare organization Number. Foreign key to the 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_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_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON
ELMTS_DISC_FLAG DOUBLE Y Indicates if 4 key elements of transition record was discussed with receiving facility or if its blank. 1 - Yes, 2 - No, 999 - Missing.
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 if this case meets the criteria to be 'excluded' for the Transition Record Received metric.
EXCLUDE_2_IND DOUBLE Y Identifies if this case meets the criteria to be 'excluded' for the Timely Transition metric.
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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_TR_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_TR_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.
MEDLIST_FLAG DOUBLE Y Identifies if the transition record included a current medication list. 0 - No, 1 - Yes, 999 - Missing.
NUMERATOR_1_IND DOUBLE Y Identifies if this case meets the criteria to be 'met' or 'not met' for the Transition Record Received metric.
NUMERATOR_2_IND DOUBLE Y Identifies if this case meets the criteria to be 'met' or 'not met' for the Timely Transition metric.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
OTH_DIAGNOSIS_LIST VARCHAR(250) Y A comma separated list of other diagnoses associated with the encounter.
OTH_PROCEDURE_DATES_LIST VARCHAR(400) Y A comma separated list of dates the other procedures associated with the encounter were performed.
OTH_PROCEDURE_LIST VARCHAR(400) 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. 1 - Medicare, 2 - Non-Medicare, 999 - Missing.
PENDSTUDIES_FLAG DOUBLE Y Identifies if the transition record included studies pending at discharge. 0 - No, 1 - Yes, 999 - Missing.
PHYSICIAN_1_TXT VARCHAR(50) Y First physician identifier
PHYSICIAN_2_TXT VARCHAR(50) Y Second physician identifier
PLAN_FLAG DOUBLE Y Identifies if the transition record included a plan for follow-up care. 0 - No, 1 - Yes, 999 - Missing.
PRIMPHY_FLAG DOUBLE Y Identifies if the transition record included a health care professional or site designated for follow-up care. 0 - No, 1 - Yes, 999 - Missing.
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
PROC_TESTS_FLAG DOUBLE Y Identifies if the transition record included major procedures and tests performed. 0 - No, 1 - Yes, 999 - Missing.
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.
PTINSTRCTNS_FLAG DOUBLE Y Identifies if the transition record include patient instructions. 0 - No, 1 - Yes, 999 - Missing.
REASON_FLAG DOUBLE Y Identifies if the patient's transition record included the reason for inpatient admission. 0 - No, 1 - Yes, 999 - Missing.
RECORD_FLAG DOUBLE Y Identifies if the patient received a transition record at the time of discharge. 0 - No, 1 - Yes, 999 - Missing.
REJECT_1_IND DOUBLE Y Identifies if this case meets the criteria to be 'rejected' for the Transition Record Received metric.
REJECT_2_IND DOUBLE Y Identifies if this case meets the criteria to be 'rejected' for the Timely Transition metric.
RESULTSCONT_FLAG DOUBLE Y Identifies if the transition record included contact information for obtaining results of studies. 0 - No, 1 - Yes, 999 - Missing.
SAMPLE_IND DOUBLE Y Indicates if the case was sampled
TR1_REASON_TXT VARCHAR(250) Y Stores the category reason obtained during the completion of abstraction.
TRANSMIT_DT_TM DATETIME Y The date/time transition record was transmitted.
TRANSMIT_DT_TXT VARCHAR(10) Y The date response when transition record was transmitted stored in a character format.
TRANSMIT_FLAG DOUBLE Y Identifies if the transition record with all 11 elements was transmitted to the facility or person designated for follow-up care within 24 hours of discharge. 0 - No, 1 - Yes, 999 - Missing.
TRANSMIT_TM_TXT VARCHAR(10) Y The time response when transition record was transmitted stored in a character format.
TRANSMIT_UTC_DT_TM DATETIME Y The date/time transition record was transmitted; normalized to GMT.
TRANS_METHOD_FLAG DOUBLE Y Identifies method of transmission. 1 - Mail, 2 - Fax, 3 - Secure E-Mail, 4 - Hard Copy Provided to Transport Personnel, 5 - Electronic Health Record (EHR), 6 - Other, 999 - Missing.
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 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_TR_METRICS


Child Column in LH_ABS_TR_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_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_VTE_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_ABS_VTE_METRICS
Definition: This table is used to store VTE metrics from the Lighthouse Abstractor (eQuality Check). This table is at the encounter grain.
Table Type: ACTIVITY





Column Detail - LH_ABS_VTE_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.
ANES_START_DATE_TXT VARCHAR(10) Y Date the anesthesia for the procedure started.User Entered (MM-DD-YYYY) Includes dashes
ANES_START_DT_TM DATETIME Y Date the anesthesia for the procedure started.
ANES_START_UTC_DT_TM DATETIME Y Date the anesthesia for the procedure started normalized to GMT.
ANES_TYPE_FLAG DOUBLE Y Documentation that the procedure was performed using general or neuraxial anesthesia
ANTICOAG_ADMIN_IND DOUBLE Y A parenteral anticoagulant medication was administered
ANTICOAG_DISC_IND DOUBLE Y Parenteral anticoagulant medication was prescribed at discharge
ANTICOAG_END_DATE_TXT VARCHAR(10) Y The last date that a parenteral anticoagulant medication was administered.User Entered (MM-DD-YYYY) Includes dashes
ANTICOAG_END_DT_TM DATETIME Y The last date that a parenteral anticoagulant medication was administered.
ANTICOAG_END_UTC_DT_TM DATETIME Y The last date that a parenteral anticoagulant medication was administered normalized to GMT.
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
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.
DISCH_INSTR_ADVERSE_REACT_IND DOUBLE Y Written discharge instructions or other documentation of educational material given to the patient/caregiver address potential for adverse drug reactions and interactions related to warfarin therapy prescribed after discharge
DISCH_INSTR_COMPLIANCE_IND DOUBLE Y Written discharge instructions or other documentation of educational material given to the patient/caregiver address compliance issues related to warfarin therapy prescribed after discharge
DISCH_INSTR_DIETARY_IND DOUBLE Y Written discharge instructions or other documentation of educational material given to the patient/caregiver address dietary advice related to warfarin therapy prescribed after discharge
DISCH_INSTR_FOLLOWUP_IND DOUBLE Y Written discharge instructions or other documentation of educational material given to the patient/caregiver address follow-up monitoring related to warfarin therapy prescribed after discharge
DISC_DISP_FLAG DOUBLE Y The patient's discharge disposition on the day of discharge.
DISC_OVERLAP_REASON_IND DOUBLE Y Reason documented by a physician/APN/PA or pharmacist for discontinuation of the overlap therapy
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 Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_11_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_12_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_13_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_14_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_15_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_16_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_17_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_18_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_19_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_1_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_20_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_2_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_3_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_4_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_5_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_6_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_7_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_8_ID DOUBLE Y Identifies the metric identifier for the Lighthouse metric.
D_METRIC_9_ID DOUBLE Y 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.
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 VTE-1
EXCLUDE_1_MU_IND DOUBLE Y Identifies if a patient was excluded from the meaningful use measure.
EXCLUDE_2_IND DOUBLE Y Identifies patients excluded from VTE-2
EXCLUDE_2_MU_IND DOUBLE Y Identifies if a patient was excluded from the meaningful use measure.
EXCLUDE_3_IND DOUBLE Y Identifies patients excluded from VTE-3
EXCLUDE_3_MU_IND DOUBLE Y Identifies if a patient was excluded from the meaningful use measure.
EXCLUDE_4_IND DOUBLE Y Identifies patients excluded from VTE-4
EXCLUDE_4_MU_IND DOUBLE Y Identifies if a patient was excluded from the meaningful use measure.
EXCLUDE_5_IND DOUBLE Y Identifies patients excluded from VTE-5
EXCLUDE_5_MU_IND DOUBLE Y Identifies if a patient was excluded from the meaningful use measure.
EXCLUDE_6_IND DOUBLE Y Identifies patients excluded from VTE-6
EXCLUDE_6_MU_IND DOUBLE Y Identifies if a patient was excluded from the meaningful use measure.
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.
ICU_PATIENT_IND DOUBLE Y The patient admitted or transferred to the intensive care unit (ICU) during the hospitalization
ICU_REASON_ORAL_FACTOR_IND DOUBLE Y Holds the reason for icu oral factor xa response information.
ICU_SURGICAL_IND DOUBLE Y A surgical procedure was performed using general or neuraxial anesthesia the day of or the day after ICU Admission or Transfer
ICU_SURG_END_DATE_TXT VARCHAR(10) Y Date the surgical procedure ended after ICU admission or transfer.User Entered (MM-DD-YYYY) Includes dashes
ICU_SURG_END_DT_TM DATETIME Y Date the surgical procedure ended after ICU admission or transfer.
ICU_SURG_END_UTC_DT_TM DATETIME Y Date the surgical procedure ended after ICU admission or transfer normalized to GMT.
ICU_VTE_PROPHYLAXIS_DATE_TXT VARCHAR(10) Y Date the initial VTE prophylaxis administered in the ICU.User Entered (MM-DD-YYYY) Includes dashes
ICU_VTE_PROPHYLAXIS_DT_TM DATETIME Y Date the initial VTE prophylaxis administered in the ICU.
ICU_VTE_PROPHYLAXIS_MASK DOUBLE Y Type(s) of VTE prophylaxis documented in the ICU
ICU_VTE_PROPHYLAXIS_UTC_DT_TM DATETIME Y Date the initial VTE prophylaxis administered in the ICU normalized to GMT.
INIT_ICU_ADMIT_DATE_TXT VARCHAR(10) Y Date of the ICU admission or transfer.User Entered (MM-DD-YYYY) Includes dashes
INIT_ICU_ADMIT_DT_TM DATETIME Y Date of the ICU admission or transfer.
INIT_ICU_ADMIT_UTC_DT_TM DATETIME Y Date of the ICU admission or transfer normalized to GMT.
INIT_ICU_DISC_DATE_TXT VARCHAR(10) Y Date was the patient physically discharged from the ICU, left AMA or expired.User Entered (MM-DD-YYYY) Includes dashes
INIT_ICU_DISC_DT_TM DATETIME Y Date was the patient physically discharged from the ICU, left AMA or expired.
INIT_ICU_DISC_UTC_DT_TM DATETIME Y Date was the patient physically discharged from the ICU, left AMA or expired normalized to GMT.
INR_RESULT_IND DOUBLE Y Documentation of an INR value >= 2 prior to discontinuation of the parenteral anticoagulation
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_ABS_VTE_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_VTE_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE Y The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
NO_ICU_VTE_PROPH_REASON_IND DOUBLE Y Documentation why prophylaxis was not administered in the ICU.
NO_VTE_PROPH_REASON_IND DOUBLE Y Documentation why prophylaxis was not administered at hospital admission.
NUMERATOR_1_IND DOUBLE Y Identifies patients that qualify for VTE-1
NUMERATOR_1_MU_IND DOUBLE Y Identifies if a patient met the meaningful use measure.
NUMERATOR_2_IND DOUBLE Y Identifies patients that qualify for VTE-2
NUMERATOR_2_MU_IND DOUBLE Y Identifies if a patient met the meaningful use measure.
NUMERATOR_3_IND DOUBLE Y Identifies patients that qualify for VTE-3
NUMERATOR_3_MU_IND DOUBLE Y Identifies if a patient met the meaningful use measure.
NUMERATOR_4_IND DOUBLE Y Identifies patients that qualify for VTE-4
NUMERATOR_4_MU_IND DOUBLE Y Identifies if a patient met the meaningful use measure.
NUMERATOR_5_IND DOUBLE Y Identifies patients that qualify for VTE-5
NUMERATOR_5_MU_IND DOUBLE Y Identifies if a patient met the meaningful use measure.
NUMERATOR_6_IND DOUBLE Y Identifies patients that qualify for VTE-6
NUMERATOR_6_MU_IND DOUBLE Y Identifies if a patient met the meaningful use measure.
ORG_MRN_TXT VARCHAR(50) Y Identifies the medical record number of the patient.
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.
OVERLAP_START_DATE_TXT VARCHAR(10) Y The first date that parenteral anticoagulation therapy AND warfarin were both administered.User Entered (MM-DD-YYYY) Includes dashes
OVERLAP_START_DT_TM DATETIME Y The first date that parenteral anticoagulation therapy AND warfarin were both administered.
OVERLAP_START_UTC_DT_TM DATETIME Y The first date that parenteral anticoagulation therapy AND warfarin were both administered normalized to GMT.
OVERLAY_THERAPY2_FLAG DOUBLE Y Overlap Therapy Question Flag
OVERLAY_THERAPY_FLAG DOUBLE Y 1 - There is documentation that parenteral anticoagulation therapy and warfarin were both administered on the same day. 2 - There is documentation of a reason why parenteral anticoagulation therapy and warfarin were not administered on the same day. 3 -Parenteral anticoagulation therapy and warfarin were not administered on the same day and there is no documentation of a reason for no overlap therapy or unable to determine from medical record. 999 - Missing.
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).
REASN_OVERLAY_THERAPY_FLAG DOUBLE Y Reason for No Overlap Therapy Question Flag
REASON_ORAL_FACTOR_IND DOUBLE Y Holds the reason for oral factor xa response information.
REJECT_1_IND DOUBLE Y Identifies patients reject for VTE-1
REJECT_2_IND DOUBLE Y Identifies patients reject for VTE-2
REJECT_3_IND DOUBLE Y Identifies patients reject for VTE-3
REJECT_4_IND DOUBLE Y Identifies patients reject for VTE-4
REJECT_5_IND DOUBLE Y Identifies patients reject for VTE-5
REJECT_6_IND DOUBLE Y Identifies patients reject for VTE-6
RSNNOADMVTEPRPH_FLAG DOUBLE Y Reason for not administrating VTE Prophylaxis
SAMPLE_IND DOUBLE Y This case represent part of a sample
STRATUM_TITLE VARCHAR(50) Y The stratum title of the condition.
SURGICAL_IND DOUBLE Y Surgical procedure performed using general or neuraxial anesthesia the day of or the day after hospital admission
SURG_END_DATE_TXT VARCHAR(10) Y Date the surgical procedure ended.User Entered (MM-DD-YYYY) Includes dashes
SURG_END_DT_TM DATETIME Y Date the surgical procedure ended.
SURG_END_UTC_DT_TM DATETIME Y Date the surgical procedure ended normalized to GMT.
UFH_ADMIN_IND DOUBLE Y IV UFH was administered
UFH_PLATELET_MONITOR_IND DOUBLE Y Documentation that the IV UFH AND platelet counts were managed by defined parameters using a nomogram or protocol
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_6_REASON_TXT VARCHAR(250) Y Stores the category reason obtained during the completion of abstraction.
VTE_CONFIRMED_IND DOUBLE Y Documentation that the patient had a diagnosis of VTE confirmed in one of the defined locations
VTE_DIAGNOSTIC_IND DOUBLE Y Documentation that a diagnostic test for VTE was performed.
VTE_POA_IND DOUBLE Y Documentation by the physician/APN/PA that VTE was diagnosed or suspected on admission
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.
VTE_PROPH_STATUS_FLAG DOUBLE Y VTE prophylaxis administered between the admission day and the day before the VTE diagnostic test order date
WARFARIN_ADMIN_IND DOUBLE Y Warfarin was administered during hospitalization
WARFARIN_DISC_IND DOUBLE Y Warfarin was prescribed at discharge



Relationship Detail - LH_ABS_VTE_METRICS


Child Column in LH_ABS_VTE_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_WORK_QUEUE



Column Section Top of Page


Table-level Detail

Description: LH_ABS_WORK_QUEUE
Definition: Records appearing in the Work Queue of the Lighthouse Abstractor (eQuality Check)
Table Type: ACTIVITY





Column Detail - LH_ABS_WORK_QUEUE


Column Name Type Null? Definition
ABSTRACTION_STATUS_FLAG DOUBLE Y Indicates that completion status of the abstraction for the encounter.1 = Not Started2 = Partial3 = Complete
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.
BR_DATAMART_CATEGORY_ID DOUBLE N Identifies the Category (i.e. Stroke, VTE, or ED Throughput). Foreign Key to BR_DATAMART_CATEGORY
CONCURRENT_IND DOUBLE Y Indicates whether the case is added through concurrent tab
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
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 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.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LAST_UPDT_PRSNL_ID DOUBLE N The person from the personnel (PRSNL) table that caused the last insert or update of the row in the table.
LH_ABS_WORK_QUEUE_ID DOUBLE N Unique generated number that identifies a single row on the LH_ABS_WORK_QUEUE table.
PERSON_ID DOUBLE N Identifies the person that will be abstracted. Foreign key to the PERSON table.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) Y The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


LH_D_MEASURE_REASON



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_D_MEASURE_REASON
Definition: Hold possible metric outcome reasons for measures within eQualityCheck
Table Type: REFERENCE





Column Detail - LH_D_MEASURE_REASON


Column Name Type Null? Definition
D_MEASURE_REASON_ID DOUBLE N Unique generated number that identifies a single row on the LH_D_MEASURE_REASON table.
EXTRACT_DT_TM DATETIME Y Contains the last date the record was extracted. If the record has been extracted more than once, contains the latest date.
FIRST_PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
HEALTH_SYSTEM_ID DOUBLE N Identifies the delivery network responsible for supplying the data.
HEALTH_SYSTEM_SOURCE_ID DOUBLE N Identifies the unique source within the delivery network responsible for supplying the data.
LAST_PROCESS_DT_TM DATETIME Y The date/time the record was last loaded into the table.
PROCESS_DT_TM DATETIME Y The date/time the record was first loaded into the table.
REASON_KEY VARCHAR(50) Y Unique key for the exclusion reason.
REASON_TXT VARCHAR(200) Y Text describing the reason for exclusion
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.



Relationship Detail - LH_D_MEASURE_REASON




Parent Column in LH_D_MEASURE_REASON (PK) Child Table Name Child Column Name
Children: D_MEASURE_REASON_ID LH_ABS_PC_MOTHER_METRICS D_REASON_1_ID
HEALTH_SYSTEM_SOURCE_ID LH_ABS_PC_MOTHER_METRICS HEALTH_SYSTEM_SOURCE_ID