Extended CA Properties Model Data Map Table

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, (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.

Element	Value Type	Star Tag	SP Parameter	Eagle DB	DB Table	DB Field	DB Field Type	Xpath
transType	CATransTypeEnum	1257	in_trans_type	TRADESDBO	CORP_ACT_HIST	TRANS_TYPE	CHAR(30)	../transType
sweepDate	date	1197	in_sweep_date	TRADESDBO	CORP_ACT_HIST	SWEEP_DATE	DATE	../sweepDate
cpStatus	CAStatusEnum	54	in_cp_status	TRADESDBO	CORP_ACT_HIST	CP_STATUS	VARCHAR2(2)	../cpStatus
cpReason	string	1728	in_cp_reason	TRADESDBO	CORP_ACT_HIST	CP_REASON	VARCHAR2(50)	../cpReason
splitRatio	decimal	1001	in_split_ratio	TRADESDBO	CORP_ACT_HIST	SPLIT_RATIO	NUMBER(28,12)	../splitRatio
cpDebt	decimal	1696	in_cp_debt	TRADESDBO	CORP_ACT_HIST	CP_DEBT	NUMBER(28,12)	../cpDebt
cpSwapRatio	decimal			TRADESDBO	CORP_ACT_HIST	CP_SWAP_RATIO	NUMBER(28,12)	../cpSwapRatio
cpTermFlag	decimal			TRADESDBO	CORP_ACT_HIST	CP_TERM_FLAG	CHAR(2)	../cpTermFlag