Completed DtExpected Treatment Start DtPatient Assessment ReasonPatient Assessment TypeReferral Received DtSource System
| Business Data Model Data Model |
| Description | A patient evaluation completed by a practitioner which indicates the status of a patient's condition. Assessments are part of a care plan. For example: Pain assessment Neurological assessment Skin assessment |
| Attributes | |
| Completed Dt |
|
| Expected Treatment Start Dt |
|
| Patient Assessment Reason |
|
| Patient Assessment Type |
|
| Referral Received Dt |
|
| Source System |
|
| Relationship | |
 Patient Assessment_Care Plan_FK |
|
| Patient Assessment_Patient Problem_FK |
|
| Patient Assessment_Patient_FK |
|
| Patient Assessment_Practitioner_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Completed Dt
| Description | The date upon which the assessment was completed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Expected Treatment Start Dt
| Description | An date upon which the treatment is expected to start for the patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Patient Assessment Reason
| Description | Indicates the reason for the patient assessment. |
| 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 |
Patient Assessment Type
| Description | Indicates the type of patient assessment. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Referral Received Dt
| Description | The date upon which the referral was received. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Source System
| Description | Indicates the Origin of the data. |
| 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 |
| Relationship Details |
Patient Assessment_Care Plan_FK
| Is Identifying Relationship | true |
| Child Table | Patient Assessment |
| 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 | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Assessment_Patient Problem_FK
| Is Identifying Relationship | true |
| Child Table | Patient Assessment |
| 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 Problem |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Assessment_Patient_FK
| Is Identifying Relationship | true |
| Child Table | Patient Assessment |
| 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 |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Assessment_Practitioner_FK
| Is Identifying Relationship | true |
| Child Table | Patient Assessment |
| 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 | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |