Retail Fund Toolkit: Generic Interfaces

The Retail Fund Toolkit requires each entity to be set up. If you are loading benchmarks, refer to the Index Toolkit.

Generic Entity Interface

Interface Details

The generic Entity interface is a generic stream available in Message Center in the CSV or STAR formats:

  • Eagle_Default_In_Csv_Entity

  • Eagle_Default_In_Star_Entity

See the Supported Generic Interfaces V17 Wiki for more details.

Columns Used

The following table shows columns used by the Retail Fund Toolkit.

Database Column

Table

Tag

Required?

Purpose

Database Column

Table

Tag

Required?

Purpose

ENTITY_TYPE

ENTITY

1105

Y

Type of entity

ENTITY_NAME

ENTITY

1164

Y

Name of entity

BASE_CURRENCY

ENTITY

86

Y

Base currency of entity

INCEPTION_DATE

ENTITY

1138

Y

Inception date of entity

MFP_SPLIT_RATIO

ENTITY_EXTENSION

2442

Y

Split Ratio

TERMINATION_DATE

ENTITY

1161

N

Termination date of entity

FISCAL_END_DATE

ENTITY

1162

N



CDSC_LOAD_YEAR_1

ENTITY

1988

N



CDSC_LOAD_YEAR_10

ENTITY

11041

N



CDSC_LOAD_YEAR_2

ENTITY

1989

N



CDSC_LOAD_YEAR_3

ENTITY

1990

N



CDSC_LOAD_YEAR_4

ENTITY

1991

N



CDSC_LOAD_YEAR_5

ENTITY

1992

N



CDSC_LOAD_YEAR_6

ENTITY

1993

N



CDSC_LOAD_YEAR_7

ENTITY

11038

N



CDSC_LOAD_YEAR_8

ENTITY

11039

N



CDSC_LOAD_YEAR_9

ENTITY

11040

N



FRONT_END_LOAD

ENTITY

1987

N



MFP_ANN_EXPWAIVER

ENTITY_EXTENSION

2449

N

Annual expense waiver ratio

MFP_CONV_FREQUENCY

ENTITY_EXTENSION

2436

N



MFP_CONV_PARENT_ID

ENTITY_EXTENSION

2437

N



MFP_CONV_PERIOD

ENTITY_EXTENSION

2438

N



MFP_DISTRIBUTION_TYPE

ENTITY_EXTENSION

2439

N



MFP_EXP_RATIO

ENTITY_EXTENSION

2448

N



MFP_FIXED_CONV_DATE

ENTITY_EXTENSION

2440

N



MFP_GR_ACCRUAL

ENTITY_EXTENSION

2450

N



MFP_OPEN_CLOSED_FLAG

ENTITY_EXTENSION

2441

N



MFP_SPREAD_CALENDAR

ENTITY_EXTENSION

2443

N



MFP_SPREAD_METHOD

ENTITY_EXTENSION

2444

N



MFP_SYN_INCEPTION_DATE

ENTITY_EXTENSION

2445

N



MFP_SYN_PARENT_ID

ENTITY_EXTENSION

2446

N



MFP_TAXABLE_INCOME_FLAG

ENTITY_EXTENSION

2447

N



REDEMPTION_FEE

ENTITY_EXTENSION

11506

N



REDEMPTION_FREQUENCY

ENTITY_EXTENSION

11505

N



REDEMPTION_PERIOD

ENTITY_EXTENSION

11504

N



Generic NAV Interface

The Retail Fund Toolkit requires NAV data to be loaded.

Interface Details

The generic NAV interface is a generic stream available in Message Center in the CSV or STAR formats:

  • Eagle_Default_In_Csv_NAV

  • Eagle_Default_In_Star_NAV

See the Supported Generic Interfaces V17 Wiki for more details.

Columns Used

The following table shows columns used by the Retail Fund Toolkit.

Database Column

Table

Tag

Required?

Purpose

Database Column

Table

Tag

Required?

Purpose

ENTITY_ID

NAV

1163

Y

Fund ID

EFFECTIVE_DATE

NAV

221

Y

NAV date

CLASS_LEVEL

NAV

34

Y

Share class

NAV_PER_SHARE

NAV

3195

Y

Net Asset Value

TOTAL_NET_ASSETS

NAV

2542

Y

Net Assets

NAV_CHANGE

NAV

5375

N

Change in NAV

UPDATE_SOURCE

NAV

944

N

Update source

UPDATE_DATE

NAV

N/A

N

Update date

SRC_INTFC_INST

NAV

1102

Y

Source

DIVIDEND

NAV

2544

N

Total of all distributions

SPLIT_RATIO

NAV

2545

Y

Split Ratio

OFFER_PRICE

NAV

1846

N

Public Offer Price

MKT_PRICE

NAV

1110

N

Market Price

REINVEST_PRICE

NAV

1276

N

Reinvest Price

PREM_OR_DISC

NAV

2546

N

Premium/discount market price

NAV_PRIOR_DAY

NAV

11961

N

Prior day NAV

NAV_PRIOR_MONTH

NAV

2548

N

Prior month NAV

DIV_EARNING_SHARES

NAV

2549

N

Dividend earning shares outstanding

SHARES_OUTSTANDING

NAV

3244

N

Total shares outstanding

SUBSCRIPTION_DOLLARS

NAV

3281

N

Subscription dollars

SUBSCRIPTION_SHARES

NAV

10165

N

Subscription shares

REDEMPTION_DOLLARS

NAV

3282

N

Redemption dollars

REDEMPTION_SHARES

NAV

9394

N

Redemption shares

INC_AMT_TOT

NAV

2550

N

Income dist dollars

INC_AMT_PSHR

NAV

2551

N

Income dist per share

INC_REINVEST_DATE

NAV

2553

N

Income reinvest date

INC_EX_DATE

NAV

2664

N

Income ex date

INC_REC_DATE

NAV

2555

N

Income record date

INC_PAY_DATE

NAV

2556

N

Income pay date

TE_INC_AMT_TOT

NAV

2557

N

TE income dollars

TE_INC_AMT_PSHR

NAV

2558

N

TE income per share

TE_INC_REINVEST_DATE

NAV

2560

N

TE income reinvest date

TE_INC_EX_DATE

NAV

2561

N

TE income ex date

TE_INC_REC_DATE

NAV

2562

N

TE income record date

TE_INC_PAY_DATE

NAV

2563

N

TE income pay date

SUPP_INC_AMT_TOT

NAV

2564

N

Supplemental income dollars

SUPP_INC_AMT_PSHR

NAV

2565

N

Supplemental income per share

SUPP_INC_REINVEST_DATE

NAV

2567

N

Supplemental income reinvest date

SUPP_INC_EX_DATE

NAV

2568

N

Supplemental income ex date

SUPP_INC_REC_DATE

NAV

2569

N

Supplemental income record date

SUPP_INC_PAY_DATE

NAV

2570

N

Supplemental income pay date

STCG_AMT_TOT

NAV

2571

N

Short term cap gain dollars

STCG_AMT_PSHR

NAV

2572

N

Short term cap gain per share

STCG_REINVEST_DATE

NAV

2574

N

Short term cap gain reinvest date

STCG_EX_DATE

NAV

2575

N

Short term cap gain ex date

STCG_REC_DATE

NAV

2576

N

Short term cap gain record date

STCG_PAY_DATE

NAV

2577

N

Short term cap gain pay date

MTCG_AMT_TOT

NAV

2578

N

Mid term cap gain dollars

MTCG_AMT_PSHR

NAV

2579

N

Mid term cap gain per share

MTCG_REINVEST_DATE

NAV

2581

N

Mid term cap gain reinvest date

MTCG_EX_DATE

NAV

2582

N

Mid term cap gain ex date

MTCG_REC_DATE

NAV

2583

N

Mid term cap gain record date

MTCG_PAY_DATE

NAV

2584

N

Mid term cap gain pay date

LTCG_AMT_TOT

NAV

2585

N

Long term cap gain dollars

LTCG_AMT_PSHR

NAV

2586

N

Long term cap gain per share

LTCG_REINVEST_DATE

NAV

2588

N

Long term cap gain reinvest date

LTCG_EX_DATE

NAV

2589

N

Long term cap gain ex date

LTCG_REC_DATE

NAV

2590

N

Long term cap gain record date

LTCG_PAY_DATE

NAV

2591

N

Long term cap gain pay date

RETCAP_AMT_TOT

NAV

2592

N

Return of capital dollars

RETCAP_AMT_PSHR

NAV

2593

N

Return of capital per share

RETCAP_REINVEST_DATE

NAV

2595

N

Return of capital reinvest date

RETCAP_EX_DATE

NAV

2596

N

Return of capital ex date

RETCAP_REC_DATE

NAV

2597

N

Return of capital record date

RETCAP_PAY_DATE

NAV

2598

N

Return of capital pay date

EXPENSE_AMT_TOT

NAV

2599

N

Daily expense accrual dollars

EXPENSE_AMT_PSHR

NAV

2600

N

Daily expense accrual per share

EXPENSE_REINVEST_DATE

NAV

2601

N

Daily expense reinvest date

WAIVER_AMT_TOT

NAV

2602

N

Daily expense waiver accrual dollars

WAIVER_AMT_PSHR

NAV

2603

N

Daily expense waiver accrual per share

WAIVER_REINVEST_DATE

NAV

2604

N

Daily expense waiver accrual reinvest date

MKT_DISC_INC_RECLASS

NAV

2605

N

Market discount income dollars

MKT_DISC_INC_PSHR

NAV

2606

N

Market discount income per share

MKT_DISC_INC_REINVEST_DATE

NAV

2607

N

Market discount income reinvest date

TAXABLE_REPO_INT

NAV

2608

N

Taxable repo interest dollars

TAXABLE_REPO_PSHR

NAV

2609

N

Taxable repo interest per share

TAXABLE_REPO_REINVEST_DATE

NAV

2610

N

Taxable repo interest reinvest date

FOREIGN_TAX_CREDIT

NAV

2611

N

Foreign tax credit dollars

FOREIGN_TAX_PSHR

NAV

2612

N

Foreign tax credit per share

FOREIGN_TAX_REINVEST_DATE

NAV

2613

N

Foreign tax credit reinvest date

USER_DECIMAL1

NAV

2614

N

Alternative Reinvest Price

USER_DECIMAL2

NAV

2615

N

Section 1250 Gain

USER_DECIMAL3

NAV

2616

N

Retained Gain

USER_DATE2

NAV

2645

N

Section 1250 Reinvest Date

USER_DATE3

NAV

2646

N

 Retained Cap Gain Reinvest Date

NAV_INCEPT

NAV

2661

N

NAV Begin Of Day

NAV_UNROUNDED

NAV

2662

N

NAV Unrounded

LOWER_NAV_MARKET

NAV

2663

N

Lower of NAV or Market

UD_PRICE1

NAV

2664

N

User price 1

UD_PRICE2

NAV

2665

N

User price 2

UD_PRICE3

NAV

2666

N

User price 3

UD_PRICE4

NAV

2667

N

User price 4

QUAL_INC_PSHR

NAV

2668

N

Qual Inc Dist

QUAL_INC_REINV_DATE

NAV

2669

N

Qual Inc Redate

QUAL_STCG_PSHR

NAV

2670

N

Qual STCG

QUAL_STCG_REINV_DATE

NAV

2671

N

Qual STCG Redate

GROSS_DIST_PSHR

NAV

2672

N

Gross Distribution

GROSS_DIST_REINV_DATE

NAV

2673

N

Gross Dist ReDate

UD_INCDIST1

NAV

2674

N

User Income1

UD_INCDIST2

NAV

2675

N

User Income2

UD_INCDIST3

NAV

2676

N

User Income3

UD_CAPGAIN1

NAV

2677

N

User CapGain1

UD_CAPGAIN2

NAV

2678

N

User CapGain2

UD_CAPGAIN3

NAV

2679

N

User CapGain3