| Business Data Model Data Model |
| Description | An agreement (usually contractual) that describes which organizations or levels of an organization have access to a tenant's data. It is a generic term that refers to any of the following: - Multi-Entity Agreement (MEA) - Business Associate Agreement (BAA) - Data Sharing Agreement (DSA) |
| Attributes | |
Agreement Location Name |
|
Agreement Num |
|
Agreement Record Name |
|
Comment Txt |
|
Data Agreement End Date |
|
Data Agreement Start Date |
|
Data Sharing Agreement Type |
|
Phi Data Ind |
|
| Relationship | |
Data Sharing Agreement_Tenant_FK1 |
|
Data Sharing Agreement_Tenant_FK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Agreement Location Name
| Description | Location of Multi-Entity Agreement (MEA). This can be a network location link or text like contract server. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Location Name [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Agreement Num
| Description | Uniquely identifies the agreement. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Agreement Record Name
| Description | Multi-Entity Agreement (MEA) Record Name (entity code + hospital or health system name +"MEA"). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Comment Txt
| Description | Comments or Notes recorded for Data Sharing Agreement. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Data Agreement End Date
| Description | The date upon which the agreement between parties expires and the tenant's data can no longer be accessed. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Data Agreement Start Date
| Description | The date upon which the agreement between parties commences and the tenant's data can be accessed. |
| 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 |
Data Sharing Agreement Type
| Description | Indicates an Agreement Type. For example: MEA BAA |
| 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 |
Phi Data Ind
| Description | Indicates whether or not the Application is marked as PHI. PHI applications need PHI agreements for data sharing. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Data Sharing Agreement_Tenant_FK1
| Is Identifying Relationship | true |
| Child Table | Data Sharing Agreement |
| Child Role Name | shared with |
| 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 | Tenant |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Data Sharing Agreement_Tenant_FK
| Is Identifying Relationship | true |
| Child Table | Data Sharing Agreement |
| Child Role Name | shared 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 | Tenant |
| 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 |