Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »

Extended CA model is extract-only and available only for a limited number of feed types:

  • WRHSTRADEEXTRACT,
  • WRHSCLOSELOTEXTRACT,
  • TRADEDCAEXTRACT,
  • SETTLEDCAEXTRACT.

To extract the model, add the value CA to the IncludeExtendedDetails parameter.

 Example of CA only (click to expand):
<taskParameter>
	<name>IncludeExtendedDetails</name>
	<dataType>S</dataType>
	<value>CA</value>
</taskParameter>

If you use IncludeExtendedDetails = Y or ALL and want to extract Extended CA as well, add it comma-separated as in the examples below, (the order is not relevant).

 Click to expand:
<taskParameter>
	<name>IncludeExtendedDetails</name>
	<dataType>S</dataType>
	<value>CA,ALL</value>
</taskParameter> 
<taskParameter>
	<name>IncludeExtendedDetails</name>
	<dataType>S</dataType>
	<value>Y,CA</value>
</taskParameter>

Important:

  • Y and ALL values apply to SMF- and Entity-related fields only. IncludeExtendedDetails = ALL will not extract CA-related fields. This is expected behavior. To extract the newly added fields, specify CA within the value of IncludeExtendedDetails.
  • New functionality is applicable to streaming extracts only. Non-streaming are not supported.


ElementValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpath
transTypeCATransTypeEnum1257in_trans_typeTRADESDBOCORP_ACT_HISTTRANS_TYPECHAR(30) ../transType
sweepDatedate1197in_sweep_dateTRADESDBOCORP_ACT_HISTSWEEP_DATEDATE ../sweepDate
cpStatusCAStatusEnum54in_cp_statusTRADESDBOCORP_ACT_HISTCP_STATUSVARCHAR2(2) ../cpStatus
cpReasonstring1728in_cp_reasonTRADESDBOCORP_ACT_HISTCP_REASONVARCHAR2(50) ../cpReason
splitRatiodecimal1001in_split_ratioTRADESDBOCORP_ACT_HISTSPLIT_RATIONUMBER(28,12) ../splitRatio
cpDebtdecimal1696in_cp_debtTRADESDBOCORP_ACT_HISTCP_DEBTNUMBER(28,12) ../cpDebt
cpSwapRatiodecimal61in_cp_swap_ratioTRADESDBOCORP_ACT_HISTCP_SWAP_RATIONUMBER(28,12) ../cpSwapRatio
cpTermFlagdecimal1734in_cp_term_flagTRADESDBOCORP_ACT_HISTCP_TERM_FLAGCHAR(2) ../cpTermFlag
cpShareTaxabilitystring3960in_cp_share_taxabilityTRADESDBOCORP_ACT_HISTCP_SHARE_TAXABILITYCHAR(3) ../cpShareTaxability
cpCashTaxabilitystring3963in_cp_cash_taxabilityTRADESDBOCORP_ACT_HISTCP_CASH_TAXABILITYCHAR(3) ../cpCashTaxability
cpCashdecimal1692in_cp_cashTRADESDBOCORP_ACT_HISTCP_CASHNUMBER(28,12) ../cpCash
cpCallPxdecimal1264in_cp_call_pxTRADESDBOCORP_ACT_HISTCP_CALL_PXNUMBER(28,12) ../cpCallPx
fromFmvPricedecimal369in_from_fmv_priceTRADESDBOCORP_ACT_HISTFROM_FMV_PRICENUMBER(28,12) ../fromFmvPrice
toFmvPricedecimal319in_to_fmv_priceTRADESDBOCORP_ACT_HISTTO_FMV_PRICENUMBER(28,12) ../toFmvPrice
cpNewPxdecimal1705in_cp_new_pxTRADESDBOCORP_ACT_HISTCP_NEW_PXNUMBER(28,12) ../cpNewPx
consentRtdecimal8010in_consent_rtTRADESDBOCORP_ACT_HISTCONSENT_RTNUMBER(22,12) ../consentRt
userGroup1string1739in_user_group1TRADESDBOCORP_ACT_HISTUSER_GROUP1VARCHAR2(255) ../userGroup1
userGroup3string1741in_user_group3TRADESDBOCORP_ACT_HISTUSER_GROUP3VARCHAR2(255) ../userGroup3
userGroup4string1742in_user_group4TRADESDBOCORP_ACT_HISTUSER_GROUP4VARCHAR2(255) ../userGroup4
userGroup5string1743in_user_group5TRADESDBOCORP_ACT_HISTUSER_GROUP5VARCHAR2(255) ../userGroup5
cpSubPrioritydecimal3961in_cp_sub_priorityTRADESDBOCORP_ACT_HISTCP_SUB_PRIORITYNUMBER(28,12)../cpSubPriority
  • No labels