Extended CA Properties Model Data Map Table

Owned by Dmitry Donosiyan (Unlicensed)
Last updated: Oct 25, 2024 by Kinga Huszno
1 min read

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.

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

<taskParameter> <name>IncludeExtendedDetails</name> <dataType>S</dataType> <value>CA,ALL</value> </taskParameter>

  • 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

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