...
| 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/warehouseNAVMonthEnd/objectType | |||||||||||||
| objectId | ObjectId | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMonthEnd/objectId | |||||||||||||
| objectDescription | FeedTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMonthEnd/objectDescription | |||||||||||||
| updateTimestamp | dateTime | ESTAR | MONTHLY_ESTAR_NAV | UPDATE_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/updateTimestamp | ||||||||||
| sourceName | Required | string | CHAR(15) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/sourceName | ||||||||||||
| updateSource | Optional | string | ESTAR | MONTHLY_ESTAR_NAV | UPDATE_SOURCE | VARCHAR2(32) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/updateSource | |||||||||
| batchCollectErrorsFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMonthEnd/batchCollectErrorsFlag | ||||||||||||
| singleRowCommitFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMonthEnd/singleRowCommitFlag | ||||||||||||
| Entity Common Id Model | EagleML/warehouseTransaction/warehouseNAVMonthEnd/ | |||||||||||||||
| Asset Identifiers Model | EagleML/warehouseTransaction/warehouseNAVMonthEnd/ | |||||||||||||||
| maturityDate | Optional | date | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMonthEnd/maturityDate | ||||||||||||
| shareClass | Required | normalizedString | 34 | in_share_class | S | ESTAR | MONTHLY_ESTAR_NAV | SHARE_CLASS | VARCHAR2(10) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClass | ||||||
| valuationDate | Required | date | 3192 | in_valuation_date | S | ESTAR | MONTHLY_ESTAR_NAV | VALUATION_DATE | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/valuationDate | ||||||
| navSequence | Required | integer | 3196 | in_nav_rounding_ind | I | ESTAR | MONTHLY_ESTAR_NAV | NAV_SEQUENCE | NUMBER | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navSequence | ||||||
| netAssetAmount | Optional | decimal | 3193 | in_nav_amount | ESTAR | MONTHLY_ESTAR_NAV | NET_ASSET_AMOUNT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmount | |||||||
| navAmountPerShare | Optional | decimal | 3195 | in_nav_per_share | ESTAR | MONTHLY_ESTAR_NAV | NAV_AMOUNT_PER_SHARE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navAmountPerShare | |||||||
| sharesOutstanding | Optional | decimal | 3209 | in_shares_outstanding | ESTAR | MONTHLY_ESTAR_NAV | SHARES_OUTSTANDING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/sharesOutstanding | |||||||
| sharesSettled | Optional | decimal | 758 | in_shares_settled | ESTAR | MONTHLY_ESTAR_NAV | SHARES_SETTLED | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/sharesSettled | |||||||
| status | Optional | string | 3190 | in_status | ESTAR | MONTHLY_ESTAR_NAV | STATUS | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/status | |||||||
| activeFlag | Optional | normalizedString | 1283 | in_active_flag | S | ESTAR | MONTHLY_ESTAR_NAV | ACTIVE_FLAG | VARCHAR2(5) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/activeFlag | ||||||
| millRateAdjustmentAmount | Optional | decimal | 4282 | in_mill_rate_adjustment_amt | F | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_ADJUSTMENT_AMT | NUMBER(38,2) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateAdjustmentAmount | ||||||
| millRateDaysInYear | Optional | integer | 4283 | in_mill_rate_days_in_year | I | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_DAYS_IN_YEAR | NUMBER | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInYear | ||||||
| millRateDaysInMonth | Optional | integer | 4284 | in_mill_rate_days_in_month | I | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_DAYS_IN_MONTH | NUMBER | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInMonth | ||||||
| millRateWeeksInYear | Optional | decimal | 4285 | in_mill_rate_weeks_in_year | F | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_WEEKS_IN_YEAR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateWeeksInYear | ||||||
| millRateDailyYield | Optional | decimal | 4286 | in_mill_rate_daily_yield | F | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_DAILY_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDailyYield | ||||||
| millRate7dayEffectiveYield | Optional | decimal | 4287 | in_mill_rate_7day_eff_yield | F | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_7DAY_EFF_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYield | ||||||
| millRate7dayAverageYield | Optional | decimal | 4288 | in_mill_rate_7day_avg_yield | F | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_7DAY_AVG_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayAverageYield | ||||||
| millRate30dayEffectiveYield | Optional | decimal | 4289 | in_mill_rate_30day_eff_yield | F | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_30DAY_EFF_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayEffectiveYield | ||||||
| millRate30dayAverageYield | Optional | decimal | 4290 | in_mill_rate_30day_avg_yield | F | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_30DAY_AVG_YIELD | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayAverageYield | ||||||
| incomeDistribution | Optional | decimal | 4229 | in_income_distribution | F | ESTAR | MONTHLY_ESTAR_NAV | INCOME_DISTRIBUTION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeDistribution | ||||||
| shortTermCapGainDist | Optional | decimal | 4230 | in_short_term_cap_gain_dist | ESTAR | MONTHLY_ESTAR_NAV | SHORT_TERM_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDist | |||||||
| longTermCapGainDist | Optional | decimal | 4231 | in_long_term_cap_gain_dist | ESTAR | MONTHLY_ESTAR_NAV | LONG_TERM_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDist | |||||||
| netActivity | Optional | decimal | 478 | in_net_activity | F | ESTAR | MONTHLY_ESTAR_NAV | NET_ACTIVITY | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/netActivity | ||||||
| distributionReinvestAmount | Optional | decimal | 741 | in_distribution_reinvest_amt | F | ESTAR | MONTHLY_ESTAR_NAV | DISTRIBUTION_REINVEST_AMT | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/distributionReinvestAmount | ||||||
| fixedDistributionAmount | Optional | decimal | 4484 | in_fixed_distribution_amt | ESTAR | MONTHLY_ESTAR_NAV | FIXED_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/fixedDistributionAmount | |||||||
| millRate | Optional | decimal | 4564 | in_MILL_RATE | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate | |||||||
| allocRatio | Optional | decimal | 756 | in_alloc_ratio | F | ESTAR | MONTHLY_ESTAR_NAV | ALLOC_RATIO | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/allocRatio | ||||||
| periodicDistributionAmount | Optional | decimal | 4759 | in_periodic_dist_amt | ESTAR | MONTHLY_ESTAR_NAV | PERIODIC_DISTRIBUTION_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/periodicDistributionAmount | |||||||
| otherCapGainDist | Optional | decimal | 4779 | in_other_cap_gain_dist | F | ESTAR | MONTHLY_ESTAR_NAV | OTHER_CAP_GAIN_DIST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDist | ||||||
| marketPrice | Optional | decimal | 4800 | in_market_price | F | ESTAR | MONTHLY_ESTAR_NAV | MARKET_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPrice | ||||||
| averageMaturityDays | Optional | integer | 4809 | in_avg_maturity_days | I | ESTAR | MONTHLY_ESTAR_NAV | AVG_MATURITY_DAYS | NUMBER | EagleML/warehouseTransaction/warehouseNAVMonthEnd/averageMaturityDays | ||||||
| incomeAdjustmentAmount | Optional | decimal | 4482 | in_income_adjustment_amt | ESTAR | MONTHLY_ESTAR_NAV | INCOME_ADJUSTMENT_AMT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeAdjustmentAmount | |||||||
| securitiesPriced | Optional | decimal | 3968 | in_securities_priced | ESTAR | MONTHLY_ESTAR_NAV | SECURITIES_PRICED | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesPriced | |||||||
| securitiesTotal | Optional | decimal | 3969 | in_securities_total | ESTAR | MONTHLY_ESTAR_NAV | SECURITIES_TOTAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesTotal | |||||||
| navChange | Optional | integer | 4225 | in_nav_change | ESTAR | MONTHLY_ESTAR_NAV | NAV_CHANGE | NUMBER | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChange | |||||||
| navVariance | Optional | decimal | 4226 | in_nav_variance | ESTAR | MONTHLY_ESTAR_NAV | NAV_VARIANCE | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVariance | |||||||
| reportingNavChange | Optional | decimal | 10149 | ESTAR | MONTHLY_ESTAR_NAV | REPORTING_NAV_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportingNavChange | ||||||||
| reportingPublicOffering | Optional | decimal | 4227 | in_public_offering | ESTAR | MONTHLY_ESTAR_NAV | PUBLIC_OFFERING | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportingPublicOffering | |||||||
| publicOfferingChange | Optional | decimal | 4228 | in_public_offering_change | ESTAR | MONTHLY_ESTAR_NAV | PUBLIC_OFFERING_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingChange | |||||||
| navCalcCount | Optional | decimal | 4251 | in_nav_calc_count | ESTAR | MONTHLY_ESTAR_NAV | NAV_CALC_COUNT | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcCount | |||||||
| preferredNetAssets | Optional | integer | 4630 | in_pref_net_asset | ESTAR | MONTHLY_ESTAR_NAV | PREFERRED_NET_ASSETS | NUMBER(38,10) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/preferredNetAssets | |||||||
| nasdaqTransmissionStatus | Optional | normalizedString | 4784 | in_nasdaq_trans_status | ESTAR | MONTHLY_ESTAR_NAV | NASDAQ_TRANSMISSION_STATUS | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqTransmissionStatus | |||||||
| nasdaqCompletedStatus | Optional | normalizedString | 4785 | in_nasdaq_compltd_status | ESTAR | MONTHLY_ESTAR_NAV | NASDAQ_COMPLETED_STATUS | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqCompletedStatus | |||||||
| approvalStatus | Optional | decimal | 4786 | ESTAR | MONTHLY_ESTAR_NAV | APPROVAL_STATUS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalStatus | ||||||||
| approvalMode | Optional | decimal | 4787 | ESTAR | MONTHLY_ESTAR_NAV | APPROVAL_MODE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalMode | ||||||||
| approvalUser | Optional | normalizedString | 4788 | ESTAR | MONTHLY_ESTAR_NAV | APPROVAL_USER | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalUser | ||||||||
| approvalDatetime | Optional | date | 4789 | ESTAR | MONTHLY_ESTAR_NAV | APPROVAL_DATETIME | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalDatetime | ||||||||
| overrideFlag | Optional | normalizedString | 3623 | in_override_flag | ESTAR | MONTHLY_ESTAR_NAV | OVERRIDE_FLAG | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideFlag | |||||||
| overrideUser | Optional | normalizedString | 3625 | in_override_user | ESTAR | MONTHLY_ESTAR_NAV | OVERRIDE_USER | VARCHAR2(8) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideUser | |||||||
| overrideDatetime | Optional | decimal | 3624 | in_overridde_dt | ESTAR | MONTHLY_ESTAR_NAV | OVERRIDE_DATETIME | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideDatetime | |||||||
| netAssetAmountOvr | Optional | decimal | 4776 | in_net_asset_amnt_ovr | ESTAR | MONTHLY_ESTAR_NAV | NET_ASSET_AMOUNT_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmountOvr | |||||||
| shortTermCapGainDistOvr | Optional | decimal | 4777 | in_short_term_cap_dist_ovr | ESTAR | MONTHLY_ESTAR_NAV | SHORT_TERM_CAP_GAIN_DIST_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDistOvr | |||||||
| longTermCapGainDistOvr | Optional | decimal | 4778 | in_long_term_cap_dist_ovr | ESTAR | MONTHLY_ESTAR_NAV | LONG_TERM_CAP_GAIN_DIST_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDistOvr | |||||||
| otherCapGainDistOvr | Optional | decimal | 4780 | in_other_cap_gain_dist_ovr | ESTAR | MONTHLY_ESTAR_NAV | OTHER_CAP_GAIN_DIST_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDistOvr | |||||||
| stockDividend | Optional | decimal | 4781 | in_stock_dividend | ESTAR | MONTHLY_ESTAR_NAV | STOCK_DIVIDEND | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividend | |||||||
| stockDividendOvr | Optional | decimal | 4782 | in_stock_dividend_ovr | ESTAR | MONTHLY_ESTAR_NAV | STOCK_DIVIDEND_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividendOvr | |||||||
| publicOfferingOvr | Optional | decimal | 4783 | in_public_offering_ovr | ESTAR | MONTHLY_ESTAR_NAV | PUBLIC_OFFERING_OVR | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingOvr | |||||||
| marketPriceOvr | Optional | decimal | 4801 | in_market_price_ovr | ESTAR | MONTHLY_ESTAR_NAV | MARKET_PRICE_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPriceOvr | |||||||
| cashDividendOvr | Optional | decimal | 4803 | in_cash_dividend_ovr | ESTAR | MONTHLY_ESTAR_NAV | CASH_DIVIDEND_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividendOvr | |||||||
| unallocatedDistr | Optional | decimal | 4804 | in_unallocated_distr | ESTAR | MONTHLY_ESTAR_NAV | UNALLOCATED_DISTR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/unallocatedDistr | |||||||
| footnotes | Optional | decimal | 4805 | in_foot_notes | ESTAR | MONTHLY_ESTAR_NAV | FOOTNOTES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/footnotes | |||||||
| millRate7dayEffectiveYieldOvr | Optional | decimal | ESTAR | MONTHLY_ESTAR_NAV | MILL_RATE_7DAY_EFF_YIELD_OVR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYieldOvr | |||||||||
| funcCode | Optional | decimal | 4807 | in_func_code | ESTAR | MONTHLY_ESTAR_NAV | FUNC_CODE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/funcCode | |||||||
| navChangePersent | Optional | decimal | 4815 | in_nav_change_percent | ESTAR | MONTHLY_ESTAR_NAV | NAV_CHANGE_PERCENT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChangePersent | |||||||
| stockSplitRate | Optional | decimal | 4832 | in_stock_split_rate | ESTAR | MONTHLY_ESTAR_NAV | STOCK_SPLIT_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRate | |||||||
| stockSplitRateOvr | Optional | decimal | 4833 | in_stock_split_rate_ovr | ESTAR | MONTHLY_ESTAR_NAV | STOCK_SPLIT_RATE_OVR | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRateOvr | |||||||
| priorNAV | Optional | decimal | 4817 | in_prior_nav | ESTAR | MONTHLY_ESTAR_NAV | PRIOR_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/priorNAV | |||||||
| acknowledgedNAV | Optional | decimal | 4818 | in_acknowledged_nav | ESTAR | MONTHLY_ESTAR_NAV | ACKNOWLEDGED_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedNAV | |||||||
| acknowledgedPop | Optional | decimal | 4819 | in_acknowledged_pop | ESTAR | MONTHLY_ESTAR_NAV | ACKNOWLEDGED_POP | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedPop | |||||||
| capGains | Optional | decimal | 4842 | in_cap_gains | ESTAR | MONTHLY_ESTAR_NAV | CAP_GAINS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/capGains | |||||||
| prevDayNAV | Optional | decimal | 4820 | in_prev_day_nav | ESTAR | MONTHLY_ESTAR_NAV | PREV_DAY_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/prevDayNAV | |||||||
| assets | Optional | decimal | 4825 | ESTAR | MONTHLY_ESTAR_NAV | ASSETS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/assets | ||||||||
| lastAckNAV | Optional | decimal | 4834 | in_last_ack_nav | ESTAR | MONTHLY_ESTAR_NAV | LAST_ACK_NAV | NUMBER(38,9) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckNAV | |||||||
| lastAckPop | Optional | decimal | 4835 | in_last_ack_pop | ESTAR | MONTHLY_ESTAR_NAV | LAST_ACK_POP | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckPop | |||||||
| lastCalcNAV | Optional | decimal | 4841 | in_last_calc_nav | ESTAR | MONTHLY_ESTAR_NAV | LAST_CALC_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastCalcNAV | |||||||
| navChangeTolerance | Optional | decimal | 4836 | in_nav_change_tolerance | ESTAR | MONTHLY_ESTAR_NAV | NAV_CHANGE_TOLERANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChangeTolerance | |||||||
| navReconTolerance | Optional | decimal | 4837 | in_nav_recon_tolerance | ESTAR | MONTHLY_ESTAR_NAV | NAV_RECON_TOLERANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReconTolerance | |||||||
| popChange | Optional | decimal | 4838 | in_pop_change | ESTAR | MONTHLY_ESTAR_NAV | POP_CHANGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/popChange | |||||||
| navPublicationVariance2 | Optional | decimal | 4839 | in_nav_pub_variance_2 | ESTAR | MONTHLY_ESTAR_NAV | NAV_PUBLICATION_VARIANCE_2 | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance2 | |||||||
| navPublicationVariance4 | Optional | decimal | 4840 | in_nav_pub_variance_4 | ESTAR | MONTHLY_ESTAR_NAV | NAV_PUBLICATION_VARIANCE_4 | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance4 | |||||||
| calculatedDate | Optional | date | 4843 | in_calculated_dt | ESTAR | MONTHLY_ESTAR_NAV | CALCULATED_DT | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/calculatedDate | |||||||
| navVariancePersent | Optional | decimal | 4774 | in_nav_var_percent | ESTAR | MONTHLY_ESTAR_NAV | NAV_VARIANCE_PERCENT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVariancePersent | |||||||
| navCalcDateTime | Optional | date | 5522 | in_nav_calc_dt_time | ESTAR | MONTHLY_ESTAR_NAV | NAV_CALC_DATE_TIME | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcDateTime | |||||||
| navVerificationAmount | Optional | decimal | 5521 | in_nav_verification_amount | ESTAR | MONTHLY_ESTAR_NAV | NAV_VERIFICATION_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVerificationAmount | |||||||
| outstandingSubs | Optional | decimal | 11717 | in_outstanding_subs | ESTAR | MONTHLY_ESTAR_NAV | OUTSTANDING_SUBS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingSubs | |||||||
| outstandingExchSubs | Optional | decimal | 11718 | in_outstanding_exch_subs | ESTAR | MONTHLY_ESTAR_NAV | OUTSTANDING_EXCH_SUBS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchSubs | |||||||
| outstandingReds | Optional | decimal | 11719 | in_outstanding_reds | ESTAR | MONTHLY_ESTAR_NAV | OUTSTANDING_REDS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchReds | |||||||
| outstandingReinvest | Optional | decimal | 11721 | in_outstanding_reinvest | ESTAR | MONTHLY_ESTAR_NAV | OUTSTANDING_REINVEST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingReinvest | |||||||
| settledSubs | Optional | decimal | 11722 | in_settled_subs | ESTAR | MONTHLY_ESTAR_NAV | SETTLED_SUBS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledSubs | |||||||
| settledExchSubs | Optional | decimal | 11723 | in_settled_exch_subs | ESTAR | MONTHLY_ESTAR_NAV | SETTLED_EXCH_SUBS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchSubs | |||||||
| settledReds | Optional | decimal | 11724 | in_settled_reds | ESTAR | MONTHLY_ESTAR_NAV | SETTLED_REDS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReds | |||||||
| settledExchangeReds | Optional | decimal | 11725 | in_settled_exchange_reds | ESTAR | MONTHLY_ESTAR_NAV | SETTLED_EXCHANGE_REDS | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchangeReds | |||||||
| settledReinv | Optional | decimal | 11726 | in_settled_reinv | ESTAR | MONTHLY_ESTAR_NAV | SETTLED_REINV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReinv | |||||||
| navPrecision | Optional | decimal | 10065 | in_nav_round_precision | ESTAR | MONTHLY_ESTAR_NAV | NAV_PRECISION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPrecision | |||||||
| cashDividend | Optional | decimal | 4802 | in_cash_dividend | ESTAR | MONTHLY_ESTAR_NAV | CASH_DIVIDEND | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividend | |||||||
| transClosedFlag | Optional | decimal | 1299 | in_trans_closed_flag | ESTAR | MONTHLY_ESTAR_NAV | TRANS_CLOSED_FLAG | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedFlag | |||||||
| transClosedDate | Optional | date | 1003 | in_trans_closed_dt | ESTAR | MONTHLY_ESTAR_NAV | TRANS_CLOSED_DT | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedDate | |||||||
| transClosedUserId | Optional | decimal | 1005 | in_trans_closed_usr_id | ESTAR | MONTHLY_ESTAR_NAV | TRANS_CLOSED_USER_ID | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedUserId | |||||||
| transReopenUserId | Optional | decimal | 1004 | in_trans_reopen_usr_id | ESTAR | MONTHLY_ESTAR_NAV | TRANS_REOPEN_USER_ID | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/transReopenUserId | |||||||
| closedFlag | Optional | decimal | 2072 | in_closed_flag | ESTAR | MONTHLY_ESTAR_NAV | CLOSED_FLAG | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/closedFlag | |||||||
| closedDate | Optional | date | 933 | in_closed_dt | ESTAR | MONTHLY_ESTAR_NAV | CLOSED_DT | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/closedDate | |||||||
| closedUserId | Optional | decimal | 934 | in_closed_usr_id | ESTAR | MONTHLY_ESTAR_NAV | CLOSED_USER_ID | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/closedUserId | |||||||
| reopenUserId | Optional | decimal | 935 | ESTAR | MONTHLY_ESTAR_NAV | REOPEN_USER_ID | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenUserId | ||||||||
| reopenedDate | Optional | date | 1006 | in_trans_reopened_dt | ESTAR | MONTHLY_ESTAR_NAV | REOPENED_DT | DATE | EagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenedDate | |||||||
| reportingNav | Optional | decimal | ESTAR | MONTHLY_ESTAR_NAV | REPORTING_NAV | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportingNav | |||||||||
| shareClassDescription | Optional | decimal | ESTAR | MONTHLY_ESTAR_NAV | SHARE_CLASS_DESCRIPTION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClassDescription | |||||||||
| navRoundingInd | Optional | decimal | 10064 | in_nav_rounding_ind | ESTAR | MONTHLY_ESTAR_NAV | NAV_ROUNDING_INDICATOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navRoundingInd | |||||||
| shareClassDescription | Optional | decimal | ESTAR | MONTHLY_ESTAR_NAV | SHARE_CLASS_DESCRIPTION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClassDescription | |||||||||
| Entity Share Class Model (extract-only, see extra data map table) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/ | |||||||||||||||
| NAV Report Details Model (see extra table below) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/ | |||||||||||||||
| ||||||||||||||||
| mktValueBaseCash | Optional | decimal | ESTAR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueBaseCash | |||||||||||
| mktValueForeignCash | Optional | decimal | ESTAR | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueForeignCas | |||||||||||
...