Asset Identifiers Model Data Map Table

On this page:

Click to get an overall idea about the structure of this model. Note that real examples of use may contain less elements:

     ...

<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 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
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
ticker			InstrumentId	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)	../ticker
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

Asset Identifiers Model Data Map Table

AssetIdAndAssetIdType Data Map

SMFXrefIdentifiers Data Map

SMFXrefIdentifier Data Map