Retail Fund Toolkit: Generic Interfaces

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