| Dimensional Warehouse Model Data Model |
| Description | CMS has finalized the use the Clinician and Group Consumer Assessment of Health Care Providers and Systems (CG CAHPS) to assess patient and caregiver experience of care. CMS plans to use the adult 12 month base survey and certain of the supplemental modules for the adult survey. |
| Primary Key | |
 ACO - Patient/Caregiver Experience PK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
ACO 1 Getting Timely Care, Appointments, and Information
| Description | ACO 1 (NQF #0005): Getting Timely Care, Appointments, and 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 |
ACO 2 How Well Your Doctors Communicate
| Description | ACO 2 (NQF #0005): How Well Your Doctors Communicate. |
| 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 |
ACO 3 Patient Rating of Doctor
| Description | ACO 3 (NQF #0005): Patient Rating of Doctor. |
| 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 |
ACO 4 Access to Specialist
| Description | ACO 4 (NQF #0005): Access to Specialist. |
| 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 |
ACO 5 Health Promotion and Education
| Description | ACO 5 (NQF #0005): Health Promotion and Education. |
| 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 |
ACO 6 Shared Decision Making
| Description | ACO 6 (NQF #0005): Shared Decision Making. |
| 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 |
ACO 7 Health Status/Functional Status
| Description | ACO 7 (NQF #0006): Health Status/Functional Status. |
| 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 |
Calendar Dk
| 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 |
Geographic Area Dk
| 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 |
Practitioner Dk
| 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 |
Provider Dk
| 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 |
| Relationship Details |
ACO - Patient/Caregiver Experience_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | ACO - Patient/Caregiver Experience |
| 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 |
ACO - Patient/Caregiver Experience_Geographic Area Dimension_FK
| Is Identifying Relationship | true |
| Child Table | ACO - Patient/Caregiver Experience |
| 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 | Geographic Area Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
ACO - Patient/Caregiver Experience_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | ACO - Patient/Caregiver Experience |
| 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 |
ACO - Patient/Caregiver Experience_Practitioner Dimension_FK
| Is Identifying Relationship | true |
| Child Table | ACO - Patient/Caregiver Experience |
| 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 |
| Primary Key Details |
ACO - Patient/Caregiver Experience PK
| Key Attribute | Calendar Dk |
| Key Attribute | Geographic Area Dk |
| Key Attribute | Provider Dk |
| Key Attribute | Practitioner Dk |
| Dimensional Warehouse Model Data Model |