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

32
Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive Agency Better Training for Safer Food Initiative TRACES: DATA WAREHOUSE QLIKVIEW CERTIFICATES TO EU Control Checks at Border Inspection Posts Session 4 13 th – 16 th October 2015 – Felixstowe

Upload: elvin-townsend

Post on 19-Jan-2016

217 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

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

Page 2: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

DATA WAREHOUSE

Page 3: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse - Retrieving information

Page 4: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Page 5: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Page 6: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Page 7: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Page 8: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Data Warehouse

Save

Page 9: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

QLIKVIEW

Use Google Chrome

or Mozilla Firefox

Page 10: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Page 11: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

33Health andConsumers

Statistics: Qlikview

33

Page 12: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Health andConsumers

Qlikview Search

Page 13: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Qlikview SearchQlikview Search

Page 14: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Qlikview Search

Page 15: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Qlikview Search

Page 16: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Page 17: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Page 18: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Page 19: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Page 20: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

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

Page 21: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

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

Page 22: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

Page 23: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Consumers, Health And Food Executive Agency

23

Page 24: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

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

Page 25: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

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

Page 26: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

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

Page 27: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Page 28: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Page 29: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Page 30: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Page 31: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

Cloning to CVED

Page 32: Consumers, Health, Agriculture and Food Executive Agency Consumers, Health, Agriculture and Food Executive Agency Consumers, Health And Food Executive

Consumers, Health, Agriculture and Food Executive Agency

BTSFConsumers, Health And Food Executive Agency

BTSFThank you