Versions Compared

Old Version 16

changes.mady.by.user Dmitry Donosiyan

Saved on

compared with

New Version Current

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 the following two global parameters in w_config_custom.inc:

...

  • 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'"/>

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

Anchor
AssetIdAndAssetIdType
AssetIdAndAssetIdType
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

Anchor
SMFXrefIdentifiers
SMFXrefIdentifiers
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/

Anchor
SMFXrefIdentifier
SMFXrefIdentifier
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