Warehouse NAV Multi Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Also in this page:
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/warehouseTransaction/warehouseNAVMulti/objectType | |||
objectId |
| ObjectId |
|
|
| not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/objectId | |||
objectDescription |
| FeedTypeEnum |
|
|
| not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/objectDescription | |||
updateTimestamp |
| dateTime |
|
|
| HOLDINGDBO | NAV_MULTI | UPDATE_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/updateTimestamp |
customElements |
| CustomElements |
|
|
| reserved for customization |
| EagleML/warehouseTransaction/warehouseNAVMulti/customElements/ | ||
sourceName | Required | string |
|
|
|
|
|
| CHAR(15) | EagleML/warehouseTransaction/warehouseNAVMulti/sourceName |
updateSource |
| string |
|
|
| HOLDINGDBO | NAV_MULTI | UPDATE_SOURCE | VARCHAR2(32) | EagleML/warehouseTransaction/warehouseNAVMulti/updateSource |
batchCollectErrorsFlag |
| YesNoOptionEnum |
|
|
| not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/batchCollectErrorsFlag | |||
singleRowCommitFlag |
| YesNoOptionEnum |
|
|
| not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/singleRowCommitFlag | |||
reportType |
| FundReportTypeEnum |
|
|
|
|
| |||
EagleML/warehouseTransaction/warehouseNAVMulti/ | ||||||||||
EagleML/warehouseTransaction/warehouseNAVMulti/ | ||||||||||
accountingBasis |
| string |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseNAVMulti/accountingBasis | ||
EagleML/warehouseTransaction/warehouseNAVMulti/ | ||||||||||
EagleML/warehouseTransaction/warehouseNAVMulti/ | ||||||||||
maturityDate |
| date |
|
|
| not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/maturityDate | |||
baseCurrency |
|
|
|
|
| HOLDINGDBO | NAV_MULTI | BASE_CURRENCY | VARCHAR2(3) | EagleML/warehouseTransaction/warehouseNAVMulti/baseCurrency |
localCurrency | Required | CurrencyCode | 8569 | in_local_currency | S | HOLDINGDBO | NAV_MULTI | LOCAL_CURRENCY | VARCHAR2(3) | EagleML/warehouseTransaction/warehouseNAVMulti/localCurrency |
shareClass | Required | normalizedString | 34 | in_share_class | S | HOLDINGDBO | NAV_MULTI | SHARE_CLASS | VARCHAR2(10) | EagleML/warehouseTransaction/warehouseNAVMulti/shareClass |
valuationDate | Required | date | 3192 | in_valuation_date | S | HOLDINGDBO | NAV_MULTI | VALUATION_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/valuationDate |
navSequence | Required | integer | 3196 | in_nav_sequence | I | HOLDINGDBO | NAV_MULTI | NAV_SEQUENCE | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/navSequence |
netAssetAmount |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | NET_ASSET_AMOUNT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMulti/netAssetAmount |
navAmountPerShare |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | NAV_AMOUNT_PER_SHARE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navAmountPerShare |
navSharesOutstanding |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | SHARES_OUTSTANDING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navSharesOutstanding |
sharesSettled |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | SHARES_SETTLED | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/sharesSettled |
status |
| string |
|
|
| HOLDINGDBO | NAV_MULTI | STATUS | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMulti/status |
activeFlag |
| normalizedString | 1283 | in_active_flag | S | HOLDINGDBO | NAV_MULTI | ACTIVE_FLAG | VARCHAR2(5) | EagleML/warehouseTransaction/warehouseNAVMulti/activeFlag |
millRateAdjustmentAmount |
| decimal | 4282 | in_mill_rate_adjustment_amt | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_ADJUSTMENT_AMT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMulti/millRateAdjustmentAmount |
millRateDaysInYear |
| integer | 4283 | in_mill_rate_days_in_year | I | HOLDINGDBO | NAV_MULTI | MILL_RATE_DAYS_IN_YEAR | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/millRateDaysInYear |
millRateDaysInMonth |
| integer | 4284 | in_mill_rate_days_in_month | I | HOLDINGDBO | NAV_MULTI | MILL_RATE_DAYS_IN_MONTH | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/millRateDaysInMonth |
millRateWeeksInYear |
| decimal | 4285 | in_mill_rate_weeks_in_year | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_WEEKS_IN_YEAR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/millRateWeeksInYear |
millRateDailyYield |
| decimal | 4286 | in_mill_rate_daily_yield | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_DAILY_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/millRateDailyYield |
millRate7dayEffectiveYield |
| decimal | 4287 | in_mill_rate_7day_eff_yield | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_7DAY_EFF_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/millRate7dayEffectiveYield |
millRate7dayAverageYield |
| decimal | 4288 | in_mill_rate_7day_avg_yield | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_7DAY_AVG_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/millRate7dayAverageYield |
millRate30dayEffectiveYield |
| decimal | 4289 | in_mill_rate_30day_eff_yield | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_30DAY_EFF_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/millRate30dayEffectiveYield |
millRate30dayAverageYield |
| decimal | 4290 | in_mill_rate_30day_avg_yield | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_30DAY_AVG_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/millRate30dayAverageYield |
incomeDistribution |
| decimal | 4229 | in_income_distribution | F | HOLDINGDBO | NAV_MULTI | INCOME_DISTRIBUTION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/incomeDistribution |
shortTermCapGainDist |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | SHORT_TERM_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/shortTermCapGainDist |
longTermCapGainDist |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | LONG_TERM_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/longTermCapGainDist |
netActivity |
| decimal | 478 | in_net_activity | F | HOLDINGDBO | NAV_MULTI | NET_ACTIVITY | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/netActivity |
distributionReinvestAmount |
| decimal | 740 | in_distribution_reinvest_amt | F | HOLDINGDBO | NAV_MULTI | DISTRIBUTION_REINVEST_AMT | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/distributionReinvestAmount |
fixedDistributionAmount |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | FIXED_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/fixedDistributionAmount |
millRate |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/millRate |
allocRatio |
| decimal | 576 | in_alloc_ratio | F | HOLDINGDBO | NAV_MULTI | ALLOC_RATIO | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMulti/allocRatio |
periodicDistributionAmount |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | PERIODIC_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/periodicDistributionAmount |
otherCapGainDist |
| decimal | 4779 | in_other_cap_gain_dist | F | HOLDINGDBO | NAV_MULTI | OTHER_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/otherCapGainDist |
stockDividendRate |
| decimal | 4781 | in_stock_dividend_rate | F | HOLDINGDBO | NAV_MULTI | STOCK_DIVIDEND_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/stockDividendRate |
marketPrice |
| decimal | 4800 | in_market_price | F | HOLDINGDBO | NAV_MULTI | MARKET_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/marketPrice |
averageMaturityDays |
| integer | 4809 | in_avg_maturity_days | I | HOLDINGDBO | NAV_MULTI | AVG_MATURITY_DAYS | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/averageMaturityDays |
xrate |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | XRATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/xrate |
reportingNav |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingNav |
fxrate |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | FXRATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/fxrate |
navPrecision |
| integer |
|
|
| HOLDINGDBO | NAV_MULTI | NAV_PRECISION | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/navPrecision |
navRoundIndctr |
| normalizedString |
|
|
| HOLDINGDBO | NAV_MULTI | NAV_ROUND_INDCTR | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseNAVMulti/navRoundIndctr |
reportingNavChange |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_NAV_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingNavChange |
reportingNavPrior |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_NAV_PRIOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingNavPrior |
reportingPublicOffer |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFER | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOffer |
reportingPublicOfferPrior |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFER_PRIOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferPrior |
reportingPublicOfferChange |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFER_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferChange |
averageMaturityYears |
| decimal | 10117 | in_avg_maturity_years | F | HOLDINGDBO | NAV_MULTI | AVG_MATURITY_YEARS | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMulti/averageMaturityYears |
distributionDays |
| integer |
|
|
| HOLDINGDBO | NAV_MULTI | DISTRIBUTION_DAYS | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/distributionDays |
expenseRatio |
| decimal | 3967 | in_expense_ratio | F | HOLDINGDBO | NAV_MULTI | EXPENSE_RATIO | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMulti/expenseRatio |
grossAssets |
| decimal | 10 | in_gross_assets | F | HOLDINGDBO | NAV_MULTI | GROSS_ASSETS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/grossAssets |
grossExpenses |
| decimal | 4001 | in_gross_expenses | F | HOLDINGDBO | NAV_MULTI | GROSS_EXPENSES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/grossExpenses |
interimProfits |
| decimal | 10157 | in_interim_profits | F | HOLDINGDBO | NAV_MULTI | INTERIM_PROFITS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/interimProfits |
longTermCapGainDistAmount |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | LONG_TERM_CAP_GAIN_DIST_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/longTermCapGainDistAmount |
marketPriceChange |
| decimal | 9172 | in_market_price_change | F | HOLDINGDBO | NAV_MULTI | MARKET_PRICE_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/marketPriceChange |
netExpenses |
| decimal | 5784 | in_net_expenses | F | HOLDINGDBO | NAV_MULTI | NET_EXPENSES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/netExpenses |
periodicExDate |
| date |
|
|
| HOLDINGDBO | NAV_MULTI | PERIODIC_EX_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicExDate |
periodicIncomeDistAmount |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | PERIODIC_INCOME_DIST_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/periodicIncomeDistAmount |
periodicIncomeDistRate |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | PERIODIC_INCOME_DIST_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/periodicIncomeDistRate |
periodicPayableDate |
| date |
|
|
| HOLDINGDBO | NAV_MULTI | PERIODIC_PAYABLE_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicPayableDate |
periodicRecordDate |
| date |
|
|
| HOLDINGDBO | NAV_MULTI | PERIODIC_RECORD_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicRecordDate |
periodicReinvestDate |
| date |
|
|
| HOLDINGDBO | NAV_MULTI | PERIODIC_REINVEST_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicReinvestDate |
premiumDiscount |
| decimal | 1314 | in_premium_discount | F | HOLDINGDBO | NAV_MULTI | PREMIUM_DISCOUNT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/premiumDiscount |
marketPricePrevious |
| decimal | 10158 | in_market_price_previous | F | HOLDINGDBO | NAV_MULTI | MARKET_PRICE_PREVIOUS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/marketPricePrevious |
realizedUnrealizedGl |
| decimal | 8838 | in_realized_unrealized_gl | F | HOLDINGDBO | NAV_MULTI | REALIZED_UNREALIZED_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/realizedUnrealizedGl |
redemptionExchangeShares |
| decimal | 10160 | in_redemption_exch_shares | F | HOLDINGDBO | NAV_MULTI | REDEMPTION_EXCHANGE_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redemptionExchangeShares |
redemptionAmount |
| decimal | 3282 | in_redemption_amount | F | HOLDINGDBO | NAV_MULTI | REDEMPTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redemptionAmount |
redemptionExchangeAmount |
| decimal | 10159 | in_redemption_exch_amount | F | HOLDINGDBO | NAV_MULTI | REDEMPTION_EXCHANGE_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redemptionExchangeAmount |
reinvestmentPrice |
| decimal | 1276 | in_reinvestment_price | F | HOLDINGDBO | NAV_MULTI | REINVESTMENT_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reinvestmentPrice |
reinvestmentShares |
| decimal | 10162 | in_reinvestment_shares | F | HOLDINGDBO | NAV_MULTI | REINVESTMENT_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reinvestmentShares |
reportingPublicOffering |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFERING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOffering |
reportingPublicOfferingPrior |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_PUB_OFFERING_PRIOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferingPrior |
reportingPublicOfferingChange |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REPORTING_PUB_OFFERING_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferingChange |
secYield |
| decimal | 1112 | in_sec_yield | F | HOLDINGDBO | NAV_MULTI | SEC_YIELD | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/secYield |
shortTermCapGainDistAmount |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | SHORT_TERM_CAP_GAIN_DIST_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/shortTermCapGainDistAmount |
subscriptionAmount |
| decimal | 3281 | in_subscription_amount | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionAmount |
subscriptionExchangeAmount |
| decimal | 10163 | in_subscription_exch_amount | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_EXCHANGE_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionExchangeAmount |
subscriptionExchangeShares |
| decimal | 10164 | in_subscription_exch_shares | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_EXCHANGE_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionExchangeShares |
subscriptionShares |
| decimal | 10165 | in_subscription_shares | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionShares |
millRateChange |
| decimal | 4633 | in_mill_rate_change | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/millRateChange |
navPercentChange |
| decimal | 1870 | in_nav_percent_change | F | HOLDINGDBO | NAV_MULTI | NAV_PERCENT_CHANGE | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/navPercentChange |
annualizedExpense |
| decimal | 4760 | in_annualized_expense | F | HOLDINGDBO | NAV_MULTI | ANNUALIZED_EXPENSE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/annualizedExpense |
shortTermCapGainAmount |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | SHORT_TERM_CAP_GAIN_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/shortTermCapGainAmount |
redemptionShares |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | REDEPTION_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redeptionShares |
daysInMillRate |
| integer |
|
|
| HOLDINGDBO | NAV_MULTI | DAYS_IN_MILL_RATE | INTEGER | EagleML/warehouseTransaction/warehouseNAVMulti/daysInMillRate |
nasdaqSymbol |
| string |
|
|
| HOLDINGDBO | NAV_MULTI | NASDAQ_SYMBOL | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseNAVMulti/nasdaqSymbol |
incomeNetAssets |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | INCOME_NET_ASSETS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/incomeNetAssets |
incomeNav |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | INCOME_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/incomeNav |
capitalNav |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | CAPITAL_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/capitalNav |
cashDividend |
| decimal |
|
|
| HOLDINGDBO | NAV_MULTI | CASH_DIVIDEND | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/cashDividend |
weightedAverageMaturity |
| decimal | 8623 | in_wam_day | F | HOLDINGDBO | NAV_MULTI | WEIGHTED_AVG_MATURITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/weightedAverageMaturity |
weightedAverageLife |
| decimal | 8624 | in_wal_day | F | HOLDINGDBO | NAV_MULTI | WEIGHTED_AVG_LIFE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/weightedAverageLife |
shareClassDescription |
| string |
|
|
| PACE_MASTERDBO | CODE_VALUES | LONG_DESC |
| EagleML/warehouseTransaction/warehouseNAVMulti/shareClassDescription |
Entity Share Class Model Data Map Table (extract-only, see extra data map table) | EagleML/warehouseTransaction/warehouseNAVMulti/ | |||||||||
navReportDetails |
| EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/ | ||||||||
averageNetAssets |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ | ||||||||
dailyYieldMillRate |
| EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/ | ||||||||
navReportDetails Model Data Map TablePlease set includeCustomReportDetails="Y" in the RTR to add navReportDetails model to a single extract or W_INCLUDE_CUSTOM_REPORT_DETAILS="Y" global parameter to enhance all NAV Multi extracts in the environment
| ||||||||||
EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/ | ||||||||||
EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/mktValueCash/ | ||||||||||
EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/ | ||||||||||
EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/ | ||||||||||
EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/ | ||||||||||
transferAgentMillRate |
| decimal |
|
|
| Calculated value millRate + shortTermCapGainDist |
| EagleML/warehouseTransaction/warehouseNAVMulti/transferAgentMillRate | ||
rawNavChange |
| decimal |
|
|
| Calculated value navAmountPerShare - priorRawNAV |
| EagleML/warehouseTransaction/warehouseNAVMulti/rawNavChange | ||
reportingNavChange |
| decimal | 10150 |
|
| HOLDINGDBO | NAV_MULTI | REPORTING_NAV_CHANGE |
| EagleML/warehouseTransaction/warehouseNAVMulti/reportingNavChange |
netAssetsTotalFund |
| decimal |
|
|
| Calculated value - sum of netAssetAmount values grouped by entityId + valuationDate + navSequence |
| EagleML/warehouseTransaction/warehouseNAVMulti/netAssetsTotalFund | ||
priorNAV Model Data Map Table | ||||||||||
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
priorValuationDate |
| date |
| calculated field |
| HOLDINGDBO | NAV_MULTI | VALUATION_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorValuationDate |
priorRawNAV |
| decimal |
| calculated field |
| HOLDINGDBO | NAV_MULTI | NAV_AMOUNT_PER_SHARE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorRawNAV |
priorNetAssetsNAV |
| decimal |
| calculated field |
| HOLDINGDBO | NAV_MULTI | NET_ASSET_AMOUNT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorNetAssetsNAV |
priorSharesOutstanding |
| decimal |
| calculated field |
| HOLDINGDBO | NAV_MULTI | SHARES_OUTSTANDING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorSharesOutstanding |
priorMillRate |
| decimal |
| calculated field |
| HOLDINGDBO | NAV_MULTI | MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorMillRate |
priorMillRateDailyYield |
| decimal |
| calculated field |
| HOLDINGDBO | NAV_MULTI | MILL_RATE_DAILY_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorMillRateDailyYield |
reportingPublicOfferPrior |
| decimal |
| calculated field |
| HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFER_PRIOR |
| EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/reportingPublicOfferPrior |
reportingNavPrior |
| decimal |
| calculated field |
| HOLDINGDBO | NAV_MULTI | REPORTING_NAV_PRIOR |
| EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/reportingNavPrior |
mktValueCash Model Data Map Table | ||||||||||
mktValueBaseCash |
| decimal |
| calculated field |
| HOLDINGDBO | POSITION_DETAIL | STAR_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/mktValueCash/mktValueBaseCash |
mktValueForeignCash |
| decimal |
| calculated field |
| HOLDINGDBO | POSITION_DETAIL | STAR_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/mktValueCash/mktValueForeignCash |
mktValueSource |
| string |
| calculated field |
| PACE_MASTERDBO | INTERFACES | SHORT_DESC |
| EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/mktValueCash/mktValueSource |
shareClassLevel Model Data Map Table | ||||||||||
accretionAmortization |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/accretionAmortization |
currentNetAssets |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/currentNetAssets |
currentSharesOutstanding |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/currentSharesOutstanding |
expenses |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/expenses |
interestIncome |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/interestIncome |
netAssetChange |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/netAssetChange |
previousNetAssets |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/previousNetAssets |
priorSharesOutstanding |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/priorSharesOutstanding |
totalActivityMovement |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/totalActivityMovement |
variance |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/variance |
contrForDscReceivable |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/contrForDscReceivable |
currentShareActivity |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/currentShareActivity |
derivativesCashFlow |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/derivativesCashFlow |
distributions |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/distributions |
dividendIncome |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/dividendIncome |
fyeAsAfActivity |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/fyeAsAfActivity |
litigationCommission |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/litigationCommission |
marketValue |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/marketValue |
markToMarkets |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/markToMarkets |
miscellaneous |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/miscellaneous |
miscellaneousIncome |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/miscellaneousIncome |
netShareholderActivity |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/netShareholderActivity |
realizedCurrencyGainLoss |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/realizedCurrencyGainLoss |
tradingGainLoss |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/tradingGainLoss |
variationMargin |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/variationMargin |
totalFundLevel Model Data Map Table | ||||||||||
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
accretionAmortization |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/accretionAmortization |
currentNetAssets |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/currentNetAssets |
currentSharesOutstanding |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/currentSharesOutstanding |
expenses |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/expenses |
interestIncome |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/interestIncome |
netAssetChange |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/netAssetChange |
previousNetAssets |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/previousNetAssets |
priorSharesOutstanding |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/priorSharesOutstanding |
totalActivityMovement |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/totalActivityMovement |
variance |
| decimal |
| calculated field |
| ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/variance |
distributionLogLevels Model Data Map TabledistributionLogLevel Model Data Map Table | ||||||||||
fixedAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmount |
periodicIAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmount |
periodicLTAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmount |
periodicSPAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmount |
periodicSTAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmount |
periodicADJIAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmount |
periodicADJLTAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmount |
periodicADJSPAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmount |
periodicADJSTAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmount |
niiIAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmount |
niiADJIAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmount |
setIAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setIAmount |
setADJIAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmount |
fixedRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/fixedRate |
periodicIRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRate |
periodicLTRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRate |
periodicSPRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRate |
periodicSTRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRate |
periodicADJIRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRate |
periodicADJLTRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRate |
periodicADJSPRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRate |
periodicADJSTRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRate |
niiIRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiIRate |
niiADJIRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRate |
setIRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setIRate |
setADJIRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIRate |
fixedAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmountN |
periodicIAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmountN |
periodicLTAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmountN |
periodicSPAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmountN |
periodicSTAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmountN |
periodicADJIAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmountN |
periodicADJLTAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmountN |
periodicADJSPAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmountN |
periodicADJSTAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmountN |
niiIAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmountN |
niiADJIAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmountN |
setIAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setIAmountN |
setADJIAmountN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmountN |
fixedRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/fixedRateN |
periodicIRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRateN |
periodicLTRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRateN |
periodicSPRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRateN |
periodicSTRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRateN |
periodicADJIRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRateN |
periodicADJLTRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRateN |
periodicADJSPRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRateN |
periodicADJSTRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRateN |
niiIRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiIRateN |
niiADJIRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRateN |
setIRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setIRateN |
setADJIRateN |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIRateN |
totalFixedDistrAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/totalFixedDistrAmount |
totalFixedDistrRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/totalFixedDistrRate |
totalDailyDistrAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/totalDailyDistrAmount |
totalDailyDistrRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/totalDailyDistrRate |
totalPeriodicDistrAmount |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/totalPeriodicDistrAmount |
totalPeriodicDistrRate |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/totalPeriodicDistrRate |
distributionShares |
| decimal |
| calculated field |
| ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevels/distributionLogLevel/distributionShares |
estarSecYield30Day Model Data Map Table | ||||||||||
secYldTaxEqWithWvrReim |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | SEC_YLD_TAX_EQ_WITH_WVR_REIM | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/secYldTaxEqWithWvrReim |
secYldTaxEqWithoutWvrReim |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | SEC_YLD_TAX_EQ_WOUT_WVR_REIM | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/secYldTaxEqWithoutWvrReim |
secYldWithWvrReim |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | SEC_YLD_WITH_WVR_REIM | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/secYldWithWvrReim |
secYldWithoutWvrReim |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | SEC_YLD_WOUT_WVR_REIM | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/secYldWithoutWvrReim |
secIncome30Day |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | INCOME_30DAY | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/secIncome30Day |
taxEqIncome30Day |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | TAX_EQ_INCOME_30DAY | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/taxEqIncome30Day |
wVRReim30Day |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | WVR_REIM_30DAY | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/wVRReim30Day |
secExpenses30Day |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | EXPENSES_30DAY | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/secExpenses30Day |
secAverageShares |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | AVERAGE_SHARES | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/secAverageShares |
maxOfferingPrice |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | MAX_OFFER_PRICE | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/maxOfferingPrice |
adjustedMOP |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | ADJUSTED_MOP | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/adjustedMOP |
totalNetAssets |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | TOTAL_NET_ASSETS | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/totalNetAssets |
undistributedIncome |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | UNDISTRIBUTED_INC | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/undistributedIncome |
shares |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | SHARES | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/shares |
approvedFlag |
| YesNoOptionEnum |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | APPROVED_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/approvedFlag |
incomeWithoutShort30Day |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | INC_WOUT_SHORT_30DAY | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/incomeWithoutShort30Day |
shortDividendIncome |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | SH_DIV_INC | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/shortDividendIncome |
expectedWithShortDividend |
| decimal |
| calculated field |
| ESTAR | ESTAR_SECYLD_30DAY | EXP_WITH_SH_DIV | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/estarSecYield30Day/expectedWithShortDividend |
averageNetAssets Model Data Map Table | ||||||||||
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
effectiveDate |
| date |
|
|
|
|
|
|
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/effectiveDate |
mtdCumulative |
| decimal | 12059 |
|
| ESTAR | AVERAGE_NET_ASSETS | MTD_CUMULATIVE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/mtdCumulative |
mtdDays |
| integer | 12060 |
|
| ESTAR | AVERAGE_NET_ASSETS | DAYS_MTD |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/mtdDays |
mtdAna |
| decimal | 12061 |
|
| ESTAR | AVERAGE_NET_ASSETS | MTD_ANA |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/mtdAna |
fytdCumulative |
| decimal | 12062 |
|
| ESTAR | AVERAGE_NET_ASSETS | FYTD_CUMULATIVE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdCumulative |
fytdDays |
| integer | 12063 |
|
| ESTAR | AVERAGE_NET_ASSETS | FYTD_DAYS |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdDays |
fytdAna |
| decimal | 12064 |
|
| ESTAR | AVERAGE_NET_ASSETS | FYTD_ANA |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdAna |
fytdCumulativeSinceCapChange |
| decimal | 12065 |
|
| ESTAR | AVERAGE_NET_ASSETS | FYTD_CUM_SINCE_CAP_CHANGE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdCumulativeSinceCapChange |
fytdDaysSinceCapChange |
| integer | 12066 |
|
| ESTAR | AVERAGE_NET_ASSETS | DAYS_FYTD_SINCE_CAP_CHANGE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdDaysSinceCapChange |
fytdAnaSinceCapChange |
| decimal | 12067 |
|
| ESTAR | AVERAGE_NET_ASSETS | FYTD_ANA_SINCE_CAP_CHANGE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdAnaSinceCapChange |
netActivity |
| decimal | 478 |
|
| HOLDINGDBO | NAV_MULTI | NET_ACTIVITY |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/netActivity |
priorDayAjustedNetAssets |
| decimal | 4963 |
|
| ESTAR | AVERAGE_NET_ASSETS | PRIOR_DAY_ADJ_NET_ASSETS |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/priorDayAjustedNetAssets |
relNetAssetsMv |
| decimal |
|
|
| ESTAR | AVERAGE_NET_ASSETS | REL_NET_ASSETS_MV |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/relNetAssetsMv |
fvSettledSharesOut |
| decimal |
|
|
| ESTAR | AVERAGE_NET_ASSETS | FV_SETTLED_SHRS_OUT |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fvSettledSharesOut |
ptdCumulative |
| decimal |
|
|
| ESTAR | AVERAGE_NET_ASSETS | PTD_CUMULATIVE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ptdCumulative |
ptdDays |
| integer |
|
|
| ESTAR | AVERAGE_NET_ASSETS | PTD_DAYS |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ptdDays |
ajustedPtdCumulative |
| decimal |
|
|
| ESTAR | AVERAGE_NET_ASSETS | ADJ_PTD_CUMULATIVE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ajustedPtdCumulative |
priorDayNetAssets |
| decimal |
|
|
| ESTAR | AVERAGE_NET_ASSETS | PRIOR_DAY_NET_ASSETS |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/priorDayNetAssets |
pdPtdCumulative |
| decimal |
|
|
| ESTAR | AVERAGE_NET_ASSETS | PD_PTD_CUMULATIVE |
| EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/pdPtdCumulative |
dailyYieldMillRate Model Data Map Table | ||||||||||
millRate |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate |
millRateSpike |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_SPIKE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateSpike |
millRateSpikeAmount |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_SPIKE_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateSpikeAmount |
millRateAuto |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_AUTO | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateAuto |
millRateAutoReversal |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_AUTO_REVERSAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateAutoReversal |
millRateAdjustmentAmount |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_ADJUSTMENT_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateAdjustmentAmount |
millRateMtd |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_MTD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateMtd |
millRateSpikeMtd |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_SPIKE_MTD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateSpikeMtd |
millRate12Month |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_12MTH | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate12Month |
millRateDaysInYear |
| integer |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_DAYS_IN_YEAR | NUMBER(38) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateDaysInYear |
millRateDaysInMonth |
| integer |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_DAYS_IN_MONTH | NUMBER(38) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateDaysInMonth |
millRateWeeksInYear |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_WEEKS_IN_YEAR | NUMBER(38,6) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateWeeksInYear |
millRateDailyYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_DAILY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRateDailyYield |
millRate7dayEffectiveYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_7DAY_EFF_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate7dayEffectiveYield |
millRate7dayAverageYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_7DAY_AVG_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate7dayAverageYield |
millRate30dayEffectiveYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_30DAY_EFF_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate30dayEffectiveYield |
millRate30dayAverageYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_30DAY_AVG_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate30dayAverageYield |
millRate1monthYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_1MTH_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate1monthYield |
millRate12monthYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MILL_RATE_12MTH_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/millRate12monthYield |
n1aMillRate |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aMillRate |
n1aRestatedMillRate |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_RESTATED_MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aRestatedMillRate |
n1aOutStatePct |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_OUT_STATE_PCT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aOutStatePct |
n1aDailyYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_DAILY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aDailyYield |
n1aRestatedDailyYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_RESTATED_DAILY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aRestatedDailyYield |
n1a7dayYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_7DAY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1a7dayYield |
n1aRestated7dayYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_RESTATED_7DAY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aRestated7dayYield |
n1a30dayYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_30DAY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1a30dayYield |
n1aRestated30dayYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_RESTATED_30DAY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aRestated30dayYield |
n1a7dayEffectiveYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_7DAY_EFF_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1a7dayEffectiveYield |
n1aGrossYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | N1A_GROSS_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/n1aGrossYield |
monthEndFlag |
| YesNoOptionEnum |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | MONTH_END_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/monthEndFlag |
incomeDistribution |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | INCOME_DISTRIBUTION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/incomeDistribution |
incomeLedgerBalance |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | INCOME_LEDGER_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/incomeLedgerBalance |
expensesLedgerBalance |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | EXPENSES_LEDGER_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/expensesLedgerBalance |
fixedDistributionAmount |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | FIXED_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/fixedDistributionAmount |
periodicDistributionAmount |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | PERIODIC_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/periodicDistributionAmount |
reimbursement |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | REIMBURSEMENT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/reimbursement |
incomeAdjustmentAmount |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | INCOME_ADJ_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/incomeAdjustmentAmount |
grossYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | GROSS_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/grossYield |
gross7dayYield |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | GROSS_7DAY_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/gross7dayYield |
fytdTaxableIncome |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | FYTD_TAXABLE_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/fytdTaxableIncome |
fytdTaxExemptIncome |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | FYTD_TAX_EXEMPT_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/fytdTaxExemptIncome |
fytdMixedExpenses |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | FYTD_MIXED_EXPENSES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/fytdMixedExpenses |
fytdTaxableExpAlloc |
| decimal |
|
|
| ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | FYTD_TAXABLE_EXP_ALLOC | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/dailyYieldMillRate/fytdTaxableExpAlloc |