| | | | | | | | | | |
|---|
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 TablePlease set includeReportDetails="Y" in the RTR to add navReportDetails model to a single extract or W_INCLUDE_REPORT_DETAILS="Y" global parameter to enhance all NAV Month End extracts in the environment |
priorNAV | | priorNAV Model (see extra table below) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/ |
mktValueCash | | mktValueCash Model (see extra table below) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/ |
shareClassLevel | | shareClassLevel Model (see extra table below) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/ |
totalFundLevel | | totalFundLevel Model (see extra table below) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/ |
distributionLogLevels | | distributionLogLevels Model (see extra table below) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/ |
estarSecYield30Day | | estarSecYield30Day Model (see extra table below) | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/estarSecYield30Day/ |
transferAgentMillRate | | decimal | | | | Calculated value millRate + shortTermCapGainDist | | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/transferAgentMillRate |
rawNavChange | | decimal | | | | Calculated value navAmountPerShare - priorRawNAV | | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/rawNavChange |
reportingNavChange | | decimal | | | | Calculated value | | | | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/reportingNavChange |
netAssetsTotalFund | | decimal | | | | Calculated value - sum of netAssetAmount values grouped by entityId + valuationDate + 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 |