Versions Compared

Old Version 7

changes.mady.by.user Dmitry Donosiyan

Saved on

compared with

New Version 8

changes.mady.by.user Dmitry Donosiyan

Saved on

Key

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


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
Optional

string


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

YesNoOptionEnum


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

YesNoOptionEnum


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

not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportType
Entity Common Id ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/
Extended Entity PropertiesEagleML/warehouseTransaction/warehouseNAVMonthEnd/
accountingBasis
string


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/accountingBasis
Asset Identifiers ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/
Extended Asset PropertiesEagleML/warehouseTransaction/warehouseNAVMonthEnd/
maturityDate
Optional

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
Optional

decimal3193in_nav_amount
ESTARMONTHLY_ESTAR_NAVNET_ASSET_AMOUNTNUMBER(38,2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmount
navAmountPerShare
Optional

decimal3195in_nav_per_share
ESTARMONTHLY_ESTAR_NAVNAV_AMOUNT_PER_SHARENUMBER(38,
12Optional
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navAmountPerShare
sharesOutstanding
navSharesOutstanding
decimal3209in_shares_outstanding
ESTARMONTHLY_ESTAR_NAVSHARES_OUTSTANDINGNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
sharesOutstanding
navSharesOutstanding
sharesSettled
Optional

decimal758in_shares_settled
ESTARMONTHLY_ESTAR_NAVSHARES_SETTLEDNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/sharesSettled
status
Optional

string3190in_status
ESTARMONTHLY_ESTAR_NAVSTATUSVARCHAR2(8)EagleML/warehouseTransaction/warehouseNAVMonthEnd/status
activeFlag
Optional

normalizedString1283in_active_flagSESTARMONTHLY_ESTAR_NAVACTIVE_FLAGVARCHAR2(5)EagleML/warehouseTransaction/warehouseNAVMonthEnd/activeFlag
millRateAdjustmentAmount
Optional

decimal4282in_mill_rate_adjustment_amtFESTARMONTHLY_ESTAR_NAVMILL_RATE_ADJUSTMENT_AMTNUMBER(38,2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateAdjustmentAmount
millRateDaysInYear
Optional

integer4283in_mill_rate_days_in_yearIESTARMONTHLY_ESTAR_NAVMILL_RATE_DAYS_IN_YEARNUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInYear
millRateDaysInMonth
Optional

integer4284in_mill_rate_days_in_monthIESTARMONTHLY_ESTAR_NAVMILL_RATE_DAYS_IN_MONTHNUMBER(38,0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInMonth
millRateWeeksInYear
Optional

decimal4285in_mill_rate_weeks_in_yearFESTARMONTHLY_ESTAR_NAVMILL_RATE_WEEKS_IN_YEARNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateWeeksInYear
millRateDailyYield
Optional

decimal4286in_mill_rate_daily_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_DAILY_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDailyYield
millRate7dayEffectiveYield
Optional

decimal4287in_mill_rate_7day_eff_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_7DAY_EFF_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYield
millRate7dayAverageYield
Optional

decimal4288in_mill_rate_7day_avg_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_7DAY_AVG_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayAverageYield
millRate30dayEffectiveYield
Optional

decimal4289in_mill_rate_30day_eff_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_30DAY_EFF_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayEffectiveYield
millRate30dayAverageYield
Optional

decimal4290in_mill_rate_30day_avg_yieldFESTARMONTHLY_ESTAR_NAVMILL_RATE_30DAY_AVG_YIELDNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayAverageYield
incomeDistribution
Optional

decimal4229in_income_distributionFESTARMONTHLY_ESTAR_NAVINCOME_DISTRIBUTIONNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeDistribution
shortTermCapGainDist
Optional

decimal4230in_short_term_cap_gain_dist
ESTARMONTHLY_ESTAR_NAVSHORT_TERM_CAP_GAIN_DISTNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDist
longTermCapGainDist
Optional

decimal4231in_long_term_cap_gain_dist
ESTARMONTHLY_ESTAR_NAVLONG_TERM_CAP_GAIN_DISTNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDist
netActivity
Optional

decimal478in_net_activityFESTARMONTHLY_ESTAR_NAVNET_ACTIVITYNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/netActivity
distributionReinvestAmount
Optional

decimal741in_distribution_reinvest_amtFESTARMONTHLY_ESTAR_NAVDISTRIBUTION_REINVEST_AMTNUMBER(38,9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/distributionReinvestAmount
fixedDistributionAmount
Optional

decimal4484in_fixed_distribution_amt
ESTARMONTHLY_ESTAR_NAVFIXED_DISTRIBUTION_AMTNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/fixedDistributionAmount
millRate
Optional

decimal4564in_MILL_RATE
ESTARMONTHLY_ESTAR_NAVMILL_RATENUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate
allocRatio
Optional

decimal756in_alloc_ratioFESTARMONTHLY_ESTAR_NAVALLOC_RATIONUMBER(38,10)EagleML/warehouseTransaction/warehouseNAVMonthEnd/allocRatio
periodicDistributionAmount
Optional

decimal4759in_periodic_dist_amt
ESTARMONTHLY_ESTAR_NAVPERIODIC_DISTRIBUTION_AMTNUMBER(38,
12decimal
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/periodicDistributionAmount
otherCapGainDist
Optional

decimal4779in_other_cap_gain_distFESTARMONTHLY_ESTAR_NAVOTHER_CAP_GAIN_DISTNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDist
stockDividendRate
decimal


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividendRate
marketPrice
Optional

decimal4800in_market_priceFESTARMONTHLY_ESTAR_NAVMARKET_PRICENUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPrice
averageMaturityDays
Optional

integer4809in_avg_maturity_daysIESTARMONTHLY_ESTAR_NAVAVG_MATURITY_DAYSNUMBEREagleML/warehouseTransaction/warehouseNAVMonthEnd/averageMaturityDays
incomeAdjustmentAmount
Optional

decimal4482in_income_adjustment_amt
ESTARMONTHLY_ESTAR_NAVINCOME_ADJUSTMENT_AMTNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeAdjustmentAmount
estimateVersion
integer


not stored in DB
EagleML/warehouseTransaction/warehouseNAVMonthEnd/estimateVersion
securitiesPriced
Optional

decimal3968in_securities_priced
ESTARMONTHLY_ESTAR_NAVSECURITIES_PRICEDNUMBER(38,
12
0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesPriced
securitiesTotal
Optional

decimal3969in_securities_total
ESTARMONTHLY_ESTAR_NAVSECURITIES_TOTALNUMBER(38,
12
0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesTotal
navChange
estimateQuality
Optional

EstimateQualityEnum
integer4225in_nav_change
3194

ESTARMONTHLY_ESTAR_NAV
NAV
ESTIMATE_
CHANGENUMBER
QUALITYCHAR(1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navChange4226
estimateQuality
navVarianceOptionaldecimal
millRatePaymentFrequency
string4291

ESTARMONTHLY_ESTAR_NAVMILL_RATE_PAYMENT_FREQUENCYVARCHAR2(2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRatePaymentFrequency
navChange
integer4225in_nav_
variance
change
ESTARMONTHLY_ESTAR_NAVNAV_
VARIANCE
CHANGENUMBER(38,
10
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChange
navVariance
reportingNavChange

decimal
Optionaldecimal10149
4226in_nav_variance
ESTARMONTHLY_ESTAR_NAV
REPORTING_
NAV_
CHANGE
VARIANCENUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
reportingNavChange
navVariance
reportingPublicOffering
publicOffering
Optional

decimal4227in_public_offering
ESTARMONTHLY_ESTAR_NAVPUBLIC_OFFERINGNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
reportingPublicOffering
publicOffering
publicOfferingChange
Optional

decimal4228in_public_offering_change
ESTARMONTHLY_ESTAR_NAVPUBLIC_OFFERING_CHANGENUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingChange
navCalcCount
Optional

decimal4251in_nav_calc_count
ESTARMONTHLY_ESTAR_NAVNAV_CALC_COUNTNUMBER(38,
10
0)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcCount
preferredNetAssets
Optional

integer4630in_pref_net_asset
ESTARMONTHLY_ESTAR_NAVPREFERRED_NET_ASSETSNUMBER(38,
10
9)EagleML/warehouseTransaction/warehouseNAVMonthEnd/preferredNetAssets
nasdaqTransmissionStatus
Optional

normalizedString4784in_nasdaq_trans_status
ESTARMONTHLY_ESTAR_NAVNASDAQ_TRANSMISSION_STATUSVARCHAR2(
8
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqTransmissionStatus
nasdaqCompletedStatus
Optional

normalizedString4785in_nasdaq_compltd_status
ESTARMONTHLY_ESTAR_NAVNASDAQ_COMPLETED_STATUSVARCHAR2(
8
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqCompletedStatus
approvalStatus
Optional

decimal4786

ESTARMONTHLY_ESTAR_NAVAPPROVAL_STATUS
NUMBER
VARCHAR2(
28,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalStatus
approvalMode
Optional

decimal4787

ESTARMONTHLY_ESTAR_NAVAPPROVAL_MODE
NUMBER
VARCHAR2(
28,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalMode
approvalUser
Optional

normalizedString4788

ESTARMONTHLY_ESTAR_NAVAPPROVAL_USERVARCHAR2(
8
32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalUser
approvalDatetime
Optional

date4789

ESTARMONTHLY_ESTAR_NAVAPPROVAL_DATETIMEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalDatetime
overrideFlag
Optional

normalizedString3623in_override_flag
ESTARMONTHLY_ESTAR_NAVOVERRIDE_FLAGVARCHAR2(
8
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideFlag
overrideUser
Optional

normalizedString3625in_override_user
ESTARMONTHLY_ESTAR_NAVOVERRIDE_USERVARCHAR2(
8
32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideUser
overrideDatetime
Optional

decimal3624in_overridde_dt
ESTARMONTHLY_ESTAR_NAVOVERRIDE_DATETIMEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideDatetime
netAssetAmountOvr
Optional

decimal4776in_net_asset_amnt_ovr
ESTARMONTHLY_ESTAR_NAVNET_ASSET_AMOUNT_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmountOvr
shortTermCapGainDistOvr
Optional

decimal4777in_short_term_cap_dist_ovr
ESTARMONTHLY_ESTAR_NAVSHORT_TERM_CAP_GAIN_DIST_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDistOvr
longTermCapGainDistOvr
Optional

decimal4778in_long_term_cap_dist_ovr
ESTARMONTHLY_ESTAR_NAVLONG_TERM_CAP_GAIN_DIST_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDistOvr
otherCapGainDistOvr
Optional

decimal4780in_other_cap_gain_dist_ovr
ESTARMONTHLY_ESTAR_NAVOTHER_CAP_GAIN_DIST_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDistOvr
stockDividend
Optional

decimal4781in_stock_dividend
ESTARMONTHLY_ESTAR_NAVSTOCK_DIVIDENDNUMBER(
28
38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividend
stockDividendOvr
Optional

decimal4782in_stock_dividend_ovr
ESTARMONTHLY_ESTAR_NAVSTOCK_DIVIDEND_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividendOvr
publicOfferingOvr
Optional

decimal4783in_public_offering_ovr
ESTARMONTHLY_ESTAR_NAVPUBLIC_OFFERING_OVR
NUMBER
VARCHAR2(
28,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingOvr
marketPriceOvr
Optional

decimal4801in_market_price_ovr
ESTARMONTHLY_ESTAR_NAVMARKET_PRICE_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPriceOvr
cashDividendOvr
Optional

decimal4803in_cash_dividend_ovr
ESTARMONTHLY_ESTAR_NAVCASH_DIVIDEND_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividendOvr
unallocatedDistr
Optional

decimal4804in_unallocated_distr
ESTARMONTHLY_ESTAR_NAVUNALLOCATED_DISTRNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/unallocatedDistr
footnotes
Optional

decimal4805in_foot_notes
ESTARMONTHLY_ESTAR_NAVFOOTNOTES
NUMBER
VARCHAR2(
38,12
5)EagleML/warehouseTransaction/warehouseNAVMonthEnd/footnotes
millRate7dayEffectiveYieldOvr
Optional

decimal


ESTARMONTHLY_ESTAR_NAVMILL_RATE_7DAY_EFF_YIELD_OVR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYieldOvr
funcCode
Optional

decimal4807in_func_code
ESTARMONTHLY_ESTAR_NAVFUNC_CODE
NUMBER
VARCHAR2(
38,12
2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/funcCode
navChangePersent
navChangePercent
Optional

decimal4815in_nav_change_percent
ESTARMONTHLY_ESTAR_NAVNAV_CHANGE_PERCENTNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navChangePersent
navChangePercent
stockSplitRate
Optional

decimal4832in_stock_split_rate
ESTARMONTHLY_ESTAR_NAVSTOCK_SPLIT_RATENUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRate
stockSplitRateOvr
Optional

decimal4833in_stock_split_rate_ovr
ESTARMONTHLY_ESTAR_NAVSTOCK_SPLIT_RATE_OVR
NUMBER
VARCHAR2(
28,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRateOvr
priorNAV
Optional

decimal4817in_prior_nav
ESTARMONTHLY_ESTAR_NAVPRIOR_NAVNUMBER
(38,12)EagleML
EagleML/warehouseTransaction/warehouseNAVMonthEnd/priorNAV
acknowledgedNAV
Optional

decimal4818in_acknowledged_nav
ESTARMONTHLY_ESTAR_NAVACKNOWLEDGED_NAVNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedNAV
acknowledgedPop
Optional

decimal4819in_acknowledged_pop
ESTARMONTHLY_ESTAR_NAVACKNOWLEDGED_POPNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedPop
capGains
Optional

decimal4842in_cap_gains
ESTARMONTHLY_ESTAR_NAVCAP_GAINSNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/capGains
prevDayNAV
Optional

decimal4820in_prev_day_nav
ESTARMONTHLY_ESTAR_NAVPREV_DAY_NAVNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/prevDayNAV
assets
Optional

decimal4825

ESTARMONTHLY_ESTAR_NAVASSETSNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/assets
lastAckNAV
Optional

decimal4834in_last_ack_nav
ESTARMONTHLY_ESTAR_NAVLAST_ACK_NAVNUMBER
(38,9)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckNAV
lastAckPop
Optional

decimal4835in_last_ack_pop
ESTARMONTHLY_ESTAR_NAVLAST_ACK_POPNUMBER
(28,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckPop
lastCalcNAV
Optional

decimal4841in_last_calc_nav
ESTARMONTHLY_ESTAR_NAVLAST_CALC_NAVNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastCalcNAV
navChangeTolerance
Optional

decimal4836in_nav_change_tolerance
ESTARMONTHLY_ESTAR_NAVNAV_CHANGE_TOLERANCENUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChangeTolerance
navReconTolerance
Optional

decimal4837in_nav_recon_tolerance
ESTARMONTHLY_ESTAR_NAVNAV_RECON_TOLERANCENUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReconTolerance
popChange
Optional

decimal4838in_pop_change
ESTARMONTHLY_ESTAR_NAVPOP_CHANGENUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/popChange
navPublicationVariance2
Optional

decimal4839in_nav_pub_variance_2
ESTARMONTHLY_ESTAR_NAVNAV_PUBLICATION_VARIANCE_2NUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance2
navPublicationVariance4
Optional

decimal4840in_nav_pub_variance_4
ESTARMONTHLY_ESTAR_NAVNAV_PUBLICATION_VARIANCE_4NUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance4
calculatedDate
Optional

date4843in_calculated_dt
ESTARMONTHLY_ESTAR_NAVCALCULATED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/calculatedDate
navVariancePersent
navVariancePercent
Optional

decimal4774in_nav_var_percent
ESTARMONTHLY_ESTAR_NAVNAV_VARIANCE_PERCENTNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navVariancePersent
navVariancePercent
navCalcDateTime
Optional

date5522in_nav_calc_dt_time
ESTARMONTHLY_ESTAR_NAVNAV_CALC_DATE_TIMEDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcDateTime
navVerificationAmount
Optional

decimal5521in_nav_verification_amount
ESTARMONTHLY_ESTAR_NAVNAV_VERIFICATION_AMOUNTNUMBER(38,
12
2)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVerificationAmount
outstandingSubs
Optional

decimal11717in_outstanding_subs
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_SUBSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingSubs
outstandingExchSubs
Optional

decimal11718in_outstanding_exch_subs
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_EXCH_SUBSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchSubs
outstandingReds
Optional

decimal11719in_outstanding_reds
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_REDSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchReds
outstandingExchReds
decimal11720

ESTARMONTHLY_ESTAR_NAVOUTSTANDING_EXCH_REDSNUMBER(38,6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchReds
outstandingReinvest
Optional

decimal11721in_outstanding_reinvest
ESTARMONTHLY_ESTAR_NAVOUTSTANDING_REINVESTNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingReinvest
settledSubs
Optional

decimal11722in_settled_subs
ESTARMONTHLY_ESTAR_NAVSETTLED_SUBSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledSubs
settledExchSubs
Optional

decimal11723in_settled_exch_subs
ESTARMONTHLY_ESTAR_NAVSETTLED_EXCH_SUBSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchSubs
settledReds
Optional

decimal11724in_settled_reds
ESTARMONTHLY_ESTAR_NAVSETTLED_REDSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReds
settledExchangeReds
Optional

decimal11725in_settled_exchange_reds
ESTARMONTHLY_ESTAR_NAVSETTLED_EXCHANGE_REDSNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchangeReds
settledReinv
Optional

decimal11726in_settled_reinv
ESTARMONTHLY_ESTAR_NAVSETTLED_REINVNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReinv
navPrecision
Optional

decimal10065in_nav_round_precision
ESTARMONTHLY_ESTAR_NAVNAV_PRECISIONNUMBER
(38,12)
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPrecision
cashDividend
Optional

decimal4802in_cash_dividend
ESTARMONTHLY_ESTAR_NAVCASH_DIVIDENDNUMBER(38,
12
6)EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividend
transClosedFlag
Optional

decimal1299in_trans_closed_flag
ESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_FLAG
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedFlag
transClosedDate
Optional

date1003in_trans_closed_dt
ESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedDate
transClosedUserId
Optional

decimal1005in_trans_closed_usr_id
ESTARMONTHLY_ESTAR_NAVTRANS_CLOSED_USER_ID
NUMBER
VARCHAR2(
38,12
32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedUserId
transReopenUserId
Optional

decimal1004in_trans_reopen_usr_id
ESTARMONTHLY_ESTAR_NAVTRANS_REOPEN_USER_ID
NUMBER
VARCHAR2(
38,12
32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/transReopenUserId
closedFlag
navmeClosedFlag
Optional

decimal2072in_closed_flag
ESTARMONTHLY_ESTAR_NAVCLOSED_FLAG
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
closedFlag
navmeClosedFlag
closedDate
navmeClosedDate
Optional

date933in_closed_dt
ESTARMONTHLY_ESTAR_NAVCLOSED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/
closedDate
navmeClosedDate
closedUserId
Optional

decimal934in_closed_usr_id
ESTARMONTHLY_ESTAR_NAVCLOSED_USER_ID
NUMBER
VARCHAR2(
38,12
32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/closedUserId
reopenUserId
Optional

decimal935

ESTARMONTHLY_ESTAR_NAVREOPEN_USER_ID
NUMBER
VARCHAR2(
38,12
32)EagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenUserId
reopenedDate
Optional

date1006in_trans_reopened_dt
ESTARMONTHLY_ESTAR_NAVREOPENED_DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenedDate
reportingNav
OptionalOptional

decimal


ESTARMONTHLY_ESTAR_NAVREPORTING_NAVNUMBER(38,12)EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportingNav
shareClassDescriptionNUMBER(38,12)
navPercentChange
decimal
ESTARMONTHLY_ESTAR_NAVSHARE_CLASS_DESCRIPTION
1870in_nav_percent_change
HOLDINGDBONAV_MULTINAV_PERCENT_CHANGE
EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPercentChange
shareClassDescription
decimal


PACE_MASTERDBOCODE_VALUESLONG_DESC
EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClassDescription
navRoundingInd
Optional

decimal10064in_nav_rounding_ind
ESTARMONTHLY_ESTAR_NAVNAV_ROUNDING_INDICATOR
NUMBER
VARCHAR2(
38,12
1)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navRoundingInd
shareClassDescription
transReopenendDate
Optional

date
decimal



ESTARMONTHLY_ESTAR_NAV
SHARE
TRANS_
CLASS
REOPENED_
DESCRIPTIONNUMBER(38,12)EagleML
DTDATEEagleML/warehouseTransaction/warehouseNAVMonthEnd/
shareClassDescription
transReopenendDate
Entity Share Class Model (extract-only, see extra data map table)EagleML/warehouseTransaction/warehouseNAVMonthEnd/
navReportDetails NAV Report Details Model (see extra table below)EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/
anchorNAV_Report_Details
NAV_Report_Details
NAV Report Details Model Data Map Table
mktValueBaseCashNUMBER(38,12)







priorNAV
OptionaldecimalESTAR

priorNAV ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/
mktValueCash
mktValueCash ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/
mktValueBaseCash
mktValueForeignCashNUMBER(38,12)
shareClassLevel
OptionaldecimalESTAR

shareClassLevel ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/
totalFundLevel
totalFundLevel ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/
mktValueCash/mktValueForeignCas
totalFundLevel/
distributionLogLevels
distributionLogLevels ModelEagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/
estarSecYield30Day
estarSecYield30Day ModelEagleML/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
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
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
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
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
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
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