If you are viewing this website through The National Archives it may be necessary to copy and paste external links directly into your browser.

What's New in Tools

Child Health Profiles 2016 - PDF reports

15 March 2016
These popular profiles provide a snapshot of child health and wellbeing for each local authority in England using key health indicators.

Health behaviours in young people

15 March 2016
Our Health Behaviours in Young People Tool gives an insight into healthy lifestyles and risky behaviours. Two-page summaries available for each local authority.

Teenage Parent Outcomes Modelling Tool

24 February 2016
This new tool for teenage pregnancy leads in local authorities brings together data and evidence about factors that affect outcomes for teenage parents and their babies. It allows you to model the potential impact of local services on outcomes in your area.

Child Health Clinical Indicator Summaries

17 December 2015
These summaries present children and young people’s health and healthcare data for each of the 12 strategic clinical network (SCN) areas to help identify priorities, benchmark and track progress and outcomes.

Mental health in pregnancy, the postnatal period and babies and toddlers: needs assessment report

9 December 2015
Our new needs assessment report brings together data and evidence on mental health in pregnancy, the postnatal period and babies and toddlers. Available for local authorities and CCGs.

Continence in children

5 October 2015
We’ve updated our Needs Assessment Report about continence in children and young people with the latest data for local authorities and CCGs. This is one of a series of popular reports which help you undertake local needs assessments as part of children’s and young people’s planning and joint strategic needs assessments.

NHS Atlas of Variation in Healthcare 2015

21 September 2015
We bring together over 60 indicators relating to the care of mothers, babies, children and young people to support the NHS Atlas of Variation in Healthcare in highlighting and tackling unwarranted variation in healthcare and health outcomes.

Comprehensive CAMHS Integrated Workforce Planning Tool

Back to About the tool

This tool helps you produce your Comprehensive CAMHS Integrated Workforce Plan.

It provides a workforce planning template which guides you through the stages of integrated workforce planning in order to successfully complete your own plan. The data workbook, training modules and audit tools support you to engage partners and gain their input and advice as an integral part in the planning process, collect and analyse data and build capacity and capability to workforce plan amongst provider and commissioner organisations.

Find out more about the Comprehensive Integrated Workforce Planning Tool in About the tool.

Follow the stages below to complete your workforce plan.

How to use the template

Before using the tool, read the user guidance for helpful tips on completing the workforce planning template.

We recommend you carry out a self assessment of workforce planning capacity before beginning the workforce planning process and repeat this when you have completed it.

We have developed a self assessment questionnaire – workforce planning capacity and knowledge to help you do this. See training modules below.


Start building the workforce plan

The workforce planning template is your step-by-step guide through the stages of integrated workforce planning.

Download the template and save it to your own computer.


Use data to support the development of your plan

The data workbook is a microsoft excel spreadsheet which provides the data you need to complete the workforce planning template. It enables you to:

  • Choose your local authority areas to include in the tables
  • Select the health and social care provider to include in the tables
  • Produce charts and graphs to compare teams and services along with regional and national benchmarks
  • Add your own data to pre-designed data worksheets to create local charts and graphs

Download the spreadsheet to your computer and save it with the template.

To use the workbook, you must select 'Save File' to save it to your computer and click on 'enable macros'. For help using macros, see below.

Excel 2003:

For quicker download, the modelling tool is available in zip format.

Collect current local data to inform your plan

The Children's Services Mapping team have produced a tool to assist services in collecting 'Presenting problems' information. The Mapping team will no longer collect this information on a national level. Locally services may wish to collect new data which can be compared and thematically analysed with previous years' benchmarked data available in the data workbook.

This data collection tool is for use in part 3 of the template.


Engage partners and build skills using the training modules

The training modules are designed to help with practical tasks in the planning process.

For use in part 1.5 of the template:

The self assessment questionnaire helps you identify needs for further experience, education or learning opportunities to build your capability to workforce plan. We recommend you carry out the self assessment at the beginning and end of your workforce planning process.


Audit the skills and knowledge of the workforce

An integral part of workforce planning and development is the identification and analysis of what skills and knowledge the workforce has in order to meet the psychological well-being and mental health needs of children and young people.

The Self Assessed Skills Audit Tool (SASAT- CoRE) will significantly support your Partnership in gathering and mapping the skills in the workforce to assist you in your application to be a CYP IAPT site.

The individual, team and service profiles will assist your Partnership in the production of a training needs analysis, mapping presenting clinical need with skill sets, identifying current and potential gaps. The information generated will support you to respond flexibly to the opportunity of the education and training offered in the evidence based therapies and ultimately support service transformation.

These tools are for use in part 3.5 of the template.

Example reports of skills audits carried out by the pilot sites using SASAT-CoRE are available below.


Learn from the integrated workforce planning pilot sites

Seven pilot sites across England tested the Integrated Workforce Planning Tool. Download and learn from their completed plans and skills audits..

Example CAMHS integrated workforce plans:

Example skills audit reports using the Self Assessed Skills Audit Tool (SASAT-CoRE):


View a model workforce plan

We have produced a model comprehensive CAMHS integrated workforce plan to demonstrate how the workforce planning template can be populated to provide an evidence base for decision making about the comprehensive CAMHS workforce in a typical setting.


Help with macros

Each time you open the Excel files, a pop-up box may ask you to choose a 'macro' setting. Select 'enable macros' to ensure you are able to navigate around the toolkit. If you are still experiencing problems with the Excel files, your security settings may be too high. Before you download the files, re-set your security settings as follows:

  1. Open Excel
  2. Go to the 'Tools' menu
  3. Select the 'Macros' option
  4. Select 'Security'
  5. Select the 'Medium' option
  6. Click the 'OK' button.


The Comprehensive CAMHS Integrated Workforce Planning Tool is one of several integrated initiatives within the former National CAMHS Workforce Programme. For more information about this tool or its use, contact Barry Nixon at barry.nixon@cmecic.org.

ChiMat Disclaimer

The data in the Comprehensive CAMHS Integrated Workforce Planning Tool is published with the permission of Children's Services Mapping. It is final or provisional data, as published by Children's Services Mapping under its standard procedure. ChiMat has only presented the data in a user-friendly format. ChiMat accepts no responsibility for how readers and users of this toolkit interpret the data and information. ChiMat accepts no responsibility for the onward communication and transmission of the data.


Validates against XHTML 1.0  Cascading Style Sheet compliance  Single A Accessibility compliance