| Dimensional Warehouse Model Data Model |
Description | An analytical requirement addressing the need for providers to demonstrate that they are using Electronic Health Records (EHRs) in a meaningful way. The Centers for Medicare and Medicaid Services issued a notice of proposed rulemaking that outlines provisions governing the Medicare and Medicaid EHR incentive programs, including a proposed definition for the central concept of "meaningful use" of EHR technology. In order for professionals and hospitals to be eligible to receive payments under the incentive programs, provided through the Recovery Act, they must be able to demonstrate meaningful use of a certified EHR system. These 25 measures comprise the Stage 1 Meaningful Use criteria for eligible providers as defined in the proposed rules for the Medicare and Medicaid Programs; Electronic Health Record Incentive Program. Subsequently Stage 2 measures were published. Having achieved Stage 1 certification, providers should proceed to Stage 2. There is a lot of overlap between stage 1 and stage 2 measures and between the measure sets for eligible professionals and eligible hospitals. This analytical requirement includes the full set of meaningful use measures and indicates which apply to Stage 1/Stage 2 and whether they are core measures or menu measures (optional) for each stage. It also indicates their applicability to Eligible Professionals (EP) and Eligible Hospitals (EH). Note that some of these measures are simply declarations or attestations by the provider that they have the ability to execute a particular function or that they have tested a particular function and cannot be calculated or confirmed based on a database. |
Relationship | |
![]() |
|
![]() |
|
![]() |
|
![]() |
|
![]() |
Primary Key | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | Maintain active medication list. Formula: (Count(Current Medication List Logged)/Count(Patient Visits))*100 Stage 1 EH & EP Core Target: At least 80 percent of all unique patients seen by the EP have at least one entry (or an indication of "none" if the patient is not currently prescribed any medication) recorded as structured data. Stage 2 Target: n/a |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Record advance directives for patient 65 years old or older. Stage 1 & Stage 2 EH Menu Target: More than 50 percent of all unique patients 65 years old or older admitted to the eligible hospital's or CAH's inpatient department (POS 21) during the EHR reporting period have an indication of an advance directive status recorded as structured data. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Use clinical decision support to improve performance on high-priority health conditions. Stage 1 EH & EP Core Target: Implement five clinical decision support rule Stage 2 EH & EP Core Target: Implement five clinical decision support rules relevant to 4 quality measures (or high priority health conditions if less than 4 measures). Plus, show functionality for Drug/Allergy interaction checks. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Incorporate clinical lab-test results into EHR as structured data. Formula: (Count(Orders Having Test Results Logged)/Count(Eligible Lab Tests Performed))*100 Stage 1 EH & EP Menu Target: At least 40 percent of all clinical lab tests results ordered by the EP or by an authorized provider of the eligible hospital during the EHR reporting period whose results are in either in a positive/negative or numerical format are incorporated in certified EHR technology as structured data. Stage 2 EH & EP Core Target: At least 55 percent of all clinical lab tests results ordered by the EP or by an authorized provider of the eligible hospital during the EHR reporting period whose results are in either in a positive/negative or numerical format are incorporated in certified EHR technology as structured data. |
Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Report clinical quality measures to CMS. (1) Calculate. Electronically calculate all of the clinical quality measures specified by CMS for eligible hospitals and critical access hospitals. (2) Submission. Enable a user to electronically submit calculated clinical quality measures in accordance with the standard and implementation specifications specified in §170.205(f). Standards Criteria Quality reporting §170.205(f) - CMS PQRI 2009 Registry XML Specification. Implementation specification: PQRI Measure Specifications Manual for Claims and Registry. Stage 1 EH & EP Core Target: Attest ability Stage 2 Target: n/a |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Provide clinical summaries to patients for each office visit. Stage 1 EP Core Target: Clinical summaries provided to patients for at least 50 percent of all office visits within 3 days. Stage 2 EP Core Target: Clinical summaries provided to patients for at least 50 percent of all office visits within 1 business day. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Use computerized provider order entry (CPOE) for medication, laboratory, and radiology orders directly entered by any licensed healthcare professional who can enter orders into the medical record per state, local, and professional guidelines. Formula: (Count(CPOE Orders)/Count(Orders Entered))*100 Stage 1 EH & EP Core Target: More than 30 percent of medication orders created by authorized providers of the eligible hospital's or CAH's inpatient or emergency department (POS 21 or 23) during the EHR reporting period are recorded using CPOE. Stage 2 EH & EP Core Target: More than 60 percent of medication, 30 percent of laboratory, and 30 percent of radiology orders created by authorized providers of the eligible hospital's or CAH's inpatient or emergency department (POS 21 or 23) during the EHR reporting period are recorded using CPOE. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Implement drug formulary checks. Stage 1 EH & EP Menu Target: The EP has or EH/CAH enabled this functionality and has access to at least one internal or external formulary for the entire EHR reporting period. Stage 2 : n/a (incorporated into the Prescribing measure in stage 2) |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Implement drug-drug, drug-allergy, drug- formulary checks. Stage 1 EH & EP Core Target: The EH or EP has enabled this functionality. Stage 2 Target: n/a (incorporated into Clinical Decision Support measure) |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Provide patients with an electronic copy of their discharge instructions at time of discharge, upon request. Stage 1 EH Core Target: More than 50 percent of all patients who are discharged from an eligible hospital or CAH’s inpatient or emergency department and who request an electronic copy of their discharge instructions are provided it. Stage 2 Target: n/a |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Provide patients with an electronic copy of their health information (including diagnostic test results, problem list, medication lists, medication allergies, discharge summary, procedures) upon request. Stage 1 EH & EP Core Target: More than 50 percent of all patients who request an electronic copy of their health information are provided it within 3 business days. Stage 2 Target: n/a |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Automatically track medications from order to administration using assistive technologies in conjunction with an electronic medication administration record (eMAR). Stage 2 EH Core Target: More than 10 percent of medication orders created by authorized providers of the eligible hospital's or CAH's inpatient or emergency department (POS 21 or 23) during the EHR reporting period for which all doses are tracked using eMAR. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Record electronic notes in patient records. Stage 1: n/a Stage 2 EH Menu Target: Enter at least one electronic progress note created, edited and signed by an authorized provider of the eligible hospital's or CAH's inpatient or emergency department (POS 21 or 23) for more than 30 percent of unique patients admitted to the eligible hospital or CAH's inpatient or emergency department during the EHR reporting period. The text of the electronic note must be text searchable and may contain drawings and other content. Stage 2 EP Menu Target: Enter at least one electronic progress note created, edited and signed by an EP for more than 30 percent of unique patients with at least one office visit during the EHR Measure reporting period. The text of the electronic note must be text searchable and may contain drawings and other content. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Electronic Reportable Laboratory Results (previously "Reportable Lab Results to Public Health Agencies" in Stage 1) Capability to submit electronic data on reportable (as required by State or local law) lab results to public health agencies and actual submission according to applicable law and practice. Stage 1 EH Menu Target: Performed at least one test of certified EHR technology’s capacity to provide electronic submission of reportable lab results to public health agencies and follow-up submission if the test is successful (unless none of the public health agencies to which an eligible hospital or CAH submits such information has the capacity to receive the information electronically), except where prohibited. Stage 2 EH Core Target: Successful ongoing submission of electronic reportable laboratory results from Certified EHR Technology to a public health agency for the entire EHR reporting period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Generate and transmit permissible prescriptions electronically (eRx). Formula: (Count(Electronically Transmitted Prescriptions)/Count(Permissible Prescriptions))*100 Stage 1 EP Core Target: At least 40 percent of all permissible prescriptions written by the EP are transmitted electronically using certified EHR technology. Stage 2 EH Menu Target: At least 10 percent of all permissible prescriptions written by an eligible hospital or CAH are transmitted electronically using certified EHR technology. Stage 2 EP Core Target: At least 50 percent of all permissible prescriptions written by the EP are transmitted electronically using certified EHR technology. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Record patient family health history as structured data. Stage 1: n/a Stage 2 EH Menu Target: More than 20 percent of all unique patients admitted to the eligible hospital or CAH's inpatient or emergency department (POS 21 or 23) during the EHR reporting period have a structured data entry for one or more first-degree relatives. Stage 2 EP Menu Target: More than 20 percent of all unique patients seen by the EP during the EHR reporting period have a structured data entry for one or more first-degree relatives. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Imaging results consisting of the image itself and any explanation or other accompanying information are accessible through Certified EHR Technology. Stage 1: n/a Stage 2 EH Menu Target: More than 10 percent of all tests whose result is one or more images ordered by an authorized provider of the eligible hospital or CAH for patients admitted to its inpatient or emergency department (POS 21 or 23) during the EHR reporting period are accessible through Certified EHR Technology . Stage 2 EP Menu Target: More than 10 percent of all tests whose result is one or more images ordered by the EP during the EHR reporting period are accessible through CEHRT. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Capability to submit electronic data to immunization registries or immunization information systems and actual submission according to applicable law and practice. Stage 1 EH & EP Menu Target: Performed at least one test of certified EHR technology's capacity to submit electronic data to immunization registries. Stage 2 EH & EP Core Target: Successful ongoing submission of electronic immunization data to an immunization registry or immunization information system. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Provide structured electronic lab results to ambulatory providers. Stage 1: n/a Stage 2 EH Menu Target: Hospital labs send structured electronic clinical lab results to the ordering provider for more than 20 percent of electronic lab orders received. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Maintain an up-to-date problem list of current and active diagnoses based on ICD-9-CM or SNOMED CT® Formula: (Count(Patient Diagnosis Logged)/Count(Patient Visits))*100 Stage 1 EH & EP Core Target: At least 80 percent of all unique patients seen by the EP have at least one entry or an indication of none recorded as structured data. Stage 2 Target: n/a |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Maintain active medication allergy list. Formula: (Count(Current Medication Allergy List Logged)/Count(Patient Visits))*100 Stage 1 EH & EP Core Target: At least 80 percent of all unique patients seen by the EP have at least one entry (or an indication of "none" if the patient has no medication allergies) recorded as structured data. Stage 2 Target: n/a |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Perform medication reconciliation at relevant encounters and each transition of care. Stage 1 EH & EP Menu Target: Perform medication reconciliation for at least 50 percent of relevant encounters and transitions of care. Stage 2 EH & EP Core Target: Perform medication reconciliation for at least 50 percent of relevant encounters and transitions of care. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Provide patients with timely electronic access to their health information (including lab results, problem list, medication lists, and allergies) within 4 business days of the information being available to the EP. Stage 1 EH Target: n/a Stage 1 EP Menu Target: At least 10 percent of all unique patients seen by the EP are provided timely (available to the patient within four business days of being updated in the certified EHR technology) electronic access to their health information subject to the EP’s discretion to withhold certain information. Stage 2 EH Core Target: More than 50 percent of all unique patients discharged from the inpatient or emergency departments of the eligible hospital or CAH (POS 21 or 23) during the EHR reporting period have their information available online within 36 hours of discharge. More than 5 percent of all unique patients (or their authorized representatives) who are discharged from the inpatient or emergency department (POS 21 or 23) of an eligible hospital or CAH view, download or transmit to a third party their information during the EHR reporting period. Stage 2 EP Core Target: More than 50 percent of all unique patients seen by the EP during the EHR reporting period are provided timely (available to the patient within 4 business days after the information is available to the EP) online access to their health information. More than 5 percent of all unique patients seen by the EP during the EHR reporting period (or their authorized representatives) view, download, or transmit to a third party their health information. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Generate lists of patients by specific conditions to use for quality improvement, reduction of disparities, research, or outreach. Formula: Count (Patient Having Specific Condition Generated) Stage 1 EH & EP Menu Target: Generate at least one report listing patients with a specific condition. Stage 2 EH & EP Core Target: Generate at least one report listing patients with a specific condition. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Send reminders to patients per patient preference for preventive/ follow-up care Stage 1 EP Menu Target: More than 20 percent of all patients 65 years or older or 5 years old or younger were sent an appropriate reminder during the EHR reporting period. Stage 2 Target: n/a (Replaced by "Preventive Care") |
Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Use certified EHR technology to identify patient-specific education resources and provide those resources to the patient if appropriate. Stage 1 EH Menu Target: More than 10 percent of all unique patients admitted to the eligible hospital’s or CAH’s inpatient or emergency department (POS 21 or 23) are provided patient specific education resources. Stage 1 EP Menu Target: More than 10 percent of all unique patients seen by the EP are provided patient-specific education resources. Stage 2 EH Core Target: More than 10 percent of all unique patients admitted to the eligible hospital's or CAH's inpatient or emergency departments (POS 21 or 23) are provided patient-specific education resources identified by Certified EHR Technology. Stage 2 EP Core Target: Patient-specific education resources identified by Certified EHR Technology are provided to patients for more than 10 percent of all unique patients with office visits seen by the EP during the EHR reporting period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Use clinically relevant information to identify patients who should receive reminders for preventive/follow-up care and send these patients the reminders, per patient preference. Stage 1 Target: n/a Stage 2 EP Core Target: More than 10 percent of all unique patients who have had 2 or more office visits with the EP within the 24 months before the beginning of the EHR reporting period were sent a reminder, per patient preference when available. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Protect electronic health information created or maintained by the certified EHR technology through the implementation of appropriate technical capabilities. Stage 1 EH & EP Core Target: Conduct or review a security risk analysis in accordance with the requirements under 45 CFR 164.308 (a)(1) and implement security updates as necessary. Stage 2 EH & EP Core Target: Conduct or review a security risk analysis in accordance with the requirements under 45 CFR 164.308(a) (1), including addressing the encryption/security of data stored in CEHRT in accordance with requirements under 45 CFR 164.312 (a)(2)(iv) and 45 CFR 164.306(d)(3). |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
Is Part Of PrimaryKey | true |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Description | Record demographics. Formula: (Count(Patient Demographics Logged)/Count(Patient Visits))*100 Stage 1 EH & EP Core Target: At least 50 percent of all unique patients seen by the EP or admitted to the eligible hospital have demographics recorded as structured data Stage 2 EH & EP Core Target: At least 80 percent of all unique patients seen by the EP or admitted to the eligible hospital have demographics recorded as structured data |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Record smoking status for patients 13 years old or older Formula: (Count(Patient Smoking Status Logged)/Count(Patient Visits where Patient Age = 13))*100 Stage 1 EH & EP Core Target: At least 50 percent of all unique patients age 13 and over seen by the EP have "smoking status" recorded Stage 2 EH & EP Core Target: At least 80 percent of all unique patients age 13 and over seen by the EP have "smoking status" recorded |
Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Record and chart changes in the following vital signs: (A) Height (B) Weight (C) Blood pressure (D) Calculate and display body mass index (BMI) (E) Plot and display growth charts for children 2-20 years, including BMI Stage 1 Formula: If Patient Age between 2 and 20, then (Count(Patient Vital Signs Taken and Growth Charted)/Count(Patient Visits where Patient Age = 2))*100, else (Count(Patient Vital Signs Taken)/Count(Patient Visits where Patient Age = 2))*100 Stage 1 EH & EP Core Target: For at least 50 percent of all unique patients age 2 and over seen by the EP, record blood pressure and BMI; additionally, plot growth chart for children ages 2-20. Stage 2 EH & EP Core Target: For at least 80 percent of all unique patients age 2 and over seen by the EP, record blood pressure and BMI; additionally, plot growth chart for children ages 0-20. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Capability to identify and report cancer cases to a public health central cancer registry, except where prohibited, and in accordance with applicable law and practice. Stage 1: n/a Stage 2 EP Menu Target: Successful ongoing submission of cancer case information from CEHRT to a public health central cancer registry for the entire EHR reporting period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Capability to identify and report specific cases to a specialized registry (other than a cancer registry), except where prohibited, and in accordance with applicable law and practice. Stage 1: n/a Stage 2 EP Menu Target: Successful ongoing submission of specific case information from CEHRT to a specialized registry for the entire EHR reporting period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Provide summary care record for each transition of care and referral. Stage 1 EH & EP Menu Target: Provide summary of care record for at least 50 percent of transitions of care and referrals. Stage 2 EH & EP Core Target 1: Provide summary of care record for at least 50 percent of transitions of care and referrals. Target 2: Provide summary of care record for at least 10 percent of transitions of care and referrals electronically. Target 3: 1 transmit to provider with different EHR technology Target 4: 1 transmit to CMS |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Capability to provide electronic syndromic surveillance data to public health agencies and actual transmission according to applicable law and practice. Stage 1 EH & EP Menu Target: Performed at least one test of certified EHR technology's capacity to provide electronic syndromic surveillance data to public health agencies (unless none of the public health agencies to which an EP or eligible hospital submits such information have the capacity to receive the information electronically). Stage 2 EH Core & EP Menu Target: Successful ongoing submission of electronic syndromic surveillance data from Certified EHR Technology to a public health agency for the entire EHR reporting period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | true |
Is Surrogate Key | false |
Description | Use secure electronic messaging to communicate with patients on relevant health information. Stage 2 EP Core Target: A secure message was sent using the electronic messaging function of CEHRT by more than 5 percent of unique patients (or their authorized representatives) seen by the EP during the EHR reporting period. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Is Identifying Relationship | true |
Child Table | Meaningful Use Analysis |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Patient Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Meaningful Use Analysis |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Calendar Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Meaningful Use Analysis |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Encounter Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Meaningful Use Analysis |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Practitioner Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Meaningful Use Analysis |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Provider Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Primary Key Details |
Key Attribute | Provider Dk |
Key Attribute | Patient Dk |
Key Attribute | Practitioner Dk |
Key Attribute | Encounter Dk |
Key Attribute | Calendar Dk |
| Dimensional Warehouse Model Data Model |