...
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 | 10185 | 10181 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_ | INDUSTRYSECTOR | VARCHAR2(60) | ../ | gicsIndustrygicsSector | ||
gicsSectorName | string | 10183 | 10182 | 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 | 10186 | 10184 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_GROUP_NAME | VARCHAR2(60) | ../ | gicsIndustryNamegicsIndustryGroupName | |||
gicsNamegicsIndustry | string | 10182 | 10185 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_NAME INDUSTRY | VARCHAR2(60) | ../gicsNamegicsIndustry | ||||
gicsOverrideIndustrygicsIndustryName | string | 10197 | 10186 | 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_ | OVERRIDESUB_INDUSTRY_ | SECTORNAME | VARCHAR2(60) | ../ | gicsOverrideSectorgicsSubIndustryName | |
gicsOverrideSubIndustrygicsOverrideIndustry | string | 10196 | 10197 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_SUB_INDUSTRY | VARCHAR2(60) | ../gicsOverrideSubIndustrygicsOverrideIndustry | ||||
gicsSectorgicsOverrideIndustryGrp | string | 10181 | 10198 | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_SECTOR INDUSTRY_GROUP | VARCHAR2(60) | ../gicsSectorgicsOverrideIndustryGrp | ||||
gicsSubIndustrygicsOverrideSector | string | 1018710199 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUBOVERRIDE_INDUSTRY SECTOR | VARCHAR2(60) | ../gicsSubIndustrygicsOverrideSector | ||||
gicsSubIndustryNamegicsOverrideSubIndustry | string | 10188 | 10196 | 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 |