consumers, health, agriculture and food executive agency consumers, health, agriculture and food...

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Better Training for Safer FoodInitiative

TRACES: DATA WAREHOUSE

QLIKVIEWCERTIFICATES TO EU

Control Checks at Border Inspection Posts

Session 4 13th – 16th October 2015 – Felixstowe

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

DATA WAREHOUSE

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse - Retrieving information

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Save

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

QLIKVIEW

Use Google Chrome

or Mozilla Firefox

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

33Health andConsumers

Statistics: Qlikview

33

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Health andConsumers

Qlikview Search

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Qlikview SearchQlikview Search

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Qlikview Search

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Qlikview Search

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

To save or print, right click within the data you want to save /print

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

If it doesn’t save automatically, click on press here. Downloaded file should appear at the bottom of the screen

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

23

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Veterinary Certificate to EU

Many certificates accompanying consignments to the EU are now produced on TRACES from countries e.g. Bosnia & Herzegovina, Benin, Costa Rica, Croatia, French Polynesia, Guatemala, Indonesia, Mayotte, Mexico, Morocco, Madagascar, Mauritania, Mauritius, New Caledonia, Saint Pierre & Miquelon, Seychelles, Senegal, Taiwan, Uruguay. New Zealand.

Once located on TRACES these can be ‘cloned’ to produce the CVED

Consumers, Health, Agriculture and Food Executive Agency

Economic operator has a link ‘direct access’To find an IMPORT certificate, the economic operator must enter: • ‘Certificate reference number TRACES’• ‘Certificate reference’• ‘Country of Destination’ and click Direct Access

Searching for a Veterinary Certificate to EU

Consumers, Health, Agriculture and Food Executive Agency

Searching for a Veterinary Certificate to EU

To find an IMPORT certificate from New Zealand EO must enter: • ‘Certificate reference’• ‘Country of Destination’ • ‘Country of Origin (=NZ)’ and click Direct Access

New Zealand

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Consumers, Health, Agriculture and Food Executive Agency

BTSFConsumers, Health And Food Executive Agency

BTSFThank you