Note
Note
This model 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.
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 |
annualDividend | decimal | 3233 |
| SECURITYDBO | EQUITY | ANNUAL_DIVIDEND | NUMBER(28,12) | ../annualDividend |
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 |
gicsIndustry | string | 10185 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY | VARCHAR2(60) | ../gicsIndustry |
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 |
gicsIndustryName | string | 10186 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_NAME | VARCHAR2(60) | ../gicsIndustryName |
gicsName | string | 10182 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_NAME | VARCHAR2(60) | ../gicsName |
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 |
gicsSector | string | 10181 |
| SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SECTOR | VARCHAR2(60) | ../gicsSector |
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 |
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 |