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.
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).
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 |