Versions Compared

Old Version 18

changes.mady.by.user Vitali Kostyrenko

Saved on

compared with

New Version Current

changes.mady.by.user Kinga Huszno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

:
Expand
titleExample of CA only (click to expand)
language
<taskParameter>
	<name>IncludeExtendedDetails</name>
	<dataType>S</dataType>
	<value>CA</value>
</taskParameter>
Code Block
xml

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

:
Expand
titleClick to expand
xml<taskParameter> <name>IncludeExtendedDetails</name> <dataType>S</dataType> <value>Y,CA</value>
</taskParameter>
 Code Block
language
<taskParameter>
	<name>IncludeExtendedDetails</name>
	<dataType>S</dataType>
	<value>CA,ALL</value>
</taskParameter>
 
 Code Block
languagexml
Important:
 Warning
  • 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
61
in_cp_swap_ratio
TRADESDBO
CORP_ACT_HIST
CP_SWAP_RATIO
NUMBER(28,12)
 ../cpSwapRatio
cpTermFlag
decimal
1734
in_cp_term_flag
TRADESDBO
CORP_ACT_HIST
CP_TERM_FLAG
CHAR(2)
 ../cpTermFlag
cpShareTaxability
string
3960
in_cp_share_taxability
TRADESDBO
CORP_ACT_HIST
CP_SHARE_TAXABILITY
CHAR(3)
 ../cpShareTaxability
cpCashTaxability
string
3963
in_cp_cash_taxability
TRADESDBO
CORP_ACT_HIST
CP_CASH_TAXABILITY
CHAR(3)
 ../cpCashTaxability
cpCash
decimal
1692
in_cp_cash
TRADESDBO
CORP_ACT_HIST
CP_CASH
NUMBER(28,12)
 ../cpCash
cpCallPx
decimal
1264
in_cp_call_px
TRADESDBO
CORP_ACT_HIST
CP_CALL_PX
NUMBER(28,12)
 ../cpCallPx
fromFmvPrice
decimal
369
in_from_fmv_price
TRADESDBO
CORP_ACT_HIST
FROM_FMV_PRICE
NUMBER(28,12)
 ../fromFmvPrice
toFmvPrice
decimal
319
in_to_fmv_price
TRADESDBO
CORP_ACT_HIST
TO_FMV_PRICE
NUMBER(28,12)
 ../toFmvPrice
cpNewPx
decimal
1705
in_cp_new_px
TRADESDBO
CORP_ACT_HIST
CP_NEW_PX
NUMBER(28,12)
 ../cpNewPx
consentRt
decimal
8010
in_consent_rt
TRADESDBO
CORP_ACT_HIST
CONSENT_RT
NUMBER(22,12)
 ../consentRt
userGroup1
string
1739
in_user_group1
TRADESDBO
CORP_ACT_HIST
USER_GROUP1
VARCHAR2(255)
 ../userGroup1
userGroup3
string
1741
in_user_group3
TRADESDBO
CORP_ACT_HIST
USER_GROUP3
VARCHAR2(255)
 ../userGroup3
userGroup4
string
1742
in_user_group4
TRADESDBO
CORP_ACT_HIST
USER_GROUP4
VARCHAR2(255)
 ../userGroup4
userGroup5
string
1743
in_user_group5
TRADESDBO
CORP_ACT_HIST
USER_GROUP5
VARCHAR2(255)
 ../userGroup5
cpSubPriority
decimal
3961
in_cp_sub_priority
TRADESDBO
CORP_ACT_HIST
CP_SUB_PRIORITY
NUMBER(28,12)
../cpSubPriority