Using a Reference Data Model for CrossBorder Information

Using a Reference Data Model for Cross-Border Information Exchange Case Study: The UNe. Docs Preferential Co. O In the ASEAN Pathfinder Project

Using a Data Model for Cross Border Data Exchange National Documents and DR UN Trade Data Directory Regional Cross Border DM Reference UN Trade Data Directory National Documents and DR CBRDM TDED UNe. Docs/WCO DM TDED Country B Regional Agreement Country A

Agenda Introduction to ASEAN Single Window (ASW) Pilot Project n UNe. Docs for ASW Pilot Project n Video Clips for the Proof-Of-Concept n

Introduction to ASW Pilot Project

Goal of ASW Pilot Project to implement the ASW project for Philippines and Thailand on the basis of standardization and simplification of documents, information and data, and processes

Process Flow For Exchange of CEPT Form D Export Thailand – Import Philippines Thailand PH NSW TH NSW Receive Approved CEPT Form D details Bureau Of Customs Send Approved CEPT Form D details eb. MS Gateway Dept Of Foreign Trade, Ministry of Commerce Parties involved: Sending : Depart of Foreign Trade, Min of Commerce, Thailand Receiving : Bureau of Customs, Phlippines

UNe. Docs for ASW Pilot Project

Chronology of events n n n Discussion between ASW Pilot project team (PH Customs, TH Customs) and TBG 2 members in Geneva on 4 th May, 2006 (in conjunction with Single Window Symposium) Requirement : UNe. Docs Proof-Of-Concept (POC) for the ASEAN Single Window Pilot Project TBG 2 team members started development work for the POC after the meeting POC approved by ASW Pilot Project team on 29 th May, 2006 (in conjunction with 2 nd ASW Workshop in Bangkok) Presented by ASW Pilot project during ASEAN Customs DG Meeting in Cambodia on 5 th June, 2006

Work done for the ASEAN CEPT Form D Proof-Of-Concept n n n Alignment of ASEAN CEPT Form D to UN Layout Key Definition of national data requirement and mapping to global semantic standard Mapping of ASEAN CEPT Form D to the UNe. Docs Data Model Generation of UNe. Docs XML Structure for the ASEAN CEPT Form D Development of an UNe. Docs Interactive PDF Document (optional step)

Alignment to UNLK ASEAN CEPT Form D is aligned to UNLK n Implemented important international standards n ¨ Code lists – UN/LOCODE ¨ ISO Codes ¨ UN/TDED

CEPT Form D (Sample)

Definition of national data requirement & mapping to global semantic standard Definition of national data requirement for import / export process n Submission to a focal point in ASEAN Secretariat for consolidation n Mapped against the UN/TDED and WCO Data Set n

Comparative Matrix ASEAN Information Parameters Mapping to WCO 2. 0 Dataset Mapping to Thailand Mapping to Philippines 3 Total number of packages 141: Type of packages identification 146: Total number of packages 7370/7065: Amount and kind of package 7370: No. of packages 7065: Type of packages for - cargo type - package type - packaging material 4 Country and/or region of exportation/whence consigned (country of destination) 062: Country of exportation, coded 201: Place whence consigned 202: Place whence consigned, coded 3221: Place of export

Mapping to UNe. Docs Data Model Mapped each box in CEPT Form D to a structure in UNe. Docs Co. O data model n All boxes in CEPT Form D were mapped to UNe. Docs Co. O data model n Result : simplified UNe. Docs data model of the CEPT Form D that is fully mapped to the paper form n

Sample – UNe. Docs data model mapping to ASEAN CEPT Form D

Generation of UNe. Docs XML Structure for ASEAN CEPT Form D n n n Expert team used EDIFIX to transform Simplified UNe. Docs data model for CEPT Form D into XML structure based on UN/CEFACT Naming and Design Rules (DNR) Result : UNe. Docs XML Schema for CEPT Form D Through interfaces, the UNe. Docs CEPT Form D document is integrated directly into PH & TH Customs processing for G 2 G business data exchange

Sample CEPT Form D XML Schema

Development of UNe. Docs Interactive PDF Document (Optional steps) n Implemented UNe. Docs CEPT Form D using UN Toolkit in combination with Adobe Interactive PDF ¨ Use UN Toolkit to create CEPT Form D as Interactive PDF form ¨ Map Interactive PDF to UNe. Docs CEPT Form D XML Schema ¨ Apply digital signatures to UNe. Docs CEPT Form D

Video Clip: ASEAN CEPT Form D mapping to UNe. Docs Data Model

Video Clip: PDF Interactive for the POC

Cross Border Trade - today Country of Export Country of Import … … F FO OR RM M Exchange of individual documents • Requires physical transport of documents • Documents issued in Country of Export • . . must match requirements of Country of Import (COI) • • electronic documents need to match COI technical specs What happens if one document is missing?

Cross Border Trade- tomorrow? Country of Export Country of Import Exchange based on Reference Data Model • Advance exchange of information • One time submission of all data BOL Invoice Co. O • Documents generated in Country of Import (COI) XML XML • COI can determine which documents are required • COI can determine formats of documents and automation • Both countries have a stable base to invest in automation Regional Cross Border Data Model Invoice BOL F O R M BOL Invoice F O R M Co. O F O R M

THANK YOU