Extended Asset Properties Model Data Map

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 for WRHSTRADEEXTRACT, TRADEDCAEXTRACT or SETTLEDCAEXTRACT, please refer to Extended CA Properties Model Data Map

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
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