Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Also on this page:

Table of Contents

ElementOptional/ RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldDB Field TypeXPath
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


ESTARMONTHLY_ESTAR_NAVUPDATE_DATEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/updateTimestamp
customElementsNot recommendedCustomElements


reserved for customization
EagleML/warehouseTransaction/warehouseNAVMonthEnd/customElements/
sourceNameRequiredstring





CHAR(15)EagleML/warehouseTransaction/warehouseNAVMonthEnd/sourceName
updateSource
string


ESTARMONTHLY_ESTAR_NAVUPDATE_SOURCEVARCHAR2(32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/updateSource
batchCollectErrorsFlag
YesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/batchCollectErrorsFlag
singleRowCommitFlag
YesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/singleRowCommitFlag
reportType
FundReportTypeEnum

not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportType
Entity Common Id ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/
Extended Entity Properties Model (extract-only)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
accountingBasis
string


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/accountingBasis
Asset Identifiers ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/
Extended Asset Properties Model (extract-only)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
maturityDate
date


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/maturityDate
shareClassRequirednormalizedString34in_share_classSESTARMONTHLY_ESTAR_NAVSHARE_CLASSVARCHAR2(10)EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClass
valuationDateRequireddate3192in_valuation_dateSESTARMONTHLY_ESTAR_NAVVALUATION_DATEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/valuationDate
navSequenceRequiredinteger3196in_nav_rounding_indIESTARMONTHLY_ESTAR_NAVNAV_SEQUENCENUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navSequence
netAssetAmount
decimal3193in_nav_amount
ESTARMONTHLY_ESTAR_NAVNET_ASSET_AMOUNTNUMBER(38,2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmount
navAmountPerShare
decimal3195in_nav_per_share
ESTARMONTHLY_ESTAR_NAVNAV_AMOUNT_PER_SHARENUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navAmountPerShare
navSharesOutstanding
decimal3209in_shares_outstanding
ESTARMONTHLY_ESTAR_NAVSHARES_OUTSTANDINGNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navSharesOutstanding
sharesSettled
decimal758in_shares_settled
ESTARMONTHLY_ESTAR_NAVSHARES_SETTLEDNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/sharesSettled
status
string3190in_status
ESTARMONTHLY_ESTAR_NAVSTATUSVARCHAR2(8)EagleML/warehouseTransaction/warehouseNAVMonthEnd/status
activeFlag
normalizedString1283in_active_flagSESTARMONTHLY_ESTAR_NAVACTIVE_FLAGVARCHAR2(5)EagleML/warehouseTransaction/warehouseNAVMonthEnd/activeFlag
millRateAdjustmentAmount
decimal4282in_mill_rate_adjustment_amtFESTARMONTHLY_ESTAR_NAVMILL_RATE_ADJUSTMENT_AMTNUMBER(38,2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateAdjustmentAmount
millRateDaysInYear
integer4283in_mill_rate_days_in_yearIESTARMONTHLY_ESTAR_NAVMILL_RATE_DAYS_IN_YEARNUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInYear
millRateDaysInMonth
integer4284in_mill_rate_days_in_monthIESTARMONTHLY_ESTAR_NAVMILL_RATE_DAYS_IN_MONTHNUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInMonth
millRateWeeksInYear
decimal4285in_mill_rate_weeks_in_yearFESTARMONTHLY_ESTAR_NAVMILL_RATE_WEEKS_IN_YEARNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateWeeksInYear
millRateDailyYield
decimal4286in_mill_rate_daily_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_DAILY_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDailyYield
millRate7dayEffectiveYield
decimal4287in_mill_rate_7day_eff_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_7DAY_EFF_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYield
millRate7dayAverageYield
decimal4288in_mill_rate_7day_avg_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_7DAY_AVG_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayAverageYield
millRate30dayEffectiveYield
decimal4289in_mill_rate_30day_eff_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_30DAY_EFF_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayEffectiveYield
millRate30dayAverageYield
decimal4290in_mill_rate_30day_avg_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_30DAY_AVG_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayAverageYield
incomeDistribution
decimal4229in_income_distributionFESTARMONTHLY_ESTAR_NAVINCOME_DISTRIBUTIONNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeDistribution
shortTermCapGainDist
decimal4230in_short_term_cap_gain_dist
ESTARMONTHLY_ESTAR_NAVSHORT_TERM_CAP_GAIN_DISTNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDist
longTermCapGainDist
decimal4231in_long_term_cap_gain_dist
ESTARMONTHLY_ESTAR_NAVLONG_TERM_CAP_GAIN_DISTNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDist
netActivity
decimal478in_net_activityFESTARMONTHLY_ESTAR_NAVNET_ACTIVITYNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/netActivity
distributionReinvestAmount
decimal741in_distribution_reinvest_amtFESTARMONTHLY_ESTAR_NAVDISTRIBUTION_REINVEST_AMTNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/distributionReinvestAmount
fixedDistributionAmount
decimal4484in_fixed_distribution_amt
ESTARMONTHLY_ESTAR_NAVFIXED_DISTRIBUTION_AMTNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/fixedDistributionAmount
millRate
decimal4564in_MILL_RATE
ESTARMONTHLY_ESTAR_NAVMILL_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate
allocRatio
decimal756in_alloc_ratioFESTARMONTHLY_ESTAR_NAVALLOC_RATIONUMBER(38,10)EagleML/warehouseTransaction/warehouseNAVMonthEnd/allocRatio
periodicDistributionAmount
decimal4759in_periodic_dist_amt
ESTARMONTHLY_ESTAR_NAVPERIODIC_DISTRIBUTION_AMTNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/periodicDistributionAmount
otherCapGainDist
decimal4779in_other_cap_gain_distFESTARMONTHLY_ESTAR_NAVOTHER_CAP_GAIN_DISTNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDist
stockDividendRate
decimal


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividendRate
marketPrice
decimal4800in_market_priceFESTARMONTHLY_ESTAR_NAVMARKET_PRICENUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPrice
averageMaturityDays
integer4809in_avg_maturity_daysIESTARMONTHLY_ESTAR_NAVAVG_MATURITY_DAYSNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/averageMaturityDays
incomeAdjustmentAmount
decimal4482in_income_adjustment_amt
ESTARMONTHLY_ESTAR_NAVINCOME_ADJUSTMENT_AMTNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeAdjustmentAmount
estimateVersion
integer


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/estimateVersion
securitiesPriced
decimal3968in_securities_priced
ESTARMONTHLY_ESTAR_NAVSECURITIES_PRICEDNUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesPriced
securitiesTotal
decimal3969in_securities_total
ESTARMONTHLY_ESTAR_NAVSECURITIES_TOTALNUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesTotal
estimateQuality
EstimateQualityEnum3194

ESTARMONTHLY_ESTAR_NAVESTIMATE_QUALITYCHAR(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/estimateQuality
millRatePaymentFrequency
string4291

ESTARMONTHLY_ESTAR_NAVMILL_RATE_PAYMENT_FREQUENCYVARCHAR2(2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRatePaymentFrequency
navChange
integer4225in_nav_change
ESTARMONTHLY_ESTAR_NAVNAV_CHANGENUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChange
navVariance
decimal4226in_nav_variance
ESTARMONTHLY_ESTAR_NAVNAV_VARIANCENUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVariance
publicOffering
decimal4227in_public_offering
ESTARMONTHLY_ESTAR_NAVPUBLIC_OFFERINGNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOffering
publicOfferingChange
decimal4228in_public_offering_change
ESTARMONTHLY_ESTAR_NAVPUBLIC_OFFERING_CHANGENUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingChange
navCalcCount
decimal4251in_nav_calc_count
ESTARMONTHLY_ESTAR_NAVNAV_CALC_COUNTNUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcCount
preferredNetAssets
integer4630in_pref_net_asset
ESTARMONTHLY_ESTAR_NAVPREFERRED_NET_ASSETSNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/preferredNetAssets
nasdaqTransmissionStatus
normalizedString4784in_nasdaq_trans_status
ESTARMONTHLY_ESTAR_NAVNASDAQ_TRANSMISSION_STATUSVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqTransmissionStatus
nasdaqCompletedStatus
normalizedString4785in_nasdaq_compltd_status
ESTARMONTHLY_ESTAR_NAVNASDAQ_COMPLETED_STATUSVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqCompletedStatus
approvalStatus
decimal4786

ESTARMONTHLY_ESTAR_NAVAPPROVAL_STATUSVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalStatus
approvalMode
decimal4787

ESTARMONTHLY_ESTAR_NAVAPPROVAL_MODEVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalMode
approvalUser
normalizedString4788

ESTARMONTHLY_ESTAR_NAVAPPROVAL_USERVARCHAR2(32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalUser
approvalDatetime
date4789

ESTARMONTHLY_ESTAR_NAVAPPROVAL_DATETIMEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalDatetime
overrideFlag
normalizedString3623in_override_flag
ESTARMONTHLY_ESTAR_NAVOVERRIDE_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideFlag
overrideUser
normalizedString3625in_override_user
ESTARMONTHLY_ESTAR_NAVOVERRIDE_USERVARCHAR2(32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideUser
overrideDatetime
decimal3624in_overridde_dt
ESTARMONTHLY_ESTAR_NAVOVERRIDE_DATETIMEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideDatetime
netAssetAmountOvr
decimal4776in_net_asset_amnt_ovr
ESTARMONTHLY_ESTAR_NAVNET_ASSET_AMOUNT_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmountOvr
shortTermCapGainDistOvr
decimal4777in_short_term_cap_dist_ovr
ESTARMONTHLY_ESTAR_NAVSHORT_TERM_CAP_GAIN_DIST_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDistOvr
longTermCapGainDistOvr
decimal4778in_long_term_cap_dist_ovr
ESTARMONTHLY_ESTAR_NAVLONG_TERM_CAP_GAIN_DIST_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDistOvr
otherCapGainDistOvr
decimal4780in_other_cap_gain_dist_ovr
ESTARMONTHLY_ESTAR_NAVOTHER_CAP_GAIN_DIST_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDistOvr
stockDividend
decimal4781in_stock_dividend
ESTARMONTHLY_ESTAR_NAVSTOCK_DIVIDENDNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividend
stockDividendOvr
decimal4782in_stock_dividend_ovr
ESTARMONTHLY_ESTAR_NAVSTOCK_DIVIDEND_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividendOvr
publicOfferingOvr
decimal4783in_public_offering_ovr
ESTARMONTHLY_ESTAR_NAVPUBLIC_OFFERING_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingOvr
marketPriceOvr
decimal4801in_market_price_ovr
ESTARMONTHLY_ESTAR_NAVMARKET_PRICE_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPriceOvr
cashDividendOvr
decimal4803in_cash_dividend_ovr
ESTARMONTHLY_ESTAR_NAVCASH_DIVIDEND_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividendOvr
unallocatedDistr
decimal4804in_unallocated_distr
ESTARMONTHLY_ESTAR_NAVUNALLOCATED_DISTRNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/unallocatedDistr
footnotes
decimal4805in_foot_notes
ESTARMONTHLY_ESTAR_NAVFOOTNOTESVARCHAR2(5)EagleML/warehouseTransaction/warehouseNAVMonthEnd/footnotes
millRate7dayEffectiveYieldOvr
decimal


ESTARMONTHLY_ESTAR_NAVMILL_RATE_7DAY_EFF_YIELD_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYieldOvr
funcCode
decimal4807in_func_code
ESTARMONTHLY_ESTAR_NAVFUNC_CODEVARCHAR2(2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/funcCode
navChangePercent
decimal4815in_nav_change_percent
ESTARMONTHLY_ESTAR_NAVNAV_CHANGE_PERCENTNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/navChangePercent
stockSplitRate
decimal4832in_stock_split_rate
ESTARMONTHLY_ESTAR_NAVSTOCK_SPLIT_RATENUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRate
stockSplitRateOvr
decimal4833in_stock_split_rate_ovr
ESTARMONTHLY_ESTAR_NAVSTOCK_SPLIT_RATE_OVRVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRateOvr
priorNAV
decimal4817in_prior_nav
ESTARMONTHLY_ESTAR_NAVPRIOR_NAVNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/priorNAV
acknowledgedNAV
decimal4818in_acknowledged_nav
ESTARMONTHLY_ESTAR_NAVACKNOWLEDGED_NAVNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedNAV
acknowledgedPop
decimal4819in_acknowledged_pop
ESTARMONTHLY_ESTAR_NAVACKNOWLEDGED_POPNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedPop
capGains
decimal4842in_cap_gains
ESTARMONTHLY_ESTAR_NAVCAP_GAINSNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/capGains
prevDayNAV
decimal4820in_prev_day_nav
ESTARMONTHLY_ESTAR_NAVPREV_DAY_NAVNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/prevDayNAV
assets
decimal4825

ESTARMONTHLY_ESTAR_NAVASSETSNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/assets
lastAckNAV
decimal4834in_last_ack_nav
ESTARMONTHLY_ESTAR_NAVLAST_ACK_NAVNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckNAV
lastAckPop
decimal4835in_last_ack_pop
ESTARMONTHLY_ESTAR_NAVLAST_ACK_POPNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckPop
lastCalcNAV
decimal4841in_last_calc_nav
ESTARMONTHLY_ESTAR_NAVLAST_CALC_NAVNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/lastCalcNAV
navChangeTolerance
decimal4836in_nav_change_tolerance
ESTARMONTHLY_ESTAR_NAVNAV_CHANGE_TOLERANCENUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/navChangeTolerance
navReconTolerance
decimal4837in_nav_recon_tolerance
ESTARMONTHLY_ESTAR_NAVNAV_RECON_TOLERANCENUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/navReconTolerance
popChange
decimal4838in_pop_change
ESTARMONTHLY_ESTAR_NAVPOP_CHANGENUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/popChange
navPublicationVariance2
decimal4839in_nav_pub_variance_2
ESTARMONTHLY_ESTAR_NAVNAV_PUBLICATION_VARIANCE_2NUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance2
navPublicationVariance4
decimal4840in_nav_pub_variance_4
ESTARMONTHLY_ESTAR_NAVNAV_PUBLICATION_VARIANCE_4NUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance4
calculatedDate
date4843in_calculated_dt
ESTARMONTHLY_ESTAR_NAVCALCULATED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/calculatedDate
navVariancePercent
decimal4774in_nav_var_percent
ESTARMONTHLY_ESTAR_NAVNAV_VARIANCE_PERCENTNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/navVariancePercent
navCalcDateTime
date5522in_nav_calc_dt_time
ESTARMONTHLY_ESTAR_NAVNAV_CALC_DATE_TIMEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcDateTime
navVerificationAmount
decimal5521in_nav_verification_amount
ESTARMONTHLY_ESTAR_NAVNAV_VERIFICATION_AMOUNTNUMBER(38,2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVerificationAmount
outstandingSubs
decimal11717in_outstanding_subs
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_SUBSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingSubs
outstandingExchSubs
decimal11718in_outstanding_exch_subs
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_EXCH_SUBSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchSubs
outstandingReds
decimal11719in_outstanding_reds
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_REDSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchReds
outstandingExchReds
decimal11720

ESTARMONTHLY_ESTAR_NAVOUTSTANDING_EXCH_REDSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchReds
outstandingReinvest
decimal11721in_outstanding_reinvest
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_REINVESTNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingReinvest
settledSubs
decimal11722in_settled_subs
ESTARMONTHLY_ESTAR_NAVSETTLED_SUBSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledSubs
settledExchSubs
decimal11723in_settled_exch_subs
ESTARMONTHLY_ESTAR_NAVSETTLED_EXCH_SUBSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchSubs
settledReds
decimal11724in_settled_reds
ESTARMONTHLY_ESTAR_NAVSETTLED_REDSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReds
settledExchangeReds
decimal11725in_settled_exchange_reds
ESTARMONTHLY_ESTAR_NAVSETTLED_EXCHANGE_REDSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchangeReds
settledReinv
decimal11726in_settled_reinv
ESTARMONTHLY_ESTAR_NAVSETTLED_REINVNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReinv
navPrecision
decimal10065in_nav_round_precision
ESTARMONTHLY_ESTAR_NAVNAV_PRECISIONNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/navPrecision
cashDividend
decimal4802in_cash_dividend
ESTARMONTHLY_ESTAR_NAVCASH_DIVIDENDNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividend
transClosedFlag
decimal1299in_trans_closed_flag
ESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedFlag
transClosedDate
date1003in_trans_closed_dt
ESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedDate
transClosedUserId
decimal1005in_trans_closed_usr_id
ESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_USER_IDVARCHAR2(32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedUserId
transReopenUserId
decimal1004in_trans_reopen_usr_id
ESTARMONTHLY_ESTAR_NAVTRANS_REOPEN_USER_IDVARCHAR2(32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/transReopenUserId
navmeClosedFlag
decimal2072in_closed_flag
ESTARMONTHLY_ESTAR_NAVCLOSED_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navmeClosedFlag
navmeClosedDate
date933in_closed_dt
ESTARMONTHLY_ESTAR_NAVCLOSED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/navmeClosedDate
closedUserId
decimal934in_closed_usr_id
ESTARMONTHLY_ESTAR_NAVCLOSED_USER_IDVARCHAR2(32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/closedUserId
reopenUserId
decimal935

ESTARMONTHLY_ESTAR_NAVREOPEN_USER_IDVARCHAR2(32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenUserId
reopenedDate
date1006in_trans_reopened_dt
ESTARMONTHLY_ESTAR_NAVREOPENED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenedDate
reportingNav
decimal


ESTARMONTHLY_ESTAR_NAVREPORTING_NAVNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportingNav
navPercentChange
decimal1870in_nav_percent_change
HOLDINGDBONAV_MULTINAV_PERCENT_CHANGE
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPercentChange
shareClassDescription
decimal


PACE_MASTERDBOCODE_VALUESLONG_DESC
EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClassDescription
navRoundingInd
decimal10064in_nav_rounding_ind
ESTARMONTHLY_ESTAR_NAVNAV_ROUNDING_INDICATORVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navRoundingInd
transReopenendDate
date


ESTARMONTHLY_ESTAR_NAVTRANS_REOPENED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/transReopenendDate
Entity Share Class Model (extract-only
,
)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navReportDetails NAV Report Details Model (see extra
data map
table below)EagleML/warehouseTransaction
/warehouseNAVMonthEnd/navReportDetails NAV Report Details
/warehouseNAVMonthEnd/navReportDetails/


Anchor
navReportDetails
navReportDetails
NAV Report Details Model Data Map Table

Info

Please set includeReportDetails="Y" in the RTR to add navReportDetails model to a single extract or W_INCLUDE_REPORT_DETAILS="Y" global parameter to enhance all NAV Month End extracts in the environment


priorNAV
priorNAV Model (see extra table below)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/NAV Report Details Model Data Map Table
priorNAVpriorNAV Model
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/
mktValueCash
mktValueCash Model (see extra table below)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/
shareClassLevel
shareClassLevel Model (see extra table below)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/
totalFundLevel
totalFundLevel Model (see extra table below)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/
distributionLogLevels
distributionLogLevels Model (see extra table below)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/
estarSecYield30Day
estarSecYield30Day Model (see extra table below)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/
transferAgentMillRate
decimal


Calculated value millRate + shortTermCapGainDist
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/transferAgentMillRate
rawNavChange
decimal


Calculated value navAmountPerShare - priorRawNAV
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/rawNavChange
reportingNavChange
decimal


Calculated value


EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/reportingNavChange
netAssetsTotalFund
decimal


Calculated value - sum of netAssetAmount values grouped by entityId + valuationDate + navSequenceEagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/netAssetsTotalFund

Anchor
priorNAV
priorNAV
priorNAV Model Data Map Table

priorValuationDate
date
calculated field
HOLDINGDBONAV_MULTIVALUATION_DATEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorValuationDate
priorRawNAV
decimal
calculated field
HOLDINGDBONAV_MULTINAV_AMOUNT_PER_SHARENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorRawNAV
priorNetAssetsNAV
decimal
calculated field
HOLDINGDBONAV_MULTINET_ASSET_AMOUNTNUMBER(38,2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorNetAssetsNAV
priorSharesOutstanding
decimal
calculated field
HOLDINGDBONAV_MULTISHARES_OUTSTANDINGNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorSharesOutstanding
priorMillRate
decimal
calculated field
HOLDINGDBONAV_MULTIMILL_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorMillRate
priorMillRateDailyYield
decimal
calculated field
HOLDINGDBONAV_MULTIMILL_RATE_DAILY_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorMillRateDailyYield
reportingPublicOfferPrior
decimal
calculated field
HOLDINGDBONAV_MULTIREPORTING_PUBLIC_OFFER_PRIOR
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/reportingPublicOfferPrior
reportingNavPrior
decimal
calculated field
HOLDINGDBONAV_MULTIREPORTING_NAV_PRIOR
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/reportingNavPrior

Anchor
mktValueCash
mktValueCash
mktValueCash Data Map Table

mktValueBaseCash
decimal
calculated field
HOLDINGDBOPOSITION_DETAILSTAR_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueBaseCash
mktValueForeignCash
decimal
calculated field
HOLDINGDBOPOSITION_DETAILSTAR_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueForeignCash
mktValueSource
string
calculated field
PACE_MASTERDBOINTERFACESSHORT_DESC
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueSource

Anchor
shareClassLevel
shareClassLevel
shareClassLevel Data Map Table

accretionAmortization
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/accretionAmortization
currentNetAssets
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/currentNetAssets
currentSharesOutstanding
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/currentSharesOutstanding
expenses
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/expenses
interestIncome
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/interestIncome
netAssetChange
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/netAssetChange
previousNetAssets
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/previousNetAssets
priorSharesOutstanding
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/priorSharesOutstanding
totalActivityMovement
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/totalActivityMovement
variance
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/variance
contrForDscReceivable
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/contrForDscReceivable
currentShareActivity
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/currentShareActivity
derivativesCashFlow
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/derivativesCashFlow
distributions
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/distributions
dividendIncome
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/dividendIncome
fyeAsAfActivity
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/fyeAsAfActivity
litigationCommission
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/litigationCommission
marketValue
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/marketValue
markToMarkets
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/markToMarkets
miscellaneous
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/miscellaneous
miscellaneousIncome
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/miscellaneousIncome
netShareholderActivity
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/netShareholderActivity
realizedCurrencyGainLoss
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/realizedCurrencyGainLoss
tradingGainLoss
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/tradingGainLoss
variationMargin
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/variationMargin

Anchor
totalFundLevel
totalFundLevel
totalFundLevel Data Map Table

accretionAmortization
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/accretionAmortization
currentNetAssets
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/currentNetAssets
currentSharesOutstanding
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/currentSharesOutstanding
expenses
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/expenses
interestIncome
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/interestIncome
netAssetChange
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/netAssetChange
previousNetAssets
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/previousNetAssets
priorSharesOutstanding
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/priorSharesOutstanding
totalActivityMovement
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/totalActivityMovement
variance
decimal
calculated field
ARCH_CTRLCTRNAV_DETAILSBALANCE_CHANGENUMBER(22,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/variance

Anchor
distributionLogLevels
distributionLogLevels
distributionLogLevels Data Map Table

distributionLogLevel Data Map Table

fixedAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmount
periodicIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmount
periodicLTAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmount
periodicSPAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmount
periodicSTAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmount
periodicADJIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmount
periodicADJLTAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmount
periodicADJSPAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmount
periodicADJSTAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmount
niiIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmount
niiADJIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmount
setIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIAmount
setADJIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmount
fixedRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedRate
periodicIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRate
periodicLTRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRate
periodicSPRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRate
periodicSTRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRate
periodicADJIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRate
periodicADJLTRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRate
periodicADJSPRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRate
periodicADJSTRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRate
niiIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIRate
niiADJIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRate
setIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIRate
setADJIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIRate
fixedAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmountN
periodicIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmountN
periodicLTAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmountN
periodicSPAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmountN
periodicSTAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmountN
periodicADJIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmountN
periodicADJLTAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmountN
periodicADJSPAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmountN
periodicADJSTAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmountN
niiIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmountN
niiADJIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmountN
setIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIAmountN
setADJIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmountN
fixedRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedRateN
periodicIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRateN
periodicLTRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRateN
periodicSPRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRateN
periodicSTRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRateN
periodicADJIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRateN
periodicADJLTRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRateN
periodicADJSPRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRateN
periodicADJSTRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRateN
niiIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIRateN
niiADJIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRateN
setIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIRateN
setADJIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIRateN
totalFixedDistrAmount
decimal
calculated field




EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/totalFixedDistrAmount
totalFixedDistrRate
decimal
calculated field




EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/totalFixedDistrRate
totalDailyDistrAmount
decimal
calculated field




EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/totalDailyDistrAmount
totalDailyDistrRate
decimal
calculated field




EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/totalDailyDistrRate
totalPeriodicDistrAmount
decimal
calculated field




EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/totalPeriodicDistrAmount
totalPeriodicDistrRate
decimal
calculated field




EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/totalPeriodicDistrRate
distributionShares
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_SHARESNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/distributionShares

Anchor
estarSecYield30Day
estarSecYield30Day
estarSecYield30Day Data Map Table

secYldTaxEqWithWvrReim
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSEC_YLD_TAX_EQ_WITH_WVR_REIMNUMBER(28,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldTaxEqWithWvrReim
secYldTaxEqWithoutWvrReim
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSEC_YLD_TAX_EQ_WOUT_WVR_REIMNUMBER(28,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldTaxEqWithoutWvrReim
secYldWithWvrReim
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSEC_YLD_WITH_WVR_REIMNUMBER(28,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldWithWvrReim
secYldWithoutWvrReim
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSEC_YLD_WOUT_WVR_REIMNUMBER(28,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldWithoutWvrReim
secIncome30Day
decimal
calculated field
ESTARESTAR_SECYLD_30DAYINCOME_30DAYNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secIncome30Day
taxEqIncome30Day
decimal
calculated field
ESTARESTAR_SECYLD_30DAYTAX_EQ_INCOME_30DAYNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/taxEqIncome30Day
wVRReim30Day
decimal
calculated field
ESTARESTAR_SECYLD_30DAYWVR_REIM_30DAYNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/wVRReim30Day
secExpenses30Day
decimal
calculated field
ESTARESTAR_SECYLD_30DAYEXPENSES_30DAYNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secExpenses30Day
secAverageShares
decimal
calculated field
ESTARESTAR_SECYLD_30DAYAVERAGE_SHARESNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secAverageShares
maxOfferingPrice
decimal
calculated field
ESTARESTAR_SECYLD_30DAYMAX_OFFER_PRICENUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/maxOfferingPrice
adjustedMOP
decimal
calculated field
ESTARESTAR_SECYLD_30DAYADJUSTED_MOPNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/adjustedMOP
totalNetAssets
decimal
calculated field
ESTARESTAR_SECYLD_30DAYTOTAL_NET_ASSETSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/totalNetAssets
undistributedIncome
decimal
calculated field
ESTARESTAR_SECYLD_30DAYUNDISTRIBUTED_INCNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/undistributedIncome
shares
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSHARESNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/shares
approvedFlag
YesNoOptionEnum
calculated field
ESTARESTAR_SECYLD_30DAYAPPROVED_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/approvedFlag
incomeWithoutShort30Day
decimal
calculated field
ESTARESTAR_SECYLD_30DAYINC_WOUT_SHORT_30DAYNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/incomeWithoutShort30Day
shortDividendIncome
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSH_DIV_INCNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/shortDividendIncome
expectedWithShortDividend
decimal
calculated field
ESTARESTAR_SECYLD_30DAYEXP_WITH_SH_DIVNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/expectedWithShortDividend