Versions Compared

Old Version 31

changes.mady.by.user Pamela Totas

Saved on

compared with

New Version 32

changes.mady.by.user Nancy Cohn

Saved on

Key

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

Anchor
top
top
On this page:

Table of Contents

Expand
titleClick to get an overall idea about the structure of this model. 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 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:


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

ExchangeCode1981in_xref_exchangeSSECURITYDBOXREFERENCEEXCHANGEVARCHAR2../../../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
xShortDescextract-onlystring-

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