Calendar DkCare Goals Met CntCare Reviews Performed CntCare Team Members Assigned CntCondition DkConsults Performed CntEducation Provided CntEncounter DkOrders Placed CntPatient DkPoint Of Care Location DkPractitioner DkProvider Dk
| Dimensional Warehouse Model Data Model |
| Description | Supports analysis of care plans, pathways, and care teams. Could be used to answer questions such as; By Primary Care Physician, what percentage of care plans have met their goals? By Condition, how often are patient receiving education as part of their care? |
| Primary Key | |
 Clinical Care Variability Analysis PK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
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 |
Care Goals Met Cnt
| Description | Number of Goals met in conjunction with a Care Plan. |
| 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 |
Care Reviews Performed Cnt
| Description | Number of care plan reviews performed. |
| 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 |
Care Team Members Assigned Cnt
| Description | The number of care team members assigned to the plan. This could include practitioners, family members, or legal guardians. |
| 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 |
Condition 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 |
Consults Performed Cnt
| Description | Number of Consults performed in conjunction with a Care Plan. |
| 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 |
Education Provided Cnt
| Description | Count of education materials provided in conjunction with care plan. |
| 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 |
Encounter 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 |
Orders Placed Cnt
| Description | Number of orders placed in conjunctions with a Care Plan. |
| 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 |
Patient 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 |
Point Of Care Location 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 |
Clinical Care Variability Analysis_Condition Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Care Variability 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 | Condition Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Clinical Care Variability Analysis_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Care Variability 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 |
Clinical Care Variability Analysis_Patient Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Care Variability 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 |
Clinical Care Variability Analysis_Encounter Dimension_FK1
| Is Identifying Relationship | false |
| Child Table | Clinical Care Variability Analysis |
| Child Role Name | discharge encounter |
| 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 |
Clinical Care Variability Analysis_Practitioner Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Care Variability 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 |
Clinical Care Variability Analysis_Calendar Dimension_FK1
| Is Identifying Relationship | false |
| Child Table | Clinical Care Variability 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 |
Clinical Care Variability Analysis_Point Of Care Location Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Care Variability 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 | Point Of Care Location 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 |
Clinical Care Variability Analysis PK
| Key Attribute | Provider Dk |
| Key Attribute | Patient Dk |
| Key Attribute | Encounter Dk |
| Key Attribute | Practitioner Dk |
| Key Attribute | Calendar Dk |
| Key Attribute | Condition Dk |
| Key Attribute | Point Of Care Location Dk |
| Dimensional Warehouse Model Data Model |