New Developments at the OECD: The Common Processing Application (COPRA) ITS Experts Meeting – September 2006

1. New Developments at the OECD: The Common Processing Application (COPRA)ITS Experts Meeting – September 2006 Trevor Fletcher ITN/CBS

2. Introduction Presentation to cover: • Background on the Joint OECD/UNSD Trade System • The Common Processing Application (COPRA) • COPRA Processing steps

3. The OECD/UNSD joint Trade System • Common application jointly developed for processing OECD and UNSD Trade data. • OECD process member country data • UNSD process all other data • Data exchanged between the organisations to complete each organisations database content.

4. UNSD OECD Data Exchange Disseminate Disseminate Dissemination Database Dissemination Database Working Database Working Database Process Process Common Processing Module Common Processing Module Data Access Data capture Data capture

5. The Common Processing Application - COPRA • Application software for managing all steps of International Commodity Statistics processing from Data Capture to Dissemination • Incorporates common processing rules agreed by OECD and UNSD • System in production at both organisations

6. Application processing phases • Data Capture • Normalisation of Codes • Data Completeness • Normalisation of Commodities • Data Aggregation • Quantity and Value Checking • Data Classification Conversions • Data Publishing

7. Thank you ... Trevor.Fletcher@OECD.org questions & answers ...