| Name | BA_Alias |
|---|---|
| Entity Type | Extension of Business_Associate |
| Description | A name or identifier assigned to a business associate. For example, maiden name, nickname, trade name, or former name. Typical aliases for businesses are SIC for Standard Industry Classification code from the US Dept of Commerce; and DUNS for the company identification number assigned by Dun and Bradstreet. A business associate can have more than one alias of a given type, for example, a company can be assigned multiple SIC codes if it participates in more than one type of business. |
| Submodel | Business_Associate |
| Entity Scope | Shared |
| Primary Key | Id |
| Natural Key | |
| Generalizations | IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| BA_Alias_Source_Code | R_BA_Alias_Source |
A mnemonic code or abbreviation that uniquely identifies the source of the alias. Examples of BA alias sources are Dun and Bradstreet for DUNS company identifier, the New York Stock Exchange for ticker symbols, and the US Department of Commerce for SIC and NAICS codes. | Yes |
VARCHAR2(64) |
| BA_Alias_Text | ENTITY_NAME NA |
The text of the alias such as a nickname or maiden name for a person. For companies, typical aliases are SIC for Standard Industry Classification code from the US Dept of Commerce; and DUNS for the company identification number assigned by Dun and Bradstreet. | No |
VARCHAR2(255) |
| BA_Alias_Type | R_BA_Alias |
A mnemonic code or abbreviation that uniquely identifies the valid type for the business associate alias. | Yes |
VARCHAR2(64) |
| Business_Associate_Id | Business_Associate |
A number that uniquely identifies the business associate that has an alias. Business associates may have alternate identifiers or aliases such as a "Doing Business As" or DBA, a trade name, or DUNS number supplied by Dun and Bradstreet, stock symbol, and SIC (Standard Industry Code) supplied by the US Commerce Dept. Must provide both the type alias and the source of the alias since some sources provide more than one type. | Yes |
NUMBER(38) |
| End_Date | DATE NA |
The date (and optionally time of day) that the alias expires. | No |
DATE |
| Existence_Kind | REF_EXISTENCE_KIND NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| GUID | STRING128 NA |
Globally Unique IDentifier for an instance of a class. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers. | No |
VARCHAR2(128) |
| Id | ID No_Unit |
Unique identifier for this entity. | Yes |
NUMBER(38) |
| 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) |
| Produced_By | STRING64 NA |
ID of the activity that was executing when the entity was created, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | REMARKS_STR NA |
Remarks related to the use of an alias for a business associate, for example the reason for a name change. | No |
VARCHAR2(999) |
| SDAT_Label | int No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Start_Date | DATE NA |
The date (and optionally the time of day) that the alias becomes effective. | No |
DATE |
| 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) |
| Version | STRING255 NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| BA_Alias_Type | R_BA_Alias | A mnemonic code or abbreviation that uniquely identifies the valid type for the business associate alias. | Restrict | Yes |
| Business_Associate | Business_Associate | A number that uniquely identifies the business associate that has an alias. Business associates may have alternate identifiers or aliases such as a "Doing Business As" or DBA, a trade name, or DUNS number supplied by Dun and Bradstreet, stock symbol, and SIC (Standard Industry Code) supplied by the US Commerce Dept. Must provide both the type alias and the source of the alias since some sources provide more than one type. | Cascade | Yes |
| BA_Alias_Source_Code | R_BA_Alias_Source | A mnemonic code or abbreviation that uniquely identifies the source of the alias. Examples of BA alias sources are Dun and Bradstreet for DUNS company identifier, the New York Stock Exchange for ticker symbols, and the US Department of Commerce for SIC and NAICS codes. | Restrict | Yes |