| Name | R_Valid_BA_Alias_Source |
|---|---|
| Entity Type | Table |
| Description | A reference entity that links business associate alias types to the sources that provide that type of alias. For example, the New York Stock Exchange provides stock ticker symbols for companies whose stock is traded on that exchange. And the Department of Commerce provides the codes for SIC (Standard Industrial Classification) and NAICS (North American Industrial Classification System). |
| Submodel | Business_Associate |
| Entity Scope | Reference |
| Primary Key | BA_Alias_Type , BA_Alias_Source_Code |
| Natural Key | BA_Alias_Type , BA_Alias_Source_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_Alias_Source_Code | R_BA_Alias_Source |
|
A mnemonic code or abbreviation that uniquely identifies a valid source of a business associate alias type. Examples are Dow Jones for stock symbol, Dun and Bradstreet for DUNS number, and the US Dept of Commerce for SIC and NAICS. | Yes |
VARCHAR2(64) |
| BA_Alias_Type | R_BA_Alias |
|
A mnemonic code or abbreviation that uniquely identifies an alias type which is valid for a given source of aliases. Examples of sources are SIC, NAICS, and DUNS. Examples of valid combinations are stock symbol (provided by NYSE), DUNS number (provided by Dun and Bradstreet), and SIC and NAICS (provided by the US Dept of Commerce). | 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 |
|---|---|---|---|---|
| BA_Alias | BA_Alias_Type | The valid Alias_Type and Alias_Source_Code for the BA_Alias. | Restrict | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| BA_Alias_Source_Code | R_BA_Alias_Source | A mnemonic code or abbreviation that uniquely identifies a valid source of a business associate alias type. Examples are Dow Jones for stock symbol, Dun and Bradstreet for DUNS number, and the US Dept of Commerce for SIC and NAICS. | Restrict | Yes |
| BA_Alias_Type | R_BA_Alias | A mnemonic code or abbreviation that uniquely identifies an alias type which is valid for a given source of aliases. Examples of sources are SIC, NAICS, and DUNS. Examples of valid combinations are stock symbol (provided by NYSE), DUNS number (provided by Dun and Bradstreet), and SIC and NAICS (provided by the US Dept of Commerce). | Restrict | Yes |