Data Harmonization IPT Kickoff

1
Data Harmonization IPT Kick-off

• February 9, 2005
• V1.0

Unrestricted Use
2
Agenda

• Objectives
• Data Harmonization Process
• Works Sessions Schedule, Process,
  Responsibilities
• Next Steps
• Supplemental Information
• Contact Information
• Terminology and Acronyms

3
Objectives

• By the end of this presentation, you should
  understand
• The overall process by which Data Harmonization
  will be accomplished
• Purpose of one-on-one meetings with ITDS Data
  Architects
• Which work sessions your Agency should
  participate in
• The approach planned for the work sessions,
  including your Agencys responsibilities

4
Application Requirements Interaction
5
ACE/ITDS Requirements Relationship

• Process Assessment
• Business Process Templates
• Business Process Diagrams

Data Element Questionnaire
6
Focus of Data Harmonization is on Updating the
Standard Data Set from PGAs Data Element
Questionnaires
Data Element Questionnaire
Standard Data Set (SDS)
7
ACE/ITDS Data Harmonization

• Data Harmonization is the iterative process of
• capturing,
• defining,
• analyzing, and
• reconciling the information into a standardized
  format required by PGAs that will use ACE/ITDS
• This superset of all required/desired data and
  their associated definitions is called the
  ACE/ITDS Standard Data Set (SDS)

Agency Data Elements

• The Data Harmonization Integrated Process Team
  (DH IPT) task is the shaded area i.e. using all
  PGA Data Element Questionnaires to create the
  next version of SDS.

8
Data Harmonization Process Diagram
9
Data Harmonization Process Description

• PGAs capture their Data Elements producing their
  Agency Data Element Questionnaire mapped to the
  Standard Data Set (SDS)
• ITDS Data Architects (ITDS DAs)
• Cluster the Data Elements of all PGAs into
  categories
• Identify Similar Data Elements
• PGA SMEs and ITDS DAs Attend Data Harmonization
  IPT (DH IPT) Kick-off
• ITDS DAs visit PGAs to
• Validate Maintenance SDS model
• Clarify PGA Data Elements for Harmonization
• Conduct DH IPT Work Sessions in which PGA SMEs
  and ITDS DAs collaboratively
• Evaluate Candidate Data Elements
• Recommend New SDS Elements
• Update SDS to new version
• Map new version of SDS to eCP Logical Data Model
  (LDM)
• Map new version of SDS to World Customs
  Organization (WCO) Model
• Map new version of SDS to Multi-Modal Manifest
  (MMM) Model
• Produce SDS Reports
• Review mappings and SDS Reports
• ITDS Board approves new version of the SDS

10
UN Trade Data Elements Directory (UNTDED) Data
Element Groupings

• Group 1 Documentation, references (0001-1699)
• Data elements intended for data handling or
  documentation purposes, such as those required to
  service the interchange of user data, document
  and message names, references and reference
  numbers, ordinal numbers such as item and page
  numbers, number of copies of documents.
• Group 2 Dates, times, periods of time
  (2000-2799)
• All expressions of time, such as calendar dates,
  periods of time (month, week, day), time limits,
  commencement and expiry dates.
• Group 3 Parties, addresses, places, countries
  (3000-3799)
• Names and addresses of legal and physical
  persons, designations of officials,
  organizational units, places, countries, routes.
• Group 4 Clauses, conditions, terms, instructions
  (4000-4799)
• Authentications, authorizations, endorsements,
  certifications, clauses, conditions, terms,
  reference clauses, stamps, labels, requests,
  instructions, receipts, statements, information
  text.
• Group 5 Amounts, charges, percentages
  (5000-5799)
• Financial values, amounts, charges other
  quantities and values for commercial, transport,
  Customs, statistical and any other purposes
  other details, such as prices, rates, percentages
  and discounts, used as a basis for invoice
  calculations, etc..
• Group 6 Measures, identifiers, quantities (other
  than monetary) (6000-6799)
• Dimensions, weights, volumes, distances,
  temperature, currency, other quantities, with the
  exception of monetary quantities in Group 5,
  measure unit specifies.
• Group 7 Goods and articles descriptions and
  identifiers (7000-7799)
• Descriptions, classifications and identifications
  of goods and articles, consignment identifiers,
  number and kind of packages, dangerous goods
  details.
• Group 8 Transport modes and means, containers
  (8000-8799)
• Identification and description of means of
  transport and containers, transport equipment
  details, transport modes and movements, voyage
  and flight numbers.
• Group 9 Other data elements (Customs, etc.)
  (9000-9799)
• Data elements not belonging to any other specific
  categories 1 8.

11
Work Session Schedule

• Feb 09 Kick-off
• (PGA one-on-one meetings 2/10-2/18)
• Feb 22 Locations and Parties (Group 3)
• Feb 23 Transportation Modes and Containers
  (Group 8) AND Measures, Identifiers and
  Quantities (Group 6)
• March 1 Amounts, Charges and Percents (Group 5)
• March 2 Dates and Periods of Time (Group 2)
• March 8 Descriptions, Identifiers and
  Classifications (Group 7) AND LPC and
  Authentications (Group 4)
• March 10 Tracking Number and References (Group
  1) AND Other Data Elements (Group 9)
• March 15 17 Clean-up address Export data
  elements from all WCO Groups, if time permits
• All sessions held at
• 1-4 pm, Room 350, Sandler Travis Offices
• Ronald Reagan Building (Pennsylvania Avenue
  Entrance)

12
Assumptions for Data Harmonization

• Only data elements from PGAs who have completed
  one-on-one meetings by 2/18 can be considered for
  this round of Data Harmonization
• Maintenance version of SDS will be used as the
  baseline
• Scope of new version of SDS will include
• All Release 5 data elements
• Multi-Modal Manifest (MMM) data elements
• Data elements used for both import and export
• Export only data elements, if time permits
• All SDS candidates not included in new version of
  SDS remain as candidates for next Data
  Harmonization beginning May 2005

13
Purpose of PGA one-on-one meetings with ITDS Data
Architects

• Verify that the Agencys Data Element
  Questionnaire is properly mapped to the
  maintenance SDS model
• Validate the pre-grouped clusters of similar PGA
  data elements
• Assure Agency Data Elements are aligned with
  correct WCO data element groups
• Confirm Data Elements are correctly mapped to the
  Business Process Areas
• Manage Accounts
• Manage Release Validate the timing assumptions
  for data elements
• Pre-arrival
• Arrival
• Manage Post Release
• Manage Export
• Manage Finance

14
Process for Work Sessions on each WCO Data
Element Grouping

• Summarize decisions made on action items from
  previous work session, if any
• Present the list of SDS Data Candidates in UNTDED
  data element group(s) for this work session in
  seven subgroups
• Pre-arrival
• Arrival
• Post-release
• Accounts
• Export (subgroup will be addressed in separate
  session, if time permits)
• Finance
• Miscellaneous
• Each subgroup (except Export) is assigned a time
  segment in the agenda, based on the number and
  complexity of the data elements in the subgroup
• An ITDS DA will facilitate a discussion to
  recommend
• SDS candidates to be combined, including updating
  descriptions
• SDS candidates to be added to the new version of
  the SDS
• Unresolved candidates or other issues by the end
  of the time segment will be assigned as action
  items to be worked on between work sessions

15
Example of SDS Candidates in WCO Groups
16
Example of WCO Group of SDS Candidates in
Subgroups
17
ITDS Responsibilities

• Assign all current, maintenance, and candidate
  SDS data elements to
• WCO Groups
• Business Area and time related sub groups
• Map Agency Data Elements to new SDS
• Facilitate works session including managing time
  allotted for each subgroup
• Follow-up on action items between work sessions
• Map new version of SDS to
• eCP Logical Data Model (LDM)
• WCO Model
• MMM Model
• Present recommendations to ITDS Board for approval

18
PGA Responsibilities

• Confirm assignments of Agency Data Elements to
• WCO Groups
• Business Area and time related sub groups
• Attend and participate in works sessions for WCO
  Groups in which you have candidate data elements
• Work on action items after a work session to
  complete unresolved issues

19
Objectives How did we do?

• By the end of this presentation, you should
  understand
• The overall process by which Data Harmonization
  will be accomplished
• Purpose of one-on-one meetings with ITDS Data
  Architects
• Which work sessions your Agency should
  participate in
• The approach planned for the work sessions,
  including your Agencys responsibilities

20
Next Steps
21
Next Steps ITDS DAs

• Complete PGA one-on-one meetings 2/10-2/18
• Conduct Work Sessions 2/22-3/17
• Finalize new version of SDS 3/18 to 3/24
• Prepare for peer and ITDS Board reviews 3/25 to
  3/31
• Complete all mappings and reviews 4/1 to 4/5

22
Next Steps PGAs

• Select or confirm work sessions you plan to
  attend
• email Mike Compeau at MCompeau_at_strtrade.com
• If not yet scheduled, contact your Agency Liaison
  to schedule your Agency one-on-one meeting with
  ITDS DAs listed below
• AMS, APHIS, CBP, EPA, FDA, FSIS, FWS Janet
  Wetter 703 336-4437 Janet.Wetter_at_associates.dhs.go
  v
• BTS, Census, FMCSA, ITA-FTZB, ITA-IA, ITC, MARAD,
  NHTSA, TSA, USACE Alan Briggs 703 336-4441
  Alan.Briggs_at_associates.dhs.gov
• ATF, BLS, FAA, FCC, FMC, OFAC Parul Patel 703
  336-4438 Parul.Desai_at_associates.dhs.gov

23
Questions?

• ?

24
Contact Information
25
eCP/ITDS Key Contacts
26
Terminology
27
Terminology

• Agency Liaison eCP person assigned to a
  specific Agency. Your main point of contact for
  interaction with the ACE/ITDS program
• Business Process A grouping of meaningful
  activities, which when executed from beginning to
  end, provide business value to the organization
  or Agency
• Data Harmonization the process of generating a
  Standard Data Set (SDS) that contains the
  superset of all required/desired data elements
  per Agency that are then mapped to the ACE/ITDS
  data models
• Entry Summary the final statement of duties,
  taxes and fees owed, currently submitted on CF
  7501 form
• International Trade Data System (ITDS) former
  pilot system whose goal is/was to consolidate
  International Trade functionality, providing a
  single filing window for the trade to submit
  information. Functionality is now being folded
  into the ACE/ITDS system
• Metadata - data about data. Examples of metadata
  are definition, type (numeric, date etc.),
  length, access to data (roles)
• Metadata Repository - A place to store metadata
  to facilitate the analysis of information assets.
  The basis for designing and creating an
  effective Data Warehouse as well as the means to
  access the contents of a Data Warehouse.
• Standard Data Set (SDS) the superset of all
  required/desired data elements for an Agency
• Subject Matter Expert (SME) a representative of
  an Agency containing the requisite knowledge,
  clearance and authority to advocate an Agencys
  needs and requirements on the ACE/ITDS program

28
Alphabet Soup Acronyms

• ABI Automated Broker Interface
• ACE Automated Commercial Environment
• ACE/ITDS Realization of ITDS requirements and
  vision within the ACE/ITDS system
• ACS Automated Commercial System
• AES Automated Export System
• AMS Automated Manifest System
• IASS Import Activity Summary Statement
• AOOR ACE/ITDS Overview of Releases
• ARR Agency Readiness Review
• ATRR Agency Test Readiness Review
• ATS Automated Targeting System
• BPA Business Process Analysis
• BPR Business Process Re-Engineering also
  Business Process Redesign
• CBP Customs and Border Protection
• CBPMO Customs and Border Protection
  Modernization Office
• CCIE Cargo, Conveyances, Individuals (Crew) and
  Associated Equipment
• CDR Critical Design Review
• ConOps Concept of Operations
• DH IPT Data Harmonization Integrated Process
  Team

29
Alphabet Soup Acronyms (contd)

• ITDS International Trade Data System
• ITDS DA International Trade Data System Data
  Architect
• LDM Logical Data Models
• MMM Multi-Modal Manifest
• MOU Memorandum Of Understanding
• MOA Memorandum Of Agreement
• OMB 300 Office of Management and Budget document
  required to obtain capital funding
• PAT Process Analysis Teams
• PDCR Program Definition Completion Review
• PDR Program Definition Review
• PGA Participating Government Agency
• PIRA Project Initiation Review Assessment
• PRR Production Readiness Review
• RAM Release Allocation Matrix
• RSS Requirements Specification Set mid-level
  business and technical ACE/ITDS requirements (RSS
  Level)
• RTM Requirements Traceability Management
  product by Integrated Chipware
• ST Screening and Targeting
• SAP Systems, Application, and Products the
  Enterprise Application for ACE/ITDS Releases 5-7
• SAT System Acceptance Test