Difference between revisions of "Test1"

From E-fileWiki
Jump to navigation Jump to search
 
(29 intermediate revisions by 2 users not shown)
Line 1: Line 1:


=Introduction=
==Test==
<div class="mw-collapsible mw-collapsed" >
<div class="mw-collapsible-toggle" style="float:left; margin-left:0; margin-right:1em;">Ouvrir</div>
Expand for more details  Expand for more details Expand for more details
<div class="mw-collapsible-content">
this is a text for test purpose and expand demonstration.this is a text for test purpose and expand demonstration.this is a text for test purpose and expand demonstration.
</div>
</div>


<span style="color:white; background:DarkTurquoise"> '''Please be informed that we are working on a new e-file version of the '''Static Data Management''' ('''SDM''') application that will be delivered in the first quarter of 2020.''' </span>


This modernized e-file version will introduce a <u>new design</u> and <u>improved ergonomics</u> for a better user experience.
<div style="height:200px;  width:auto; overflow-y:scroll">


Please find below our '''Before - After User Guide''' where we will explain all important changes.
{| class="wikitable table-filterable mw-collapsible mw-collapsed sortable"
|+ <span style="white-space:nowrap"> Table test </span>
|- <div style="position:sticky;top:-1px;z-index:10">
!scope="col" style="color:green |Lib Metier EN
!scope="col" style="color:green"| CODE
!scope="col" style="color:green"| Déclaration CSSF
!scope="col" style="color:green"| Particularités
!scope="col" style="color:green"| Config a vérifier
</div>
|-
| CSSF pilot phase member                                      ||  ||  ||  ||
|-
| Stock Exchange pilot phase member                            ||  ||  ||  ||
|-
| Stock Exchange filing entity                                ||  ||  ||  ||
|-
| Stock Exchange pilot phase non-member                        ||  ||  ||  ||
|-
| CSSF pilot phase non-member                                  ||  ||  || Pour la validation de prospectus (par groupe principal) ||
|-
| Publication Service S7                                      ||  ||  ||  ||
|-
| Transmission of UCI descriptive information                  ||  ||  || www.fundsquare.net ||
|-
| Transmission of UCI regulatory reports                      ||  || Pour les O1.2 || www.fundsquare.net ||
|-
| Transmission of periodic data                                ||  ||  || www.fundsquare.net ||
|-
| Euronext - Corporate Bonds                                  ||  ||  ||  ||
|-
| TAF COREP FINREP reports transmission                        || 07/302 & 07/306 & 06/251& 07/319 & 07/316 & 07/324 & 07/331 & 08/344 & 08/365 & 14/583 || PKCS7 (declarer BIC pour TAF MiFID + agrement CSSF pour COREP + FINREP) || www.bourse.lu || "Code BIC
|-
| Code agrément CSSF"                                          ||  ||  ||  ||
|-
| Balance of Paiements                                        || 2011/7 ||  ||  ||
|-
| BCL Statistics                                              ||  || A VALIDER A PRIORI : NON ||  || Code agrément CSSF (BXXX)
|-
| CSSF Polls                                                  || 08/363 & 11/500 & 12/530 || PKCS7 (agrement CSSF) ||  || Code agrément CSSF (BXXX)
|-
| EDIFACT Reporting                                            || 08/344 ||  ||  ||
|-
| SICAR Reporting                                              || 08/376 || PKCS7(agrement CSSF) ||  || Code agrément CSSF (BXXX)
|-
| PSF Reporting                                                || 08/369 || PKCS7(agrement CSSF) ||  || Code agrément CSSF (BXXX)
|-
| OTHER Reporting (-> CSSF)                                    ||  || PKCS7(agrement CSSF) ||  || Code agrément CSSF (BXXX)
|-
| Security by security Reporting                              ||  ||  || www.bourse.lu + www.e-file.lu/e-file ||
|-
| Metier des circulaires CSSF 371 et 09/423                    || 08/371 & 09/423 ||  ||  ||
|-
| Various correspondence (OTH -> BCL)                          ||  ||  || Gratuit ||
|}


 
</div>
 
 
 
=Select Test or Production environment=
 
Production environment : '''https://www.e-file.lu/e-file/'''
 
Homologation environment (Test) : '''https://homologation.e-file.lu/e-file/'''
 
 
 
 
 
=E-file login=
 
Enter your e-file login credentials (user name and password) and click the ACCESS button.
 
[[File:BeforAfterLogin.png|border|800 px]]
 
'''IMPORTANT:''' If you do not have an e-file user account, you might contact your '''e-file administrator''' of your company.
 
[[E-file Administration|=>for more detailed information please click the link '''e-file Administration''']]
 
 
 
 
 
=Launchpad=
 
The e-file launchpad opens.
 
Click on the '''Static Data Management''' icon.
 
[[File:3Launchpad.png|800 px]]
 
 
 
 
 
=Select template - Before=
 
The '''Export screen''' opens.
 
[[File:3BeforeServiceSelection.png|border|700 px]]
 
[[File:BeforePoint1.png|20 px]] Open the drop-down list to select the SERVICE
 
 
 
 
 
=Select template - After=
 
[[File:5After SelectTemplate.png|700 px]]
 
[[File:AfterPoint1.png|20 px]] Click on the arrow highlighted in yellow in the top left hand corner of the page to open the drop-down list to select the TEMPLATE [[File:AfterPoint2.png|20 px]]
 
 
 
 
 
=Filter functions - Before=
 
[[File:2Before FilterFunctions.png|1000 px]]
 
[[File:BeforePoint1.png|20 px]] Click on the FILTER button on the left side of the screen. A window opens where you can specify your search criteria.
 
[[File:BeforePoint2.png|20 px]] Narrow your search criteria by selecting the PROMOTER/LIBRARY OWNER, FUNDS, SUB-FUND, SHARE CLASS.
 
[[File:BeforePrint3.png|20 px]] Narrow your search criteria by selecting the STATUS of your instrument (e.g. active and public).
 
[[File:BeforePrint4.png|20 px]] RESET button to clear all fields and start a new search.
 
[[File:BeforePrint5.png|20 px]] SEARCH button to start the search.
 
[[File:BeforePrint6.png|20 px]] EXPAND/COLLAPSE button to display the whole fund tree (fund, sub-funds and share classes) (EXPAND) or to display only the fund level (COLLAPSE).
 
[[File:BeforePrint7.png|20 px]] Narrow your search criteria by entering the ISIN, CSSF CODE or INTERNAL CODE in the appropriate search field.
 
[[File:BeforePrint8.png|20 px]] REFRESH button to make available the most updated version of the page you are viewing.
 
[[File:BeforePrint9.png|20 px]] Specify your display options: SHOW SELECTED instruments, SELECT ALL instruments, UNCHECK ALL boxes.
 
[[File:BeforePrint10.png|20 px]] Specify your SELECTION option. STANDARD: each box of the fund tree has to be selected either manually or through the SELECT ALL button. [[File:BeforePrint11.png|20 px]] SPREAD: the checked box of the fund will be automatically spread to the whole fund tree.
 
[[File:BeforePrint12.png|20 px]] EXPORT button: all selected instruments (with checked boxes) will be exported in the file.
 
 
 
 
 
=Filter functions - After=
[[File:2AfterSDMExport.png|1000 px]]
 
[[File:AfterPoint1.png|20 px]] Click on the '''FILTER''' button [[File:AfterSDMFilter.png|30 px]] on the right side of the screen. A toolbar (highlighted in yellow) opens where you can narrow your search options by specifying the [[File:AfterPoint2.png|20 px]] STATUS of the instrument (e.g. active and public).
 
[[File:AfterPoint3.png|20 px]] Click inside the toolbar highlighted in yellow. A drop-down list '''DATA FILTERS''' pops up where you can narrow your search criteria by selecting e.g. ISIN, CSSF CODE. Enter your ISIN, CSSF CODE in the dedicated search field (3a, 3b) and
 
[[File:AfterPoint4.png|20 px]] Press the '''SEARCH'''  button or press ENTER.
 
[[File:AfterPoint5.png|20 px]] Press the '''RESET''' button [[File:AfterSDMResetButton.png|20 px]] to clear all fields and reset filters.
 
[[File:AfterPoint6.png|20 px]] If the '''SELECT ALL''' box is checked, all instruments of all management companies that are linked in our database to the ACTOR are selected.
 
[[File:AfterPoint7.png|20 px]] Display options
 
:: If the '''SHOW ONLY SELECTED''' button is green, only the selected instruments are displayed on the screen.
 
:: If the '''EXPAND ALL''' button is green, the whole tree structure (fund, sub-fund, share class) of the instrument is displayed.
 
:: If the '''SPREAD SELECTION TO RELATED INSTRUMENTS''' button is green and you select an instrument at fund level, the whole tree structure of the fund will be automatically selected.
 
[[File:AfterPoint8.png|20 px]] If you press the '''EXPORT''' button, all selected instruments with checked boxes will be exported in the file.
 
 
 
 
 
=Export a file - Before=
[[File:2BeforeSDMExport.png|700 px]]
 
Press the '''EXPORT''' button.
 
[[File:BeforePoint1.png|20 px]] A message on the top of the screen informs you that '''Currently 1 report(s) is generated'''.
 
[[File:BeforePoint2.png|20 px]] Once the file is generated, a window pops up indicating '''The following report has been generated'''. Press the OK button to open the file.
 
 
 
 
 
=Export a file - After=
[[File:2AfterSDMEportFDF.png|700 px]]
 
[[File:AfterPoint1.png|20 px]] Press the '''EXPORT''' button
 
[[File:AfterPoint2.png|20 px]] The red notification indicates that one file is being generated or has been generated.
 
[[File:AfterPoint3.png|20 px]] Once that file is generated, a window pops up indicating '''The following report was generated'''.
 
[[File:AfterPoint4.png|20 px]] Open the file that is available at the bottom of the page.
 
 
 
 
 
=Import a file - Before=
[[File:3BeforeSDMImport.png|800 px]]
 
[[File:BeforePoint1.png|20 px]] Open the '''IMPORT''' tab on the top of the screen.
 
[[File:BeforePoint2.png|20 px]] Select the '''SERVICE'''.
 
[[File:BeforePrint3.png|20 px]] Press the button '''ADD a FILE''' and select the file you want to import.
 
[[File:BeforePrint4.png|20 px]] Press the '''IMPORT''' button.
 
[[File:BeforePrint5.png|20 px]] A window '''REQUEST FOR UPDATE WITHIN THE FUNDSQUARE STATIC DATA REFERENTIAL''' pops up. Complete the fields and press the '''VALIDATE''' button.
 
[[File:BeforePrint6.png|20 px]] A window opens indicating that '''Your document has been successfully uploaded. Within 72 hours you will receive a confirmation on its processing.'''
 
 
 
 
 
=Import a file - After=
[[File:3AfterSDMImport.png|800 px]]
 
[[File:AfterPoint1.png|20 px]] Press the '''FLOW-CHART''' button [[File:AfterSDMFlowChartButton.png|20 px]]. A small window pops up with two options: '''EXPORT''' and '''IMPORT'''. Select '''IMPORT.'''
 
[[File:AfterPoint2.png|20 px]] You have two options to upload your file:
 
:: - either you '''BROWSE''' your file system and select the file you want to upload
 
:: - or you '''DRAG & DROP your file directly onto the appropriate area [[File:AfterSDMDragDrop.png|20 px]]
 
:: <span style="color:white; background:DarkTurquoise"> '''NEW:''' </span> Please be informed that new <u>features</u> have been added to the new e-file version of the '''Static Data Management''' application. You have now the possibility to upload <u>several</u> files at the same time.
 
:: In our example we uploaded two files:
 
:: ABC_2019_12_17_FDF.xlsx (cf. '''2b''')
 
:: XYZ_2019_12_17_FDF.xlsx (cf. '''2a''')
 
[[File:AfterPoint3.png|20 px]] You have two options to add the mandatory parameters '''TEMPLATE''', '''ACTION''', '''COMMENT'''
 
::- either you select each parameter for each single file
 
::- or you set all parameters via the SET BULK PARAMETERS [[File:AfterPoint4.png|20 px]] funcionality cf. screen below
 
 
 
'''VERY IMPORTANT INFORMATION'''
 
Please ensure that you always follow the Fundsquare naming convention of the templates. The respective acronyms at the end of the file name are '''mandatory''' and they have to be preceded by an underscore. Please note that only '''.xlsx''' files are allowed to be imported.
 
FDF template: nnnnnnn_'''FDF'''.xlsx
 
MIFID template: nnnnnnn_'''MIFID'''.xlsx
 
PRIIPS template: nnnnnnn_'''PRIIPS'''.xlsx
 
 
 
 
 
 
 
 
==Set bulk parameters==
[[File:2AfterSDMBulkImport.png|600 px]]
 
[[File:AfterPoint1.png|20 px]] If you check the '''SELECT ALL''' box and complete all mandatory fields in this sections, all mandatory fields of the two files we imported, will be populated automatically with the same parameters.
 
[[File:AfterPoint2.png|20 px]] Press the '''VALIDATE IMPORT PARAMETERS''' button.
 
 
 
 
 
==Import confirmation==
[[File:NewSDM.png|600 px]]
 
[[File:AfterPoint1.png|20 px]] Press the IMPORT DATA button.
 
[[File:AfterPoint2.png|20 px]] A window pops up indicating '''Your documents were received''' and
 
[[File:AfterPoint3.png|20 px]] another window pops up confirming that the import was successful.
 
[[File:AfterPoint4.png|20 px]] The red notification with number 2 inside, shows you that 2 files have been imported.
 
[[File:AfterPoint5.png|20 px]] If you click on the EXCLAMATION MARK, a drop down list with all imported files opens.
 
 
Furthermore, please be informed, that you will receive a '''notification''' by email with detailed information on your files you imported.
 
[[File:ConfirmationMail.png|border|400 px]]
 
 
 
 
 
=How to use FSQ IDs in the Fundamental Data Form (FDF)=
 
In the following we would like to explain you how to use Fundsquare's internal identification numbers of instruments which are available in column 45, 46, 47 of the Fundamental Data Form (Id Fund, Id Sub-Fund, Id Share-Class).
 
[[File:1 FSQ ID FDF.png|border|300 px]]
 
 
(1) Modification of an instrument
 
If you modify an instrument '''the three FSQ Id must not be changed under no circomstances.'''
 
For example, if you want to change a Sub-fund name, the new name must be reported in the appropriate cell. '''DO NOT CHANGE''' the FSQ IDs.
 
 
(2) Closure of an instrument
 
If you want to close an instrument, the appropriate cells in column 13, 24, 34 have to be completed with the closure date. '''DO NOT CHANGE''' the FSQ IDs.

Latest revision as of 09:22, 2 October 2023

Test

Ouvrir

Expand for more details Expand for more details Expand for more details

this is a text for test purpose and expand demonstration.this is a text for test purpose and expand demonstration.this is a text for test purpose and expand demonstration.


Table test
Lib Metier EN CODE Déclaration CSSF Particularités Config a vérifier
CSSF pilot phase member
Stock Exchange pilot phase member
Stock Exchange filing entity
Stock Exchange pilot phase non-member
CSSF pilot phase non-member Pour la validation de prospectus (par groupe principal)
Publication Service S7
Transmission of UCI descriptive information www.fundsquare.net
Transmission of UCI regulatory reports Pour les O1.2 www.fundsquare.net
Transmission of periodic data www.fundsquare.net
Euronext - Corporate Bonds
TAF COREP FINREP reports transmission 07/302 & 07/306 & 06/251& 07/319 & 07/316 & 07/324 & 07/331 & 08/344 & 08/365 & 14/583 PKCS7 (declarer BIC pour TAF MiFID + agrement CSSF pour COREP + FINREP) www.bourse.lu "Code BIC
Code agrément CSSF"
Balance of Paiements 2011/7
BCL Statistics A VALIDER A PRIORI : NON Code agrément CSSF (BXXX)
CSSF Polls 08/363 & 11/500 & 12/530 PKCS7 (agrement CSSF) Code agrément CSSF (BXXX)
EDIFACT Reporting 08/344
SICAR Reporting 08/376 PKCS7(agrement CSSF) Code agrément CSSF (BXXX)
PSF Reporting 08/369 PKCS7(agrement CSSF) Code agrément CSSF (BXXX)
OTHER Reporting (-> CSSF) PKCS7(agrement CSSF) Code agrément CSSF (BXXX)
Security by security Reporting www.bourse.lu + www.e-file.lu/e-file
Metier des circulaires CSSF 371 et 09/423 08/371 & 09/423
Various correspondence (OTH -> BCL) Gratuit
Retrieved from "http://www.e-file.lu/wiki/index.php?title=Test1&oldid=6845"