...
| Info | ||
|---|---|---|
| ||
| While the names are similar, Asset Properties and Extended Asset Properties are different models | ||
| Info | ||
|
Extended Asset Properties is extract-only. There are several options for it:
- Extract nothing (default);
- Extract only the Asset Properties model.
...
- For this, 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, 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 | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
../ | |||||||||||
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 | ||||
annualDividendindicatedAnnualDividend | decimal | 3233 | SECURITYDBO | EQUITY | ANNUAL_DIVIDEND | NUMBER(28,12) | ../annualDividendindicatedAnnualDividend | ||||
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) | ../marketIssuegicsIndustry | ||||
| gicsSector | string | 1018510181 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_ | INDUSTRYSECTOR | VARCHAR2(60) | ../ | gicsIndustrygicsSector | ||
| gicsSectorName | string | 1018310182 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_ | INDUSTRY_GROUP VARCHAR2(60)SECTOR_NAME | ../gicsSectorName | ||||
| gicsIndustryGroup | gicsIndustryGroupNamestring | 1018410183 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_ | GROUP_NAMEGROUP | VARCHAR2(60) | ../gicsIndustryGroup | |||
| gicsIndustryGroupName | gicsIndustryNamestring | 1018610184 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_GROUP_NAME | VARCHAR2(60) | ../ | gicsIndustryNamegicsIndustryGroupName | |||
gicsNamegicsIndustry | string | 1018210185 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_NAME INDUSTRY | VARCHAR2(60) | ../gicsNamegicsIndustry | ||||
gicsOverrideIndustrygicsIndustryName | string | 1019710186 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDEINDUSTRY_INDUSTRY NAME | VARCHAR2(60) | ../gicsOverrideIndustrygicsIndustryNamegicsOverrideIndustryGrp | ||||
| gicsSubIndustry | string | 1019810187 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_ | OVERRIDESUB_ | INDUSTRY_GROUPINDUSTRY | VARCHAR2(60) | ../ | gicsOverrideIndustryGrpgicsSubIndustry | |
| gicsSubIndustryName | string | 1019910188 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUB_ | OVERRIDEINDUSTRY_ | SECTORNAME | VARCHAR2(60) | ../ | gicsOverrideSectorgicsSubIndustryName | |
gicsOverrideSubIndustrygicsOverrideIndustry | string | 1019610197 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_SUB_INDUSTRY | VARCHAR2(60) | ../gicsOverrideSubIndustrygicsOverrideIndustry | ||||
gicsSectorgicsOverrideIndustryGrp | string | 1018110198 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_INDUSTRY_SECTOR GROUP | VARCHAR2(60) | ../gicsSectorgicsOverrideIndustryGrp | ||||
gicsSubIndustrygicsOverrideSector | string | 1018710199 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUBOVERRIDE_INDUSTRY SECTOR | VARCHAR2(60) | ../gicsSubIndustrygicsOverrideSector | ||||
gicsSubIndustryNamegicsOverrideSubIndustry | string | 1018810196 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_SUB_INDUSTRY_NAME INDUSTRY | VARCHAR2 (60) | ../gicsSubIndustryNamegicsOverrideSubIndustry | ||||
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 | ||||
| fwdBrokerCode | string | 676 | SECURITYDBO | SECURITY_MASTER_DETAIL | FWD_BROKER_CODE | ../fwdBrokerCode | |||||
| issueDate | date | 68 | SECURITYDBO | FIXED_INCOME | ISSUE_DATE | ../issueDate | |||||
| firstIncomeDate | date | 473 | SECURITYDBO | FIXED_INCOME | FIRST_INCOME_DATE | ../firstIncomeDate | |||||
| lastIncomeDate | date | 474 | SECURITYDBO | FIXED_INCOME | LAST_INCOME_DATE | ../lastIncomeDate | |||||
| smDefaultDate | date | 10142 | SECURITYDBO | FIXED_INCOME | DEFAULT_DATE | ../smDefaultDate | |||||
| prvtPlace | string | 1421 | SECURITYDBO | SECURITY_MASTER | PRVT_PLACE | ../prvtPlace | |||||
| clearedSecurity | string | 5027 | SECURITYDBO | DERIVATIVES | CLEARED_SECURITY | ../clearedSecurity | |||||
| countryOfIssue | string | 10193 | SECURITYDBO | SECMASTER_DETAIL_EXT | COUNTRY_OF_ISSUE | ../countryOfIssue | |||||
| incomeCurrency | CurrencyCode | 1186 | SECURITYDBO | SECURITY_MASTER | INCOME_CURRENCY | ../incomeCurrency | |||||
| smMinorInd | string | 1789 | SECURITYDBO | SECURITY_MASTER | MINOR_IND | ../smMinorInd | |||||
| muniIssuerDes2ndLine | string | 3108 | SECURITYDBO | MUNI | MUNI_ISSUER_DES_2ND_LINE | ../muniIssuerDes2ndLine | |||||
| muniIndustryClassification | string | 3130 | SECURITYDBO | MUNI | MUNI_LONG_INDUSTRY_TYP | ../muniIndustryClassification | |||||
| muniIssueSize | decimal | 3106 | SECURITYDBO | MUNI | MUNI_ISSUE_SIZE | ../muniIssueSize | |||||
| pricingCusip | string | 5436 | SECURITYDBO | SECURITY_MASTER_EXT | PRICING_CUSIP | ../pricingCusip | |||||
| buysell | string | 1377 | SECURITYDBO | DERIVATIVES | BUYSELL | VARCHAR2(4) | ../buysell | ||||
| amortizationParValue | decimal | 42 | SECURITYDBO | FIXED_INCOME | AMORTIZATION_PAR_VALUE | NUMBER(28,12) | ../amortizationParValue | ||||