Support DescrSupport StatusSupport Type
| Business Data Model Data Model |
| Description | An individual or organization that provides or may in certain circumstances provide assistance to a person should it be required. Such support may include, transportation, daily living assistance, advice, power of attorney or advocacy. |
| Attributes | |
| Support Descr |
|
| Support Status |
|
| Support Type |
|
| Relationship | |
 Personal Support_Party_FK |
|
| Personal Support_Person_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Support Descr
| Description | Describes in detail the nature of and extent of any support available to a patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Support Status
| Description | Indicates the current status of a patient support arrangement. For example: Active Pending Suspended Terminated |
| 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 |
Support Type
| Description | Indicates the type of support given to or available to a patient according to its nature. |
| 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 |
Personal Support_Party_FK
| Is Identifying Relationship | false |
| Child Table | Personal Support |
| Child Role Name | is provided by |
| 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 | Party |
| Parent Role Name | provides |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Personal Support_Person_FK
| Is Identifying Relationship | false |
| Child Table | Personal Support |
| Child Role Name | received by |
| 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 | Person |
| Parent Role Name | receives |
| 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 |