In this page:
By default, security alias is not extracted for warehouse, but IS extracted for other security-related objects. This behavior can be then manipulated by two global parameters in w_config_custom.inc:
EXCLUDE_SECURITY_ALIAS - If set to Y, switches off security alias extraction for all feedtypes. 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:
<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 | AssetIdAndAssetIdType Complex Group | ../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 | SMFXrefIdentifiers Complex Group | ../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 | |||||||
AssetIdAndAssetIdType Data Map | |||||||||||
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 | ||
SMFXrefIdentifiers Data Map | |||||||||||
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 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId1/ | ||||||||
xId2 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId2/ | |||||||||
xId3 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId3/ | |||||||||
xId4 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId4/ | |||||||||
xId5 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId5/ | |||||||||
xId6 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId6/ | |||||||||
xId7 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId7/ | |||||||||
xId8 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId8/ | |||||||||
xId9 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId9/ | |||||||||
xId10 | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId10/ | |||||||||
or set of unbounded number elements with the same name xId | |||||||||||
xId | Required | SMFXrefIdentifier Complex Group | ../xrefIdentifiers/xId/ | ||||||||
SMFXrefIdentifier Data Map | |||||||||||
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 | - | not stored in DB; involved in extraction logic | ../../../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 |