Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
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 | EagleML/warehouseTransaction/warehouseNAVMonthEnd/ | |||||||||
accountingBasis | string | not stored in DB | EagleML/warehouseTransaction/warehouseNAVMonthEnd/accountingBasis | |||||||
Asset Identifiers Model | EagleML/warehouseTransaction/warehouseNAVMonthEnd/ | |||||||||
Extended Asset Properties | 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, see extra data map table) | 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 | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/priorNAV/ | ||||||||
mktValueCash | mktValueCash Model | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/mktValueCash/ | ||||||||
shareClassLevel | shareClassLevel Model | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/shareClassLevel/ | ||||||||
totalFundLevel | totalFundLevel Model | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/totalFundLevel/ | ||||||||
distributionLogLevels | distributionLogLevels Model | EagleML/warehouseTransaction/warehouseNAVMonthEnd/navReportDetails/distributionLogLevels/ | ||||||||
estarSecYield30Day | estarSecYield30Day Model | 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 |
Manage space
Manage content
Integrations