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 table below)EagleML/warehouseTransaction/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/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
/reportingNavChangereportingPublicOfferingOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmount
periodicIAmount
decimal
4227in_public_offering

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
PUBLIC
DISTRIBUTION_
OFFERING
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/reportingPublicOfferingpublicOfferingChangeOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmount
periodicLTAmount
decimal
4228in_public_offering_change

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
PUBLIC
DISTRIBUTION_
OFFERING_CHANGE
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/publicOfferingChangenavCalcCountOptionaldecimal4251in_nav_calc_countESTARMONTHLY_ESTAR_NAVNAV_CALC_COUNT
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmount
periodicSPAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,
10
12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navCalcCountpreferredNetAssetsOptionalinteger4630in_pref_net_assetESTARMONTHLY_ESTAR_NAVPREFERRED_NET_ASSETS
navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmount
periodicSTAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,
10
12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
preferredNetAssetsnasdaqTransmissionStatusOptionalnormalizedString4784in_nasdaq_trans_status
navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmount
periodicADJIAmount
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
NASDAQ
DISTRIBUTION_
TRANSMISSION_STATUS
AMOUNT
VARCHAR2
NUMBER(
8
38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
nasdaqTransmissionStatusnasdaqCompletedStatusOptionalnormalizedString4785in_nasdaq_compltd_statusESTARMONTHLY_ESTAR_NAVNASDAQ_COMPLETED_STATUSVARCHAR2(8
navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmount
periodicADJLTAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
nasdaqCompletedStatusapprovalStatusOptional
navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmount
periodicADJSPAmount
decimal
4786

calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
APPROVAL
DISTRIBUTION_
STATUS
AMOUNTNUMBER(
28
38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/approvalStatusapprovalModeOptionaldecimal4787
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmount
periodicADJSTAmount
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
APPROVAL
DISTRIBUTION_
MODE
AMOUNTNUMBER(
28
38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/approvalModeapprovalUserOptionalnormalizedString4788ESTARMONTHLY_ESTAR_NAVAPPROVAL_USERVARCHAR2(8
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmount
niiIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
approvalUserapprovalDatetimeOptionaldate4789
navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmount
niiADJIAmount
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
APPROVAL
DISTRIBUTION_
DATETIMEDATE
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
approvalDatetimeoverrideFlagOptionalnormalizedString3623in_override_flagESTARMONTHLY_ESTAR_NAVOVERRIDE_FLAGVARCHAR2(8
navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmount
setIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
overrideFlagoverrideUserOptionalnormalizedString3625in_override_userESTARMONTHLY_ESTAR_NAVOVERRIDE_USERVARCHAR2(8
navReportDetails/distributionLogLevels/distributionLogLevel/setIAmount
setADJIAmount
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/overrideUseroverrideDatetimeOptionaldecimal3624in_overridde_dtESTARMONTHLY_ESTAR_NAVOVERRIDE_DATETIMEDATE
/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmount
fixedRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/overrideDatetimenetAssetAmountOvrOptionaldecimal4776in_net_asset_amnt_ovrESTARMONTHLY_ESTAR_NAVNET_ASSET_AMOUNT_OVR
/navReportDetails/distributionLogLevels/distributionLogLevel/fixedRate
periodicIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/netAssetAmountOvrshortTermCapGainDistOvrOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRate
periodicLTRate
decimal
4777in_short_term_cap_dist_ovrESTARMONTHLY_ESTAR_NAVSHORT_TERM_CAP_GAIN_DIST_OVR

calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
shortTermCapGainDistOvrlongTermCapGainDistOvrOptional
navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRate
periodicSPRate
decimal
4778in_long_term_cap_dist_ovrESTARMONTHLY_ESTAR_NAVLONG_TERM_CAP_GAIN_DIST_OVR

calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/longTermCapGainDistOvrotherCapGainDistOvrOptionaldecimal4780in_other_cap_gain_dist_ovrESTARMONTHLY_ESTAR_NAVOTHER_CAP_GAIN_DIST_OVR
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRate
periodicSTRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/otherCapGainDistOvrstockDividendOptionaldecimal4781in_stock_dividendESTARMONTHLY_ESTAR_NAVSTOCK_DIVIDENDNUMBER(28
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRate
periodicADJIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/stockDividendstockDividendOvrOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRate
periodicADJLTRate
decimal
4782in_stock_dividend_ovr

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
STOCK
DISTRIBUTION_
DIVIDEND_OVR
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/stockDividendOvrpublicOfferingOvrOptionaldecimal4783in_public_offering_ovrESTARMONTHLY_ESTAR_NAVPUBLIC_OFFERING_OVRNUMBER(28
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRate
periodicADJSPRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
publicOfferingOvrmarketPriceOvrOptional
navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRate
periodicADJSTRate
decimal
4801in_market_price_ovr

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
MARKET
DISTRIBUTION_
PRICE_OVR
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/marketPriceOvrcashDividendOvrOptionaldecimal4803in_cash_dividend_ovrESTARMONTHLY_ESTAR_NAVCASH_DIVIDEND_OVR
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRate
niiIRate
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
cashDividendOvrunallocatedDistrOptional
navReportDetails/distributionLogLevels/distributionLogLevel/niiIRate
niiADJIRate
decimal
4804in_unallocated_distr

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
UNALLOCATED
DISTRIBUTION_
DISTR
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/unallocatedDistrfootnotesOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRate
setIRate
decimal
4805in_foot_notes

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
FOOTNOTES
DISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/footnotesmillRate7dayEffectiveYieldOvrOptionaldecimal
/navReportDetails/distributionLogLevels/distributionLogLevel/setIRate
setADJIRate
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
MILL
DISTRIBUTION_RATE
_7DAY_EFF_YIELD_OVR
NUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
millRate7dayEffectiveYieldOvrfuncCodeOptionaldecimal4807in_func_code
navReportDetails/distributionLogLevels/distributionLogLevel/setADJIRate
fixedAmountN
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
FUNC
DISTRIBUTION_
CODE
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/funcCodenavChangePersentOptionaldecimal4815in_nav_change_percentESTARMONTHLY_ESTAR_NAVNAV_CHANGE_PERCENT
/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmountN
periodicIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/navChangePersentstockSplitRateOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmountN
periodicLTAmountN
decimal
4832in_stock_split_rate

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
STOCK
DISTRIBUTION_
SPLIT_RATE
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction
/warehouseNAVMonthEnd/stockSplitRatestockSplitRateOvrOptionaldecimal4833in_stock_split_rate_ovrESTARMONTHLY_ESTAR_NAVSTOCK_SPLIT_RATE_OVRNUMBER(28
/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmountN
periodicSPAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/stockSplitRateOvrpriorNAVOptionaldecimal4817in_prior_navESTARMONTHLY_ESTAR_NAVPRIOR_NAV
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmountN
periodicSTAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/priorNAVacknowledgedNAVOptionaldecimal4818in_acknowledged_nav
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmountN
periodicADJIAmountN
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
ACKNOWLEDGED
DISTRIBUTION_
NAV
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/acknowledgedNAVacknowledgedPopOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmountN
periodicADJLTAmountN
decimal
4819in_acknowledged_pop

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
ACKNOWLEDGED
DISTRIBUTION_
POP
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/acknowledgedPopcapGainsOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmountN
periodicADJSPAmountN
decimal
4842in_cap_gains

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
CAP
DISTRIBUTION_
GAINS
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
capGainsprevDayNAVOptional
navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmountN
periodicADJSTAmountN
decimal
4820in_prev_day_nav

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
PREV
DISTRIBUTION_
DAY_NAV
AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/prevDayNAVassetsOptionaldecimal4825
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmountN
niiIAmountN
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
ASSETS
DISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/assetslastAckNAVOptionaldecimal4834in_last_ack_navESTARMONTHLY_ESTAR_NAVLAST_ACK_NAV
/navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmountN
niiADJIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,
9
12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/lastAckNAVlastAckPopOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmountN
setIAmountN
decimal
4835in_last_ack_pop

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
LAST
DISTRIBUTION_
ACK_POP
AMOUNTNUMBER(
28
38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/lastAckPoplastCalcNAVOptionaldecimal4841in_last_calc_navESTARMONTHLY_ESTAR_NAVLAST_CALC_NAV
/navReportDetails/distributionLogLevels/distributionLogLevel/setIAmountN
setADJIAmountN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_AMOUNTNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
lastCalcNAVnavChangeToleranceOptionaldecimal4836in_nav_change_tolerance
navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmountN
fixedRateN
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
NAV
DISTRIBUTION_
CHANGE_TOLERANCE
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navChangeTolerancenavReconToleranceOptionaldecimal4837in_nav_recon_toleranceESTARMONTHLY_ESTAR_NAVNAV_RECON_TOLERANCE
navReportDetails/distributionLogLevels/distributionLogLevel/fixedRateN
periodicIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/navReconTolerancepopChangeOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRateN
periodicLTRateN
decimal
4838in_pop_change

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
POP
DISTRIBUTION_
CHANGE
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/popChangenavPublicationVariance2Optional
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRateN
periodicSPRateN
decimal
4839in_nav_pub_variance_2

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
NAV_PUBLICATION_VARIANCE_2
DISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/navPublicationVariance2navPublicationVariance4Optionaldecimal4840in_nav_pub_variance_4ESTARMONTHLY_ESTAR_NAVNAV_PUBLICATION_VARIANCE_4
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRateN
periodicSTRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/navPublicationVariance4calculatedDateOptionaldate4843in_calculated_dt
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRateN
periodicADJIRateN
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
CALCULATED
DISTRIBUTION_
DTDATE
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
calculatedDatenavVariancePersentOptional
navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRateN
periodicADJLTRateN
decimal
4774in_nav_var_percent

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
NAV
DISTRIBUTION_
VARIANCE_PERCENT
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/navVariancePersentnavCalcDateTimeOptionaldate5522in_nav_calc_dt_timeESTARMONTHLY_ESTAR_NAVNAV_CALC_DATE_TIMEDATE
/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRateN
periodicADJSPRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navCalcDateTimenavVerificationAmountOptionaldecimal5521in_nav_verification_amountESTARMONTHLY_ESTAR_NAVNAV_VERIFICATION_AMOUNT
navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRateN
periodicADJSTRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navVerificationAmountoutstandingSubsOptionaldecimal11717in_outstanding_subs
navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRateN
niiIRateN
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
DIST_
NAV
LOG
OUTSTANDING
DISTRIBUTION_
SUBS
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/outstandingSubsoutstandingExchSubsOptionaldecimal11718in_outstanding_exch_subsESTARMONTHLY_ESTAR_NAVOUTSTANDING_EXCH_SUBS
/navReportDetails/distributionLogLevels/distributionLogLevel/niiIRateN
niiADJIRateN
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/outstandingExchSubsoutstandingRedsOptional
/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRateN
setIRateN
decimal
11719in_outstanding_reds

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
OUTSTANDING
DISTRIBUTION_
REDS
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
outstandingExchRedsoutstandingReinvestOptional
navReportDetails/distributionLogLevels/distributionLogLevel/setIRateN
setADJIRateN
decimal
11721in_outstanding_reinvest

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
DIST_
NAV
LOG
OUTSTANDING
DISTRIBUTION_
REINVEST
RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
outstandingReinvestsettledSubsOptionaldecimal11722in_settled_subsESTARMONTHLY_ESTAR_NAVSETTLED_SUBSNUMBER(38,12)
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
/settledSubssettledExchSubsOptionaldecimal11723in_settled_exch_subsESTARMONTHLY_ESTAR_NAVSETTLED_EXCH_SUBSNUMBER(38,12)
/navReportDetails/distributionLogLevels/distributionLogLevel/totalDailyDistrAmount
totalDailyDistrRate
decimal
calculated field




EagleML/warehouseTransaction/warehouseNAVMonthEnd
/settledExchSubssettledRedsOptionaldecimal11724in_settled_redsESTARMONTHLY_ESTAR_NAVSETTLED_REDSNUMBER(38,12)
/navReportDetails/distributionLogLevels/distributionLogLevel/totalDailyDistrRate
totalPeriodicDistrAmount
decimal
calculated field




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




EagleML/warehouseTransaction/warehouseNAVMonthEnd
/settledExchangeRedssettledReinvOptionaldecimal11726in_settled_reinvESTARMONTHLY_ESTAR_NAVSETTLED_REINV
/navReportDetails/distributionLogLevels/distributionLogLevel/totalPeriodicDistrRate
distributionShares
decimal
calculated field
ESTARESTAR_DIST_LOGDISTRIBUTION_SHARESNUMBER(38,12)EagleML/warehouseTransaction
/warehouseNAVMonthEnd/settledReinvnavPrecisionOptionaldecimal10065in_nav_round_precisionESTARMONTHLY_ESTAR_NAVNAV_PRECISIONNUMBER(38
/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/
navPrecision
secYldTaxEqWithWvrReim
cashDividend
secYldTaxEqWithoutWvrReim
Optional

decimal
decimal

calculated field
4802

ESTAR
in
ESTAR_
cash
SECYLD_
dividendESTARMONTHLY_ESTAR_NAVCASH_DIVIDEND
30DAYSEC_YLD_TAX_EQ_WOUT_WVR_REIMNUMBER(
38
28,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
cashDividendtransClosedFlagOptionaldecimal1299in_trans_closed_flagESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_FLAGNUMBER(38
navReportDetails/estarSecYield30Day/secYldTaxEqWithoutWvrReim
secYldWithWvrReim
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSEC_YLD_WITH_WVR_REIMNUMBER(28,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/
transClosedFlag
secYldWithWvrReim
transClosedDate
secYldWithoutWvrReim
Optional

decimal
date

calculated field
1003

ESTAR
in
ESTAR_
trans
SECYLD_
closed_dtESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_DTDATE
30DAYSEC_YLD_WOUT_WVR_REIMNUMBER(28,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
transClosedDatetransClosedUserIdOptional
navReportDetails/estarSecYield30Day/secYldWithoutWvrReim
secIncome30Day
decimal
1005in_trans_closed_usr_id

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
SECYLD_
NAV
30DAY
TRANS_CLOSED_USER_ID
INCOME_30DAYNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/
transClosedUserId
secIncome30Day
transReopenUserId
taxEqIncome30Day
Optional

decimal
1004in_trans_reopen_usr_id

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
SECYLD_
NAV
30DAY
TRANS
TAX_
REOPEN
EQ_
USER
INCOME_
ID
30DAYNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/
warehouseNAVMonthEnd
estarSecYield30Day/
transReopenUserId
taxEqIncome30Day
closedFlag
wVRReim30Day
Optional

decimal
2072in_closed_flag

calculated field
ESTARESTAR
MONTHLY
_
ESTAR
SECYLD_
NAV
30DAY
CLOSED
WVR_REIM_
FLAG
30DAYNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
closedFlagclosedDateOptionaldate933in_closed_dtESTARMONTHLY_ESTAR_NAVCLOSED_DTDATE
navReportDetails/estarSecYield30Day/wVRReim30Day
secExpenses30Day
decimal
calculated field
ESTARESTAR_SECYLD_30DAYEXPENSES_30DAYNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
closedDateclosedUserIdOptionaldecimal934in_closed_usr_id
navReportDetails/estarSecYield30Day/secExpenses30Day
secAverageShares
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
SECYLD_
NAV
30DAY
CLOSED
AVERAGE_
USER_ID
SHARESNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
closedUserIdreopenUserIdOptionaldecimal935
navReportDetails/estarSecYield30Day/secAverageShares
maxOfferingPrice
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
SECYLD_
NAV
30DAY
REOPEN
MAX_
USER
OFFER_
ID
PRICENUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
reopenUserIdreopenedDateOptionaldate1006in_trans_reopened_dtESTARMONTHLY_ESTAR_NAVREOPENED_DTDATE
navReportDetails/estarSecYield30Day/maxOfferingPrice
adjustedMOP
decimal
calculated field
ESTARESTAR_SECYLD_30DAYADJUSTED_MOPNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
reopenedDatereportingNavOptionaldecimal
navReportDetails/estarSecYield30Day/adjustedMOP
totalNetAssets
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
SECYLD_
NAV
30DAY
REPORTING
TOTAL_NET_
NAV
ASSETSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
reportingNavshareClassDescriptionOptionaldecimal
navReportDetails/estarSecYield30Day/totalNetAssets
undistributedIncome
decimal
calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
SECYLD_
NAV
30DAY
SHARE
UNDISTRIBUTED_
CLASS_DESCRIPTION
INCNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
shareClassDescriptionnavRoundingIndOptional
navReportDetails/estarSecYield30Day/undistributedIncome
shares
decimal
10064in_nav_rounding_indESTARMONTHLY_ESTAR_NAVNAV_ROUNDING_INDICATOR

calculated field
ESTARESTAR_SECYLD_30DAYSHARESNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/
navRoundingInd
shares
shareClassDescription
approvedFlag
Optional

YesNoOptionEnum
decimal

calculated field
ESTAR
MONTHLY
ESTAR_
ESTAR
SECYLD_
NAV
30DAY
SHARE
APPROVED_
CLASS_DESCRIPTION
FLAG
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd
/shareClassDescriptionShareholder Activity Model (extract-only, see extra data map table)EagleML/warehouseTransaction/warehouseNAVMonthEnd/NAV Report Details Model (see extra table below
/navReportDetails/estarSecYield30Day/approvedFlag
incomeWithoutShort30Day
decimal
calculated field
ESTARESTAR_SECYLD_30DAYINC_WOUT_SHORT_30DAYNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/
AnchorNAV_Report_DetailsNAV_Report_DetailsNAV Report Details Model Data Map TablemktValueBaseCashOptionaldecimalESTAR
estarSecYield30Day/incomeWithoutShort30Day
shortDividendIncome
decimal
calculated field
ESTARESTAR_SECYLD_30DAYSH_DIV_INCNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/
mktValueCash
estarSecYield30Day/
mktValueBaseCash
shortDividendIncome
expectedWithShortDividend
mktValueForeignCash

decimal
Optional

calculated field
decimal

ESTARESTAR_SECYLD_30DAYEXP_WITH_SH_DIVNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/
mktValueCash
estarSecYield30Day/
mktValueForeignCas
expectedWithShortDividend