Extended Asset Properties Model Data Map Table
- Copy Page Tree (Unlicensed)
- Kinga Huszno
- Pamela Totas (Deactivated)
- Dmitry Donosiyan (Unlicensed)
While the names are similar, Asset Properties and Extended Asset Properties are different models
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 |
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 |
gicsSector | string | 10181 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SECTOR | VARCHAR2(60) | ../gicsSector |
gicsSectorName | string | 10182 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SECTOR_NAME |
| ../gicsSectorName |
gicsIndustryGroup | string | 10183 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_GROUP | VARCHAR2(60) | ../gicsIndustryGroup |
gicsIndustryGroupName | string | 10184 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_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 |
gicsSubIndustry | string | 10187 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUB_INDUSTRY | VARCHAR2(60) | ../gicsSubIndustry |
gicsSubIndustryName | string | 10188 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_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 |
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 |