objectType

ObjectTypeEnum

not stored in DB

EagleML/warehouseTransaction/warehouseNAVMonthEnd/objectType

objectId

ObjectId

not stored in DB

EagleML/warehouseTransaction/warehouseNAVMonthEnd/objectId

objectDescription

FeedTypeEnum

not stored in DB

EagleML/warehouseTransaction/warehouseNAVMonthEnd/objectDescription

updateTimestamp

dateTime

ESTAR

MONTHLY_ESTAR_NAV

UPDATE_DATE

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/updateTimestamp

customElements

Not recommended

CustomElements

reserved for customization

EagleML/warehouseTransaction/warehouseNAVMonthEnd/customElements/

sourceName

Required

string

CHAR(15)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/sourceName

updateSource

string

ESTAR

MONTHLY_ESTAR_NAV

UPDATE_SOURCE

VARCHAR2(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 Model

EagleML/warehouseTransaction/warehouseNAVMonthEnd/

Extended Entity Properties Model (extract-only)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/

accountingBasis

string

not stored in DB

EagleML/warehouseTransaction/warehouseNAVMonthEnd/accountingBasis

Asset Identifiers Model

EagleML/warehouseTransaction/warehouseNAVMonthEnd/

Extended Asset Properties Model (extract-only)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/

maturityDate

date

not stored in DB

EagleML/warehouseTransaction/warehouseNAVMonthEnd/maturityDate

shareClass

Required

normalizedString

34

in_share_class

S

ESTAR

MONTHLY_ESTAR_NAV

SHARE_CLASS

VARCHAR2(10)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClass

valuationDate

Required

date

3192

in_valuation_date

S

ESTAR

MONTHLY_ESTAR_NAV

VALUATION_DATE

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/valuationDate

navSequence

Required

integer

3196

in_nav_rounding_ind

I

ESTAR

MONTHLY_ESTAR_NAV

NAV_SEQUENCE

NUMBER(38,0)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navSequence

netAssetAmount

decimal

3193

in_nav_amount

ESTAR

MONTHLY_ESTAR_NAV

NET_ASSET_AMOUNT

NUMBER(38,2)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmount

navAmountPerShare

decimal

3195

in_nav_per_share

ESTAR

MONTHLY_ESTAR_NAV

NAV_AMOUNT_PER_SHARE

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navAmountPerShare

navSharesOutstanding

decimal

3209

in_shares_outstanding

ESTAR

MONTHLY_ESTAR_NAV

SHARES_OUTSTANDING

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navSharesOutstanding

sharesSettled

decimal

758

in_shares_settled

ESTAR

MONTHLY_ESTAR_NAV

SHARES_SETTLED

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/sharesSettled

status

string

3190

in_status

ESTAR

MONTHLY_ESTAR_NAV

STATUS

VARCHAR2(8)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/status

activeFlag

normalizedString

1283

in_active_flag

S

ESTAR

MONTHLY_ESTAR_NAV

ACTIVE_FLAG

VARCHAR2(5)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/activeFlag

millRateAdjustmentAmount

decimal

4282

in_mill_rate_adjustment_amt

F

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_ADJUSTMENT_AMT

NUMBER(38,2)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateAdjustmentAmount

millRateDaysInYear

integer

4283

in_mill_rate_days_in_year

I

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_DAYS_IN_YEAR

NUMBER(38,0)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInYear

millRateDaysInMonth

integer

4284

in_mill_rate_days_in_month

I

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_DAYS_IN_MONTH

NUMBER(38,0)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDaysInMonth

millRateWeeksInYear

decimal

4285

in_mill_rate_weeks_in_year

F

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_WEEKS_IN_YEAR

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateWeeksInYear

millRateDailyYield

decimal

4286

in_mill_rate_daily_yield

F

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_DAILY_YIELD

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRateDailyYield

millRate7dayEffectiveYield

decimal

4287

in_mill_rate_7day_eff_yield

F

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_7DAY_EFF_YIELD

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYield

millRate7dayAverageYield

decimal

4288

in_mill_rate_7day_avg_yield

F

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_7DAY_AVG_YIELD

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayAverageYield

millRate30dayEffectiveYield

decimal

4289

in_mill_rate_30day_eff_yield

F

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_30DAY_EFF_YIELD

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayEffectiveYield

millRate30dayAverageYield

decimal

4290

in_mill_rate_30day_avg_yield

F

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_30DAY_AVG_YIELD

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate30dayAverageYield

incomeDistribution

decimal

4229

in_income_distribution

F

ESTAR

MONTHLY_ESTAR_NAV

INCOME_DISTRIBUTION

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeDistribution

shortTermCapGainDist

decimal

4230

in_short_term_cap_gain_dist

ESTAR

MONTHLY_ESTAR_NAV

SHORT_TERM_CAP_GAIN_DIST

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDist

longTermCapGainDist

decimal

4231

in_long_term_cap_gain_dist

ESTAR

MONTHLY_ESTAR_NAV

LONG_TERM_CAP_GAIN_DIST

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDist

netActivity

decimal

478

in_net_activity

F

ESTAR

MONTHLY_ESTAR_NAV

NET_ACTIVITY

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/netActivity

distributionReinvestAmount

decimal

741

in_distribution_reinvest_amt

F

ESTAR

MONTHLY_ESTAR_NAV

DISTRIBUTION_REINVEST_AMT

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/distributionReinvestAmount

fixedDistributionAmount

decimal

4484

in_fixed_distribution_amt

ESTAR

MONTHLY_ESTAR_NAV

FIXED_DISTRIBUTION_AMT

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/fixedDistributionAmount

millRate

decimal

4564

in_MILL_RATE

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate

allocRatio

decimal

756

in_alloc_ratio

F

ESTAR

MONTHLY_ESTAR_NAV

ALLOC_RATIO

NUMBER(38,10)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/allocRatio

periodicDistributionAmount

decimal

4759

in_periodic_dist_amt

ESTAR

MONTHLY_ESTAR_NAV

PERIODIC_DISTRIBUTION_AMT

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/periodicDistributionAmount

otherCapGainDist

decimal

4779

in_other_cap_gain_dist

F

ESTAR

MONTHLY_ESTAR_NAV

OTHER_CAP_GAIN_DIST

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDist

stockDividendRate

decimal

not stored in DB

EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividendRate

marketPrice

decimal

4800

in_market_price

F

ESTAR

MONTHLY_ESTAR_NAV

MARKET_PRICE

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPrice

averageMaturityDays

integer

4809

in_avg_maturity_days

I

ESTAR

MONTHLY_ESTAR_NAV

AVG_MATURITY_DAYS

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/averageMaturityDays

incomeAdjustmentAmount

decimal

4482

in_income_adjustment_amt

ESTAR

MONTHLY_ESTAR_NAV

INCOME_ADJUSTMENT_AMT

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/incomeAdjustmentAmount

estimateVersion

integer

not stored in DB

EagleML/warehouseTransaction/warehouseNAVMonthEnd/estimateVersion

securitiesPriced

decimal

3968

in_securities_priced

ESTAR

MONTHLY_ESTAR_NAV

SECURITIES_PRICED

NUMBER(38,0)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesPriced

securitiesTotal

decimal

3969

in_securities_total

ESTAR

MONTHLY_ESTAR_NAV

SECURITIES_TOTAL

NUMBER(38,0)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/securitiesTotal

estimateQuality

EstimateQualityEnum

3194

ESTAR

MONTHLY_ESTAR_NAV

ESTIMATE_QUALITY

CHAR(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/estimateQuality

millRatePaymentFrequency

string

4291

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_PAYMENT_FREQUENCY

VARCHAR2(2)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRatePaymentFrequency

navChange

integer

4225

in_nav_change

ESTAR

MONTHLY_ESTAR_NAV

NAV_CHANGE

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChange

navVariance

decimal

4226

in_nav_variance

ESTAR

MONTHLY_ESTAR_NAV

NAV_VARIANCE

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVariance

publicOffering

decimal

4227

in_public_offering

ESTAR

MONTHLY_ESTAR_NAV

PUBLIC_OFFERING

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOffering

publicOfferingChange

decimal

4228

in_public_offering_change

ESTAR

MONTHLY_ESTAR_NAV

PUBLIC_OFFERING_CHANGE

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingChange

navCalcCount

decimal

4251

in_nav_calc_count

ESTAR

MONTHLY_ESTAR_NAV

NAV_CALC_COUNT

NUMBER(38,0)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcCount

preferredNetAssets

integer

4630

in_pref_net_asset

ESTAR

MONTHLY_ESTAR_NAV

PREFERRED_NET_ASSETS

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/preferredNetAssets

nasdaqTransmissionStatus

normalizedString

4784

in_nasdaq_trans_status

ESTAR

MONTHLY_ESTAR_NAV

NASDAQ_TRANSMISSION_STATUS

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqTransmissionStatus

nasdaqCompletedStatus

normalizedString

4785

in_nasdaq_compltd_status

ESTAR

MONTHLY_ESTAR_NAV

NASDAQ_COMPLETED_STATUS

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/nasdaqCompletedStatus

approvalStatus

decimal

4786

ESTAR

MONTHLY_ESTAR_NAV

APPROVAL_STATUS

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalStatus

approvalMode

decimal

4787

ESTAR

MONTHLY_ESTAR_NAV

APPROVAL_MODE

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalMode

approvalUser

normalizedString

4788

ESTAR

MONTHLY_ESTAR_NAV

APPROVAL_USER

VARCHAR2(32)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalUser

approvalDatetime

date

4789

ESTAR

MONTHLY_ESTAR_NAV

APPROVAL_DATETIME

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/approvalDatetime

overrideFlag

normalizedString

3623

in_override_flag

ESTAR

MONTHLY_ESTAR_NAV

OVERRIDE_FLAG

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideFlag

overrideUser

normalizedString

3625

in_override_user

ESTAR

MONTHLY_ESTAR_NAV

OVERRIDE_USER

VARCHAR2(32)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideUser

overrideDatetime

decimal

3624

in_overridde_dt

ESTAR

MONTHLY_ESTAR_NAV

OVERRIDE_DATETIME

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/overrideDatetime

netAssetAmountOvr

decimal

4776

in_net_asset_amnt_ovr

ESTAR

MONTHLY_ESTAR_NAV

NET_ASSET_AMOUNT_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/netAssetAmountOvr

shortTermCapGainDistOvr

decimal

4777

in_short_term_cap_dist_ovr

ESTAR

MONTHLY_ESTAR_NAV

SHORT_TERM_CAP_GAIN_DIST_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/shortTermCapGainDistOvr

longTermCapGainDistOvr

decimal

4778

in_long_term_cap_dist_ovr

ESTAR

MONTHLY_ESTAR_NAV

LONG_TERM_CAP_GAIN_DIST_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/longTermCapGainDistOvr

otherCapGainDistOvr

decimal

4780

in_other_cap_gain_dist_ovr

ESTAR

MONTHLY_ESTAR_NAV

OTHER_CAP_GAIN_DIST_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/otherCapGainDistOvr

stockDividend

decimal

4781

in_stock_dividend

ESTAR

MONTHLY_ESTAR_NAV

STOCK_DIVIDEND

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividend

stockDividendOvr

decimal

4782

in_stock_dividend_ovr

ESTAR

MONTHLY_ESTAR_NAV

STOCK_DIVIDEND_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockDividendOvr

publicOfferingOvr

decimal

4783

in_public_offering_ovr

ESTAR

MONTHLY_ESTAR_NAV

PUBLIC_OFFERING_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/publicOfferingOvr

marketPriceOvr

decimal

4801

in_market_price_ovr

ESTAR

MONTHLY_ESTAR_NAV

MARKET_PRICE_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/marketPriceOvr

cashDividendOvr

decimal

4803

in_cash_dividend_ovr

ESTAR

MONTHLY_ESTAR_NAV

CASH_DIVIDEND_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividendOvr

unallocatedDistr

decimal

4804

in_unallocated_distr

ESTAR

MONTHLY_ESTAR_NAV

UNALLOCATED_DISTR

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/unallocatedDistr

footnotes

decimal

4805

in_foot_notes

ESTAR

MONTHLY_ESTAR_NAV

FOOTNOTES

VARCHAR2(5)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/footnotes

millRate7dayEffectiveYieldOvr

decimal

ESTAR

MONTHLY_ESTAR_NAV

MILL_RATE_7DAY_EFF_YIELD_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/millRate7dayEffectiveYieldOvr

funcCode

decimal

4807

in_func_code

ESTAR

MONTHLY_ESTAR_NAV

FUNC_CODE

VARCHAR2(2)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/funcCode

navChangePercent

decimal

4815

in_nav_change_percent

ESTAR

MONTHLY_ESTAR_NAV

NAV_CHANGE_PERCENT

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChangePercent

stockSplitRate

decimal

4832

in_stock_split_rate

ESTAR

MONTHLY_ESTAR_NAV

STOCK_SPLIT_RATE

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRate

stockSplitRateOvr

decimal

4833

in_stock_split_rate_ovr

ESTAR

MONTHLY_ESTAR_NAV

STOCK_SPLIT_RATE_OVR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/stockSplitRateOvr

priorNAV

decimal

4817

in_prior_nav

ESTAR

MONTHLY_ESTAR_NAV

PRIOR_NAV

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/priorNAV

acknowledgedNAV

decimal

4818

in_acknowledged_nav

ESTAR

MONTHLY_ESTAR_NAV

ACKNOWLEDGED_NAV

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedNAV

acknowledgedPop

decimal

4819

in_acknowledged_pop

ESTAR

MONTHLY_ESTAR_NAV

ACKNOWLEDGED_POP

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/acknowledgedPop

capGains

decimal

4842

in_cap_gains

ESTAR

MONTHLY_ESTAR_NAV

CAP_GAINS

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/capGains

prevDayNAV

decimal

4820

in_prev_day_nav

ESTAR

MONTHLY_ESTAR_NAV

PREV_DAY_NAV

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/prevDayNAV

assets

decimal

4825

ESTAR

MONTHLY_ESTAR_NAV

ASSETS

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/assets

lastAckNAV

decimal

4834

in_last_ack_nav

ESTAR

MONTHLY_ESTAR_NAV

LAST_ACK_NAV

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckNAV

lastAckPop

decimal

4835

in_last_ack_pop

ESTAR

MONTHLY_ESTAR_NAV

LAST_ACK_POP

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastAckPop

lastCalcNAV

decimal

4841

in_last_calc_nav

ESTAR

MONTHLY_ESTAR_NAV

LAST_CALC_NAV

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/lastCalcNAV

navChangeTolerance

decimal

4836

in_nav_change_tolerance

ESTAR

MONTHLY_ESTAR_NAV

NAV_CHANGE_TOLERANCE

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navChangeTolerance

navReconTolerance

decimal

4837

in_nav_recon_tolerance

ESTAR

MONTHLY_ESTAR_NAV

NAV_RECON_TOLERANCE

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReconTolerance

popChange

decimal

4838

in_pop_change

ESTAR

MONTHLY_ESTAR_NAV

POP_CHANGE

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/popChange

navPublicationVariance2

decimal

4839

in_nav_pub_variance_2

ESTAR

MONTHLY_ESTAR_NAV

NAV_PUBLICATION_VARIANCE_2

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance2

navPublicationVariance4

decimal

4840

in_nav_pub_variance_4

ESTAR

MONTHLY_ESTAR_NAV

NAV_PUBLICATION_VARIANCE_4

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPublicationVariance4

calculatedDate

date

4843

in_calculated_dt

ESTAR

MONTHLY_ESTAR_NAV

CALCULATED_DT

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/calculatedDate

navVariancePercent

decimal

4774

in_nav_var_percent

ESTAR

MONTHLY_ESTAR_NAV

NAV_VARIANCE_PERCENT

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVariancePercent

navCalcDateTime

date

5522

in_nav_calc_dt_time

ESTAR

MONTHLY_ESTAR_NAV

NAV_CALC_DATE_TIME

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navCalcDateTime

navVerificationAmount

decimal

5521

in_nav_verification_amount

ESTAR

MONTHLY_ESTAR_NAV

NAV_VERIFICATION_AMOUNT

NUMBER(38,2)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navVerificationAmount

outstandingSubs

decimal

11717

in_outstanding_subs

ESTAR

MONTHLY_ESTAR_NAV

OUTSTANDING_SUBS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingSubs

outstandingExchSubs

decimal

11718

in_outstanding_exch_subs

ESTAR

MONTHLY_ESTAR_NAV

OUTSTANDING_EXCH_SUBS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchSubs

outstandingReds

decimal

11719

in_outstanding_reds

ESTAR

MONTHLY_ESTAR_NAV

OUTSTANDING_REDS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchReds

outstandingExchReds

decimal

11720

ESTAR

MONTHLY_ESTAR_NAV

OUTSTANDING_EXCH_REDS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingExchReds

outstandingReinvest

decimal

11721

in_outstanding_reinvest

ESTAR

MONTHLY_ESTAR_NAV

OUTSTANDING_REINVEST

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/outstandingReinvest

settledSubs

decimal

11722

in_settled_subs

ESTAR

MONTHLY_ESTAR_NAV

SETTLED_SUBS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledSubs

settledExchSubs

decimal

11723

in_settled_exch_subs

ESTAR

MONTHLY_ESTAR_NAV

SETTLED_EXCH_SUBS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchSubs

settledReds

decimal

11724

in_settled_reds

ESTAR

MONTHLY_ESTAR_NAV

SETTLED_REDS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReds

settledExchangeReds

decimal

11725

in_settled_exchange_reds

ESTAR

MONTHLY_ESTAR_NAV

SETTLED_EXCHANGE_REDS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledExchangeReds

settledReinv

decimal

11726

in_settled_reinv

ESTAR

MONTHLY_ESTAR_NAV

SETTLED_REINV

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/settledReinv

navPrecision

decimal

10065

in_nav_round_precision

ESTAR

MONTHLY_ESTAR_NAV

NAV_PRECISION

NUMBER

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPrecision

cashDividend

decimal

4802

in_cash_dividend

ESTAR

MONTHLY_ESTAR_NAV

CASH_DIVIDEND

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/cashDividend

transClosedFlag

decimal

1299

in_trans_closed_flag

ESTAR

MONTHLY_ESTAR_NAV

TRANS_CLOSED_FLAG

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedFlag

transClosedDate

date

1003

in_trans_closed_dt

ESTAR

MONTHLY_ESTAR_NAV

TRANS_CLOSED_DT

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedDate

transClosedUserId

decimal

1005

in_trans_closed_usr_id

ESTAR

MONTHLY_ESTAR_NAV

TRANS_CLOSED_USER_ID

VARCHAR2(32)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/transClosedUserId

transReopenUserId

decimal

1004

in_trans_reopen_usr_id

ESTAR

MONTHLY_ESTAR_NAV

TRANS_REOPEN_USER_ID

VARCHAR2(32)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/transReopenUserId

navmeClosedFlag

decimal

2072

in_closed_flag

ESTAR

MONTHLY_ESTAR_NAV

CLOSED_FLAG

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navmeClosedFlag

navmeClosedDate

date

933

in_closed_dt

ESTAR

MONTHLY_ESTAR_NAV

CLOSED_DT

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navmeClosedDate

closedUserId

decimal

934

in_closed_usr_id

ESTAR

MONTHLY_ESTAR_NAV

CLOSED_USER_ID

VARCHAR2(32)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/closedUserId

reopenUserId

decimal

935

ESTAR

MONTHLY_ESTAR_NAV

REOPEN_USER_ID

VARCHAR2(32)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenUserId

reopenedDate

date

1006

in_trans_reopened_dt

ESTAR

MONTHLY_ESTAR_NAV

REOPENED_DT

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/reopenedDate

reportingNav

decimal

ESTAR

MONTHLY_ESTAR_NAV

REPORTING_NAV

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/reportingNav

navPercentChange

decimal

1870

in_nav_percent_change

HOLDINGDBO

NAV_MULTI

NAV_PERCENT_CHANGE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navPercentChange

shareClassDescription

decimal

PACE_MASTERDBO

CODE_VALUES

LONG_DESC

EagleML/warehouseTransaction/warehouseNAVMonthEnd/shareClassDescription

navRoundingInd

decimal

10064

in_nav_rounding_ind

ESTAR

MONTHLY_ESTAR_NAV

NAV_ROUNDING_INDICATOR

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navRoundingInd

transReopenendDate

date

ESTAR

MONTHLY_ESTAR_NAV

TRANS_REOPENED_DT

DATE

EagleML/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/

NAV Report Details Model Data Map Table

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 + navSequence

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/netAssetsTotalFund

priorNAV Model Data Map Table

priorValuationDate

date

calculated field

HOLDINGDBO

NAV_MULTI

VALUATION_DATE

DATE

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorValuationDate

priorRawNAV

decimal

calculated field

HOLDINGDBO

NAV_MULTI

NAV_AMOUNT_PER_SHARE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorRawNAV

priorNetAssetsNAV

decimal

calculated field

HOLDINGDBO

NAV_MULTI

NET_ASSET_AMOUNT

NUMBER(38,2)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorNetAssetsNAV

priorSharesOutstanding

decimal

calculated field

HOLDINGDBO

NAV_MULTI

SHARES_OUTSTANDING

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorSharesOutstanding

priorMillRate

decimal

calculated field

HOLDINGDBO

NAV_MULTI

MILL_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorMillRate

priorMillRateDailyYield

decimal

calculated field

HOLDINGDBO

NAV_MULTI

MILL_RATE_DAILY_YIELD

NUMBER(38,9)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/priorMillRateDailyYield

reportingPublicOfferPrior

decimal

calculated field

HOLDINGDBO

NAV_MULTI

REPORTING_PUBLIC_OFFER_PRIOR

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/reportingPublicOfferPrior

reportingNavPrior

decimal

calculated field

HOLDINGDBO

NAV_MULTI

REPORTING_NAV_PRIOR

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/reportingNavPrior

mktValueCash Data Map Table

mktValueBaseCash

decimal

calculated field

HOLDINGDBO

POSITION_DETAIL

STAR_MARKET_VALUE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueBaseCash

mktValueForeignCash

decimal

calculated field

HOLDINGDBO

POSITION_DETAIL

STAR_MARKET_VALUE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueForeignCash

mktValueSource

string

calculated field

PACE_MASTERDBO

INTERFACES

SHORT_DESC

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/mktValueSource

shareClassLevel Data Map Table

accretionAmortization

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/accretionAmortization

currentNetAssets

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/currentNetAssets

currentSharesOutstanding

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/currentSharesOutstanding

expenses

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/expenses

interestIncome

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/interestIncome

netAssetChange

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/netAssetChange

previousNetAssets

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/previousNetAssets

priorSharesOutstanding

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/priorSharesOutstanding

totalActivityMovement

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/totalActivityMovement

variance

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/variance

contrForDscReceivable

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/contrForDscReceivable

currentShareActivity

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/currentShareActivity

derivativesCashFlow

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/derivativesCashFlow

distributions

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/distributions

dividendIncome

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/dividendIncome

fyeAsAfActivity

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/fyeAsAfActivity

litigationCommission

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/litigationCommission

marketValue

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/marketValue

markToMarkets

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/markToMarkets

miscellaneous

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/miscellaneous

miscellaneousIncome

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/miscellaneousIncome

netShareholderActivity

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/netShareholderActivity

realizedCurrencyGainLoss

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/realizedCurrencyGainLoss

tradingGainLoss

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/tradingGainLoss

variationMargin

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/variationMargin

totalFundLevel Data Map Table

accretionAmortization

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/accretionAmortization

currentNetAssets

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/currentNetAssets

currentSharesOutstanding

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/currentSharesOutstanding

expenses

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/expenses

interestIncome

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/interestIncome

netAssetChange

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/netAssetChange

previousNetAssets

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/previousNetAssets

priorSharesOutstanding

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/priorSharesOutstanding

totalActivityMovement

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/totalActivityMovement

variance

decimal

calculated field

ARCH_CTRLCTR

NAV_DETAILS

BALANCE_CHANGE

NUMBER(22,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/variance

distributionLogLevels Data Map Table

distributionLogLevel Data Map Table

fixedAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmount

periodicIAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmount

periodicLTAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmount

periodicSPAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmount

periodicSTAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmount

periodicADJIAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmount

periodicADJLTAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmount

periodicADJSPAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmount

periodicADJSTAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmount

niiIAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmount

niiADJIAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmount

setIAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIAmount

setADJIAmount

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmount

fixedRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedRate

periodicIRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRate

periodicLTRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRate

periodicSPRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRate

periodicSTRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRate

periodicADJIRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRate

periodicADJLTRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRate

periodicADJSPRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRate

periodicADJSTRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRate

niiIRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIRate

niiADJIRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRate

setIRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIRate

setADJIRate

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIRate

fixedAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedAmountN

periodicIAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIAmountN

periodicLTAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTAmountN

periodicSPAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPAmountN

periodicSTAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTAmountN

periodicADJIAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIAmountN

periodicADJLTAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTAmountN

periodicADJSPAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPAmountN

periodicADJSTAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTAmountN

niiIAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIAmountN

niiADJIAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIAmountN

setIAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIAmountN

setADJIAmountN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_AMOUNT

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setADJIAmountN

fixedRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/fixedRateN

periodicIRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicIRateN

periodicLTRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicLTRateN

periodicSPRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSPRateN

periodicSTRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicSTRateN

periodicADJIRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJIRateN

periodicADJLTRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJLTRateN

periodicADJSPRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSPRateN

periodicADJSTRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/periodicADJSTRateN

niiIRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiIRateN

niiADJIRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/niiADJIRateN

setIRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/setIRateN

setADJIRateN

decimal

calculated field

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_RATE

NUMBER(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

ESTAR

ESTAR_DIST_LOG

DISTRIBUTION_SHARES

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/distributionLogLevel/distributionShares

estarSecYield30Day Data Map Table

secYldTaxEqWithWvrReim

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

SEC_YLD_TAX_EQ_WITH_WVR_REIM

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldTaxEqWithWvrReim

secYldTaxEqWithoutWvrReim

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

SEC_YLD_TAX_EQ_WOUT_WVR_REIM

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldTaxEqWithoutWvrReim

secYldWithWvrReim

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

SEC_YLD_WITH_WVR_REIM

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldWithWvrReim

secYldWithoutWvrReim

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

SEC_YLD_WOUT_WVR_REIM

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secYldWithoutWvrReim

secIncome30Day

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

INCOME_30DAY

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secIncome30Day

taxEqIncome30Day

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

TAX_EQ_INCOME_30DAY

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/taxEqIncome30Day

wVRReim30Day

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

WVR_REIM_30DAY

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/wVRReim30Day

secExpenses30Day

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

EXPENSES_30DAY

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secExpenses30Day

secAverageShares

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

AVERAGE_SHARES

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/secAverageShares

maxOfferingPrice

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

MAX_OFFER_PRICE

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/maxOfferingPrice

adjustedMOP

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

ADJUSTED_MOP

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/adjustedMOP

totalNetAssets

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

TOTAL_NET_ASSETS

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/totalNetAssets

undistributedIncome

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

UNDISTRIBUTED_INC

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/undistributedIncome

shares

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

SHARES

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/shares

approvedFlag

YesNoOptionEnum

calculated field

ESTAR

ESTAR_SECYLD_30DAY

APPROVED_FLAG

VARCHAR2(1)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/approvedFlag

incomeWithoutShort30Day

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

INC_WOUT_SHORT_30DAY

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/incomeWithoutShort30Day

shortDividendIncome

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

SH_DIV_INC

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/shortDividendIncome

expectedWithShortDividend

decimal

calculated field

ESTAR

ESTAR_SECYLD_30DAY

EXP_WITH_SH_DIV

NUMBER(38,6)

EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/expectedWithShortDividend