Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 16 Next »

In this page:

 Click to get an overall idea about the structure of this model (please 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 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'"/>
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

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

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/

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
 string-  SECURITYDBOXREFERENCESHORT_DESCVARCHAR2(255)../../../xShortDesc
  • No labels