Voluntary CA Election Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Optional /Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
|
|---|---|---|---|---|---|---|---|---|---|---|---|
objectType |
| ObjectTypeEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/objectType |
| ||
objectId |
| ObjectId |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/objectId |
| ||
objectDescription |
| FeedTypeEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/objectDescription |
| ||
updateTimestamp |
| dateTime |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/updateTimestamp |
| ||
customElements | Not recommended | CustomElements - reserved for customizations | EagleML/referenceTransaction/voluntaryCAElection/customElements |
| |||||||
sourceName |
| string | 1102 |
|
| PACE_MASTERDBO | INTERFACES | SHORT_DESC |
| EagleML/referenceTransaction/voluntaryCAElection/sourceName |
|
updateSource |
| string | 944 | in_update_user | S | SECURITYDBO | VOL_CORP_ACTION_ELECTION | UPDATE_SOURCE | CHAR(255) | EagleML/referenceTransaction/voluntaryCAElection/updateSource |
|
effectiveDate | Required | date | 1109 | in_effective_date | S | SECURITYDBO | VOL_CORP_ACTION_ELECTION | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/voluntaryCAElection/effectiveDate |
|
languageId |
| integer |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/languageId |
| ||
tagNochangecase |
| string |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/tagNochangecase |
| ||
preserveNull |
| string |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/preserveNull |
| ||
noLoadValidationFlag |
| YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/noLoadValidationFlag |
| ||
accountingValidationFlag |
| YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/accountingValidationFlag |
| ||
skipIfExistFlag |
| YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/skipIfExistFlag |
| ||
EagleML/referenceTransaction/voluntaryCAElection/ |
| ||||||||||
clientSpecificCAId |
| string | 1695 | in_cp_counter_party |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CP_COUNTER_PARTY | VARCHAR2(50) | EagleML/referenceTransaction/voluntaryCAElection/clientSpecificCAId |
|
transType |
| CATransTypeEnum | 1257 | in_trans_type |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | TRANS_TYPE | CHAR(30) | EagleML/referenceTransaction/voluntaryCAElection/transType |
|
sweepDate |
| date | 1197 | in_sweep_date |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | SWEEP_DATE | DATE | EagleML/referenceTransaction/voluntaryCAElection/sweepDate |
|
exDate |
| date | 65 | in_cp_ex_dt |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CP_EX_DT | DATE | EagleML/referenceTransaction/voluntaryCAElection/exDate |
|
cpStatus |
| CAStatusEnum | 54 | in_cp_status |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CP_STATUS | VARCHAR2(2) | EagleML/referenceTransaction/voluntaryCAElection/cpStatus |
|
cpReason |
| string | 1728 | in_cp_reason |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CP_REASON | VARCHAR2(50) | EagleML/referenceTransaction/voluntaryCAElection/cpReason |
|
cpInstance |
| integer | 4268 | in_instance |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INSTANCE | NUMBER | EagleML/referenceTransaction/voluntaryCAElection/cpInstance |
|
originalTransType |
| CATransTypeEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/voluntaryCAElection/originalTransType |
| ||
EagleML/referenceTransaction/voluntaryCAElection/ |
| ||||||||||
caElectionType |
| string | 4513 | in_election_type |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | ELECTION_TYPE | VARCHAR2(50) | EagleML/referenceTransaction/voluntaryCAElection/caElectionType |
|
currency |
| CurrencyCode | 1269 | in_currency |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CURRENCY | CHAR(3) | EagleML/referenceTransaction/voluntaryCAElection/currency |
|
electedAmt |
| decimal | 316 | in_elected_amt |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | ELECTED_AMT | NUMBER(28,12) | EagleML/referenceTransaction/voluntaryCAElection/electedAmt |
|
userChar1 |
| string | 4520 | in_user_char1 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | USER_CHAR1 | VARCHAR2(100) | EagleML/referenceTransaction/voluntaryCAElection/userChar1 |
|
userChar2 |
| string | 4521 | in_user_char2 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | USER_CHAR2 | VARCHAR2(100) | EagleML/referenceTransaction/voluntaryCAElection/userChar2 |
|
volPercent |
| decimal | 1001 | in_percent |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | VOL_PERCENT | NUMBER(28,12) | EagleML/referenceTransaction/voluntaryCAElection/volPercent |
|
corpActInstance |
| integer | 4268 | in_corp_act_instance |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CORP_ACT_INSTANCE | NUMBER | EagleML/referenceTransaction/voluntaryCAElection/corpActInstance |
|
consentFlag |
| YesNoOptionEnum | 8097 | in_consent_flag |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CONSENT_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/voluntaryCAElection/consentFlag |
|
consentAmt |
| decimal | 8098 | in_consent_amt |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | CONSENT_AMT | NUMBER(22,12) | EagleML/referenceTransaction/voluntaryCAElection/consentAmt |
|
brokerCode |
| string | 88 | in_broker_code |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | BROKER_CODE | CHAR(20) | EagleML/referenceTransaction/voluntaryCAElection/brokerCode |
|
electedSharesMin |
| decimal | 9612 | in_elected_shares_min |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | ELECTED_SHARES_MIN | NUMBER(28,12) | EagleML/referenceTransaction/voluntaryCAElection/electedSharesMin |
|
internalFloat1 |
| decimal | 9613 | in_internal_float1 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/voluntaryCAElection/internalFloat1 |
|
internalFloat2 |
| decimal | 9706 | in_internal_float2 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/voluntaryCAElection/internalFloat2 |
|
internalFloat3 |
| decimal | 9707 | in_internal_float3 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/voluntaryCAElection/internalFloat3 |
|
internalChar1 |
| string | 9708 | in_internal_char1 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_CHAR1 | VARCHAR2(50) | EagleML/referenceTransaction/voluntaryCAElection/internalChar1 |
|
internalChar2 |
| string | 9709 | in_internal_char2 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_CHAR2 | VARCHAR2(50) | EagleML/referenceTransaction/voluntaryCAElection/internalChar2 |
|
internalChar3 |
| string | 9710 | in_internal_char3 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_CHAR3 | VARCHAR2(50) | EagleML/referenceTransaction/voluntaryCAElection/internalChar3 |
|
preference |
| integer | 9005 | in_preference |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | PREFERENCE | NUMBER | EagleML/referenceTransaction/voluntaryCAElection/preference |
|
batchEventId |
| TransactionId | 701 | in_batch_event_id |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | BATCH_EVENT_ID | VARCHAR2(55) | EagleML/referenceTransaction/voluntaryCAElection/batchEventId |
|
corpActIDLikeMatchFlag |
| YesNoOptionEnum |
|
|
|
|
|
|
| EagleML/referenceTransaction/voluntaryCAElection/corpActIDLikeMatchFlag |
|
prorataCreditNoncreditLossIndicator |
| YesNoOptionEnum | 16157 |
|
|
|
|
|
| EagleML/referenceTransaction/voluntaryCAElection/prorataCreditNoncreditLossIndicator |
|
volRestrictProc |
| YesNoOptionEnum | 16658 | in_VOL_RESTRICT_PROC |
| RULESDBO | ENTITY_STAR_PROCESSING | VOL_RESTRICT_PROC |
| EagleML/referenceTransaction/voluntaryCAElection/volRestrictProc |
|
expiryDate |
| date | 12876 | in_expiry_date |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | EXPIRY_DATE |
| EagleML/referenceTransaction/voluntaryCAElection/expiryDate |
|
expiryDateFlag |
| YesNoOptionEnum | 12877 | in_expiry_date_proc_flag |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | EXPIRY_DATE_PROC_FLAG |
| EagleML/referenceTransaction/voluntaryCAElection/expiryDateFlag |
|
babyBondPrice |
| decimal | 9613 | in_internal_float1 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_FLOAT1 |
| EagleML/referenceTransaction/voluntaryCAElection/babyBondPrice |
|
reorgFee |
| decimal | 9706 | in_internal_float2 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_FLOAT2 |
| EagleML/referenceTransaction/voluntaryCAElection/reorgFee |
|
reorgFeeBase |
| decimal | 9707 | in_internal_float3 |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | INTERNAL_FLOAT3 |
| EagleML/referenceTransaction/voluntaryCAElection/reorgFeeBase |
|
custodianBankCode |
| string | 1176 | in_custody_bank_code |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/referenceTransaction/voluntaryCAElection/custodianBankCode |
|
custodyBankAccount |
| string | 1660 | in_custody_bank_acct_num |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(50) | EagleML/referenceTransaction/voluntaryCAElection/custodyBankAccount |
|
custodyBankSubaccount |
| string | 1661 | in_custody_bank_sub_acct |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_SUB_ACCT | VARCHAR2(30) | EagleML/referenceTransaction/voluntaryCAElection/custodyBankSubaccount |
|
entityBankAlias |
| string | 16 | in_entity_bank_alias |
| SECURITYDBO | VOL_CORP_ACTION_ELECTION | ENTITY_BANK_ALIAS | VARCHAR2(25) | EagleML/referenceTransaction/voluntaryCAElection/entityBankAlias |
|