| 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 / Measurement | 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) |
| Name | CODE NA |
The spelled-out name of the reference value. | No |
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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Business_Associate | Business_Associate_Type | Defines the type 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 | Defines the BA 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 | Defines 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 | 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 |