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

« Previous Version 34 Next »

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

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

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


  • No labels