Warehouse NAV Multi Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Owned by Natalie Gesin (Deactivated)
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 | |||||||||
| Entity Common Id Model | EagleML/warehouseTransaction/warehouseNAVMulti/ | |||||||||
| Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehouseNAVMulti/ | |||||||||
| accountingBasis | string | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/accountingBasis | |||||||
| Asset Identifiers Model | EagleML/warehouseTransaction/warehouseNAVMulti/ | |||||||||
| Extended Asset Properties Model (extract only) | 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 (DB v15R2 or higher) | 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 | navReportDetails Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/ | ||||||||
| averageNetAssets | averageNetAssets Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ | ||||||||
| dailyYieldMillRate | dailyYieldMillRate Model (see the data map table below) | 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 | ||||||||||
| priorNAV Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/ | |||||||||
| mktValueCash Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/mktValueCash/ | |||||||||
| shareClassLevel Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/ | |||||||||
| totalFundLevel Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/ | |||||||||
| distributionLogLevels Model (see the data map table below) | 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 | ||||