CaExtensionModel Data Map Table

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

Data Type

Xpath

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

Data Type

Xpath

caheSecurityDescription

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_SECURITY_DESCRIPTION

VARCHAR2(30)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheSecurityDescription

caheIssueCountry

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_ISSUE_COUNTRY

VARCHAR2(3)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheIssueCountry

caheDueBillInd

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_DUE_BILL_IND

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheDueBillInd

caheDueBillOnDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_DUE_BILL_ON_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheDueBillOnDt

caheDueBillOffDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_DUE_BILL_OFF_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheDueBillOffDt

caheCurrentFactor

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_CURRENT_FACTOR

NUMBER(28,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheCurrentFactor

caheRdmpDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_RDMP_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheRdmpDt

caheTradeBeginDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_TRADE_BEGIN_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheTradeBeginDt

caheTradeEndDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_TRADE_END_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheTradeEndDt

caheActionEndDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_ACTION_END_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheActionEndDt

caheActionBeginDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_ACTION_BEGIN_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheActionBeginDt

caheRelatedEventCode

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_RELATED_EVENT_CODE

VARCHAR2(8)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheRelatedEventCode

caheDayCountCode

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_DAY_COUNT_CODE

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheDayCountCode

caheVendorCancelInd

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_VENDOR_CANCEL_IND

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheVendorCancelInd

caheMarketSector

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_MARKET_SECTOR

VARCHAR2(12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheMarketSector

caheAmtTyp

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_AMT_TYP

NUMBER

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheAmtTyp

caheCustodianNumber

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_CUSTODIAN_NUMBER

VARCHAR2(24)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheCustodianNumber

caheMandatoryOptionalInd

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_MANDATORY_OPTIONAL_IND

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheMandatoryOptionalInd

caheMutualFundDateInd

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_MUTUAL_FUND_DATE_IND

VARCHAR2(2)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheMutualFundDateInd

caheHoldingsIndicator

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_HOLDINGS_INDICATOR

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheHoldingsIndicator

caheExpirationDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_EXPIRATION_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheExpirationDt

caheActionStatusCode

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_ACTION_STATUS_CODE

VARCHAR2(2)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheActionStatusCode

caheTermsReq

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_TERMS_REQ

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheTermsReq

caheEligibilityDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_ELIGIBILITY_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheEligibilityDt

caheRecordHoldingDt

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_RECORD_HOLDING_DT

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheRecordHoldingDt

caheUserGroupFlag1

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_FLAG1

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupFlag1

caheUserGroupFlag2

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_FLAG2

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupFlag2

caheUserGroupFlag3

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_FLAG3

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupFlag3

caheUserGroupFlag4

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_FLAG4

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupFlag4

caheUserGroupFlag5

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_FLAG5

VARCHAR2(1)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupFlag5

caheUserGroup1

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP1

VARCHAR2(30)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroup1

caheUserGroup2

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP2

VARCHAR2(30)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroup2

caheUserGroup3

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP3

VARCHAR2(30)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroup3

caheUserGroup4

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP4

VARCHAR2(30)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroup4

caheUserGroup5

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP5

VARCHAR2(30)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroup5

caheUserGroupDate1

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE1

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate1

caheUserGroupDate2

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE2

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate2

caheUserGroupDate3

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE3

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate3

caheUserGroupDate4

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE4

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate4

caheUserGroupDate5

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE5

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate5

caheUserGroupNumber1

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_NUMBER1

NUMBER(28,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupNumber1

caheUserGroupNumber2

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_NUMBER2

NUMBER(28,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupNumber2

caheUserGroupNumber3

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_NUMBER3

NUMBER(28,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupNumber3

caheUserGroupNumber4

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_NUMBER4

NUMBER(28,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupNumber4

caheUserGroupNumber5

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_NUMBER5

NUMBER(28,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupNumber5

caheUserGroupSector1

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_SECTOR1

NUMBER

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupSector1

caheUserGroupSector2

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_SECTOR2

NUMBER

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupSector2

caheUserGroupSector3

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_SECTOR3

NUMBER

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupSector3

caheUserGroupSector4

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_SECTOR4

NUMBER

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupSector4

caheUserGroupSector5

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_SECTOR5

NUMBER

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupSector5

caheUserGroupChar1

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_CHAR1

VARCHAR2(12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupChar1

caheUserGroupChar2

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_CHAR2

VARCHAR2(12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupChar2

caheUserGroupChar3

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_CHAR3

VARCHAR2(12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupChar3

caheUserGroupChar4

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_CHAR4

VARCHAR2(12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupChar4

caheUserGroupChar5

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_CHAR5

VARCHAR2(12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupChar5

caheUserGroupDate6

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE6

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate6

caheUserGroupDate7

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE7

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate7

caheUserGroupDate8

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE8

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate8

caheUserGroupDate9

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE9

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate9

caheUserGroupDate10

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE10

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate10

caheUserGroupDate11

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE11

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate11

caheUserGroupDate12

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE12

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate12

caheUserGroupDate13

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE13

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate13

caheUserGroupDate14

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE14

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate14

caheUserGroupDate15

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CAHE_USER_GROUP_DATE15

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/caheUserGroupDate15

installDate

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

INSTALL_DATE

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/installDate

provisional

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

PROVISIONAL

VARCHAR2(50)

 EagleML/referenceTransaction/genericCA/caExtensionModel/provisional

oldCountry

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OLD_COUNTRY

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/oldCountry

oldBelgian

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OLD_BELGIAN

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/oldBelgian

oldFonds

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OLD_FONDS

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/oldFonds

oldSicovam

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OLD_SICOVAM

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/oldSicovam

oldValor

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OLD_VALOR

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/oldValor

newValor

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

NEW_VALOR

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/newValor

oldWpk

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OLD_WPK

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/oldWpk

newWpk

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

NEW_WPK

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/newWpk

oldCommon

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OLD_COMMON

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/oldCommon

preDayCntDes

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

PRE_DAY_CNT_DES

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/preDayCntDes

postDayCntDes

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

POST_DAY_CNT_DES

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/postDayCntDes

redenomMethod

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

REDENOM_METHOD

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/redenomMethod

preEuroCalendarCode

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

PRE_EURO_CALENDAR_CODE

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/preEuroCalendarCode

postEuroCalendarCode

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

POST_EURO_CALENDAR_CODE

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/postEuroCalendarCode

preEuroMinPiece

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

PRE_EURO_MIN_PIECE

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/preEuroMinPiece

postEuroMinPiece

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

POST_EURO_MIN_PIECE

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/postEuroMinPiece

preEuroMinIncrement

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

PRE_EURO_MIN_INCREMENT

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/preEuroMinIncrement

postEuroMinIncrement

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

POST_EURO_MIN_INCREMENT

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/postEuroMinIncrement

corpActionType

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CORP_ACTION_TYPE

VARCHAR2(50)

 EagleML/referenceTransaction/genericCA/caExtensionModel/corpActionType

cpMergewName

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_MERGEW_NAME

VARCHAR2(255)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpMergewName

cpIndicator

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_INDICATOR

VARCHAR2(5)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpIndicator

termsFlag

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

TERMS_FLAG

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/termsFlag

dollarValue

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

DOLLAR_VALUE

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/dollarValue

international

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

INTERNATIONAL

VARCHAR2(10)

 EagleML/referenceTransaction/genericCA/caExtensionModel/international

internationalShOffer

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

INTERNATIONAL_SH_OFFER

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/internationalShOffer

internationalAmtOffer

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

INTERNATIONAL_AMT_OFFER

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/internationalAmtOffer

totAmtCrncy

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

TOT_AMT_CRNCY

VARCHAR2(5)

 EagleML/referenceTransaction/genericCA/caExtensionModel/totAmtCrncy

cpCouponType

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_COUPON_TYPE

VARCHAR2(5)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpCouponType

dtFlag

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

DT_FLAG

VARCHAR2(5)

 EagleML/referenceTransaction/genericCA/caExtensionModel/dtFlag

percentOwned

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

PERCENT_OWNED

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/percentOwned

percentSought

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

PERCENT_SOUGHT

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/percentSought

cpAccntMethod

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_ACCNT_METHOD

VARCHAR2(5)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpAccntMethod

unsolicited

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

UNSOLICITED

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/unsolicited

detailFlag

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

DETAIL_FLAG

VARCHAR2(5)

 EagleML/referenceTransaction/genericCA/caExtensionModel/detailFlag

cpCashValue

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_CASH_VALUE

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpCashValue

cpArbitrageProfit

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_ARBITRAGE_PROFIT

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpArbitrageProfit

cpCurrentTotalValue

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_CURRENT_TOTAL_VALUE

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpCurrentTotalValue

numberOfAdvisors

 

 

integer

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

NUMBER_OF_ADVISORS

NUMBER(38)

 EagleML/referenceTransaction/genericCA/caExtensionModel/numberOfAdvisors

advisors

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

ADVISORS

VARCHAR2(320)

 EagleML/referenceTransaction/genericCA/caExtensionModel/advisors

installAmount

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

INSTALL_AMOUNT

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/installAmount

securityId

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

SECURITY_ID

VARCHAR2(30)

 EagleML/referenceTransaction/genericCA/caExtensionModel/securityId

securityIdType

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

SECURITY_ID_TYPE

VARCHAR2(20)

 EagleML/referenceTransaction/genericCA/caExtensionModel/securityIdType

ticker1

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

TICKER1

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/ticker1

ticker2

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

TICKER2

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/ticker2

ticker3

 

 

string

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

TICKER3

VARCHAR2(15)

 EagleML/referenceTransaction/genericCA/caExtensionModel/ticker3

cpAmount2

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_AMOUNT2

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpAmount2

cpAmount3

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_AMOUNT3

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpAmount3

despatchDate

 

 

date

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

DESPATCH_DATE

DATE

 EagleML/referenceTransaction/genericCA/caExtensionModel/despatchDate

optionNumber

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

OPTION_NUMBER

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/optionNumber

dripDiscount

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

DRIP_DISCOUNT

NUMBER(38)

 EagleML/referenceTransaction/genericCA/caExtensionModel/dripDiscount

cpEusdTid

 

 

decimal

 

 

TRADESDBO

CORP_ACT_HIST_EXTENSION

CP_EUSD_TID

NUMBER(38,12)

 EagleML/referenceTransaction/genericCA/caExtensionModel/cpEusdTid

Â