Asset Properties Model Data Map Table

While the names are similar, Asset Properties and Extended Asset Properties are different models.

This model is extract-only. There are several options for it:

Extract nothing (default);
Extract only the Asset Properties model (this page). To do this, you need the IncludeAssetProperties=Y task parameter on your RTR, or its global variant W_INCLUDE_ASSET_PROPERTIES;

Extract Extended Asset Properties model, either partially or full, including the Asset Properties model. To do this, specify IncludeExtendedDetails=Y or ALL task parameter on your RTR. In other words, IncludeExtendedDetails=Y or ALL equals extraction with IncludeAssetProperties=Y task parameter plus several additional fields.

Element	Value Type	Eagle DB	DB Table	DB Field	DB Field Type	Xpath

Element	Value Type	Eagle DB	DB Table	DB Field	DB Field Type	Xpath
investmentType	StringWithCodeScheme	SECURITYDBO	SECURITY_MASTER	INVESTMENT_TYPE	CHAR(4)	…/investmentType
processingSecurityType	StringWithCodeScheme	SECURITYDBO	SECURITY_MASTER	PROCESS_SEC_TYPE	VARCHAR2(15)	…/processingSecurityType
securityType	string	SECURITYDBO	SECURITY_MASTER	SECURITY_TYPE	CHAR(15)	…/securityType
releaseStatus	string	SECURITYDBO	SECURITY_MASTER	RELEASE_STATUS	CHAR(1)	…/releaseStatus
issueCountryCode	CountryCode	SECURITYDBO	SECURITY_MASTER	NRA_TAX_COUNTRY	CHAR(30)	…/issueCountryCode
couponTypeCode	StringWithCodeScheme	SECURITYDBO	SECURITY_MASTER	COUPON_TYPE_CODE	CHAR(8)	…/couponTypeCode
smSettlementCurrency	CurrencyCode	SECURITYDBO	SECURITY_MASTER	SETTLEMENT_CURRENCY	CHAR(3)	…/smSettlementCurrency
smSecurityType	string	SECURITYDBO	SECMASTER_DETAIL_EXT	SECURITY_TYPE	VARCHAR2(60)	…/smSecurityType
securityType2	string	SECURITYDBO	SECMASTER_DETAIL_EXT	SECURITY_TYPE2	VARCHAR2(30)	…/securityType2
securitySubType	string	SECURITYDBO	SECURITY_MASTER_DETAIL	ALT_SECURITY_TYPE	CHAR(15)	…/securitySubType