Asset Identifiers Model Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Mar 07, 2024 by Nancy Cohn (Deactivated)
2 min read

On this page

 

... <primaryAssetId>TSTR8210A</primaryAssetId> <primaryAssetType>ITEMID</primaryAssetType> <altAssetIdAndType> <instrumentId>TSTR8210A</instrumentId> <instrumentIdType>SICOVNID</instrumentIdType> </altAssetIdAndType> <issueName>SWTEST04526</issueName> <unicodeIssueName>UNICODE_ISSUE_NAME</unicodeIssueName> <issueDescription>ISSUE_DESCRIPTION</issueDescription> <ticker>TICKER_ID</ticker> <cusip>CUSIP_ID1</cusip> <cusipPay>CUSIP_PAY</cusipPay> <cusipReceive>CUSIP_RECEIVE</cusipReceive> <isin>ISIN_ID22</isin> <sedol>SEDOL_ID</sedol> <reuters>REUTERS</reuters> <bloombergId>TSTR210A</bloombergId> <sicovmId>TSTR821</sicovmId> <valorenId>TS210</valorenId> <cedel>CEDEL_ID</cedel> <internalId>TSTR8210A</internalId> <cinsId>T821A</cinsId> <xrefIdentifiers> <xId> <xId>TSTR821</xId> <xIdType>IAS LINK REF NUM</xIdType> <xExchangeCode>C</xExchangeCode> <primaryXrefSecAlias>368693</primaryXrefSecAlias> <cancelInd>I</cancelInd> <endDate>2014-07-22</endDate> <xUpdateTimestamp>2014-07-22T08:15:19</xUpdateTimestamp> <xUpdateSource>UPD_SRCE</xUpdateSource> <xBkupUpdateSource>BKUP_U_S</xBkupUpdateSource> <xOrigSecurityAlias>135273</xOrigSecurityAlias> <xSecurityAlias>349799</xSecurityAlias> <xShortDesc>X_SHORT_DESC</xShortDesc> </xId> </xrefIdentifiers> <primaryExchange>ALL</primaryExchange> <primaryExchangeCode>ALL</primaryExchangeCode> <securityAlias>427434</securityAlias> <assetCurrency>USD</assetCurrency> <assetResolutionOption>XREF_EXCHANGE</assetResolutionOption> <battingOrder>ISIN,CUSIP,SEDOL</battingOrder> ...

 

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:

<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

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

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