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 10 Next »


Note

While the names are similar, Asset Properties and Extended Asset Properties are different models 


Note

Extended Asset Properties is extract-only. There are several options for it:

  • Extract nothing (default);
  • Extract only the Asset Properties model. To do that, you should have the IncludeAssetProperties=Y task parameter on your RTR or its global variant W_INCLUDE_ASSET_PROPERTIES.
  • Set the IncludeExtendedDetails=Y task parameter on your RTR to extract the first part of the Extended Asset Properties model (this page, all elements before the delimiter), which includes the Asset Properties model.
  • Set the IncludeExtendedDetails=ALL task parameter on your RTR to extract full Extended Asset Properties model (this page), which includes the Asset Properties model.
  • In other words, IncludeExtendedDetails=Y or ALL equals extraction with IncludeAssetProperties=Y task parameter plus additional fields.

To extract Extended CA model along with Extended Asset Properties for WRHSTRADEEXTRACT, TRADEDCAEXTRACT or SETTLEDCAEXTRACT, please refer to Extended CA Properties Model Data Map Table

Element

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Asset Properties Model

../

issuerId

string

1413

in_issuer_id

SECURITYDBO

SECURITY_MASTER

ISSUER_ID

CHAR(20)

../issuerId

priceMultiplier

decimal

18

in_price_multiplier

SECURITYDBO

SECURITY_MASTER

PRICE_MULTIPLIER

NUMBER(28,12)

../priceMultiplier

quantityScale

decimal

19

in_sm_trading_unit

SECURITYDBO

SECURITY_MASTER

TRADING_UNIT

NUMBER(28,12)

../quantityScale

redemptionCurrency

string

1530

in_redemption_currency

SECURITYDBO

SECURITY_MASTER

REDEMPTION_CURRENCY

CHAR(3)

../redemptionCurrency

contractSize

decimal

1483

in_contractsize

SECURITYDBO

SECURITY_MASTER_DETAIL

CONTRACTSIZE

NUMBER(28,12)

../contractSize

strikePrice

decimal

67

in_strike_price

SECURITYDBO

DERIVATIVES

STRIKE_PRICE

NUMBER(28,12)

../strikePrice

underlyingSecurity

string

1141

in_underlying_security

SECURITYDBO

DERIVATIVES

UNDERLYING_SECURITY

VARCHAR2(255)

../underlyingSecurity

underlyingSecAlias

integer

1347

in_underlying_sec_alias

SECURITYDBO

DERIVATIVES

UNDERLYING_SEC_ALIAS

NUMBER

../underlyingSecAlias

underlyingType

string

916

in_underlying_type

SECURITYDBO

UNDERLYING_SECURITY

UNDERLYING_TYPE

VARCHAR2(100)

../underlyingType

nextCouponDate

date

1189

in_next_coupon_date

SECURITYDBO

FIXED_INCOME

NEXT_COUPON_DATE

DATE

../nextCouponDate

paymentFrequency

string

1544

in_payment_freq

SECURITYDBO

FIXED_INCOME

PAYMENT_FREQ

CHAR(6)

../paymentFrequency

investmentDescription

Description

10174

in_security_description

SECURITYDBO

SECMASTER_DETAIL_EXT

SECURITY_DESCRIPTION

VARCHAR2(60)

../investmentDescription

issuePrice

decimal

69


SECURITYDBO

FIXED_INCOME

ISSUE_PRICE

NUMBER(28,12)

../issuePrice

issueCountry

string

2290


SECURITYDBO

EQUITY

ISSUE_COUNTRY

CHAR(3)

../issueCountry

To add the elements below, please set IncludeExtendedDetails=ALL in the RTR 

offset

decimal

215


SECURITYDBO

DERIVATIVES

OFFSET

NUMBER

../offset

optiondescr

string

1364


SECURITYDBO

DERIVATIVES

OPTIONDESCR

VARCHAR2(10)

../optiondescr

premiumType

string

3302


SECURITYDBO

DERIVATIVES

PREMIUM_TYPE

CHAR(2)

../premiumType

putCallFlag

string

1350


SECURITYDBO

DERIVATIVES

PUT_CALL_FLAG 

CHAR(4)

../putCallFlag

indicatedAnnualDividend

decimal

3233


SECURITYDBO

EQUITY

ANNUAL_DIVIDEND 

NUMBER(28,12)

../indicatedAnnualDividend

drdFlag

string

2907


SECURITYDBO

EQUITY

DRD_FLAG 

VARCHAR2 (1)

../drdFlag

qdiEligibleFlag

string

2905


SECURITYDBO

EQUITY

QDI_ELIGIBLE_FLAG 

VARCHAR2 (1)

../qdiEligibleFlag

sharesOutstanding

decimal

3244


SECURITYDBO

EQUITY

SHARES_OUTSTANDING 

NUMBER(28,12)

../sharesOutstanding

sicCode

string

10401


SECURITYDBO

EQUITY_DETAIL

SIC_NAME

VARCHAR2(60)

../sicCode

interestPaymentTiming

string

1523


SECURITYDBO

FIXED_INCOME

ACCRUAL_METHOD

CHAR(4)

../interestPaymentTiming

callIndicator

string

1182


SECURITYDBO

FIXED_INCOME

CALLABLE 

CHAR(2)

../callIndicator

putIndicator

string

1546


SECURITYDBO

FIXED_INCOME

PUTTABLE 

CHAR(2)

../putIndicator

datedDate

date

1183


SECURITYDBO

FIXED_INCOME

DATED_DATE

DATE

../datedDate

demandFeature

string

10555


SECURITYDBO

FIXED_INCOME

DEMAND_FEATURE 

VARCHAR2(3)

../demandFeature

uSFederalTaxIndicator

string

1545


SECURITYDBO

FIXED_INCOME

FEDERAL_TAX_INDICATOR 

CHAR(2)

../uSFederalTaxIndicator

businessDayConvention

string

1536


SECURITYDBO

FIXED_INCOME

INTEREST_METHOD_CODE 

CHAR(10)

../businessDayConvention

minimumPiece

decimal

1540


SECURITYDBO

FIXED_INCOME

MINIMUM_PIECE 

NUMBER(28,12)

../minimumPiece

sinkFundIndicator

string

1780


SECURITYDBO

FIXED_INCOME

SINK_FUND

CHAR(2)

../sinkFundIndicator

varRateFreqCode

string

1788


SECURITYDBO

FIXED_INCOME

VAR_RATE_FREQ_CODE 

CHAR(4)

../varRateFreqCode

marketIssue

string

10347


SECURITYDBO

FIXED_INCOME_DETAIL_EXT

MARKET_ISSUE

VARCHAR2(30)

../marketIssue

gicsSectorstring10181
SECURITYDBOSECMASTER_DETAIL_EXTGICS_SECTOR VARCHAR2(60)../gicsSector
gicsSectorNamestring10182
SECURITYDBOSECMASTER_DETAIL_EXTGICS_SECTOR_NAME
../gicsSectorName
gicsIndustryGroupstring10183
SECURITYDBOSECMASTER_DETAIL_EXTGICS_INDUSTRY_GROUP VARCHAR2(60)../gicsIndustryGroup
gicsIndustryGroupNamestring10184
SECURITYDBOSECMASTER_DETAIL_EXTGICS_INDUSTRY_GROUP_NAME VARCHAR2(60)../gicsIndustryGroupName

gicsIndustry

string

10185


SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY

VARCHAR2(60)

../gicsIndustry

gicsIndustryName

string

10186


SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_INDUSTRY_NAME 

VARCHAR2(60)

../gicsIndustryName

gicsSubIndustrystring10187
SECURITYDBOSECMASTER_DETAIL_EXTGICS_SUB_INDUSTRY VARCHAR2(60)../gicsSubIndustry
gicsSubIndustryNamestring10188
SECURITYDBOSECMASTER_DETAIL_EXTGICS_SUB_INDUSTRY_NAME VARCHAR2(60)../gicsSubIndustryName

gicsOverrideIndustry

string

10197


SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_INDUSTRY 

VARCHAR2(60)

../gicsOverrideIndustry

gicsOverrideIndustryGrp

string

10198


SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_INDUSTRY_GROUP 

VARCHAR2(60)

../gicsOverrideIndustryGrp

gicsOverrideSector

string

10199


SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_SECTOR 

VARCHAR2(60)

../gicsOverrideSector

gicsOverrideSubIndustry

string

10196


SECURITYDBO

SECMASTER_DETAIL_EXT

GICS_OVERRIDE_SUB_INDUSTRY 

VARCHAR2 (60)

../gicsOverrideSubIndustry

marketSectorDescription

string

10173


SECURITYDBO

SECMASTER_DETAIL_EXT

MARKET_SECTOR_DESCRIPTION

VARCHAR2(8)

../marketSectorDescription

couponDayOfMonth

decimal

1799


SECURITYDBO

SECURITY_MASTER

COUPON_DAY_OF_MONTH 

NUMBER 

../couponDayOfMonth

paymentFrequencyCode

string

472


SECURITYDBO

SECURITY_MASTER

COUPON_FREQ_CODE

CHAR(8)

../paymentFrequencyCode

dayCountBasis

string

471


SECURITYDBO

SECURITY_MASTER

DAY_CNT

CHAR(20)

../dayCountBasis

restrictedIndicator

string

1139


SECURITYDBO

SECURITY_MASTER

LIQUID_FLAG

CHAR(2)

../restrictedIndicator

oIDIndicator

string

218


SECURITYDBO

SECURITY_MASTER

OID_BOND

CHAR(2)

../oIDIndicator

quantityType

string

12


SECURITYDBO

SECURITY_MASTER

QUANTITY_TYPE

CHAR(12)

../quantityType

_144AEligibleIndicator

string

1301


SECURITYDBO

SECURITY_MASTER

SEC_144A_FLAG

CHAR(2)

../_144AEligibleIndicator

securityMinorType

string

1440


SECURITYDBO

SECURITY_MASTER

SECURITY_MINOR_TYPE

CHAR(4)

../securityMinorType

businessCalendarName

string

1480


SECURITYDBO

SECURITY_MASTER_DETAIL

BUSINESSDAY

VARCHAR2(10)

../businessCalendarName

countryOfRiskCode

string

10536


SECURITYDBO

SECURITY_MASTER_DETAIL

COUNTRY_OF_RISK

VARCHAR2(20)

../countryOfRiskCode

region

string

5423


SECURITYDBO

SECURITY_MASTER_DETAIL

REGION

VARCHAR2(50)

../region

riskClassificationType

string

11584


SECURITYDBO

SECURITY_MASTER_DETAIL

RISK_CLASSIFICATION_TYPE

CHAR

../riskClassificationType

userGroupChar1

string

1505


SECURITYDBO

SECURITY_MASTER_DETAIL

USER_GROUP_CHAR1

VARCHAR2(60)

../userGroupChar1

notionalResetType

string

4409


SECURITYDBO

SWAPS

NOTIONAL_RESET_TYPE

VARCHAR2(10)

../notionalResetType

payRecIndicator

string

4590


SECURITYDBO

SWAPS

PAY_RECEIVE_IND

VARCHAR2(10)

../payRecIndicator

smStateCode

string

1343


SECURITYDBO

FIXED_INCOME

STATE_CODE 

CHAR(2)

../smStateCode

smDefaultIndicator

string

1551


SECURITYDBO

SECURITY_MASTER

DEFAULT_FLAG

CHAR(2)

../smDefaultIndicator

smPoolNumber

string

1439


SECURITYDBO

SECURITY_MASTER

POOL_NUMBER

CHAR(12)

../smPoolNumber

fwdBrokerCodestring676
SECURITYDBOSECURITY_MASTER_DETAILFWD_BROKER_CODE
../fwdBrokerCode
issueDatedate68
SECURITYDBOFIXED_INCOMEISSUE_DATE
../issueDate
firstIncomeDatedate473
SECURITYDBOFIXED_INCOMEFIRST_INCOME_DATE
../firstIncomeDate
lastIncomeDatedate474
SECURITYDBOFIXED_INCOMELAST_INCOME_DATE
../lastIncomeDate
smDefaultDatedate10142
SECURITYDBOFIXED_INCOMEDEFAULT_DATE
../smDefaultDate
prvtPlacestring1421
SECURITYDBOSECURITY_MASTERPRVT_PLACE
../prvtPlace
clearedSecuritystring5027
SECURITYDBODERIVATIVESCLEARED_SECURITY
../clearedSecurity
countryOfIssuestring10193
SECURITYDBOSECMASTER_DETAIL_EXTCOUNTRY_OF_ISSUE
../countryOfIssue
incomeCurrencyCurrencyCode1186
SECURITYDBOSECURITY_MASTERINCOME_CURRENCY
../incomeCurrency
smMinorIndstring1789
SECURITYDBOSECURITY_MASTERMINOR_IND
../smMinorInd
muniIssuerDes2ndLinestring3108
SECURITYDBOMUNIMUNI_ISSUER_DES_2ND_LINE
../muniIssuerDes2ndLine
muniIndustryClassificationstring3130
SECURITYDBOMUNIMUNI_LONG_INDUSTRY_TYP
../muniIndustryClassification
muniIssueSizedecimal3106
SECURITYDBOMUNIMUNI_ISSUE_SIZE
../muniIssueSize
pricingCusipstring5436
SECURITYDBOSECURITY_MASTER_EXTPRICING_CUSIP
../pricingCusip
  • No labels