Versions Compared

Old Version 16

changes.mady.by.user Dmitry Donosiyan

Saved on

compared with

New Version 17

changes.mady.by.user Dmitry Donosiyan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top
In this page:

Table of Contents

Expand
titleClick to get an overall idea about the structure of this model (please note, that real examples of use may contain less elements):


Code Block
languagexml
     ...

<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 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:


Code Block
languagexml
<COL TAG="W_LOAD_XREFID_IN_UPPER_CASE" EXPRESSION="'N'"/>



ElementRequired Inbound Acct ValidationRequired Inbound Data MgtValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldDB Field TypeXpath
primaryAssetIdRequiredRequiredInstrumentId14in_primary_asset_idSSECURITYDBOSECURITY_MASTERPRIMARY_ASSET_IDCHAR(100)../primaryAssetId
primaryAssetTypeRequiredRequiredInstrumentId1432in_primary_asset_id_typeSSECURITYDBOSECURITY_MASTERPRIMARY_ASSET_ID_TYPECHAR(30)../primaryAssetType
altAssetIdAndType
  


AssetIdAndAssetIdType Complex Group../altAssetIdAndType/
issueName
  


string961in_issue_nameSSECURITYDBOSECURITY_MASTERISSUE_NAMEVARCHAR2(255)../issueName
unicodeIssueName
  


string-
  


not stored in DB../unicodeIssueName
issueDescription
  


Description962in_issue_descriptionSSECURITYDBOSECURITY_MASTERISSUE_DESCRIPTIONVARCHAR2(255)../issueDescription
tickerConditionally Required (at least one of these identifiers should be provided for security alias resolution)
 

InstrumentId13in_tickerSSECURITYDBOSECURITY_MASTERTICKERCHAR(100)../ticker
Depending on Batting Order can be mapped to any of: 1952, 1955, 1958, 1961, 1964, 1967, 1970, 1973, 1976, 1979in_x_id_1,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)
cusip
 

InstrumentIdin_x_id_2,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../cusip
cusipPay
 

InstrumentIdin_x_id_3,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../cusipPay
cusipReceive
 

InstrumentIdin_x_id_4,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../cusipReceive
isin
 

InstrumentIdin_x_id_5,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../isin
sedol
 

InstrumentIdin_x_id_6,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../sedol
reuters
 

InstrumentIdin_x_id_7,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../reuters
bloombergId
 

InstrumentIdin_x_id_8,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../bloombergId
sicovmId
 

InstrumentIdin_x_id_9,SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../sicovmId
valorenId
 

InstrumentIdin_x_id_10SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../valorenId
cedel
 

InstrumentId
 

SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../cedel
internalId
 

InstrumentId
 

SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../internalId
cinsId
 

InstrumentId
 

SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../cinsId
xrefIdentifiers
 

SMFXrefIdentifiers Complex Group../xrefIdentifiers/
primaryExchange
  


string10396in_primary_exchangeSSECURITYDBOEQUITY_DETAILPRIMARY_EXCHANGEVARCHAR2(30)../primaryExchange
primaryExchangeCodeRequired
 

ExchangeCode17in_sm_exchangeSSECURITYDBOSECURITY_MASTEREXCHANGECHAR(8)../primaryExchangeCode
securityAlias
  


integer10inout_security_aliasNSECURITYDBOSECURITY_MASTERSECURITY_ALIASNUMBER../securityAlias
assetCurrencyRequiredRequiredCurrencyCode85in_currency_codeSSECURITYDBOSECURITY_MASTERCURRENCY_CODECHAR(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

Anchor
AssetIdAndAssetIdType
AssetIdAndAssetIdType
AssetIdAndAssetIdType Data Map

 


ElementRequired Inbound Acct ValidationRequired Inbound Data MgtValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldDB Field TypeXpath
instrumentIdRequired
 

InstrumentId1795in_alt_asset_idSSECURITYDBOSECURITY_MASTERALT_ASSET_IDCHAR(100)../altAssetIdAndType/instrumentId
instrumentIdType
 


InstrumentIdType5501in_alt_asset_id_typeSSECURITYDBOSECURITY_MASTERALT_ASSET_ID_TYPECHAR(30)../altAssetIdAndType/instrumentIdType

Anchor
SMFXrefIdentifiers
SMFXrefIdentifiers
SMFXrefIdentifiers Data Map

 


ElementRequired Inbound Acct ValidationRequired Inbound Data MgtValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldDB Field TypeXpath
Set of 10 elements with names
xId1Required
 

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
xIdRequired
 

SMFXrefIdentifier Complex Group../xrefIdentifiers/xId/

Anchor
SMFXrefIdentifier
SMFXrefIdentifier
SMFXrefIdentifier Data Map

 


ElementRequired Inbound Acct ValidationRequired Inbound Data MgtValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldDB Field TypeXpath
xIdRequired
 

string1952in_x_id_1SSECURITYDBOXREFERENCEXREF_SECURITY_IDCHAR(100)../../../xId
1955in_x_id_2S
1958in_x_id_3S
1961in_x_id_4S
1964in_x_id_5S
1967in_x_id_6S
1970in_x_id_7S
1973in_x_id_8S
1976in_x_id_9S
1979in_x_id_10S
xIdTypeRequired
 

InstrumentIdType1953in_x_id_type_1SSECURITYDBOXREFERENCEXREF_TYPECHAR(30)../../../xIdType
1956in_x_id_type_2S
1959in_x_id_type_3S
1962in_x_id_type_4S
1965in_x_id_type_5S
1968in_x_id_type_6S
1971in_x_id_type_7S
1974in_x_id_type_8S
1977in_x_id_type_9S
1980in_x_id_type_10S
xExchangeCode
 


ExchangeCode-
  


not stored in DB; involved in extraction logic../../../xExchangeCode
primaryXrefSecAlias
 


integer-
  


SECURITYDBOXREFERENCE_HISTPRIMARY_XREF_SEC_ALIASNUMBER../../../primaryXrefSecAlias
cancelInd
 


string-
  


SECURITYDBOXREFERENCE_HISTCANCEL_INDVARCHAR2(1)../../../cancelInd
endDate
 


date-
  


SECURITYDBOXREFERENCE_HISTEND_DATEDATE../../../endDate
xUpdateTimestamp
 


dateTime-
  


SECURITYDBOXREFERENCEUPDATE_DATEDATE../../../xUpdateTimestamp
xUpdateSource
 


string-
  


SECURITYDBOXREFERENCE_HISTUPDATE_SOURCEVARCHAR2(255)../../../xUpdateSource
xBkupUpdateSource
 


string-
  


SECURITYDBOXREFERENCEBKUP_UPDATE_SOURCECHAR(8)../../../xBkupUpdateSource
xOrigSecurityAlias
 


integer-
  


SECURITYDBOXREFERENCEORIG_SECURITY_ALIASNUMBER../../../xOrigSecurityAlias
xSecurityAlias
 


integer1951in_x_alias_1NSECURITYDBOXREFERENCEXREF_SECURITY_ALIASNUMBER../../../xSecurityAlias
1954in_x_alias_2N
1957in_x_alias_3N
1960in_x_alias_4N
1963in_x_alias_5N
1966in_x_alias_6N
1969in_x_alias_7N
1972in_x_alias_8N
1975in_x_alias_9N
1978in_x_alias_10N
xShortDesc
 
extract-onlystring-
  


SECURITYDBOXREFERENCESHORT_DESCVARCHAR2(255)../../../xShortDesc