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 14 Next »

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

  • WRHSTRADEEXTRACT,
  • 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
cpSwapRatiodecimal61
TRADESDBOCORP_ACT_HISTCP_SWAP_RATIONUMBER(28,12) ../cpSwapRatio
cpTermFlagdecimal1734
TRADESDBOCORP_ACT_HISTCP_TERM_FLAGCHAR(2) ../cpTermFlag
cpShareTaxabilitystring3960
TRADESDBOCORP_ACT_HISTCP_SHARE_TAXABILITY
 ../cpShareTaxability
cpCashTaxabilitystring3963
TRADESDBOCORP_ACT_HISTCP_CASH_TAXABILITY
 ../cpCashTaxability
cpCashdecimal1692
TRADESDBOCORP_ACT_HISTCP_CASH
 ../cpCash
cpCallPxdecimal1264
TRADESDBOCORP_ACT_HISTCP_CALL_PX
 ../cpCallPx
fromFmvPricedecimal369
TRADESDBOCORP_ACT_HISTFROM_FMV_PRICE
 ../fromFmvPrice
toFmvPricedecimal319
TRADESDBOCORP_ACT_HISTTO_FMV_PRICE
 ../toFmvPrice
cpNewPxdecimal1705
TRADESDBOCORP_ACT_HISTCP_NEW_PX
 ../cpNewPx
consentRtdecimal8010
TRADESDBOCORP_ACT_HISTCONSENT_RT
 ../consentRt
userGroup1string1739
TRADESDBOCORP_ACT_HISTUSER_GROUP1
 ../userGroup1
userGroup3string1741
TRADESDBOCORP_ACT_HISTUSER_GROUP3
 ../userGroup3
userGroup4string1742
TRADESDBOCORP_ACT_HISTUSER_GROUP4
 ../userGroup4
userGroup5string1743
TRADESDBOCORP_ACT_HISTUSER_GROUP5
 ../userGroup5
  • No labels