Daily Yield Mill Rate Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 25, 2024 by Kinga Huszno
1 min read

Element

Optional/Required

Value Type 

Star Tag

Eagle DB

DB Table

DB Field

Data Type

Xpath

Element

Optional/Required

Value Type 

Star Tag

Eagle DB

DB Table

DB Field

Data Type

Xpath

objectType

Optional

ObjectTypeEnum

 

not stored in DB

EagleML/accountingTransaction/dailyYieldMillRate/objectType

objectId

Optional

ObjectId

 

not stored in DB

EagleML/accountingTransaction/dailyYieldMillRate/objectId

objectDescription

Optional

FeedTypeEnum

 

not stored in DB

EagleML/accountingTransaction/dailyYieldMillRate/objectDescription

updateTimestamp

Optional

dateTime

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

SYSTEM_DATE

DATE

EagleML/accountingTransaction/dailyYieldMillRate/updateTimestamp

customElements

Not recommended

CustomElements -  ComplexType

 

updateSource

Required

string

944

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

UPDATE_SOURCE

VARCHAR2(32)

EagleML/accountingTransaction/dailyYieldMillRate/updateSource

Entity Common Id Model

EagleML/accountingTransaction/dailyYieldMillRate/

effectiveDate

Required

date

1109

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

EFFECTIVE_DATE

DATE 

EagleML/accountingTransaction/dailyYieldMillRate/effectiveDate

shareClass

Required

string

34

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

SHARE_CLASS

VARCHAR2(10)

EagleML/accountingTransaction/dailyYieldMillRate/shareClass

valuationDate

Required

date

36

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

VALUATION_DATE

DATE 

EagleML/accountingTransaction/dailyYieldMillRate/valuationDate

millRate

Optional

decimal

4564

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate

millRateSpike

Optional

decimal

11974

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_SPIKE

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateSpike

millRateSpikeAmount

Optional

decimal

11975

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_SPIKE_AMOUNT

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateSpikeAmount

millRateAuto

Optional

decimal

11976

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_AUTO

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateAuto

millRateAutoReversal

Optional

decimal

11977

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_AUTO_REVERSAL

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateAutoReversal

millRateAdjustmentAmount

Optional

decimal

4282

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_ADJUSTMENT_AMT

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateAdjustmentAmount

millRateMtd

Optional

decimal

11978

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_MTD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateMtd

millRateSpikeMtd

Optional

decimal

11979

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_SPIKE_MTD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateSpikeMtd

millRate12Month

Optional

decimal

11980

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_12MTH

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate12Month

millRateDaysInYear

Optional

integer

4283

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_DAYS_IN_YEAR

NUMBER(38)

EagleML/accountingTransaction/dailyYieldMillRate/millRateDaysInYear

millRateDaysInMonth

Optional

integer

4284

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_DAYS_IN_MONTH

NUMBER(38)

EagleML/accountingTransaction/dailyYieldMillRate/millRateDaysInMonth

millRateWeeksInYear

Optional

decimal

4285

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_WEEKS_IN_YEAR

NUMBER(38,6)

EagleML/accountingTransaction/dailyYieldMillRate/millRateWeeksInYear

millRateDailyYield

Optional

decimal

4286

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_DAILY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRateDailyYield

millRate7dayEffectiveYield

Optional

decimal

4287

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_7DAY_EFF_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate7dayEffectiveYield

millRate7dayAverageYield

Optional

decimal

4288

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_7DAY_AVG_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate7dayAverageYield

millRate30dayEffectiveYield

Optional

decimal

4289

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_30DAY_EFF_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate30dayEffectiveYield

millRate30dayAverageYield

Optional

decimal

4290

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_30DAY_AVG_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate30dayAverageYield

millRate1monthYield

Optional

decimal

11981

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_1MTH_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate1monthYield

millRate12monthYield

Optional

decimal

11982

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MILL_RATE_12MTH_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/millRate12monthYield

n1aMillRate

Optional

decimal

11983

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_MILL_RATE

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aMillRate

n1aRestatedMillRate

Optional

decimal

11984

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_RESTATED_MILL_RATE

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aRestatedMillRate

n1aOutStatePct

Optional

decimal

11985

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_OUT_STATE_PCT

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aOutStatePct

n1aDailyYield

Optional

decimal

11986

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_DAILY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aDailyYield

n1aRestatedDailyYield

Optional

decimal

11987

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_RESTATED_DAILY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aRestatedDailyYield

n1a7dayYield

Optional

decimal

11988

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_7DAY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1a7dayYield

n1aRestated7dayYield

Optional

decimal

11989

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_RESTATED_7DAY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aRestated7dayYield

n1a30dayYield

Optional

decimal

11990

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_30DAY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1a30dayYield

n1aRestated30dayYield

Optional

decimal

11991

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_RESTATED_30DAY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aRestated30dayYield

n1a7dayEffectiveYield

Optional

decimal

11992

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_7DAY_EFF_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1a7dayEffectiveYield

n1aGrossYield

Optional

decimal

11993

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

N1A_GROSS_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/n1aGrossYield

monthEndFlag

Optional

YesNoOptionEnum

1198

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

MONTH_END_FLAG

VARCHAR2(1)

EagleML/accountingTransaction/dailyYieldMillRate/monthEndFlag

incomeDistribution

Optional

decimal

4229

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

INCOME_DISTRIBUTION

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/incomeDistribution

incomeLedgerBalance

Optional

decimal

11994

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

INCOME_LEDGER_BALANCE

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/incomeLedgerBalance

expensesLedgerBalance

Optional

decimal

11995

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

EXPENSES_LEDGER_BALANCE

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/expensesLedgerBalance

fixedDistributionAmount

Optional

decimal

4484

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

FIXED_DISTRIBUTION_AMT

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/fixedDistributionAmount

periodicDistributionAmount

Optional

decimal

4759

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

PERIODIC_DISTRIBUTION_AMT

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/periodicDistributionAmount

reimbursement

Optional

decimal

11996

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

REIMBURSEMENT

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/reimbursement

incomeAdjustmentAmount

Optional

decimal

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

INCOME_ADJ_AMT

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/incomeAdjustmentAmount

grossYield

Optional

decimal

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

GROSS_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/grossYield

gross7dayYield

Optional

decimal

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

GROSS_7DAY_YIELD

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/gross7dayYield

fytdTaxableIncome

Optional

decimal

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

FYTD_TAXABLE_INCOME

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/fytdTaxableIncome

fytdTaxExemptIncome

Optional

decimal

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

FYTD_TAX_EXEMPT_INCOME

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/fytdTaxExemptIncome

fytdMixedExpenses

Optional

decimal

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

FYTD_MIXED_EXPENSES

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/fytdMixedExpenses

fytdTaxableExpAlloc

Optional

decimal

 

ESTAR

ESTAR_DAILY_YIELD_MILL_RATE

FYTD_TAXABLE_EXP_ALLOC

NUMBER(38,12)

EagleML/accountingTransaction/dailyYieldMillRate/fytdTaxableExpAlloc

Â