Extended CA model is extract-only and available only for a limited number of feedtypes:
- WRHSTRADEEXTRACT,
- TRADEDCAEXTRACT,
- SETTLEDCAEXTRACT.
To extract it please add the value CA to the IncludeExtendedDetails parameter
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).
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, one should 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 | 1259 | in_div_amt | TRADESDBO | CORP_ACT_HIST | CP_SWAP_RATIO | NUMBER(28,12) | ../cpSwapRatio |
cpTermFlag | decimal | 1686 | in_cp_added_amt | TRADESDBO | CORP_ACT_HIST | CP_TERM_FLAG | CHAR(2) | ../cpTermFlag |