skip to main content

Variable Guide

Staff in Post data extraction and exclusions

Staff in Post data are extracted from The Child and Adolescent Mental Health Service Workforce Database on the second Tuesday of every month for census date as the staff in post as at the last day of the previous month.

The following lists the conditions for this data to be reported in the NHSScotland Workforce publication.

A person must be in an active post and not working on a Bank contract type:

  • Start date is less than or equal to [census date]
  • End date is greater than or equal to [census date] OR is NULL
  • Conditioned hours is greater than 0
  • Contract Types included are: Permanent Job Share, Permanent, Permanent Secondment, Fixed Term, Fixed Term Job Share, Fixed Term/Temporary, FixedTerm Secondment.

Variables reported

The table below illustrate some of the key staff in post information published in the NHSScotland CAMHS  publication and how they are derived from the main data source, The Child and Adolescent Mental Health Service Workforce Database.

Variables

How this is derived 

Data Source

Exclusions made

Whole Time Equivalent (WTE)

Calculated from Contracted Hours and F/T Conditioned Hours.

WTE = (Contracted Hours)/(F/T Conditioned Hours). 

The Child and Adolescent Mental Health Service Workforce Database.

If WTE is less than 0.0

Headcount

Derived from National Insurance Nos.

generated by The Child and Adolescent Mental Health Service Workforce Database.

 

Gender

From Gender- Male/Female

The Child and Adolescent Mental Health Service Workforce Database.

 

Whole-Time or Part-Time

Derived from Contracted hours is less than F/T Conditioned Hours

The Child and Adolescent Mental Health Service Workforce Database.

 

Age

Is calculated from Date of Birth and is grouped into 5 year age groups for publication

The Child and Adolescent Mental Health Service Workforce Database.

 

AfC band

Derived from Grade

The Child and Adolescent Mental Health Service Workforce Database.

 

Professional Group

Derived from ProfessionalGroup

The Child and Adolescent Mental Health Service Workforce Database

 

Grade

Derived from Grade as AfC Band or Grade (for Medical Professional Group)

The Child and Adolescent Mental Health Service Workforce Database

 

NHS Board

Derived from Health Board codes

The Child and Adolescent Mental Health Service Workforce Database

 

Region

Derived from Health Board codes. Regions are North, East, West.

The Child and Adolescent Mental Health Service Workforce Database

 

0-18 year population

Derived from the current year’s population estimates for 0-18 year olds

NRS (National Records of Scotland)

 

Total Population

Derived from the current year’s population estimates for total population

NRS (National Records of Scotland)