Anchor | ||||
---|---|---|---|---|
|
...
Table of Contents |
---|
Expand | |||||
---|---|---|---|---|---|
| |||||
|
By default, security alias is not extracted for warehouse, but is extracted for other security-related objects. This behavior can be then manipulated
...
by the following two global parameters in w_config_custom.inc:
EXCLUDE_SECURITY_ALIAS - If set to Y, switches off security alias extraction for all feed types. Can be
...
specified as ExcludeSecurityAlias task parameter in the RTR message.
W_INCLUDE_SECALIAS_FORWHS - If set to Y, enables security alias extraction specifically for warehouse objects (has a higher priority than EXCLUDE_SECURITY_ALIAS).
If you want Asset Identifiers always loaded in upper case, please redefine this parameter
...
in w_config_custom.inc:
Code Block | ||
---|---|---|
| ||
<COL TAG="W_LOAD_XREFID_IN_UPPER_CASE" EXPRESSION="'N'"/> |
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
primaryAssetId | Required | Required | InstrumentId | 14 | in_primary_asset_id | S | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID | CHAR(100) | ../primaryAssetId | ||||||
primaryAssetType | Required | Required | InstrumentId | 1432 | in_primary_asset_id_type | S | SECURITYDBO | SECURITY_MASTER | PRIMARY_ASSET_ID_TYPE | CHAR(30) | ../primaryAssetType | ||||||
altAssetIdAndType | ../altAssetIdAndType/ | ||||||||||||||||
issueName | string | 961 | in_issue_name | S | SECURITYDBO | SECURITY_MASTER | ISSUE_NAME | VARCHAR2(255) | ../issueName | ||||||||
unicodeIssueName | string | - | not stored in DB | ../unicodeIssueName | |||||||||||||
issueDescription | Description | 962 | in_issue_description | S | SECURITYDBO | SECURITY_MASTER | ISSUE_DESCRIPTION | VARCHAR2(255) | ../issueDescription | ||||||||
ticker | Conditionally Required (at least one of these identifiers should be provided for security alias resolution) | InstrumentId | 13 | in_ticker | S | SECURITYDBO | SECURITY_MASTER | TICKER | CHAR(100) | ../ticker | |||||||
Depending on Batting Order can be mapped to any of: 1952, 1955, 1958, 1961, 1964, 1967, 1970, 1973, 1976, 1979 | in_x_id_1, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | |||||||||||
cusip | InstrumentId | in_x_id_2, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cusip | |||||||||
cusipPay | InstrumentId | in_x_id_3, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cusipPay | |||||||||
cusipReceive | InstrumentId | in_x_id_4, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cusipReceive | |||||||||
isin | InstrumentId | in_x_id_5, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../isin | |||||||||
sedol | InstrumentId | in_x_id_6, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../sedol | |||||||||
reuters | InstrumentId | in_x_id_7, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../reuters | |||||||||
bloombergId | InstrumentId | in_x_id_8, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../bloombergId | |||||||||
sicovmId | InstrumentId | in_x_id_9, | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../sicovmId | |||||||||
valorenId | InstrumentId | in_x_id_10 | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../valorenId | |||||||||
cedel | InstrumentId | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cedel | ||||||||||
internalId | InstrumentId | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../internalId | ||||||||||
cinsId | InstrumentId | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../cinsId | ||||||||||
xrefIdentifiers | ../xrefIdentifiers/ | ||||||||||||||||
primaryExchange | string | 10396 | in_primary_exchange | S | SECURITYDBO | EQUITY_DETAIL | PRIMARY_EXCHANGE | VARCHAR2(30) | ../primaryExchange | ||||||||
primaryExchangeCode | Required | ExchangeCode | 17 | in_sm_exchange | S | SECURITYDBO | SECURITY_MASTER | EXCHANGE | CHAR(8) | ../primaryExchangeCode | |||||||
securityAlias | integer | 10 | inout_security_alias | N | SECURITYDBO | SECURITY_MASTER | SECURITY_ALIAS | NUMBER | ../securityAlias | ||||||||
assetCurrency | Required | Required | CurrencyCode | 85 | in_currency_code | S | SECURITYDBO | SECURITY_MASTER | CURRENCY_CODE | CHAR(30) | ../assetCurrency | ||||||
assetResolutionOption | normalizedString | - | not stored in DB; involved in security resolution logic | ../assetResolutionOption | |||||||||||||
battingOrder | normalizedString | - | not stored in DB; involved in security resolution logic | ../battingOrder | |||||||||||||
| |||||||||||||||||
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
instrumentId | Required | InstrumentId | 1795 | in_alt_asset_id | S | SECURITYDBO | SECURITY_MASTER | ALT_ASSET_ID | CHAR(100) | ../altAssetIdAndType/instrumentId | |||||||
instrumentIdType | InstrumentIdType | 5501 | in_alt_asset_id_type | S | SECURITYDBO | SECURITY_MASTER | ALT_ASSET_ID_TYPE | CHAR(30) | ../altAssetIdAndType/instrumentIdType | ||||||||
| |||||||||||||||||
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
Set of 10 elements with names | |||||||||||||||||
xId1 | Required | ../xrefIdentifiers/xId1/ | |||||||||||||||
xId2 | ../xrefIdentifiers/xId2/ | ||||||||||||||||
xId3 | ../xrefIdentifiers/xId3/ | ||||||||||||||||
xId4 | ../xrefIdentifiers/xId4/ | ||||||||||||||||
xId5 | ../xrefIdentifiers/xId5/ | ||||||||||||||||
xId6 | ../xrefIdentifiers/xId6/ | ||||||||||||||||
xId7 | ../xrefIdentifiers/xId7/ | ||||||||||||||||
xId8 | ../xrefIdentifiers/xId8/ | ||||||||||||||||
xId9 | ../xrefIdentifiers/xId9/ | ||||||||||||||||
xId10 | ../xrefIdentifiers/xId10/ | ||||||||||||||||
or set of unbounded number elements with the same name xId | |||||||||||||||||
xId | Required | ../xrefIdentifiers/xId/ | |||||||||||||||
| |||||||||||||||||
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
xId | Required | string | 1952 | in_x_id_1 | S | SECURITYDBO | XREFERENCE | XREF_SECURITY_ID | CHAR(100) | ../../../xId | |||||||
1955 | in_x_id_2 | S | |||||||||||||||
1958 | in_x_id_3 | S | |||||||||||||||
1961 | in_x_id_4 | S | |||||||||||||||
1964 | in_x_id_5 | S | |||||||||||||||
1967 | in_x_id_6 | S | |||||||||||||||
1970 | in_x_id_7 | S | |||||||||||||||
1973 | in_x_id_8 | S | |||||||||||||||
1976 | in_x_id_9 | S | |||||||||||||||
1979 | in_x_id_10 | S | |||||||||||||||
xIdType | Required | InstrumentIdType | 1953 | in_x_id_type_1 | S | SECURITYDBO | XREFERENCE | XREF_TYPE | CHAR(30) | ../../../xIdType | |||||||
1956 | in_x_id_type_2 | S | |||||||||||||||
1959 | in_x_id_type_3 | S | |||||||||||||||
1962 | in_x_id_type_4 | S | |||||||||||||||
1965 | in_x_id_type_5 | S | |||||||||||||||
1968 | in_x_id_type_6 | S | |||||||||||||||
1971 | in_x_id_type_7 | S | |||||||||||||||
1974 | in_x_id_type_8 | S | |||||||||||||||
1977 | in_x_id_type_9 | S | |||||||||||||||
1980 | in_x_id_type_10 | S | |||||||||||||||
xExchangeCode | ExchangeCode | 1981 | in_xref_exchange | S | SECURITYDBO | XREFERENCE | EXCHANGE | VARCHAR2 | ../../../xExchangeCode | ||||||||
primaryXrefSecAlias | integer | - | SECURITYDBO | XREFERENCE_HIST | PRIMARY_XREF_SEC_ALIAS | NUMBER | ../../../primaryXrefSecAlias | ||||||||||
cancelInd | string | - | SECURITYDBO | XREFERENCE_HIST | CANCEL_IND | VARCHAR2(1) | ../../../cancelInd | ||||||||||
endDate | date | - | SECURITYDBO | XREFERENCE_HIST | END_DATE | DATE | ../../../endDate | ||||||||||
xUpdateTimestamp | dateTime | - | SECURITYDBO | XREFERENCE | UPDATE_DATE | DATE | ../../../xUpdateTimestamp | ||||||||||
xUpdateSource | string | - | SECURITYDBO | XREFERENCE_HIST | UPDATE_SOURCE | VARCHAR2(255) | ../../../xUpdateSource | ||||||||||
xBkupUpdateSource | string | - | SECURITYDBO | XREFERENCE | BKUP_UPDATE_SOURCE | CHAR(8) | ../../../xBkupUpdateSource | ||||||||||
xOrigSecurityAlias | integer | - | SECURITYDBO | XREFERENCE | ORIG_SECURITY_ALIAS | NUMBER | ../../../xOrigSecurityAlias | ||||||||||
xSecurityAlias | integer | 1951 | in_x_alias_1 | N | SECURITYDBO | XREFERENCE | XREF_SECURITY_ALIAS | NUMBER | ../../../xSecurityAlias | ||||||||
1954 | in_x_alias_2 | N | |||||||||||||||
1957 | in_x_alias_3 | N | |||||||||||||||
1960 | in_x_alias_4 | N | |||||||||||||||
1963 | in_x_alias_5 | N | |||||||||||||||
1966 | in_x_alias_6 | N | |||||||||||||||
1969 | in_x_alias_7 | N | |||||||||||||||
1972 | in_x_alias_8 | N | |||||||||||||||
1975 | in_x_alias_9 | N | |||||||||||||||
1978 | in_x_alias_10 | N | |||||||||||||||
xShortDesc | extract-only | string | - | SECURITYDBO | XREFERENCE | SHORT_DESC | VARCHAR2(255) | ../../../xShortDesc |