Generic Interfaces

Generic Entity Interface

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

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

See the Generic Streams and Data Uploaders Reference Guide for more details.

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