A business associate may have multiple identifiers or aliases. For example, a citizen of the United States has a social security number and may also have a driver�s license with a unique number. A company may be assigned a unique identifier called a DUNS Number by Dun and Bradstreet. If it is a publicly traded company it will also have a stock ticker symbol. To provide flexibility in defining these alternative identifiers for business associates, a table called BA_Alias was created. Several reference tables support the BA_Alias table: R_BA_Alias_Source contains a list of the sources for aliases, such as the New York Stock Exchange (NYSE) as a source for stock ticker symbols; R_BA_Alias contains the definition of the aliases themselves such as the ticker symbol or social security number; and R_Valid_BA_Alias_Source contains the valid combinations of sources and aliases, for example, social security numbers are provided by the Social Security Administration. The following are samples of stock ticker symbols (whose source is the New York Stock Exchange) as aliases for the sample companies.
Company |
Ticker Symbol |
Conoco Phillips |
COP |
Halliburton |
HAL |
Duke Energy |
DUK |
ID |
BUSINESS |
Alias |
Alias Source |
Alias Type |
-270003 |
-265000 |
COP |
NYSE |
Ticker Symbol |
-270005 |
-265028 |
HAL |
NYSE |
Ticker Symbol |
-270007 |
-265038 |
DUK |
NYSE |
Ticker Symbol |
A business associate may have different types of relationships with other business associates. For example, several business associates may form a partnership to fund the purchase of a lease and subsequent exploration and drilling. Associations can also be used to express a business hierarchy with subsidiaries. The following samples include: Halliburton is the sole owner of Sperry-Sun Drilling Services and Conoco Phillips is the sole owner of Conoco Norway. Conoco Phillips is part owner (31.3%) of Duke Energy Field Services along with Duke Energy, which owns 69.7%. In each case the reverse relationship is also shown, e.g., that Duke Energy Field Services is a subsidiary of both Conoco Phillips and Duke Energy.
The Hierarchy Flag column is set to "1" (i.e., "True") if you are defining a hierarchy and "0" (False) if you are not.
ID |
PrimaryBA ID |
Secondary BA ID |
Association Role |
Hierarchy Flag |
Percent Ownership |
TBD |
-265028 |
-265019 |
Owner |
1 |
100 |
TBD |
-265000 |
-265004 |
Owner |
1 |
100 |
TBD |
-265000 |
-265033 |
Owner |
1 |
31.3 |
TBD |
-265019 |
-265028 |
Subsidiary |
0 |
|
TBD |
-265004 |
-265000 |
Subsidiary |
0 |
|
TBD |
-265033 |
-265000 |
Subsidiary |
0 |
|
TBD |
-265038 |
-265033 |
Owner |
1 |
69.7 |
TBD |
-265033 |
-265038 |
Subsidiary |
0 |
|