Table Detail Report

LH_MU_FX_3_POP_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_3_POP_METRICS
Definition: This table will have all the persons based and encounter based measures population
Table Type: ACTIVITY





Column Detail - LH_MU_FX_3_POP_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 Registration date and time for the encounter
ADMIT_LOC_DT_TM DATETIME Y The local version of the ADMIT_DT_TM column.
APPT_TYPE_CD DOUBLE N Scheduling appointment type for encounter
APPT_TYPE_TEXT VARCHAR(50) Y The display for the appt_type_cd coming from code value table
BIRTH_DT_TM DATETIME Y Birth date and time for the person
BIRTH_LOC_DT_TM DATETIME Y The local version of the BIRTH_DT_TM column
CCN_IND DOUBLE Y will signify an inpatient encounter or an observation encounter
DIRECT_EMAIL VARCHAR(100) Y Displays Direct provider email address.
DISCH_DISPOSITION_CD DOUBLE Y The conditions under which the patient left the facility at the time of discharge. From the Encounter table.
DISCH_DISPOSITION_TEXT VARCHAR(50) Y Display of Discharge Disposition code.
DISCH_DT_TM DATETIME Y Discharge date and time for the encounter
DISCH_LOC_DT_TM DATETIME Y The local version of the DISCH_DT_TM column.
D_DISCHARGE_BUILDING_ID DOUBLE N Value comes from lh_d_building
D_DISCHARGE_FACILITY_ID DOUBLE N Value comes from lh_d_facility
D_DISCHARGE_NURSE_UNIT_ID DOUBLE N Value comes from lh_d_nurse_unit
D_ENCNTR_TYPE_ID DOUBLE N Value comes from lh_d_encntr_type
D_MED_SERVICE_ID DOUBLE N Value comes from lh_d_med_service
D_PERSON_ID DOUBLE N Contains d_person_id for each person coming form lh_d_person table
EC_IND DOUBLE N Indicator used to show that an inpatient qualified for an EC.
ENCNTR_ID DOUBLE N Encntr_id of the person
EP_IND DOUBLE Y Will signify an outpatient encounter or an observation encounter
EXTRACT_DT_TM DATETIME Y Date and time the row was extracted into the table
FINANCIAL_NBR_TXT VARCHAR(200) Y Fin number for 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_MU_FX_3_POP_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_3_POP_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.
METRIC_TYPE VARCHAR(50) Y The measure mean for which the row qualified
ORG_MRN_TXT VARCHAR(200) Y MRN for the person
PARENT_ENTITY_ID DOUBLE N This column signifies unique value for which the row qualifies. Values will be either of one clinical_event_id/encntr_id/appt_id/ etc
PARENT_ENTITY_NAME VARCHAR(30) Y Will contain name of the table for which the row qualifies
PERSON_ID DOUBLE N Person id for the person
POP_DESCRIPTION VARCHAR(100) Y Detailed description for the qualification of the row
POP_QUAL_DT_TM DATETIME Y will hold admit_dt_tm/order_action_dt_tm/clinical_event_dt_tm/appointment_dt_tm depending on which query the row qualifies for. The value should be in accordance with the parent_entity_name and parent_entity_id columns.
POP_QUAL_LOC_DT_TM DATETIME Y The local version of the POP_QUAL_DT_TM column.
QUALIFY_CCD DOUBLE Y QUALIFY_CCD column will store the latest CCD Document Number.
QUAL_SOURCE VARCHAR(50) Y Displays why the patient is included in the denominator (referral source code, appointment, referred, clinical event code, etc.).
QUAL_VALUE DOUBLE Y Displays the value number of the qualifying source.
QUERY_MEAN VARCHAR(50) Y The name of the query for which the row qualified
REF_ORDER_ID DOUBLE N Will contain referral order id and will be used for TOC measure
SUB_METRIC_TYPE VARCHAR(50) Y More detailed information for which the row qualified
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 source which update/inserted the row
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_MU_FX_3_POP_METRICS


Child Column in LH_MU_FX_3_POP_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_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_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_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_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_PERSON_ID LH_D_PERSON D_PERSON_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSON HEALTH_SYSTEM_SOURCE_ID




Parent Column in LH_MU_FX_3_POP_METRICS (PK) Child Table Name Child Column Name
Children: HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_DETAILS HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_3_POP_METRICS_ID LH_MU_FX_3_DETAILS LH_MU_FX_3_POP_METRICS_ID
HEALTH_SYSTEM_SOURCE_ID LH_MU_FX_3_EP_CCN_RELTN HEALTH_SYSTEM_SOURCE_ID
LH_MU_FX_3_POP_METRICS_ID LH_MU_FX_3_EP_CCN_RELTN LH_MU_FX_3_POP_METRICS_ID


LH_MU_FX_METRICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_METRICS
Definition: Contains data used to calculate the Meaningful Use Clinical Function metrics.
Table Type: ACTIVITY





Column Detail - LH_MU_FX_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_TO_CCN_DT_TM DATETIME Y The date/time on which the patient was admitted to the CCN. This may be different than the encounter's admit_dt_tm if the patient was transferred to the CCN after admission.
ADMIT_TO_CCN_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted to the CCN. This may be different than the encounter's admit_dt_tm if the patient was transferred to the CCN after admission; normalized to GMT.
ADMIT_UTC_DT_TM DATETIME Y The date/time on which the patient was admitted, normalized to GMT.
ADVANCE_DIRECTIVES_DOC_IND DOUBLE Y Indicates that there was an entry or an indication of an advanced directive entered using structured data. This is the Numerator for the Advance Directives Report.
ADVANCE_DIRECTIVES_DT_TM DATETIME Y Stores the date/time of an entry or an indication of an advanced directive entered using structured data.This is used for the Numerator for the Advance Directives Report.
ADVANCE_DIRECTIVES_UTC_DT_TM DATETIME Y Stores the date/time of an entry or an indication of an advanced directive entered using structured data. This is used for the Numerator for the Advance Directives Report; normalized to GMT.
ALLERGY_DOC_ALT_IND DOUBLE Y Indicates that a least one entry or an indication of no allergies are known for the patient, recorded as structured data. This is the Numerator for the Allergy Report 2014 report
ALLERGY_DOC_IND DOUBLE Y Indicates that a least one entry or an indication of no allergies are known for the patient, recorded as structured data. This is the Numerator for the Allergy Report.
ALLERGY_DT_TM DATETIME Y Stores the date/time of the earliest allergy entry or an indication of no allergies for the patient, recorded as structured data. This is used for the Numerator for the Allergy Report.
ALLERGY_UTC_DT_TM DATETIME Y Stores the date/time of the earliest allergy entry or an indication of no allergies for the patient, recorded as structured data; normalized to GMT. This is used for the Numerator for the Allergy Report.
APPOINTMENT_DT_TM DATETIME Y Identifies when an appointment occurred for a patient.
APPOINTMENT_UTC_DT_TM DATETIME Y Identifies when an appointment occurred for a patient. Normalized to GMT.
APPT_TYPE_CD DOUBLE Y CODE SET:14230 The identifier for an appointment type. An example would be 'cardiac cath', 'echo stress', etc.
BR_CCN_ID DOUBLE N CMS Certification Number. Foreign key to BR_CCN.
BR_ELIGIBLE_PROVIDER_ID DOUBLE N Eligible Provider. Foreign key to BR_ELIGIBLE_PROVIDER.
CLIN_SUMMARY_IND DOUBLE Y Indicates a Clinical Summary was given within 3 business days or was held for reason.
CLIN_SUMM_DT_TM DATETIME Y The date /time of Clinical Summary provided
CLIN_SUMM_FORMAT VARCHAR(100) Y The format of Clinical Summary
CLIN_SUMM_IND DOUBLE Y Indicates a Clinical Summary was given within 1 business days or was held for reason
CLIN_SUMM_PORTAL_IND DOUBLE Y Indicates using patient portal to provide clinical summary to patient.
CLIN_SUMM_UTC_DT_TM DATETIME Y The date /time of Clinical Summary provided; normalized to GMT
CPOE_CNT DOUBLE Y The count of the number Pharmacy orders that were placed by a certified Physician. This is the Numerator for the CPOE Report.
CPOE_DENOM_CNT DOUBLE Y The count of the number Pharmacy orders that were placed. This is the Denominator for the CPOE Report.
CPOE_DT_TM DATETIME Y The date/time of the first Pharmacy orders placed by a certified Physician.
CPOE_MED_LIST_IND DOUBLE Y Determines whether or not the patient has a med on his med list for the purposes of the CPOE measure.
CPOE_UTC_DT_TM DATETIME Y The date/time of the first Pharmacy orders placed by a certified Physician; normalized to GMT.
DEMOGRAPHICS_DOC_IND DOUBLE Y Indicates all the relevant demographics elements were documented. This is the Numerator for the Demographics Report.
DEMOG_CAUSE_DEATH VARCHAR(100) Y Patient's cause of death
DEMOG_COD_DOC_IND DOUBLE Y Identifies whether or not patient cause of death was documented.
DEMOG_DEATH_DT_TM DATETIME Y The date /time of patient death
DEMOG_DEATH_UTC_DT_TM DATETIME Y The date /time of patient death; normalized to GMT.
DEMOG_ETHNICITY VARCHAR(100) Y Patient's Ethnicity
DEMOG_ETHN_DOC_IND DOUBLE Y Identifies whether or not patient ethnicity was documented.
DEMOG_LANGUAGE VARCHAR(100) Y Patient's prefer Language
DEMOG_LANG_DOC_IND DOUBLE Y Identifies whether or not patient language was documented.
DEMOG_RACE VARCHAR(100) Y Patient's race
DEMOG_RACE_DOC_IND DOUBLE Y Identifies whether or not patient race was documented.
DEMOG_SEX VARCHAR(100) Y Patient's sex
DIAG_DOC_ALT_IND DOUBLE Y Indicates that a least one entry or an indication of no problems are known for the patient, recorded as structured data in their problem list. (from the Diagnosis table) This is used for the Numerator for the Problem 2014 Report.
DIAG_DOC_IND DOUBLE Y Indicates that a least one entry or an indication of no problems are known for the patient, recorded as structured data in their problem list (from the Diagnosis table). This is used for the Numerator for the Problem Report.
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_DENOM_IND DOUBLE Y Indicates the patient requested an electronic copy of their discharge instructions. This is the Denominator for the Discharge Instructions Report.
DISCH_INSTR_IND DOUBLE Y Indicates the patient received an electronic copy of their discharge instructions. This is the Numerator for the Discharge Instructions Report.
DISC_DISP_EXP_IND DOUBLE Y Identifies whether or not the patient expired.
D_ATTEND_PRSNL_ID DOUBLE N Identifies the final attending physician associated to the encounter during the visit.
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_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
ED_RPT_METHOD_FLG DOUBLE Y Identifies which ED definition the records falls in and how it should be processed when the Report is ran.0 - N/A1 - All ED Visits2 - Observation Services
ENCNTR_EXCL_IND DOUBLE N THIS INDICATOR IS TO ENSURE THAT THE ENCOUNTER DOES NOT QUALIFY IN ENCONTER BASED REPORTS
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ERX_CNT DOUBLE Y The count of the number of non-narcotic drug prescriptions that were e-prescribed. This is the Numerator for the E-Prescribe Report.
ERX_DENOM_CNT DOUBLE Y The count of the number of non-narcotic drug prescriptions that were prescribed. This is the Denominator for the E-Prescribe Report.
ERX_ONLY_IND DOUBLE N Determines whether or not the encounter only applies to the eRx measure.
EXTRACT_DT_TM DATETIME Y The date/time that the record was extracted from the source system.
FIRST_MED_DT_TM DATETIME Y The first medication order date and time for the encounter.
FIRST_MED_UTC_DT_TM DATETIME Y The first medication order date and time for the encounter. Normalized to GMT.
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.
LAB_CNT DOUBLE Y Count of the number of structured Lab Results documented. This is the Numerator for the Lab Results Report.
LAB_DENOM_CNT DOUBLE Y Count of the number of Lab Results documented. This is the Denominator for the Lab Results Report.
LAB_ONLY_IND DOUBLE N Determines whether or not the encounter only applies to the Lab measure.
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_MU_FX_METRICS_ID DOUBLE N Unique identifier for the Meaningful Use Functional metrics.
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.
MEDICATION_DOC_IND DOUBLE Y Indicates that a least one entry or an indication that the patient is not currently prescribed medication, recorded as structured data. This is the Numerator for the Medication List Report.
MEDS_RECON_DENOM_CCN_IND DOUBLE Y Indicates that medication reconciliation needed to be done for CCN Patients This is the Denominator for the CCN Medication Reconciliation Report 2014
MEDS_RECON_DENOM_EP_IND DOUBLE Y Indicates that medication reconciliation needed to be done for EP Patients. This is the Denominator for the EP Medication Reconciliation Report.
MEDS_RECON_DENOM_IND DOUBLE Y Indicates that medication reconciliation needed to be done. This is the Denominator for the Medication Reconciliation Report.
MEDS_RECON_IND DOUBLE Y Indicates that medication reconciliation was done. This is the Numerator for the Medication Reconciliation Report.
PARENT_ENTITY_ID DOUBLE N The unique ID of the table that the row on this table is a child of
PARENT_ENTITY_NAME VARCHAR(50) N The name of the table that the row on this table is a child of
PARTITION_DT_TM DATETIME Y The date/time the encounter was discharged from the facility.
PAT_EDU_ALT_IND DOUBLE Y Indicates that the patient received proper education for alternate report
PAT_EDU_DT_TM DATETIME Y The date when the patient education material was given to the patient.
PAT_EDU_MATERIAL VARCHAR(1000) Y The education material which patient received.
PAT_ED_DENOM_IND DOUBLE Y Indicates that the patient was not discharged dead. This is the Denominator for the Patient Education Report.
PAT_ED_IND DOUBLE Y Indicates that the patient received proper education upon discharge. This is the Numerator for the Patient Education Report.
PROBLEM_DOC_ALT_IND DOUBLE Y Indicates that a least one entry or an indication of no problems are known for the patient, recorded as structured data in their problem list. (from the Problem table) This is used for the Numerator for the Problem 2014 Report.
PROBLEM_DOC_IND DOUBLE Y Indicates that a least one entry or an indication of no problems are known for the patient, recorded as structured data in their problem list. This is the Numerator for the Problem Report.
ROI_REQUEST_DT_TM DATETIME Y The date/time a Release of information request was documented.
ROI_REQUEST_IND DOUBLE Y Indicates a Release of Information request was completed. This will be the Numerator for the Electronic Copy of Record Report.
ROI_REQUEST_UTC_DT_TM DATETIME Y The UTC date/time a Release of Information request was documented.
SMOKING_DOC_IND DOUBLE Y Indicates all the smoking status was documented. This is the Numerator for the Smoking Status Report.
SMOKING_STATUS_DT_TM DATETIME Y Identifies when smoking status was first documented for the patient.
SMOKING_STATUS_UTC_DT_TM DATETIME Y Identifies when smoking status was first documented for the patient, normalized to GMT.
SUMMARY_TRAN_DENOM_IND DOUBLE Y Indicates a Transfer order was created and a Summary of Care needed to be done. This is the Denominator for the Summary of Care at Transition Report.
SUMMARY_TRAN_IND DOUBLE Y Indicates a Summary of Care happened at transfer. This is the Numerator for the Summary of Care at Transition Report.
SUMM_TRAN_DENOM_CCN_IND DOUBLE Y Indicates a Transfer order was created and a Summary of Care needed to be done for CCN Patients. This is the Denominator for the CCN Medication Reconciliation Report 2014
SUMM_TRAN_DENOM_EP_IND DOUBLE Y Indicates a Transfer order was created and a Summary of Care needed to be done for EP Patients.
SUMM_TRAN_DT_TM DATETIME Y The date /time of Transition Care or Referral.
SUMM_TRAN_INVALID_MASK DOUBLE N Indicates the patient does not have problem list, allergy list or medication list populated in summary of care transition. This is the Numerator for the Summary of Care at Transition Report.
SUMM_TRAN_M1_IND DOUBLE Y Indicates a Summary of Care happened at transfer.
SUMM_TRAN_M2_IND DOUBLE Y Indicates a Summary of Care happened at transfer by electronically transmitted.
SUMM_TRAN_REV_PRSNL VARCHAR(100) Y Indicates receiving provider (of the patient) of summary of care transition.;This is the Numerator for the Summary of Care at Transition Report.
SUMM_TRAN_TOC_TYPE VARCHAR(50) Y Indicates the type of Transition Summary of Care. Such as print, email, fax¿
SUMM_TRAN_UTC_DT_TM DATETIME Y The date /time of Transition Care or Referral.normalized to GMT.
TIMELY_ACCESS_IND DOUBLE Y Indicates Timely Access (within 4 days) of clinical data was provided.
UNIQUE_EXCL_IND DOUBLE N THIS INDICATOR IS TO ENSURE THAT THE ENCOUNTER DOES NOT QUALIFY IN UNIQUE PATIENT MEASURE REPORTS
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_SOURCE VARCHAR(50) N The script name responsible for updating the record.
UPDT_TASK VARCHAR(50) N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VDT_ACCESS_CCN_IND DOUBLE Y Indicates CCN patient clinical data accessed was provided timely.;This will be the Numerator for the VDT Timely Access Report
VDT_ACCESS_DT_TM DATETIME Y the date/time of accessing clinical data.
VDT_ACCESS_EP_IND DOUBLE Y Indicates EP patient clinical data accessed was provided timely for vdt patients.
VDT_ACCESS_UTC_DT_TM DATETIME Y The date/time of accessing clinical data.; normalized to GMT.
VITALS_DIASTOLIC_DT_TM DATETIME Y Stores the date/time the diastolic blood pressure was documented. This is used for the Numerator for the Vitals Report.
VITALS_DIASTOLIC_UTC_DT_TM DATETIME Y Stores the date/time the diastolic blood pressure was documented. This is used for the Numerator for the Vitals Report; normalized to GMT.
VITALS_DOC_IND DOUBLE Y Indicates all the vitals were documented. This is the Numerator for the Vitals Report.
VITALS_HEIGHT_DT_TM DATETIME Y Stores the date/time the height was documented. This is used for the Numerator for the Vitals Report.
VITALS_HEIGHT_UTC_DT_TM DATETIME Y Stores the date/time the height was documented. This is used for the Numerator for the Vitals Report; normalized to GMT.
VITALS_SYSTOLIC_DT_TM DATETIME Y Stores the date/time the systolic blood pressure was documented. This is used for the Numerator for the Vitals Report.
VITALS_SYSTOLIC_UTC_DT_TM DATETIME Y Stores the date/time the systolic blood pressure was documented. This is used for the Numerator for the Vitals Report; normalized to GMT.
VITALS_WEIGHT_DT_TM DATETIME Y Stores the date/time the weight was documented. This is used for the Numerator for the Vitals Report.
VITALS_WEIGHT_UTC_DT_TM DATETIME Y Stores the date/time the weight was documented. This is used for the Numerator for the Vitals Report; normalized to GMT.



Relationship Detail - LH_MU_FX_METRICS


Child Column in LH_MU_FX_METRICS(FK) Parent Table Name Parent Column Name
Parents: D_DISCHARGE_BUILDING_ID LH_D_BUILDING D_BUILDING_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_DISCHARGE_FACILITY_ID LH_D_FACILITY D_FACILITY_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_FACILITY HEALTH_SYSTEM_SOURCE_ID
D_DISCHARGE_NURSE_UNIT_ID LH_D_NURSE_UNIT D_NURSE_UNIT_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_NURSE_UNIT HEALTH_SYSTEM_SOURCE_ID
D_ATTEND_PRSNL_ID LH_D_PERSONNEL D_PRSNL_ID
HEALTH_SYSTEM_SOURCE_ID LH_D_PERSONNEL HEALTH_SYSTEM_SOURCE_ID


LH_MU_FX_OPS_PARAM



Column Section Relationship Section Top of Page


Table-level Detail

Description: LH_MU_FX_OPS_PARAM
Definition: This table contains Meaningful Use functional reports that should be ran in background
Table Type: REFERENCE





Column Detail - LH_MU_FX_OPS_PARAM


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.
AMB_LAB_DENOM VARCHAR(20) N Ambulatory Laboratory Denominator Method: 0 = Electronic; 1 = Electronic and Manual
BR_CCN_ID DOUBLE N List of CCN br_ccn_ids
BR_ELIGIBLE_PROVIDER_ID DOUBLE N List of EP's br_eligible_provider_ids
BR_GPRO_ID DOUBLE N Indicates the TIN(s) selected to run through the background report.
ED_METHOD VARCHAR(20) N 1 = All ED Visits; 0 = Overservation Services
GROUPING_OPTION VARCHAR(20) N 1 = Group by CCN/EP; 2 = Group by measure
LH_MU_FX_OPS_PARAM_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_OPS_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.
ORGANIZATION_ID DOUBLE N List of Organization_ID, for which the MU Report would be executed
OUTPUT_DEVICE VARCHAR(200) Y File to output report
REPORTING_END_DT_TM DATETIME N This column stores the Reporting Period End Date & Time
REPORTING_START_DT_TM DATETIME N This column stores the Reporting Period Start Date & Time
REPORT_LIST VARCHAR(2000) Y List of measures to report
REPORT_OPTION VARCHAR(20) N Report printing type
REPORT_TYPE VARCHAR(20) N Report by: 1 = CCN; 0 = EP
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_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_MU_FX_OPS_PARAM


Child Column in LH_MU_FX_OPS_PARAM(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


LH_MU_FX_STATUS



Column Section Top of Page


Table-level Detail

Description: LH_MU_FX_STATUS
Definition: Display Meaningful Use compliance status for a given person and encounter
Table Type: ACTIVITY





Column Detail - LH_MU_FX_STATUS


Column Name Type Null? Definition
CLIN_REC_S3_IND DOUBLE Y The indicator shows if the MU Stage 3 Clinical Reconcilation is met or not
CLIN_SUMM_IND DOUBLE Y Whether or not Clinical Summaries was met for this encounter.
ENCNTR_ID DOUBLE N Foreign key from the ENCOUNTER table
EXTRACT_DT_TM DATETIME Y The date and time when the row was extracted
FAM_HIST_IND DOUBLE Y Whether or not Family History was met for this 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.
INC_DATA_S3_IND DOUBLE Y The indicator shows if the MU Stage 3 Incorporate Data is met or not
LAST_PROCESS_DT_TM DATETIME Y The date/time that the last ETL process started that updated this record.
LH_MU_FX_STATUS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_STATUS 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.
MED_ALL_IND DOUBLE Y Whether or not the Medication Allergies measure was met for this encounter.
MED_LIST_IND DOUBLE Y Whether or not Medication List was met for this encounter.
MED_REC_IND DOUBLE Y Whether or not Medication Reconciliation was met for this encounter.
MU_STAGE_FLAG DOUBLE Y What Meaningful Use stage this row corresponds to.1 - This row represents Meaningful Use Stage 12 - This row represents Meaningful Use Stage 2
PAT_ACC_S3_IND DOUBLE Y The indicator shows if the MU Stage 3 Patient Access is met or not
PAT_DEMO_IND DOUBLE Y Whether or not Patient Demographics was met for this encounter.
PAT_ED_IND DOUBLE Y Whether or not Patient Education was met for this encounter.
PAT_ED_S3_IND DOUBLE Y The indicator shows if the MU Stage 3 Patient Education is met or not
PERSON_ID DOUBLE N Foreign key from the PERSON table
PGHI_S3_IND DOUBLE Y The indicatior shows if the MU Stage 3 Patient generated health Info measure is met or not
POSITION_CD DOUBLE N The position is used to determine the applications and tasks the personnel is authorized to use.
PROB_LIST_IND DOUBLE Y Whether or not Problem List was met for this encounter.
PROG_NOTE_IND DOUBLE Y Whether or not Progress Note was met for this encounter.
PROVIDER_ID DOUBLE N Foreign key on PERSON_ID from the PRSNL table
SEC_MSG_S3_IND DOUBLE Y The indicator shows if the MU Stage 3 Secure Messaging is met or not
SMOKING_IND DOUBLE Y Whether or not Smoking Status was met for this encounter.
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.
VITAL_SIGNS_IND DOUBLE Y Whether or not Vital Signs was met for this encounter.


LH_MU_FX_VISIT_METRICS



Column Section Top of Page


Table-level Detail

Description: LH_MU_FX_VISIT_METRICS
Definition: Fact table for Meaningful Use Functional Reporting
Table Type: ACTIVITY





Column Detail - LH_MU_FX_VISIT_METRICS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y Identifies whether the encounter record is active.
ALLERGY_DOC_IND DOUBLE Y Indicates that a least one entry or an indication of no allergies are known for the patient, recorded as structured data.This is the Numerator for the Allergy Report.
CLIN_SUMMARY_IND DOUBLE Y Indicates a Clinical Summary was given within 3 business days or was held for reason
CPOE_DENOM_IND DOUBLE Y Indicates that the patient qualifies for the CPOE denominator.
CPOE_NUM_IND DOUBLE Y Indicates that the patient qualifies for the CPOE numerator.
DEMOGRAPHICS_DOC_IND DOUBLE Y Indicates that the patient has a sex and DOB documented.This is used for the Numerator for the Demographics Report.
DEMOG_ETHN_DOC_IND DOUBLE Y Indicates that the patient has an ethnicity documented.This is used for the Numerator for the Demographics Report.
DEMOG_LANG_DOC_IND DOUBLE Y Indicates that the patient has a language documented.This is used for the Numerator for the Demographics Report.
DEMOG_RACE_DOC_IND DOUBLE Y Indicates that the patient has a race documented.This is used for the Numerator for the Demographics Report.
DIAG_DOC_IND DOUBLE Y Indicates that a least one entry or an indication of no problems are known for the patient, recorded as structured data in their diagnosis list.(from the Diagnosis table)This is used for the Numerator for the Problem Report.
D_PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the LH_D_PERSON table.
ENCNTR_ID DOUBLE N Identifies the encounter against which the quality measure is associated. Foreign key to the ENCOUNTER table.
ERX_ONLY_IND DOUBLE Y Indicates that a visit qualifies for only the eRx measure
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 record was inserted 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 last date/time that the record was updated on the table.
LH_MU_FX_VISIT_METRICS_ID DOUBLE N Unique generated number that identifies a single row on the LH_MU_FX_VISIT_METRICS table.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for the logical domain. This identifier allows the data to be grouped by logical domain.
MEDICATION_DOC_IND DOUBLE Y Indicates that a least one entry or an indication that the patient is not currently prescribed medication, recorded as structured data .This is the Numerator for the Medication List Report.
MEDS_RECON_DENOM_IND DOUBLE Y Indicates that medication reconciliation needed to be done.This is the Denominator for the Medication Reconciliation Report
MEDS_RECON_IND DOUBLE Y Indicates that medication reconciliation was done.This is the Numerator for the Medication Reconciliation Report
PARENT_ENTITY_ID DOUBLE N The unique ID of the table that the row on this table is a child of
PARENT_ENTITY_NAME VARCHAR(50) Y The name of the table that the row on this table is a child of
PAT_ED_DENOM_IND DOUBLE Y This is the Denominator for the Patient Education Report
PAT_ED_IND DOUBLE Y Indicates that the patient received proper education upon discharge.This is the Numerator for the Patient Education Report
PERSON_ID DOUBLE N Identifies the person associated with the quality measure. Foreign key to the PERSON table.
PROBLEM_DOC_IND DOUBLE Y Indicates that a least one entry or an indication of no problems are known for the patient, recorded as structured data in their problem list.(from the Problem table)This is used for the Numerator for the Problem Report.
SMOKING_STATUS_IND DOUBLE Y Indicates that smoking status was documented.
SUMMARY_TRAN_DENOM_IND DOUBLE Y Indicates a Transfer order was created and a Summary of Care needed to be done.This is the Denominator for the Summary of Care at Transition Report.
SUMMARY_TRAN_IND DOUBLE Y Indicates a Summary of Care happened at transfer.This is the Numerator for the Summary of Care at Transition Report.
TIMELY_ACCESS_IND DOUBLE Y Indicates Timely Access (within 4 days) of clinical data was provided.This will be the Numerator for the Timely Access Report
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update.
UPDT_DT_TM DATETIME Y The date/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 application responsible for updating the record.
VISIT_DT_TM DATETIME Y The date and time of the patient's visit.
VISIT_UTC_DT_TM DATETIME Y The date and time of the patient's visit converted to UTC.
VITALS_DIASTOLIC_IND DOUBLE Y Indicates that diastolic was documented.
VITALS_HEIGHT_IND DOUBLE Y Indicates that height was documented.
VITALS_SYSTOLIC_IND DOUBLE Y Indicates that systolic was documented.
VITALS_WEIGHT_IND DOUBLE Y Indicates that weight was documented.