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