Commission Implementing Regulation (EU) 2018/574 of 15 December 2017 on technical standards for the establishment and operation of a traceability system for tobacco products (Text with EEA relevance. )
Article 27Secondary repository
In force · version of Dec 21, 2023
1. A single secondary repository containing a copy of all data stored in primary repositories shall be established. The operator of the secondary repository shall be appointed from among the providers of primary repositories in accordance with the procedure laid down in Annex I, Part B.
2. The secondary repository shall provide for graphical and non-graphical interfaces, including an application programming interface, stationary and mobile user interfaces containing an inspection application for the leading mobile operating systems, that enable Member States and the Commission to access and query the data stored in the repositories system, using all commonly available database search functions, including Structured Query Language (SQL) or equivalent syntax for building custom queries, in particular by remotely carrying out the following operations: (a) retrieval of any information concerning one or multiple unique identifier(s), including the comparison and cross-checking of multiple unique identifiers and the related information, in particular their location in the supply chain; (b) creation of lists and statistics, such as product stocks and inflow/outflow numbers, associated with one or multiple elements of reporting information listed as Data Fields in Annex II; (c) identification of all tobacco products that have been reported by an economic operator to the system, including the products reported as recalled, withdrawn, stolen, missing or intended for destruction.
3. The user interfaces referred to in paragraph 2 shall enable each Member State and the Commission to configure their own rules for: (a) automatic alerting based on exceptions and specific reporting events, such as abrupt fluctuations or irregularities in trade, attempts to introduce duplicate unique identifiers into the system, deactivation of the identifiers referred to in Articles 15(4), 17(4) and 19(4), or where a product is indicated by economic operators as stolen or missing; (b) the receipt of periodic reports based on any combination of the elements of reporting information listed as Data Field in Annex II; (c) tailor-made dashboards, for stationary interfaces.
4. Automatic alerts and periodic reports referred to in paragraph 3 shall be forwarded to recipient addresses indicated by Member States and the Commission such as individual email addresses and/or internet Protocol (IP) addresses belonging to external systems used and managed by national authorities or the Commission.
5. The user interfaces referred to in paragraph 2 shall enable Member States and the Commission to: (a) connect remotely to the data stored in the repositories system with the analytical software of their choice; (b) flag individual data points for analytical purposes, with flags and their values stored in the secondary repository and made visible to all or only selected users; (c) upload external data elements, such as brand normalisation patterns, that may be required for improvements in data analytical functionalities.
6. The user interfaces referred to in paragraph 2 shall be provided in all official languages of the Union.
7. The overall response time of the repository to any already established type of query or alert trigger, not considering the speed of the internet connection of the end user, shall be no more than 10 seconds for the data stored for less than 2 years and no more than 15 seconds for the data stored for 2 years or more, in at least 99 % of all types of already established queries and automatic alerts foreseen under paragraphs 2 and 3. The provider of the secondary repository shall prepare datasets necessary for responding, in line with the prescribed timelines, to any new query or alert trigger within 4 weeks from receiving a request from Member States or the Commission. After this period, the newly requested types of queries or alert triggers shall be deemed to be already established for the purpose of the response times stipulated in this paragraph.
8. As regards individual data points and messages, the overall time between the arrival of reporting activity data and its accessibility, via the graphical and non-graphical interfaces, in the primary and secondary repositories shall be no more than 60 seconds in at least 99 % of all data transfer activities. As regards pre-structured analytical datasets, the overall time between the arrival of reporting activity data and its accessibility, via the graphical interfaces, in the secondary repository shall be no more than 24 hours in at least 99 % of all data transfer activities.
9. The repository shall allow for the receipt, storing and making available of offline flat-files for the purpose of updating verification devices used by Member States for offline decoding of unique identifiers.
10. The provider of the secondary repository shall establish and maintain a register of the information transferred to it in accordance with Article 20(3). The provider of the secondary repository shall keep a record of the information stored in the register for as long as the traceability system is operational.
ID issuers and providers of primary repositories may have access to the register referred to in the first subparagraph in order to validate the messages sent to them by manufacturers and importers.
11. Member States and the Commission shall retain the right to enter into additional service level agreements with the provider of the secondary repository for the purpose of contracting the latter to carry out additional services not provided for by this Regulation. The provider of the secondary repository may charge proportionate fees for providing such additional services.
12. The repository services provided to Member States and the Commission under this Article shall be compatible with Regulation (EU) No 910/2014 and in particular allow for the use of reusable solutions provided as building blocks under the telecommunication part of the Connecting Europe Facility.
13. The provider of the secondary repository shall organise at least one full-day technical training session per year for the users from each Member State and from the Commission, on the use of the user interfaces referred to in paragraph 2. The provider of the secondary repository shall also develop and keep updated a full set of technical and user documentation for the competent authorities available in all official languages of the Union.
14. The provider of the secondary repository shall provide an inspection application for the leading mobile operating systems that enables Member States and the Commission to connect to the secondary repository via the mobile user interfaces referred to paragraph 2.