| 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 | Optional | string | HOLDINGDBO | NAV_MULTI | UPDATE_SOURCE | VARCHAR2(32) | EagleML/warehouseTransaction/warehouseNAVMulti/updateSource | |||
| batchCollectErrorsFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/batchCollectErrorsFlag | ||||||
| singleRowCommitFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/singleRowCommitFlag | ||||||
| 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 | Optional | date | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMulti/maturityDate | ||||||
| baseCurrency | Optional | 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 | Optional | decimal | HOLDINGDBO | NAV_MULTI | NET_ASSET_AMOUNT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMulti/netAssetAmount | |||
| navAmountPerShare | Optional | decimal | HOLDINGDBO | NAV_MULTI | NAV_AMOUNT_PER_SHARE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navAmountPerShare | |||
| navSharesOutstanding | Optional | decimal | HOLDINGDBO | NAV_MULTI | SHARES_OUTSTANDING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navSharesOutstanding | |||
| sharesSettled | Optional | decimal | HOLDINGDBO | NAV_MULTI | SHARES_SETTLED | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/sharesSettled | |||
| status | Optional | string | HOLDINGDBO | NAV_MULTI | STATUS | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMulti/status | |||
| activeFlag | Optional | normalizedString | 1283 | in_active_flag | S | HOLDINGDBO | NAV_MULTI | ACTIVE_FLAG | VARCHAR2(5) | EagleML/warehouseTransaction/warehouseNAVMulti/activeFlag |
| millRateAdjustmentAmount | Optional | decimal | 4282 | in_mill_rate_adjustment_amt | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_ADJUSTMENT_AMT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMulti/millRateAdjustmentAmount |
| millRateDaysInYear | Optional | integer | 4283 | in_mill_rate_days_in_year | I | HOLDINGDBO | NAV_MULTI | MILL_RATE_DAYS_IN_YEAR | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/millRateDaysInYear |
| millRateDaysInMonth | Optional | integer | 4284 | in_mill_rate_days_in_month | I | HOLDINGDBO | NAV_MULTI | MILL_RATE_DAYS_IN_MONTH | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/millRateDaysInMonth |
| millRateWeeksInYear | Optional | 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 | Optional | decimal | 4286 | in_mill_rate_daily_yield | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_DAILY_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/millRateDailyYield |
| millRate7dayEffectiveYield | Optional | 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 | Optional | 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 | Optional | 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 | Optional | 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 | Optional | decimal | 4229 | in_income_distribution | F | HOLDINGDBO | NAV_MULTI | INCOME_DISTRIBUTION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/incomeDistribution |
| shortTermCapGainDist | Optional | decimal | HOLDINGDBO | NAV_MULTI | SHORT_TERM_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/shortTermCapGainDist | |||
| longTermCapGainDist | Optional | decimal | HOLDINGDBO | NAV_MULTI | LONG_TERM_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/longTermCapGainDist | |||
| netActivity | Optional | decimal | 478 | in_net_activity | F | HOLDINGDBO | NAV_MULTI | NET_ACTIVITY | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/netActivity |
| distributionReinvestAmount | Optional | decimal | 740 | in_distribution_reinvest_amt | F | HOLDINGDBO | NAV_MULTI | DISTRIBUTION_REINVEST_AMT | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/distributionReinvestAmount |
| fixedDistributionAmount | Optional | decimal | HOLDINGDBO | NAV_MULTI | FIXED_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/fixedDistributionAmount | |||
| millRate | Optional | decimal | HOLDINGDBO | NAV_MULTI | MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/millRate | |||
| allocRatio | Optional | decimal | 576 | in_alloc_ratio | F | HOLDINGDBO | NAV_MULTI | ALLOC_RATIO | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMulti/allocRatio |
| periodicDistributionAmount | Optional | decimal | HOLDINGDBO | NAV_MULTI | PERIODIC_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/periodicDistributionAmount | |||
| otherCapGainDist | Optional | decimal | 4779 | in_other_cap_gain_dist | F | HOLDINGDBO | NAV_MULTI | OTHER_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/otherCapGainDist |
| stockDividendRate | Optional | decimal | 4781 | in_stock_dividend_rate | F | HOLDINGDBO | NAV_MULTI | STOCK_DIVIDEND_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/stockDividendRate |
| marketPrice | Optional | decimal | 4800 | in_market_price | F | HOLDINGDBO | NAV_MULTI | MARKET_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/marketPrice |
| averageMaturityDays | Optional | integer | 4809 | in_avg_maturity_days | I | HOLDINGDBO | NAV_MULTI | AVG_MATURITY_DAYS | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/averageMaturityDays |
| xrate | Optional | decimal | HOLDINGDBO | NAV_MULTI | XRATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/xrate | |||
| reportingNav | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingNav | |||
| fxrate | Optional | decimal | HOLDINGDBO | NAV_MULTI | FXRATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/fxrate | |||
| navPrecision | Optional | integer | HOLDINGDBO | NAV_MULTI | NAV_PRECISION | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/navPrecision | |||
| navRoundIndctr | Optional | normalizedString | HOLDINGDBO | NAV_MULTI | NAV_ROUND_INDCTR | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseNAVMulti/navRoundIndctr | |||
| reportingNavChange | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_NAV_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingNavChange | |||
| reportingNavPrior | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_NAV_PRIOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingNavPrior | |||
| reportingPublicOffer | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFER | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOffer | |||
| reportingPublicOfferPrior | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFER_PRIOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferPrior | |||
| reportingPublicOfferChange | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFER_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferChange | |||
| averageMaturityYears | Optional | decimal | 10117 | in_avg_maturity_years | F | HOLDINGDBO | NAV_MULTI | AVG_MATURITY_YEARS | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMulti/averageMaturityYears |
| distributionDays | Optional | integer | HOLDINGDBO | NAV_MULTI | DISTRIBUTION_DAYS | NUMBER | EagleML/warehouseTransaction/warehouseNAVMulti/distributionDays | |||
| expenseRatio | Optional | decimal | 3967 | in_expense_ratio | F | HOLDINGDBO | NAV_MULTI | EXPENSE_RATIO | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMulti/expenseRatio |
| grossAssets | Optional | decimal | 10 | in_gross_assets | F | HOLDINGDBO | NAV_MULTI | GROSS_ASSETS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/grossAssets |
| grossExpenses | Optional | decimal | 4001 | in_gross_expenses | F | HOLDINGDBO | NAV_MULTI | GROSS_EXPENSES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/grossExpenses |
| interimProfits | Optional | decimal | 10157 | in_interim_profits | F | HOLDINGDBO | NAV_MULTI | INTERIM_PROFITS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/interimProfits |
| longTermCapGainDistAmount | Optional | decimal | HOLDINGDBO | NAV_MULTI | LONG_TERM_CAP_GAIN_DIST_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/longTermCapGainDistAmount | |||
| marketPriceChange | Optional | decimal | 9172 | in_market_price_change | F | HOLDINGDBO | NAV_MULTI | MARKET_PRICE_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/marketPriceChange |
| netExpenses | Optional | decimal | 5784 | in_net_expenses | F | HOLDINGDBO | NAV_MULTI | NET_EXPENSES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/netExpenses |
| periodicExDate | Optional | date | HOLDINGDBO | NAV_MULTI | PERIODIC_EX_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicExDate | |||
| periodicIncomeDistAmount | Optional | decimal | HOLDINGDBO | NAV_MULTI | PERIODIC_INCOME_DIST_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/periodicIncomeDistAmount | |||
| periodicIncomeDistRate | Optional | decimal | HOLDINGDBO | NAV_MULTI | PERIODIC_INCOME_DIST_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/periodicIncomeDistRate | |||
| periodicPayableDate | Optional | date | HOLDINGDBO | NAV_MULTI | PERIODIC_PAYABLE_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicPayableDate | |||
| periodicRecordDate | Optional | date | HOLDINGDBO | NAV_MULTI | PERIODIC_RECORD_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicRecordDate | |||
| periodicReinvestDate | Optional | date | HOLDINGDBO | NAV_MULTI | PERIODIC_REINVEST_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/periodicReinvestDate | |||
| premiumDiscount | Optional | decimal | 1314 | in_premium_discount | F | HOLDINGDBO | NAV_MULTI | PREMIUM_DISCOUNT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/premiumDiscount |
| marketPricePrevious | Optional | decimal | 10158 | in_market_price_previous | F | HOLDINGDBO | NAV_MULTI | MARKET_PRICE_PREVIOUS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/marketPricePrevious |
| realizedUnrealizedGl | Optional | decimal | 8838 | in_realized_unrealized_gl | F | HOLDINGDBO | NAV_MULTI | REALIZED_UNREALIZED_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/realizedUnrealizedGl |
| redemptionExchangeShares | Optional | decimal | 10160 | in_redemption_exch_shares | F | HOLDINGDBO | NAV_MULTI | REDEMPTION_EXCHANGE_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redemptionExchangeShares |
| redemptionAmount | Optional | decimal | 3282 | in_redemption_amount | F | HOLDINGDBO | NAV_MULTI | REDEMPTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redemptionAmount |
| redemptionExchangeAmount | Optional | decimal | 10159 | in_redemption_exch_amount | F | HOLDINGDBO | NAV_MULTI | REDEMPTION_EXCHANGE_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redemptionExchangeAmount |
| reinvestmentPrice | Optional | decimal | 1276 | in_reinvestment_price | F | HOLDINGDBO | NAV_MULTI | REINVESTMENT_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reinvestmentPrice |
| reinvestmentShares | Optional | decimal | 10162 | in_reinvestment_shares | F | HOLDINGDBO | NAV_MULTI | REINVESTMENT_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reinvestmentShares |
| reportingPublicOffering | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_PUBLIC_OFFERING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOffering | |||
| reportingPublicOfferingPrior | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_PUB_OFFERING_PRIOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferingPrior | |||
| reportingPublicOfferingChange | Optional | decimal | HOLDINGDBO | NAV_MULTI | REPORTING_PUB_OFFERING_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/reportingPublicOfferingChange | |||
| secYield | Optional | decimal | 1112 | in_sec_yield | F | HOLDINGDBO | NAV_MULTI | SEC_YIELD | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/secYield |
| shortTermCapGainDistAmount | Optional | decimal | HOLDINGDBO | NAV_MULTI | SHORT_TERM_CAP_GAIN_DIST_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/shortTermCapGainDistAmount | |||
| subscriptionAmount | Optional | decimal | 3281 | in_subscription_amount | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionAmount |
| subscriptionExchangeAmount | Optional | decimal | 10163 | in_subscription_exch_amount | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_EXCHANGE_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionExchangeAmount |
| subscriptionExchangeShares | Optional | decimal | 10164 | in_subscription_exch_shares | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_EXCHANGE_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionExchangeShares |
| subscriptionShares | Optional | decimal | 10165 | in_subscription_shares | F | HOLDINGDBO | NAV_MULTI | SUBSCRIPTION_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/subscriptionShares |
| millRateChange | Optional | decimal | 4633 | in_mill_rate_change | F | HOLDINGDBO | NAV_MULTI | MILL_RATE_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/millRateChange |
| navPercentChange | Optional | decimal | 1870 | in_nav_percent_change | F | HOLDINGDBO | NAV_MULTI | NAV_PERCENT_CHANGE | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/navPercentChange |
| annualizedExpense | Optional | decimal | 4760 | in_annualized_expense | F | HOLDINGDBO | NAV_MULTI | ANNUALIZED_EXPENSE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMulti/annualizedExpense |
| shortTermCapGainAmount | Optional | decimal | HOLDINGDBO | NAV_MULTI | SHORT_TERM_CAP_GAIN_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/shortTermCapGainAmount | |||
| redemptionShares | Optional | decimal | HOLDINGDBO | NAV_MULTI | REDEPTION_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/redeptionShares | |||
| daysInMillRate | Optional | integer | HOLDINGDBO | NAV_MULTI | DAYS_IN_MILL_RATE | INTEGER | EagleML/warehouseTransaction/warehouseNAVMulti/daysInMillRate | |||
| nasdaqSymbol | Optional | string | HOLDINGDBO | NAV_MULTI | NASDAQ_SYMBOL | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseNAVMulti/nasdaqSymbol | |||
| incomeNetAssets | Optional | decimal | HOLDINGDBO | NAV_MULTI | INCOME_NET_ASSETS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/incomeNetAssets | |||
| incomeNav | Optional | decimal | HOLDINGDBO | NAV_MULTI | INCOME_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/incomeNav | |||
| capitalNav | Optional | decimal | HOLDINGDBO | NAV_MULTI | CAPITAL_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/capitalNav | |||
| cashDividend | Optional | decimal | HOLDINGDBO | NAV_MULTI | CASH_DIVIDEND | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/cashDividend | |||
| weightedAverageMaturity | Optional | decimal | 8623 | in_wam_day | F | HOLDINGDBO | NAV_MULTI | WEIGHTED_AVG_MATURITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/weightedAverageMaturity |
| weightedAverageLife | Optional | decimal | 8624 | in_wal_day | F | HOLDINGDBO | NAV_MULTI | WEIGHTED_AVG_LIFE (DB version 2015R2 or higher) | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/weightedAverageLife |
| shareClassDescription | Optional | 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/ | |||||||||
| navReportDetails Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/ | |||||||||
| averageNetAssets Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/ | |||||||||
navReportDetails Model Data Map Table | ||||||||||
| priorNAV Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/ | |||||||||
| mktValueCash Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/ | |||||||||
| shareClassLevel Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/ | |||||||||
| totalFundLevel Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/ | |||||||||
| distributionLogLevel Model (see the data map table below) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/ | |||||||||
| transferAgentMillRate | Optional | decimal | Calculated value millRate + shortTermCapGainDist | EagleML/warehouseTransaction/warehouseNAVMulti/transferAgentMillRate | ||||||
| rawNavChange | Optional | decimal | Calculated value navAmountPerShare - priorRawNAV | EagleML/warehouseTransaction/warehouseNAVMulti/rawNavChange | ||||||
| reportingNavChange | Optional | decimal | 10150 | HOLDINGDBO | NAV_MULTI | REPORTING_NAV_CHANGE | EagleML/warehouseTransaction/warehouseNAVMulti/reportingNavChange | |||
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 | Optional | date | calculated field | HOLDINGDBO | NAV_MULTI | VALUATION_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorValuationDate | ||
| priorRawNAV | Optional | decimal | calculated field | HOLDINGDBO | NAV_MULTI | NAV_AMOUNT_PER_SHARE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorRawNAV | ||
| priorNetAssetsNAV | Optional | decimal | calculated field | HOLDINGDBO | NAV_MULTI | NET_ASSET_AMOUNT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorNetAssetsNAV | ||
| priorSharesOutstanding | Optional | decimal | calculated field | HOLDINGDBO | NAV_MULTI | SHARES_OUTSTANDING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorSharesOutstanding | ||
| priorMillRate | Optional | decimal | calculated field | HOLDINGDBO | NAV_MULTI | MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorMillRate | ||
| priorMillRateDailyYield | Optional | decimal | calculated field | HOLDINGDBO | NAV_MULTI | MILL_RATE_DAILY_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/priorNAV/priorMillRateDailyYield | ||
mktValueCash Model Data Map Table | ||||||||||
| mktValueBaseCash | Optional | decimal | calculated field | HOLDINGDBO | POSITION_DETAIL | STAR_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/mktValueCash/mktValueBaseCash | ||
| mktValueForeignCash | Optional | decimal | calculated field | HOLDINGDBO | POSITION_DETAIL | STAR_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/mktValueCash/mktValueForeignCash | ||
shareClassLevel Model Data Map Table | ||||||||||
| accretionAmortization | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/accretionAmortization | ||
| currentNetAssets | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/currentNetAssets | ||
| currentSharesOutstanding | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/currentSharesOutstanding | ||
| expenses | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/expenses | ||
| interestIncome | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/interestIncome | ||
| netAssetChange | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/netAssetChange | ||
| previousNetAssets | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/previousNetAssets | ||
| priorSharesOutstanding | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/priorSharesOutstanding | ||
| totalActivityMovement | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/totalActivityMovement | ||
| variance | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/variance | ||
| contrForDscReceivable | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/contrForDscReceivable | ||
| currentShareActivity | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/currentShareActivity | ||
| derivativesCashFlow | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/derivativesCashFlow | ||
| distributions | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/distributions | ||
| dividendIncome | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/dividendIncome | ||
| fyeAsAfActivity | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/fyeAsAfActivity | ||
| litigationCommission | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/litigationCommission | ||
| marketValue | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/marketValue | ||
| markToMarkets | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/markToMarkets | ||
| miscellaneous | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/miscellaneous | ||
| miscellaneousIncome | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/miscellaneousIncome | ||
| netShareholderActivity | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/netShareholderActivity | ||
| realizedCurrencyGainLoss | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/realizedCurrencyGainLoss | ||
| tradingGainLoss | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/shareClassLevel/tradingGainLoss | ||
| variationMargin | Optional | 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 | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/accretionAmortization | ||
| currentNetAssets | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/currentNetAssets | ||
| currentSharesOutstanding | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/currentSharesOutstanding | ||
| expenses | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/expenses | ||
| interestIncome | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/interestIncome | ||
| netAssetChange | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/netAssetChange | ||
| previousNetAssets | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/previousNetAssets | ||
| priorSharesOutstanding | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/priorSharesOutstanding | ||
| totalActivityMovement | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/totalActivityMovement | ||
| variance | Optional | decimal | calculated field | ARCH_CTRLCTR | NAV_DETAILS | BALANCE_CHANGE | NUMBER(22,6) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/totalFundLevel/variance | ||
distributionLogLevel Model Data Map Table | ||||||||||
| fixedAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/fixedAmount | ||
| periodicIAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicIAmount | ||
| periodicLTAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicLTAmount | ||
| periodicSPAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSPAmount | ||
| periodicSTAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSTAmount | ||
| periodicADJIAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJIAmount | ||
| periodicADJLTAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJLTAmount | ||
| periodicADJSPAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSPAmount | ||
| periodicADJSTAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSTAmount | ||
| niiIAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiIAmount | ||
| niiADJIAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiADJIAmount | ||
| setIAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setIAmount | ||
| setADJIAmount | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setADJIAmount | ||
| fixedRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/fixedRate | ||
| periodicIRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicIRate | ||
| periodicLTRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicLTRate | ||
| periodicSPRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSPRate | ||
| periodicSTRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSTRate | ||
| periodicADJIRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJIRate | ||
| periodicADJLTRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJLTRate | ||
| periodicADJSPRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSPRate | ||
| periodicADJSTRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSTRate | ||
| niiIRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiIRate | ||
| niiADJIRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiADJIRate | ||
| setIRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setIRate | ||
| setADJIRate | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setADJIRate | ||
| fixedAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/fixedAmountN | ||
| periodicIAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicIAmountN | ||
| periodicLTAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicLTAmountN | ||
| periodicSPAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSPAmountN | ||
| periodicSTAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSTAmountN | ||
| periodicADJIAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJIAmountN | ||
| periodicADJLTAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJLTAmountN | ||
| periodicADJSPAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSPAmountN | ||
| periodicADJSTAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSTAmountN | ||
| niiIAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiIAmountN | ||
| niiADJIAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiADJIAmountN | ||
| setIAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setIAmountN | ||
| setADJIAmountN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setADJIAmountN | ||
| fixedRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/fixedRateN | ||
| periodicIRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicIRateN | ||
| periodicLTRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicLTRateN | ||
| periodicSPRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSPRateN | ||
| periodicSTRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicSTRateN | ||
| periodicADJIRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJIRateN | ||
| periodicADJLTRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJLTRateN | ||
| periodicADJSPRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSPRateN | ||
| periodicADJSTRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/periodicADJSTRateN | ||
| niiIRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiIRateN | ||
| niiADJIRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/niiADJIRateN | ||
| setIRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setIRateN | ||
| setADJIRateN | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/setADJIRateN | ||
| totalFixedDistrAmount | Optional | decimal | calculated field | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/totalFixedDistrAmount | ||||||
| totalFixedDistrRate | Optional | decimal | calculated field | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/totalFixedDistrRate | ||||||
| totalDailyDistrAmount | Optional | decimal | calculated field | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/totalDailyDistrAmount | ||||||
| totalDailyDistrRate | Optional | decimal | calculated field | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/totalDailyDistrRate | ||||||
| totalPeriodicDistrAmount | Optional | decimal | calculated field | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/totalPeriodicDistrAmount | ||||||
| totalPeriodicDistrRate | Optional | decimal | calculated field | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/totalPeriodicDistrRate | ||||||
| distributionShares | Optional | decimal | calculated field | ESTAR | ESTAR_DIST_LOG | DISTRIBUTION_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMulti/navReportDetails/distributionLogLevel/distributionShares | ||
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 | Optional | date | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/effectiveDate | |||||||
| mtdCumulative | Optional | decimal | 12059 | ESTAR | AVERAGE_NET_ASSETS | MTD_CUMULATIVE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/mtdCumulative | |||
| mtdDays | Optional | integer | 12060 | ESTAR | AVERAGE_NET_ASSETS | DAYS_MTD | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/mtdDays | |||
| mtdAna | Optional | decimal | 12061 | ESTAR | AVERAGE_NET_ASSETS | MTD_ANA | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/mtdAna | |||
| fytdCumulative | Optional | decimal | 12062 | ESTAR | AVERAGE_NET_ASSETS | FYTD_CUMULATIVE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdCumulative | |||
| fytdDays | Optional | integer | 12063 | ESTAR | AVERAGE_NET_ASSETS | FYTD_DAYS | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdDays | |||
| fytdAna | Optional | decimal | 12064 | ESTAR | AVERAGE_NET_ASSETS | FYTD_ANA | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdAna | |||
| fytdCumulativeSinceCapChange | Optional | decimal | 12065 | ESTAR | AVERAGE_NET_ASSETS | FYTD_CUM_SINCE_CAP_CHANGE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdCumulativeSinceCapChange | |||
| fytdDaysSinceCapChange | Optional | integer | 12066 | ESTAR | AVERAGE_NET_ASSETS | DAYS_FYTD_SINCE_CAP_CHANGE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdDaysSinceCapChange | |||
| fytdAnaSinceCapChange | Optional | decimal | 12067 | ESTAR | AVERAGE_NET_ASSETS | FYTD_ANA_SINCE_CAP_CHANGE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fytdAnaSinceCapChange | |||
| netActivity | Optional | decimal | 478 | in_net_activity | HOLDINGDBO | NAV_MULTI | NET_ACTIVITY | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/netActivity | ||
| priorDayAjustedNetAssets | Optional | decimal | 4963 | ESTAR | AVERAGE_NET_ASSETS | PRIOR_DAY_ADJ_NET_ASSETS | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/priorDayAjustedNetAssets | |||
| relNetAssetsMv | Optional | decimal | ESTAR | AVERAGE_NET_ASSETS | REL_NET_ASSETS_MV | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/relNetAssetsMv | ||||
| fvSettledSharesOut | Optional | decimal | ESTAR | AVERAGE_NET_ASSETS | FV_SETTLED_SHRS_OUT | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/fvSettledSharesOut | ||||
| ptdCumulative | Optional | decimal | ESTAR | AVERAGE_NET_ASSETS | PTD_CUMULATIVE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ptdCumulative | ||||
| ptdDays | Optional | integer | ESTAR | AVERAGE_NET_ASSETS | PTD_DAYS | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ptdDays | ||||
| ajustedPtdCumulative | Optional | decimal | ESTAR | AVERAGE_NET_ASSETS | ADJ_PTD_CUMULATIVE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/ajustedPtdCumulative | ||||
| priorDayNetAssets | Optional | decimal | ESTAR | AVERAGE_NET_ASSETS | PRIOR_DAY_NET_ASSETS | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/priorDayNetAssets | ||||
| pdPtdCumulative | Optional | decimal | ESTAR | AVERAGE_NET_ASSETS | PD_PTD_CUMULATIVE | EagleML/warehouseTransaction/warehouseNAVMulti/averageNetAssets/pdPtdCumulative | ||||
General
Content
Integrations