FundamentalDataForm

Fundamental Data Form

General

This section will provide information on the Fundamental Data Form (FDF) Fundsquare has introduced in e-file.lu V2. This form allows you to update your static data in the Fundsquare Database. This chapter will cover the general introduction of the form, provide explanations on the fields that are used and allow you to autonomously manage your dataset with Fundsquare.

How to obtain the FDF

Blank FDF file: (FDF sample file)

OR

Fund's extraction through e-file V2: https://www.e-file.lu/e-file/index.html
On the LaunchPad of your e-file screen, you should find the below button. If you do not find it, it means that your company hasn't requested this module yet. If it is greyed out, it simply indicates that the module is not active for your personal access.

Important note : To have access to the Static Data Management module the user should have access to the group Fundamental Data Form.

How to complete the FDF

In due course, we will provide further information on this section.

Main Category	Column Number	Field Label	Mandatory Field	Definition	Type of Data	Field Format	Format Constraints	Business Rule
Third-Party Information	1	Promoter	No	Indicates the name of the Initiator/Sponsor of the fund including the country	Company Name	String char (100)	N/A	N/A
Third-Party Information	2	Management Company	Yes	Indicates the name of the Management Company of the fund including the country	Company Name	String char (100)	N/A	N/A
Third-Party Information	3	Investment Company	Conditional cf Definition	Indicates the name of the Investment Company of the fund including the country. This field is mandatory if the fund is self-managed and no management company has been provided	Company Name	String char (100)	N/A	N/A
Third-Party Information	4	Fund Administration	Yes	Indicates the name of the Administrator of the fund including the country.	Company Name	String char (100)	N/A	N/A
Third-Party Information	5	Transfer Agent	Conditional cf Definition	Indicates the name of the Transfer Agent of the fund including the country. This field is mandatory for the Order Routing Data	Company Name	String char (100)	N/A	N/A
Fund Information	6	Fund Name	Yes	Indicates the legal name of the fund	Label	String char (100)	Is unique in Fundsquare's database (upper/lower case letters)	N/A
Fund Information	7	Fund National Competent Authority Code	No	Indicates the codification used by the fund's domicile authority on fund level	Codification	String char (20)	Is unique in Fundsquare's database	N/A
Fund Information	8	Fund Administration Code	No	Indicates the central administration's instrument code at the fund level (AC internal code)	Codification	String char (20)	Is unique at this level	N/A
Fund Information	9	Fund GIIN Code	Conditional cf Definition	Indicates the Global Intermediary Identification Number of the instrument at the fund level This field is mandatory for FATCA reporting	Codification	String char (20)	Alphanumerical: Char(6).Char(5).Char(2).Number(3). Is unique in Fundsquare's database.	Has to be unique if not SP (Sponsor). 7th char = "." 13th char = "." 16th char = "." & Last 3 char = 442 or 14th&15th = SP
Fund Information	10	Fund RFI ID (CRS)	Conditional cf Definition	Indicates the Social Security Identification number at the fund level. Mandatory for CRS reporting	Codification	String char (20 or 22)	Number(11) - Number(13)	9th char is a letter followed by 8 "0"
Fund Information	11	Type of EU Directive	Yes	Indicates whether the fund is an UCITS-fund or an AIF-fund according to european directives	Indicator	String char (6)	List of values: UCITS AIF OTHER	N/A
Fund Information	12	Umbrella Fund	No	Indicates whether the fund is an umbrella or not	Indicator	String char (3)	Boolean: YES/NO	N/A
Fund Information	13	Fund Creation Date	Yes	Indicates the date on which the fund is created/activated	Date	Date char (10)	Date format: dd/MM/yyyy	If date > current date OR If no date = inactivated = anticipated creation (AC). If date ≤ current date = activated = available for documents notification and dissemination (ACT).
Fund Information	14	Fund End Date	No	Indicates the ending date of the fund's activity (closing/liquidation date)	Date	Date char (10)	Date format: dd/MM/yyyy	If Date ≤ current date = inactivated = not available for documents notification and dissemination. available 1 year for reporting.
Fund Information	15	Fund Jurisdiction Country	Yes	Indicates the country where the fund is domiciled	Legal	String char (2)	Code ISO2	The two first characters must be the same as the two first letters included in ISIN code. For example: LU, GB, IE, etc.
Fund Information	16	Fund Legal Form	Yes	Indicates the legal form of the fund	Legal	String char (4)	List of values: "FCP" = FCP: Common fund "SICV" = SICAV: Investment company with variable capital "SICF" = SICAF: Investment company with fixed capital "SICR" = SICAR: Investment company in risk capital "OT" = OT: Securitisation entities "SCA" = SCA: Partnership limited by shares "SCS" = SCS: Limited partnership "SCSp" = SCSp: Special partnership "SA" = SA: public limited liability company "OTH" = OTHER: Other fund	Linked/compatible with "Fund Legal Status"
Fund Information	17	Fund Legal Status	Yes	Indicates the legal status of the fund	Legal	String char (4)	List of values: "SIF" = SIF "NLUX" = Non-LU-domiciled "PA04" = Law 14 june 2004 "PA05" = Law 22 march 2004 "P110" = Part I 2010 law "P210" = Part II 2010 law "RAIF" = RAIF	Linked/compatible with "Fund Legal Form"
Sub-fund Information	18	Sub-Fund Name	Yes	Indicates the legal name of the sub-fund	Label	String char (100)	Is unique in Fundsquare's database at this level (upper/lower case letters)	N/A
Sub-fund Information	19	Sub-Fund National Competent Authority Code	No	Indicates the codification used by the fund's domicile authority at the sub-fund level	Codification	String char (20)	Is unique in Fundsquare's database	N/A
Sub-fund Information	20	Sub-Fund Administration Code	No	Indicates the central administration's instrument code at the sub-fund level (AC internal code)	Codification	String char (20)	Is unique at this level	N/A
Sub-fund Information	21	Sub-Fund GIIN Code	Conditional cf Definition	Indicates the Global Intermediary Identification Number for the instrument at the fund level. This field is mandatory for FATCA Reporting.	Codification	String char (20)	AlphaNumerical:Char(6).Char(5).Char(2).Number(3). Is unique in Fundsquare Database.	Has to be unique 7th char = ""."" 13th char = ""."" 16th char = ""."" & Last 3 char = 442 OR 14th&15th=SP
Sub-fund Information	22	Sub-Fund RFI ID (CRS)	Conditional cf Definition	Indicates the Social Securities Identification number at the sub-fund level. This field is mandatory for CRS reporting.	Codification	String char (20or22)	Number(11)-Number(13)	The 9th character is a letter followed by 8 numbers. The CSSF code should be retrieved in the last part of the ID (Ex: MATRICULE+F00000145). With a maximum of 8 characters after the letter.
Sub-fund Information	23	Sub-Fund Creation Date	No	Indicates the date on which the sub-fund is created/activated	Date	Date char (10)	Date format: dd/MM/yyyy	If date > current date OR If no date = inactivated = anticipated creation (AC). If date ≤ current date = activated = available for documents notification and dissemination (ACT). Ensure that the date is not greater then creation date of the fund.
Sub-fund Information	24	Sub-Fund End Date	No	Indicates the ending date of the sub-fund's activity (closing/liquidation date)	Date	Date char (10)	Date format: dd/MM/yyyy	If Date ≤ current date = inactivated = not available for documents notification and dissemination. available 1 year for reporting.
Sub-fund Information	25	Sub-Fund Base Currency	Yes	Indicates the ISO3-currency code for the base accounting currency of the sub-fund	Currency	String char (3)	Currency ISO-3	RMB should be CNH or CNY
Sub-fund Information	26	NAV per Share Frequency	Yes	Notifies the frequency of the net asset per share calculation. It must be the same for all the share classes that are included in one sub-fund.	Frequency	String char (4)	List of values: YEAR = Annual TWYR = Twice a year TOWK = Twice a week TOMN = Every two months TWMN = Twice a month WEEK = Weekly DAIL = Daily MNTH = Monthly TRIE = Every four months SEMI = Every six months QURT = Every three months MLTD = Multi-daily NIMN = Every nine months	N/A
Sub-fund Information	27	Sub-Fund Sleeping Indicator	No	Indicates whether the sub-fund is sleeping or not	Indicator	String char (3)	Boolean:YES/NO	N/A
Share-class Information	28	Share Class Name	Yes	Indicates the legal name of the share class	Label	String char (100)	Is unique at this level (upper/lower case letters)	N/A
Share-class Information	29	Client Share Class Name	No	Indicates a client's name of the share class	Label	String char (100)	Is unique in Fundsquare's database (upper/lower case letters. Combined with fund & sub-fund labels.	Name available on Fundsquare website and client whitelabelling
Share-class Information	30	Share Class National Competent Authority Code	No	Indicates the codification used by the fund's domicile authority on share class level	Codification	String char (20)	Is unique in Fundsquare's database	The CSSF codes from 1 to 9 have to be written with two characters (01-02-03...)
Share-class Information	31	Share Class Administration Code	No	Indicates the central administration's instrument code at the share class level (AC internal code). Share class ID used in the client's proprietary system (for NAV).	Codification	String char (20)	Is unique at this level	N/A
Share-class Information	32	Share Class ISIN Code	Conditional cf Definition	Indicates the ISIN code of the share class. This field is mandatory for Ucits-funds if the share class is activated (creation date)	Codification	String char (12)	Is unique in Fundsquare's database	Ensure that the first two letters match to the fund juridiction country. For Ucits Funds:If empty the share class status is inactivated (INA)
Share-class Information	33	Share-Class Ticker Bloomberg Code	No	Indicates the Instrument’s Bloomberg Ticker (code)	Codification	String char (20)	Is unique in Fundsquare's database	N/A
Share-class Information	34	Share Class Creation Date	No	Indicates the date on which the share class is created/activated	Date	Date char (10)	Date format: dd/MM/yyyy	If date > current date OR If no date = inactivated & anticipated creation (AC). If date ≤ current date = activated = available for documents notification and dissemination (ACT). If UCITS and NO ISIN CODE then no creation date should be available. Ensure that the date is not greater than creation date of the sub-fund
Share-class Information	35	Share Class End Date	No	Indicates the ending date of the share class activity (closing/liquidation date)	Date	Date char (10)	Date format: dd/MM/yyyy	If Date ≤ current date = inactivated = not available for documents notification and dissemination. Available 1 year for reporting.
Share-class Information	36	Share Class Reference Currency	Yes	Indicates the ISO3-currency code for the reference currency of the share class	Currency	String char (3)	Currency ISO-3	N/A
Share-class Information	37	Share Class Dividend Payment Frequency	No	Indicates the frequency at which the dividends are paid	Frequency	String char (4)	List of values: YEAR = Annual TWYR = Twice a year TOWK = Twice a week TOMN = Every two months TWMN = Twice a month WEEK = Weekly DAIL = Daily MNTH = Monthly TRIE = Every four months SEMI = Every six months QURT = Every three months MLTD = Multi-daily NIMN = Every nine months	Yearly by default
Share-class Information	38	Share Class Result Allocation	Yes	Indicates whether income payment is distributed or capitalized or other	Indicator	String char (3)	List of values: ACC INC CAD=Acc&Inc OTH	N/A
Share-class Information	39	Share Class Sleeping Indicator	No	Indicates whether the share is sleeping or not	Indicator	String char (3)	Boolean:YES/NO	If blank, then N by default
Share-class Information	40	Institutional Investor Type	No	Indicates whether the instrument is reserved for institutional investors or not	Indicator	String char (3)	Boolean:YES/NO	If blank, then N by default
Share-class Information	41	Initial Launch Price	No	Indicates the initial launch price of the instrument	Number	Numeric char (20)	Separator: "." => "0.0000"	N/A
Share-class Information	42	Initial Launch Price Currency	No	Indicates the ISO-3 currency code of the initial launch price of the instrument	Currency	String char (3)	Currency ISO-3	The initial launch price currency has to be the same as the share class reference currency
Share-class Information	43	Initial Launch Price Date	No	Indicates the date of the initial launch price	Date	Date char (10)	Date format: dd/MM/yyyy	Should not be greater then the creation date of the share class