...
Element | Optional/Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | XPath | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/objectType | |||||||||||||||
objectId | Optional | ObjectId | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/objectId | |||||||||||||||
objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/objectDescription | |||||||||||||||
updateTimestamp | Optional | dateTime | 1106 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | UPDATE_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/updateTimestamp | |||||||||||
customElements | Optional | CustomElements | reserved for customizations | EagleML/accountingTransaction/subscribeRedeem/customElements | |||||||||||||||
updateSource | Optional | string | 944 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/subscribeRedeem/updateSource | |||||||||||
Entity Common Id Model | EagleML/accountingTransaction/subscribeRedeem/ | ||||||||||||||||||
Asset Identifiers Model | EagleML/accountingTransaction/subscribeRedeem/ | ||||||||||||||||||
postDate | Optional | date | 30 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POST_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/postDate | |||||||||||
tradeDate | Optional | date | 35 | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/tradeDate | ||||||||||||||
settlementDate | Optional | date | 37 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CONTRACT_SETTLE_DT | DATE | EagleML/accountingTransaction/subscribeRedeem/settlementDate | |||||||||||
effectiveDate | Optional | date | 1109 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | EFFECTIVE_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/effectiveDate | |||||||||||
accountingDate | Optional | date | 36 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | ACCOUNTING_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/accountingDate | |||||||||||
navSequence | Optional | integer | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NAV_SEQUENCE | INTEGER | EagleML/accountingTransaction/subscribeRedeem/navSequence | ||||||||||||
shareClass | Optional | string | 34 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SHARE_CLASS | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/shareClass | |||||||||||
clientInstance | Optional | string | 1632 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CLIENT_INSTANCE | CHAR(12) | EagleML/accountingTransaction/subscribeRedeem/clientInstance | |||||||||||
globalShareRef | Optional | integer | 3202 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | GLOBAL_SHARE_REF | INTEGER | EagleML/accountingTransaction/subscribeRedeem/globalShareRef | |||||||||||
navEstQuality | Optional | string | 3194 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NAV_EST_QUALITY | VARCHAR2(5) | EagleML/accountingTransaction/subscribeRedeem/navEstQuality | |||||||||||
navPerShare | Optional | decimal | 3195 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NAV_PER_SHARE | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/navPerShare | |||||||||||
cashPikFlag | Optional | CashPikIndicatorEnum | 3204 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CASH_PIK_FLAG | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/cashPikFlag | |||||||||||
pikAsset | Optional | Asset Identifiers Model - (see extra table) | EagleML/accountingTransaction/subscribeRedeem/pikAsset/ | ||||||||||||||||
ruleInstance | Optional | integer | ESTAR | ESTAR_SUBSCRIBE_REDEEM | APPLIED_RULE_ID | INTEGER | EagleML/accountingTransaction/subscribeRedeem/ruleInstance | ||||||||||||
feeAmount | Optional | decimal | 3206 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | FEE_AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/feeAmount | |||||||||||
subRedIndicator | Optional | SubRedIndicatorEnum | 3198 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SUB_RED_INDICATOR | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/subRedIndicator | |||||||||||
grossAmount | Optional | decimal | 3207 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | GROSS_AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/grossAmount | |||||||||||
netAmount | Optional | decimal | 50 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NET_AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/netAmount | |||||||||||
grossShareIndicator | Optional | GrossShareIndicatorEnum | 3235 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | GROSS_SHARE_INDICATOR | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/grossShareIndicator | |||||||||||
sharesInTransaction | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SHARES_IN_TRANSACTION | NUMBER(38,8) | EagleML/accountingTransaction/subscribeRedeem/sharesInTransaction | ||||||||||||
cumulativeShareBal | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CUMULATIVE_SHARE_BAL | NUMBER(38,8) | EagleML/accountingTransaction/subscribeRedeem/cumulativeShareBal | ||||||||||||
activeFlag | Optional | YesNoOptionEnum | 1283 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | ACTIVE_FLAG | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/activeFlag | |||||||||||
eventId | Optional | TransactionId | 25 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/subscribeRedeem/eventId | |||||||||||
cancelEventId | Optional | TransactionId | 26 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/subscribeRedeem/cancelEventId | |||||||||||
settledShares | Optional | decimal | 758 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SETTLED_SHARES | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/settledShares | |||||||||||
tradedShares | Optional | decimal | 430 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | TRADED_SHARES | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/tradedShares | |||||||||||
transType | Optional | string | 1257 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | TRANS_TYPE | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/transType | |||||||||||
entranceFee | Optional | decimal | 52 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | ENTRANCE_FEE | NUMBER | EagleML/accountingTransaction/subscribeRedeem/entranceFee | |||||||||||
fxRate | Optional | decimal | 87 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | FX_RATE | NUMBER(38,9) | EagleML/accountingTransaction/subscribeRedeem/fxRate | |||||||||||
paidInCapLocal | Optional | decimal | 773 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_L | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/paidInCapLocal | |||||||||||
paidInCapBase | Optional | decimal | 774 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_B | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/paidInCapBase | |||||||||||
dilution | Optional | decimal | 4611 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DILUTION | NUMBER(38,9) | EagleML/accountingTransaction/subscribeRedeem/dilution | |||||||||||
dilutionPerShare | Optional | decimal | 4612 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DILUTION_PER_SHARE | NUMBER(38,9) | EagleML/accountingTransaction/subscribeRedeem/dilutionPerShare | |||||||||||
notes | Optional | string | 5310 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NOTES | VARCHAR2(4000) | EagleML/accountingTransaction/subscribeRedeem/notes | |||||||||||
postingAmtA | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_A | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtA | ||||||||||||
postingAmtB | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_B | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtB | ||||||||||||
postingAmtC | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_C | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtC | ||||||||||||
postingAmtD | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_D | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtD | ||||||||||||
postingAmtE | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_E | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtE | ||||||||||||
postingAmtF | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_F | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtF | ||||||||||||
postingAmtG | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_G | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtG | ||||||||||||
postingAmtH | Optional | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_H | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtH | ||||||||||||
monthEndDate | Optional | date | 4733 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | MONTH_END_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/monthEndDate | |||||||||||
recPayAccount | Optional | string | 1825 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | REC_PAY_ACCT1 | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/recPayAccount | |||||||||||
recPayAccount2 | Optional | string | 1826 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | REC_PAY_ACCT2 | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/recPayAccount2 | |||||||||||
eventType | Optional | string | 2362 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | EVENT_TYPE | VARCHAR2(32) | EagleML/accountingTransaction/subscribeRedeem/eventType | |||||||||||
settledSharesActivity | Optional | decimal | 11714 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SETTLED_SHARES_ACTIVITY | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/settledSharesActivity | |||||||||||
settlementMethod | Optional | string | 629 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SETTLEMENT_METHOD | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/settlementMethod | |||||||||||
cancelTransType | Optional | string | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_TRANS_TYPE | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/cancelTransType | ||||||||||||
deemedIncome | Optional | decimal | 2790 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DEEMED_INCOME | NUMBER(38,12) | EagleML/accountingTransaction/subscribeRedeem/deemedIncome | |||||||||||
deemedIncomeLocal | Optional | decimal | 2832 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DEEMED_INCOME_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/subscribeRedeem/deemedIncomeLocal | |||||||||||
cancelFlag | Optional | YesNoOptionEnum | 10045 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_FLAG | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/cancelFlag | |||||||||||
cancelType | Optional | string | 2981 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_TYPE | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/cancelType | |||||||||||
instance | Optional | integer | 1306 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | TRANSACTION_ID | INTEGER | EagleML/accountingTransaction/subscribeRedeem/instance | |||||||||||
Shareholder Activity Model (extract-only, see extra data map table) | EagleML/accountingTransaction/subscribeRedeem/ | ||||||||||||||||||
SubscribeRedeemCalcFields Model (extract-only) | EagleML/accountingTransaction/subscribeRedeem/ | ||||||||||||||||||
Anchor | Shareholder_Activity | Shareholder_Activity | Shareholder Activity Model (extract-only)This is an extract-only | model, added to the extract by includeShareholderActivity=Y task parameter in the RTR.||||||||||||||||
Element | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | classCode | string | RULESDBO | ENTITY_SHARE_CLASS | CLASS_CODE | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/classCode | className | string | RULESDBO | ENTITY_SHARE_CLASS | CLASS_NAME | VARCHAR2(60) | EagleML/accountingTransaction/subscribeRedeem/className | classStatus | string | RULESDBO | ENTITY_SHARE_CLASS | CLASS_STATUS | VARCHAR2(15) | EagleML/accountingTransaction/subscribeRedeem/classStatus | sharesCount | integer | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/sharesCount |
heldAsset | Asset Identifiers Model | EagleML/accountingTransaction/subscribeRedeem/heldAsset/ | transferAgency | string | RULESDBO | ENTITY_SHARE_CLASS | TRANSFER_AGENCY | VARCHAR2(60) | EagleML/accountingTransaction/subscribeRedeem/transferAgency | taCode | string | RULESDBO | ENTITY_SHARE_CLASS | TA_CODE | VARCHAR2(15) | EagleML/accountingTransaction/subscribeRedeem/taCode | shareClassNasdaqSymbol | string | RULESDBO | ENTITY_SHARE_CLASS | NASDAQ_SYMBOL | CHAR(100) | EagleML/accountingTransaction/subscribeRedeem/shareClassNasdaqSymbol | classTerminationDt | date | RULESDBO | ENTITY_SHARE_CLASS | CLASS_TERMINATION_DT | DATE | EagleML/accountingTransaction/subscribeRedeem/classTerminationDt | classTicker | string | RULESDBO | ENTITY_SHARE_CLASS | TICKER | VARCHAR2(100) | EagleML/accountingTransaction/subscribeRedeem/classTicker | classCusip | string | RULESDBO | ENTITY_SHARE_CLASS | CUSIP | VARCHAR2(100) | EagleML/accountingTransaction/subscribeRedeem/classCusip | classIsin | string | RULESDBO | ENTITY_SHARE_CLASS | ISIN | VARCHAR2(100) | EagleML/accountingTransaction/subscribeRedeem/classIsin | dailyFixedDistRate | decimal | RULESDBO | ENTITY_SHARE_CLASS | DAILY_FIXED_DIST_RATE | NUMBER(32,12) | EagleML/accountingTransaction/subscribeRedeem/dailyFixedDistRate | monthlyDistRate | decimal | RULESDBO | ENTITY_SHARE_CLASS | MONTHLY_DIST_RATE | NUMBER(32,12) | EagleML/accountingTransaction/subscribeRedeem/monthlyDistRate | inceptionNav | decimal | RULESDBO | ENTITY_SHARE_CLASS | INCEPTION_NAV | NUMBER(32,12
) | EagleML/accountingTransaction/subscribeRedeem/ | securityIdentifier | string | RULESDBO | ENTITY_SHARE_CLASS | SECURITY_IDENTIFIER | CHAR(100) | EagleML/accountingTransaction/subscribeRedeem/securityIdentifier | nasdaqListingStartDate | date | RULESDBO | ENTITY_SHARE_CLASS | NASDAQ_LISTING_START_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/nasdaqListingStartDate | nasdaqListingEndDate | date | RULESDBO | ENTITY_SHARE_CLASS | NASDAQ_LISTING_END_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/nasdaqListingEndDate | loadCharge | decimal | RULESDBO | ENTITY_SHARE_CLASS | LOAD_CHARGE | NUMBER(28,12) | EagleML/accountingTransaction/subscribeRedeem/loadCharge | loadEffectiveDate | date | RULESDBO | ENTITY_SHARE_CLASS | LOAD_EFFECTIVE_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/loadEffectiveDate | userChar1 | string | RULESDBO | ENTITY_SHARE_CLASS | USER_CHAR1 | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/userChar1 | userChar2 | string | RULESDBO | ENTITY_SHARE_CLASS | USER_CHAR2 | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/userChar2 | ind12b1 | string | RULESDBO | ENTITY_SHARE_CLASS | IND_12B1 | VARCHAR2(3) | EagleML/accountingTransaction/subscribeRedeem/ind12b1 | navCurrency | string | RULESDBO | ENTITY_SHARE_CLASS | NAV_CURRENCY | CHAR(3) | EagleML/accountingTransaction/subscribeRedeem/navCurrency | exchange | string | RULESDBO | ENTITY_SHARE_CLASS | EXCHANGE | VARCHAR2(8) | EagleML/accountingTransaction/subscribeRedeem/exchange | classInceptionDate | date | RULESDBO | ENTITY_SHARE_CLASS | CLASS_INCEPTION_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/classInceptionDate | heldAsSecurity | string | RULESDBO | ENTITY_SHARE_CLASS | HELD_AS_SECURITY | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/heldAsSecurity | navPricePrecision | integer | RULESDBO | ENTITY_SHARE_CLASS | NAV_PRICE_PRECISION | NUMBER | EagleML/accountingTransaction/subscribeRedeem/navPricePrecision | bidSpreadFactor | decimal | RULESDBO | ENTITY_SHARE_CLASS | BID_SPREAD_FACTOR | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/bidSpreadFactor | bidFormula | string | RULESDBO | ENTITY_SHARE_CLASS | BID_FORMULA | VARCHAR2(20) | EagleML/accountingTransaction/subscribeRedeem/bidFormula | offerSpreadFactor | decimal | RULESDBO | ENTITY_SHARE_CLASS | OFFER_SPREAD_FACTOR | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/offerSpreadFactor | offerFormula | string | RULESDBO | ENTITY_SHARE_CLASS | OFFER_FORMULA | VARCHAR2(20) | EagleML/accountingTransaction/subscribeRedeem/offerFormula | euroEqualMethod | string | RULESDBO | ENTITY_SHARE_CLASS | EURO_EQUAL_METHOD | VARCHAR2(15) | EagleML/accountingTransaction/subscribeRedeem/euroEqualMethod | baseClass | string | RULESDBO | ENTITY_SHARE_CLASS | BASE_CLASS | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/baseClass | contractualExpRatio | decimal | RULESDBO | ENTITY_SHARE_CLASS | CONTRACTUAL_EXP_RATIO | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/contractualExpRatio | shareClassId | string | RULESDBO | ENTITY_SHARE_CLASS | SHARE_CLASS_ID | CHAR(8) | EagleML/accountingTransaction/subscribeRedeem/shareClassId | minimumYield | decimal | RULESDBO | ENTITY_SHARE_CLASS | MINIMUM_YIELD | NUMBER(38,12) | EagleML/accountingTransaction/subscribeRedeem/minimumYield | niiDistributionMethod | string | RULESDBO | ENTITY_SHARE_CLASS | NII_DISTRIBUTION_METHOD | VARCHAR2(25) | EagleML/accountingTransaction/subscribeRedeem/niiDistributionMethod
This is an extract-only model, added to the extract by IncludeSubscribeReedemCalcFields=Y RTR parameter | |||||||||||||||||||
Element | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | |||||||||||
grossAmountBase | decimal | EagleML/accountingTransaction/subscribeRedeem/grossAmountBase | |||||||||||||||||
grossAmountLocal | decimal | EagleML/accountingTransaction/subscribeRedeem/grossAmountLocal | |||||||||||||||||
netAmountBase | decimal | EagleML/accountingTransaction/subscribeRedeem/netAmountBase | |||||||||||||||||
netAmountLocal | decimal | EagleML/accountingTransaction/subscribeRedeem/netAmountLocal | |||||||||||||||||
parValue | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_G | EagleML/accountingTransaction/subscribeRedeem/parValue | ||||||||||||||
paidInSurplusBase | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_B | EagleML/accountingTransaction/subscribeRedeem/paidInSurplusBase | ||||||||||||||
paidInSurplusLocal | decimal | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_L | EagleML/accountingTransaction/subscribeRedeem/paidInSurplusLocal | ||||||||||||||
navImpactPerShare | string | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DILUTION | EagleML/accountingTransaction/subscribeRedeem/navImpactPerShare |
...