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 |