| Name | R_Valid_BA_Association |
|---|---|
| Entity Type | Table |
| Description | This entity records combinations of business associate types that are valid to appear in business associations. The association role describes how the primary business associate relates to the secondary business associate. For example, a corporation can be the General Partner to a partnership entity, or a corporation can be the Employer of an individual (but not vice versa). |
| Submodel | Business_Associate |
| Entity Scope | Reference |
| Primary Key | Primary_BA_Type , Secondary_BA_Type , BA_Association_Role_Code |
| Natural Key | Primary_BA_Type , Secondary_BA_Type , BA_Association_Role_Code |
| Generalizations | Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Active_Flag | boolean | NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| BA_Association_Role_Code | R_BA_Association_Role |
|
A mnemonic code or abbreviation that uniquely identifies the association role type between the primary and secondary business associates in a relationship. For example, it is valid for an "Individual" to be the secondary business associate with "Corporation" type as the primary where the association role is "Employer". | Yes |
VARCHAR2(64) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Primary_BA_Type | R_Business_Associate |
|
A mnemonic code or abbreviation that uniquely identifies the business associate type for the primary business associate in a relationship. For example, it is valid for an "Individual" to be the secondary business associate with "Corporation" type as the primary where the association role is "Employer". | Yes |
VARCHAR2(64) |
| Secondary_BA_Type | R_Business_Associate |
|
A mnemonic code or abbreviation that uniquely identifies the type for the secondary business associate in a relationship. For example, it is valid for an "Individual" to be the secondary business associate with "Corporation" type as the primary where the association role is "Employer". | Yes |
VARCHAR2(64) |
| Source | CODE | NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Secondary_BA_Type | R_Business_Associate | A mnemonic code or abbreviation that uniquely identifies the type for the secondary business associate in a relationship. For example, it is valid for an "Individual" to be the secondary business associate with "Corporation" type as the primary where the association role is "Employer". | Restrict | Yes |
| BA_Association_Role_Code | R_BA_Association_Role | A mnemonic code or abbreviation that uniquely identifies the association role type between the primary and secondary business associates in a relationship. For example, it is valid for an "Individual" to be the secondary business associate with "Corporation" type as the primary where the association role is "Employer". | Restrict | Yes |
| Primary_BA_Type | R_Business_Associate | A mnemonic code or abbreviation that uniquely identifies the business associate type for the primary business associate in a relationship. For example, it is valid for an "Individual" to be the secondary business associate with "Corporation" type as the primary where the association role is "Employer". | Restrict | Yes |