| Name | R_Business_Associate |
|---|---|
| Entity Type | Table |
| Description | A look up reference that defines the type of business associate, for example, a company, partnership, person, project work team, political party precinct, or regulatory agency. |
| Submodel | Business_Associate |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , 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) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | 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) |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Business_Associate | Business_Associate_Type | A mnemonic code or abbreviation that uniquely identifies the types of Business Associate. Examples of type are corporation, sole proprietor, partnership, or individual. Note that types must form a valid combination with BA Sub Types. The Sub Types are Company, Person, BA Group, and Generic BA. A valid combination is Company/Corporation. An example of an invalid combination is Person/Corporation. This rule is enforced via a lookup against the R_Valid_BA_Type table. | Restrict | Yes |
| R_Valid_BA_Association | Secondary_BA_Type | 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 |
| R_Valid_BA_Association | Primary_BA_Type | 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 |
| R_Valid_BA_Type | Business_Associate_Type | A mnemonic code or abbreviation that uniquely identifies the valid type of business associate type in relation to Sub Types. This provides the mapping of business associate Sub Type (COMPANY, PERSON, BA_GROUP, GENERIC_BA) to business associate type (Corporation, Individual, Sole Proprietor, Partnership, Work Team.) | Restrict | Yes |