Regional stop smoking service database pre implementation update cumbria and lancashire
1 / 34

Regional Stop Smoking Service Database Pre-Implementation Update Cumbria and Lancashire - PowerPoint PPT Presentation

  • Uploaded on

Regional Stop Smoking Service Database Pre-Implementation Update Cumbria and Lancashire. Tina Williams Performance Improvement and Delivery Manager October 2010. Smoke Free North West.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about ' Regional Stop Smoking Service Database Pre-Implementation Update Cumbria and Lancashire ' - astra

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Regional stop smoking service database pre implementation update cumbria and lancashire

Regional Stop Smoking Service DatabasePre-Implementation UpdateCumbria and Lancashire

Tina Williams

Performance Improvement and Delivery Manager

October 2010

Smoke free north west
Smoke Free North West

  • Smokefree North West manages the NHS collaborative programme to work towards a tobacco-free future for everyone in the North West.

  • Jointly funded by all 24 NHS Primary Care Trusts (PCTs) within the region

  • Chaired by Julie Webster (who replaced Dr Janet Atherton). The team, led by Director Andrea Crossfield, is based in Manchester and hosted by Sefton Primary Care Trust

  • The Smokefree North West team works in partnership with the four sub-regional Tobacco Alliances across Cheshire & Merseyside, Cumbria, Greater Manchester and Lancashire and the three sub-regional Public Health Networks.

    • Together, we support local tobacco control activity and the implementation of regional and national tobacco control plans at a local level

Lsss activity what s required
LSSS Activity – what’s required?

  • Local Stop Smoking Service (LSSS) performance is currently assessed against targets

  • These targets are based on local smoking prevalence and previous performance:

    • Public Service Agreements (PSA)

    • SHA Delivery Plans

    • NHS Operating Framework

    • Local Area Agreements

Lsss data what s required
LSSS data – what’s required?

  • LSSS must currently collect data related to service activity

    • The number of smokers accessing the service

    • 4-week quit rates

    • CO monitoring outcomes

    • Socioeconomic status

  • Submit a quarterly Monitoring Report to the NHS Information Centre

Lsss activity what s required1
LSSS Activity – what’s required?

  • More importantly - Services need to maintain effective relationships with their clients to:

    • Provide a locally valued service

    • Manage treatment

    • Track progress

    • Maintain client motivation

    • Prevent relapse

    • Enable those who relapse to re-engage

      ‘Manage Customer Relationships’

Activity 2009 10
Activity 2009 / 10

  • Regional Target – 57,126 quitters

  • Regional Outcome - 57,850 smokers quit

  • Success…

Activity 2009 101
Activity 2009/10

  • Regionally 17 / 24 LSSS achieved their outcome targets

  • In Cumbria and Lancashire 3 of 6 LSSS achieved against targets

What s the problem
What’s the problem?

  • Despite our successes many LSSS struggle to collect, manage and report on accurate Local Stop Smoking Service (LSSS) activity

    • 21% of those who set a quit date were lost to follow-up

    • 20% were un-coded against socioeconomic status

    • Regionally 7 x services failed to meet their annual outcome target for the year

What s the problem1
What’s the Problem?

  • Few of the data collection systems currently in place allow for a real-time view of activity either locally or regionally

    • This prevents the early identification of problems, at either local or regional level and the implementation of timely, considered, appropriate remedial action

    • And many services find it difficult to effectively manage customer relationships and maintain low cost, regular, effective contact with their client group

Regional lsss data where are we now
Regional LSSS data - where are we now?

  • A variety of systems are in place - few are paperless

  • Many LSSSs report difficulties with their existing systems

  • Many are cumbersome, time consuming – and therefore costly

  • Inefficiencies lead to

    • Inaccurate or incomplete data

    • Under-reporting of outcomes

    • Increased lost to follow-up

    • Difficulty in meeting targets

    • Poor customer relationship management

  • Experienced, highly qualified and therefore expensive staff are frequently drawn away from client activity to contribute to reporting activity

  • Difficult to track clients effectively

  • Difficult to re-establish contact with those who have accessed the service in the past

Lsss data where are we now
LSSS data - where are we now?

  • Monitoring the details and progress of smokers accessing level 2 services across the full range settings e.g. Pharmacies, Children’s Centres etc, is undertaken manually in the majority of cases:

    • Increasing workload for participating healthcare professionals – leading to reluctance to participate

    • Further increased risk of under-reporting, lost to follow-ups, and the difficulties in reaching targets

    • Leading to the breakdown of valuable relationships with both L2 providers and their clients


Lsss data what s the solution
LSSS data - what’s the solution?

  • Modernisation of the infra-structure through the provision of a web-based, unified system for the collection, monitoring and reporting of LSSS activity at local and regional level is the key to:

    • The successful future development and progression of stop smoking services

    • The quality of the clients experience

    • The meeting of smoking cessation targets

    • Effective performance management

    • Effective relationship management and client retention


The evidence
The Evidence

“The old database didn’t help us monitor clients over time or our effectiveness. The new web-based system enables our administrative and specialist staff to know what each client had received and when. It is making it possible for the PCT to manage the service actively and evaluate every aspect of what we do,”

Director of Public Health

South Birmingham PCT

How will this be funded
How will this be funded?

  • Before discussing the funding it is important to recognise that some PCTs already have a database which delivers to the required Core Standard which they will wish to continue using therefore:

    Two funding options are available

Proposal option 1
Proposal - Option 1

  • SFNW will provide £5K of funding per PCT to enable them to work with the appointed provider to install the core database

  • Participating PCTs agree to:

    • Match fund £5K for the installation

      • For Cumbria and Lancashire this cost will be covered by the Tobacco Alliance

      • Funding at this level available for

        • Cumbria, North, East & West Lancs and BBwD

    • Pay £5K maintenance contract from year 2

    • if they choose to continue the contract

Proposal option 2
Proposal - Option 2

  • SFNW will provide a £5K funding per PCT to:

    • Enable work to be undertaken with the chosen provider to link an existing comparable database to the new Regional Database

    • Funding at this level available for Blackpool

      • Who already have a web-based system supplied by N51

Progress to date
Progress to date

  • Board level agreement

  • DPH agreement – Frank Atherton for C&L

  • Funding secured

  • Regional Steering Group establishes

    • Representation from all sub-regions

  • Scoping of requirement

    • Identification of core functionality

  • Development of Service Level Agreement

  • Procurement

  • The Provider – AN Computing

  • The Contract

    • SLA

    • Economies of scale

  • Regional Roll-out

    • Completed in Greater Manchester

  • Next Steps

    • Cheshire and Merseyside implementation currently in progress

    • Development of Regional / Sub-regional reporting arm in progress

Scoping the requirement
Scoping the Requirement

  • Review of provision by leading web-based providers in the field

  • Discussion with services who currently have web-based systems

    • Identification of required core functionality

      • Identification of need

      • Identification of essential functions

      • Identification of gaps

Development of the sla

Core Data Set

NHS Standards

Gold Standard Monitoring

The Client Journey

Maintaining Client Contact


Mail merge

Mass text

Reminders to advisors

Monitoring and Reporting

Gold Standard Monitoring

Local Reports


Specific - locally created

Export of data to Excel

Users and Access

Locally managed

Access levels

Password setting

No limit on the number of users


Train the Trainer x 1day

End user x 1day

Import of existing data

From 1st April 2010 only

Lead and Referral Management

Development of the Sub and Regional Reporting Arms

Implementation management and support to PCTs


Software License Fees

Project Management

Help Desk Support

Development of the SLA


  • Competitive Quotation Process

  • The three identified leading providers were invited to submit a proposal and quotation

  • Interview panel – 8 x members of the Steering Group

  • Applicants assessed and marked against 40 criteria

  • Financial Assessment – by Heart of Mersey Partnerships

  • Information Governance Assessment – by Sefton PCT

  • Appointment of provider:

    • Lead scorer

      • Proven track record

      • The solution – user friendly

      • Ability to supply to the required SLA

      • Competitive quote – matched to budget

The provider
The Provider

  • AN Computing

  • Unanimous choice of the panel

  • Outstanding solution

    • ‘Quit with Us’

  • History

    • National NHS Systems for Infection Control

    • Creators of the FagEnds Smoking Cessation Database

The contract
The Contract

  • Held by SFNW

  • Standard NHS Contract

    • SLA

      • Standard - provides all core requirements

      • Not negotiable at PCT level

  • One-year duration

    • Based on the ‘go live’ date for each PCT

  • Renewal after year one – local decision

The contract1
The Contract

  • Market Value per individual PCT = £20k

  • Cost negotiated (economy of scale) = £10k

  • Additional funding secured to enable N3 hosting if required

  • Cost per PCT – year one

    • No financial contribution required

Post year 1 recurring costs
Post Year 1 – Recurring Costs

  • Hosting Fees

  • Help desk support

  • Changes and fixes

  • 1 core upgrade

    Total £5k per annum

    Payable by individual PCTs

    Local contract arrangements

Regional roll out
Regional Roll-Out

  • Phase 1 began in Greater Manchester – May 2010

    • 10 PCTs

    • 3 with pre-existing web-based databases

    • Implementation within 7 x PCTs

    • Completion date – 31.10.10

  • Phase 2 Cheshire and Merseyside – current

    • Completion 31.12.10

  • Regional and Sub-Regional Reporting Structure currently under development

  • Phase 3 – Cumbria and Lancashire

    • Completion March 2011

Getting the groundwork right
Getting the groundwork right

  • Each PCT to establish an ‘Implementation Group’ to provide:

    • Liaison with AN Computing and the Sub-Regional Tobacco Control Lead (Fay Watson)

    • Lead and support the implementation process

    • Facilitate communication within the PCT and across the LSSS

    • Provide high level technical expertise

      • IT

      • Information Governance

      • Smoking cessation expertise

Getting the groundwork right1
Getting the groundwork right

  • Suggested Implementation Group Membership:

    • LSSS Co-ordinator / Manager

    • LSSS Commissioner

    • LSS Administrator

    • IT Representative

    • Information Governance Representative

Getting the groundwork right2
Getting the groundwork right

  • Before the installation process begins AN Computing will meet with the PCT Implementation Group

  • This will enable:

    • Fact finding

    • Planning

    • Communication


  • Time to decide…

Faq s

  • Can PCTs negotiate additional functionalities as part of the current contract / SLA?

    • No the contract and SLA agreement provide a fixed solution at a very competitive price and is therefore non-negotiable

  • Can PCTs negotiate additional functionalities under a separate independent contract?

    • Yes – but costs will be incurred locally and the any additional work negotiated locally must not delay the regional roll-out timetable

  • Would PCT-A have access to / or the option to view PCT-B’s data?

    No – each PCT database stands alone and access is controlled by that PCT.

  • Would a level 2 service provider, for example a pharmacist, be able to view the data of other provider’s clients e.g. the specialist service?

    No – access is controlled at PCT level

Faq s1

  • Will members of the public health intelligence teams be able to down load and interrogate the data at will?

    Yes, the solution provides a facility to enable designated users to download data into an Excel spreadsheet for local purposes

  • What is the likely cost of additional training, beyond that which is offered as part of the proposed package?

    The average cost of training of this type is £450 per-day for a maximum of 14 participants. PCTs would negotiate this locally with the provider.

    However as the standard SLA provides for the training of trainers it is unlikely that additional training would be necessary

Faq s2

  • Will it be possible to audit success rates for different pharmacotherapy’s against age gender or other criteria - to be able to identify the most appropriate products based on local data?

    Yes, this function is provided as part of the reporting suite

  • Will Commissioners, whose role it is to performance manage the service, have access to the database for this purpose

    Yes , each individual PCT would control who is able to access the system and at what level. This would be a decision taken locally.

  • Will it be possible for a smoking cessation web-based data base to interface with other NHS systems such as those used in GP Practices?

    Technically yes – but this would require further development and additional locally incurred cost.

Faq s3

  • An extensive list of additional FAQ’s has been provided within the ‘Implementation Pack’