| Business Data Model Data Model |
| Description | An association between a practitioner and a care plan that can indicate the practitioner's functional involvement with the care plan activity. For example: Case Manager Evaluator Transcriber Nurse Care Practitioner Midwife Physician Assistant |
| Attributes | |
Care Plan Role |
|
Duration Qty |
|
Duration Unit Of Measure |
|
End Ts |
|
Staff Type |
|
Start Ts |
|
| Relationship | |
Care Plan Role_Practitioner_FK |
|
Care Plan Role_Care Plan_FK |
|
Care Plan Role_Care Team Member_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Care Plan Role
| Description | Indicates the functional involvement with the care plan activity. For example: Case Manager Evaluator Transcriber Nurse Care Practitioner Midwife Physician Assistant |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Duration Qty
| Description | Indicates the qualitative length of time for a role. For example: Until the next assessment Four days, Until discharge |
| Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Duration Unit Of Measure
| Description | Indicates the unit of measure in which the duration is expressed. For example: Hours Days Months |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
End Ts
| Description | The date and time upon which the role ended. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Staff Type
| Description | The type of staff performing a role. For example: Physician Nurse Therapist |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Start Ts
| Description | The date and time upon which the role commenced. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Care Plan Role_Practitioner_FK
| Is Identifying Relationship | false |
| Child Table | Care Plan Role |
| 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 |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Care Plan Role_Care Plan_FK
| Is Identifying Relationship | false |
| Child Table | Care Plan Role |
| 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 | Care Plan |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Care Plan Role_Care Team Member_FK
| Is Identifying Relationship | false |
| Child Table | Care Plan Role |
| 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 | Care Team Member |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |