Difference between revisions of "FundamentalDataForm"

From E-fileWiki
Jump to navigation Jump to search
Line 7: Line 7:
In due course, we will provide further information on this section.<br>
In due course, we will provide further information on this section.<br>
<div style="text-align: center;">
<div style="text-align: center;">
{| border="1" cellspacing="7" cellpadding="15"
{| border="1" cellspacing="5" cellpadding="10"
|-  
|-  
|'''Main Category'''||'''Column Number'''||'''Field Label'''||'''Mandatory Field'''||'''Definition'''||'''Type of Data'''||'''Field Format'''||'''Format Constraints'''||'''Business Rule'''||  
|'''Main Category'''||'''Column Number'''||'''Field Label'''||'''Mandatory Field'''||'''Definition'''||'''Type of Data'''||'''Field Format'''||'''Format Constraints'''||'''Business Rule'''||  
Line 15: Line 15:
|'''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'''||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<br> Mandatory if self-managed and no Management Company has been provided||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.<br>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||Conditional cf Definition||Indicates the name of the Adminstrator of the fund including the country<br> Mandatory for LU funds||Company Name||String char (100)||N/A||N/A||
|'''Third-Party Information'''||4||Fund Administration||Conditional cf Definition||Indicates the name of the Adminstrator of the fund including the country.<br>This field is mandatory for LU-funds||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<br> Mandatory for Order Routing Data||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.<br>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 Database (upper/lower included)||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 Database||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'''||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||Fund GIIN Code||Indicates the Global Intermediary Identification Number of the instrument at the fund level<br>Mandatory for FATCA reporting||Codification||String char (20)||Alphanumerical: Char(6).Char(5).Char(2).Number(3)<br>Is unique in Fundsquare's Database||Has to be unique if not SP (Sponsor)<br>7th char = "."<br>13th char = "."<br>16th char = "."<br>&<br>Last 3 char = 442<br>or<br>14th&15th = SP
|'''Fund Information'''||9||Fund GIIN Code||Conditional cf Definition||Indicates the Global Intermediary Identification Number of the instrument at the fund level<br>This field is mandatory for FATCA reporting||Codification||String char (20)||Alphanumerical: Char(6).Char(5).Char(2).Number(3).<br>Is unique in Fundsquare's database.||Has to be unique if not SP (Sponsor).<br>7th char = "."<br>13th char = "."<br>16th char = "."<br>&<br>Last 3 char = 442<br>or<br>14th&15th = SP
|-  
|-  
|'''Fund Information'''||10||Fund RFI ID (CRS)||Conditional cf Definition||Indicates the Social Securities Identification number at the fund level. Manadatory for CRS reporting||Codification||String char (20 or 22)||Number(11) - Number(13)||9th char is a letter followed by 8 "0"||
|'''Fund Information'''||10||Fund RFI ID (CRS)||Conditional cf Definition||Indicates the Social Securities Identification number at the fund level. Manadatory 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 according to European Directives||Indicator||String char (6)||List of values: UCITS<br>AIF<br>OTHER<br>NON EU||N/A||
|'''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:<br>UCITS<br>AIF<br>OTHER<br>NON EU||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'''||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||No||Indicates the date on which the fund is created/activated||Duration||Date char (10)||Date format: dd/MM/yyyy||If date > current date OR If no date = inactivated = anticipated creation (AC)<br>If date ≤ current date = activated = available for documents notification and dissemination (ACT)||
|'''Fund Information'''||13||Fund Creation Date||No||Indicates the date on which the fund is created/activated||Duration||Date char (10)||Date format: dd/MM/yyyy||If date > current date OR If no date = inactivated = anticipated creation (AC).<br>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||Duration||Date char (10)||Date format: dd/MM/yyyy||If Date ≤ current date = inactivated = not available for documents notification and dissemination<br>available 1 year for reporting||
|'''Fund Information'''||14||Fund End Date||No||Indicates the ending date of the fund's activity (closing/liquidation date)||Duration||Date char (10)||Date format: dd/MM/yyyy||If Date ≤ current date = inactivated = not available for documents notification and dissemination.<br>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||2 first positions same as the two first letters included in ISIN code<br>(for example: LU, GB, IE, etc.)||
|'''Fund Information'''||15||Fund Jurisdiction Country||Yes||Indicates the country where the fund is domiciled||Legal||String char (2)||Code ISO2||The 2 first positions must be the same as the two first letters included in ISIN code.<br>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:<br>"FCP" = FCP: Common fund<br>"SICV" = SICAV: Investment company with variable capital<br>"SICF" = SICAF: Investment company with fixed capital<br>"SICR" = SICAR: Investment company in risk capital<br>"OT" = OT: Securitisation entities<br>"SCA" = SCA: Partnership limited by shares<br>"SCS" = SCS: Limited partnership<br>"SCSp" = SCSp: Special partnership<br>"SA" = SA: public limited liability company<br>"OTH" = OTHER: Other fund||Linked/compatible with "Fund Legal Status"||
|'''Fund Information'''||16||Fund Legal Form||Yes||Indicates the legal form of the fund||Legal||String char (4)||List of values:<br>"FCP" = FCP: Common fund<br>"SICV" = SICAV: Investment company with variable capital<br>"SICF" = SICAF: Investment company with fixed capital<br>"SICR" = SICAR: Investment company in risk capital<br>"OT" = OT: Securitisation entities<br>"SCA" = SCA: Partnership limited by shares<br>"SCS" = SCS: Limited partnership<br>"SCSp" = SCSp: Special partnership<br>"SA" = SA: public limited liability company<br>"OTH" = OTHER: Other fund||Linked/compatible with "Fund Legal Status"||
Line 45: Line 45:
|'''Fund Information'''||17||Fund Legal Status ||Yes||Indicates the legal status of the fund||Legal||String char (4)||List of values:<br>"SIF" = SIF<br>"NLUX" = Non-LU-domiciled<br>"PA04" = Law 14 june 2004<br>"PA05" = Law 22 march 2004<br>"P110" = Part I 2010 law<br>"P210" = Part II 2010 law<br>"RAIF" = RAIF||Linked/compatible with "Fund Legal Form"||
|'''Fund Information'''||17||Fund Legal Status ||Yes||Indicates the legal status of the fund||Legal||String char (4)||List of values:<br>"SIF" = SIF<br>"NLUX" = Non-LU-domiciled<br>"PA04" = Law 14 june 2004<br>"PA05" = Law 22 march 2004<br>"P110" = Part I 2010 law<br>"P210" = Part II 2010 law<br>"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 Database at this level (upper/lower case letters)||N/A||
|'''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 on sub-fund level||Codification||String char (20)||Is unique in Fundsquare Database||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'''||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<br>Mandatory for FATCA||Codification||String char (20)||AlphaNumerical:Char(6).Char(5).Char(2).Number(3)<br>Is unique in Fundsquare Database||Has to be unique<br>7th char = "".""<br>13th char = "".""<br>16th char = "".""<br>&<br>Last 3 char = 442<br>OR<br>14th&15th=SP||
|'''Sub-fund Information'''||21||Sub-Fund GIIN Code||Conditional cf Definition||Indicates the Global Intermediary Identification Number for the instrument at the fund level.<br>This field is mandatory for FATCA Reporting.||Codification||String char (20)||AlphaNumerical:Char(6).Char(5).Char(2).Number(3).<br>Is unique in Fundsquare Database.||Has to be unique<br>7th char = "".""<br>13th char = "".""<br>16th char = "".""<br>&<br>Last 3 char = 442<br>OR<br>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<br>Mandatory for CRS reporting||Codification||String char (20or22)||Number(11)-Number(13)||9th char is a letter followed by 8 numbers<br>CSSF Code should be retrieved in the last part of the ID (Ex: MATRICULE+F00000145)<br>with a maximum of 8 characters after the "letter"||
|'''Sub-fund Information'''||22||Sub-Fund RFI ID (CRS)||Conditional cf Definition||Indicates the Social Securities Identification number at the sub-fund level.<br>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.<br>The CSSF code should be retrieved in the last part of the ID (Ex: MATRICULE+F00000145).<br>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||Duration||Date char (10)||Date format: dd/MM/yyyy||If date > current date OR If no date = inactivated = anticipated creation (AC)<br>If date ≤ current date = activated = available for documents notification and dissemination (ACT)<br>Ensure that the date is not greater then creation date of the fund||
|'''Sub-fund Information'''||23||Sub-Fund Creation Date||No||Indicates the date on which the sub-fund is created/activated||Duration||Date char (10)||Date format: dd/MM/yyyy||If date > current date OR If no date = inactivated = anticipated creation (AC).<br>If date ≤ current date = activated = available for documents notification and dissemination (ACT).<br>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||Duration||Date char (10)||Date format: dd/MM/yyyy||If Date ≤ current date = inactivated = not available for documents notification and dissemination<br>available 1 year for reporting||
|'''Sub-fund Information'''||24||Sub-Fund End Date||No||Indicates the ending date of the sub-fund's activity (closing/liquidation date)||Duration||Date char (10)||Date format: dd/MM/yyyy||If Date ≤ current date = inactivated = not available for documents notification and dissemination.<br>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'''||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<br>It must be the same for all the share classes that are included in one sub-fund||Frequency||String char (4)||List of values:<br>YEAR = Annual<br>TWYR = Twice a year<br>TOWK = Twice a week<br>TOMN = Every two months<br>TWMN = Twice a month<br>WEEK = Weekly<br>DAIL = Daily<br>MNTH = Monthly<br>TRIE = Every four months<br>SEMI = Every six months<br>QURT = Every three months<br>MLTD = Multi-daily<br>NIMN = Every nine months<br>||N/A||
|'''Sub-fund Information'''||26||NAV per Share Frequency||Yes||Notifies the frequency of the net asset per share calculation.<br>It must be the same for all the share classes that are included in one sub-fund.||Frequency||String char (4)||List of values:<br>YEAR = Annual<br>TWYR = Twice a year<br>TOWK = Twice a week<br>TOMN = Every two months<br>TWMN = Twice a month<br>WEEK = Weekly<br>DAIL = Daily<br>MNTH = Monthly<br>TRIE = Every four months<br>SEMI = Every six months<br>QURT = Every three months<br>MLTD = Multi-daily<br>NIMN = Every nine months<br>||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||
|'''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||
Line 67: Line 67:
|'''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'''||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 Database (upper/lower case letters<br>Combined with fund & sub-fund labels||Name available on Fundsquare website and client whitelabelling||
|'''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.<br>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 database||N/A||
|'''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||N/A||
|-
|-
|'''Share-class Information'''||31||Share Class Administration Code||No||Indicates the central administration's instrument code at the share class level (AC internal code)<br>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'''||31||Share Class Administration Code||No||Indicates the central administration's instrument code at the share class level (AC internal code).<br>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<br>Mandatory for Ucits funds if share class is activated (creation date)||Codification||String char (12)||Is unique in Fundsquare Database||Ensure the first 2 letters corresponds to the Fund Juridiction Country<br>For Ucits Funds => If empty = share class inactivated (INA)||
|'''Share-class Information'''||32||Share Class ISIN Code||Conditional cf Definition||Indicates the ISIN code of the share class.<br>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 2 letters correspond to the fund juridiction country.<br>For Ucits Funds:If is empty the share class status is inactivated (INA)||
|-
|-
|'''Share-class Information'''||33||Share-Class Ticker Bloomberg Code||No||Indicates the Bloomberg Ticker instrument code||Codification||String char (20)||Is unique in Fundsquare Database||N/A||
|'''Share-class Information'''||33||Share-Class Ticker Bloomberg Code||No||Indicates the Bloomberg Ticker's instrument 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||Duration||Date char (10)||Date format: dd/MM/yyyy||If date > current date OR If no date = inactivated & anticipated creation (AC)<br>If date ≤ current date = activated = available for documents notification and dissemination (ACT)<br>If UCITS and NO ISIN Code then no creation date should be available<br>Ensure that the date is not greater then creation date of the Sub-Fund||
|'''Share-class Information'''||34||Share Class Creation Date||No||Indicates the date on which the share class is created/activated||Duration||Date char (10)||Date format: dd/MM/yyyy||If date > current date OR If no date = inactivated & anticipated creation (AC).<br>If date ≤ current date = activated = available for documents notification and dissemination (ACT).<br>If UCITS and NO ISIN CODE then no creation date should be available.<br>Ensure that the date is not greater then creation date of the sub-fund||
|-
|-
|'''Share-class Information'''||35||Share Class End Date||No||Indicates the ending date of the share class's activity||Duration||Date char (10)||Date format: dd/MM/yyyy||If Date ≤ current date = inactivated = not available for documents notification and dissemination<br>available 1 year for reporting||
|'''Share-class Information'''||35||Share Class End Date||No||Indicates the ending date of the share class's activity (closing/liquidation date)||Duration||Date char (10)||Date format: dd/MM/yyyy||If Date ≤ current date = inactivated = not available for documents notification and dissemination.<br>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'''||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||
Line 85: Line 85:
|'''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:<br>YEAR = Annual<br>TWYR = Twice a year<br>TOWK = Twice a week<br>TOMN = Every two months<br>TWMN = Twice a month<br>WEEK = Weekly<br>DAIL = Daily<br>MNTH = Monthly<br>TRIE = Every four months<br>SEMI = Every six months<br>QURT = Every three months<br>MLTD = Multi-daily<br>NIMN = Every nine months<br>||Yearly by default||
|'''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:<br>YEAR = Annual<br>TWYR = Twice a year<br>TOWK = Twice a week<br>TOMN = Every two months<br>TWMN = Twice a month<br>WEEK = Weekly<br>DAIL = Daily<br>MNTH = Monthly<br>TRIE = Every four months<br>SEMI = Every six months<br>QURT = Every three months<br>MLTD = Multi-daily<br>NIMN = Every nine months<br>||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:<br>ACC<br>INC<br>CAD = Acc&nc<br>OTH||N/A||
|'''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:<br>ACC<br>INC<br>CAD=Acc&nc<br>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'''||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||
Line 91: Line 91:
|'''Share-class Information'''||40||Investor type Institutional||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'''||40||Investor type Institutional||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'''||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'''||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||Duration||Date char (10)||Date format: dd/MM/yyyy||Should not be greater then creation date of the share class||
|'''Share-class Information'''||43||Initial Launch Price Date||No||Indicates the date of the initial launch price||Duration||Date char (10)||Date format: dd/MM/yyyy||Should not be greater then the creation date of the share class||
|-
|-
</div>
</div>


[[Category: FAQ e-file]]
[[Category: FAQ e-file]]

Revision as of 15:06, 27 March 2017

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, provides explanations on the fields that are used and shall allow you to autonomously manage your dataset with Fundsquare.

How to obtain the FDF

In due course, we will further explain to you how to obtain the FDF out of e-file.lu V2.

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 Conditional cf Definition Indicates the name of the Adminstrator of the fund including the country.
This field is mandatory for LU-funds
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 Securities Identification number at the fund level. Manadatory 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
NON EU
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 No Indicates the date on which the fund is created/activated Duration 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) Duration 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 2 first positions 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 Duration 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) Duration 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 N/A
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 2 letters correspond to the fund juridiction country.
For Ucits Funds:If is empty the share class status is inactivated (INA)
Share-class Information 33 Share-Class Ticker Bloomberg Code No Indicates the Bloomberg Ticker's instrument 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 Duration 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 then creation date of the sub-fund
Share-class Information 35 Share Class End Date No Indicates the ending date of the share class's activity (closing/liquidation date) Duration 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&nc
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 Investor type Institutional 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 Duration Date char (10) Date format: dd/MM/yyyy Should not be greater then the creation date of the share class