ETrading Standards

1
E-Trading Standards

• Noel Hunter
• Project Executive

2
Welcome

• Launch of a major new tool for the new agenda
• Part of new e-Government initiative
• Provides an easier way of sharing raw data to
  provide joined up working by TS and others

3
E-Trading Standards

• eTSN provides the tools for the new challenges
  ahead for Trading Standards
• Improved access to basic data
• Ability to analyse data
• Combined with a modern information sharing
  facility

4
E-Trading Standards

• Sir Peter Gershon
• Effective strategy,evidence-based policy and
  focused inspection regulation are critical to
  driving up performance in public services

5
E-Trading Standards

• Phillip Hampton
• Efficient enforcement can support compliance
  across the whole range of businesses, delivering
  targeted, effective interventions without
  unreasonable administrative costs

6
Retail Enforcement Project/DTI

• Work streams
• Information/process efficiency (new ways of
  working)
• Scoping operational collaboration/risk management
• Resolving conflicting enforcement advice
• Mapping business information requirements
• eTSN/PARSOL/Consumer Direct

7
Benefits

• Access to information on wider basis than local
  authority
• Links with Consumer Direct
• Intelligence is captured and held for the benefit
  of the service
• Aid to service planning intelligence led and
  risk based enforcement
• Can make decision-making quicker speedier
  protection for consumers
• Web-based access remote and out of hours

8
Benefits

• Much larger pool of data to search adding
  parameters will allow fine tuning of searches.
• Remote access via secure log in system
• Instant access to information (overnight
  upload)
• Feels different will be second nature to anyone
  familiar with the web.
• Information is captured for all to see
• Has an Email alert system
• First step likely to evolve as we reap the
  benefits and learn how to use the shared data.

9

• Further Information www.localegovnp.org/etsn

10
E-Trading Standards

• Richard Brooks
• Project Leader

11
e-TSN - Background

• Project idea came from Trading Standards service
• Funding to develop through ODPM e-government
  agenda
• Developed with large number of partners and
  stakeholders
• Consumer Direct happening in parallel

12
e-TSN - background

• One of 22 ODPM National Projects
• By Local Authorities for Local Authorities
• National Strategy
• IEG / BVPI Reporting
• Priority Service Outcomes

13
E-TSN Aims and Deliverables

• Design and deliver technical infrastructure for
  information sharing
• Develop and test a process for data clean up
• Licensing and self-assessment products
  -http//www.wandsworth.gov.uk/selfassessment/
• Electronic Service Delivery Standards
• Produce toolkits to assist implementation
• Work with Consumer Direct

14
Trading Standards National Database
15
What is shared?

• Automatic
• Visits
• Prosecutions
• Samples
• Complaints
• Recalls/Rapex
• Manual
• Intelligence
• Bulletin boards

16
(No Transcript)
17
Where are we now?

• Data clean up now completed in all 6 partner
  authorities
• Data clean-up toolkit now available
• A number of LAs have done data clean-up
• Pilot system testing taking place
• Next steps to work with information and reporting
• Adapters now being fitted
• Licensing and self assessment products completed

18
Current members

• Nottingham City
• Oxfordshire
• Wandsworth
• Warwickshire
• West Sussex
• Worcestershire

19
Early Adopters

• EMCOTS
• Derby City
• Derbyshire
• Leicester City
• Leicestershire
• Lincolnshire
• Northamptonshire
• Nottingham City
• Nottinghamshire
• Rutland

20
Early Adopters

• East Riding
• Croydon
• Sefton
• Kingston
• Swindon

21
Early Adopters phase 2

• Brent
• Cornwall
• Hackney
• Tower Hamlets

22
Any Questions?
23
(No Transcript)
24
Data Clean Up

• Keith Bean
• West Sussex CC

25
Why clean data ?

• Low quality data - reinforced by independent
  research
• Need to improve data quality and integrity
• Facilitating interoperability, exchange and
  sharing of data

26
Why clean data ?

• Other than e-TSN
• Data Protection
• Freedom of Information
• Local Data Exchange Protocols
• Government targets Hampton and Gershon

27
What is data cleaning ?

• For ETSN data cleaning is taken to be a range of
  processes to improve the integrity of data
• Matching
• De-duplicating
• Purging
• Enhancement
• Provision of additional data

28
What data are we cleaning within ETSN project?

• Business/company name
• Business Address
• Postcode

29
What additional data are we providing?

• Number of employees (total and site)
• Turnover
• SIC code and description
• Registration number
• Parent company
• Ultimate parent company
• Premises type
• UPRN
• Unique ID codes for subsequent cleaning

30
Methodology

• Automated/Bureau data cleaning
• Data selection from back office systems
• Export to Experian Intact
• Data cleaned
• Data returned in bespoke report
• Additional data provided
• Manual checking and verification
• Experian report used for manual checking and
  verification
• Accept verified data
• Make changes
• Additional data accepted
• Import into back office system

31
Advantages

• Bespoke solution from Experian
• Use of their data sources
• Report back in Excel
• Several views of matched data
• Data manipulation

32
Cost

• Automated/bureau
• Per thousand records - 250
• Manual process
• Cost of administrative and specialist staff help
  in the manual processes
• Manual checking and verification of data approx
  0.50 per record depending on depth of research
• Management of process

33
Next Steps

• Additional data
• Database management keeping it accurate and up
  to date
• Data Standards

34
Any Questions?
35

• Further Information www.localegovnp.org/etsn