| SWISS Variables | Filters and Restrictions applied |
| Start date | less than or equal to [census date] |
| Date left | greater than or equal to [census date] OR is NULL |
| Contract-type description | equal to Permanent Job Share, Permanent, Permanent Secondment, Fixed Term, Fixed Term Job Share, Fixed Term/Temporary, FixedTerm Secondment, or Honorary (medical staff only) |
| FT conditioned hours | is greater than 0 |
| National statistics variable | How this is derived from SWISS | Data Source | Exclusions made |
| Whole Time Equivalent |
Calculated from Contracted Hours and F/T Conditioned Hours. WTE = (Contracted Hours)/(F/T Conditioned Hours). Honorary contracts are amended to 0.6WTE |
Payroll |
If WTE is less than 0.0 - bank staff with 0.33 or 0.25 contracted hours (non medical only) |
| Headcount | Takes out double counting by using National Staff ID | generated by SWISS | |
| Gender | From Gender - Male/Female | Payroll | |
| Whole or part time | Derived from Contracted hours is less than F/T Conditioned Hours | Payroll | |
| Age | Is calculated from Date of Birth and is grouped into 5 year age groups for publication | Payroll | |
| AfC band | Derived from the fourth character of the Main Detail Code | Payroll | |
| Job Family | Derived from Job Sub Family for AfC staff, and from Scale for non AfC staff. | Payroll | |
| Sub Job Family | From Job Sub Family and if this is blank then is matched on from Main Detail Code for AfC staff, and from Scale for non AfC staff | Payroll | |
| Location of service delivery |
Comes from Service Delivery Location and is grouped for publication. If nothing recorded then Other. |
HR |
|
| Grade |
Comes from Medical Grade (HR) and if this is blank is matched on from Grade (Payroll). Grade is grouped for publication. |
HR or Payroll | If no Medical grade is recorded and a match cannot be made using Grade (likely as it is a free text variable) |
| Specialty |
Comes from Specialty and is grouped for publication. Staff with no specialty recorded are grouped into Not Known Medical Specialty or Not Known Dental Specialty depending on whether they have a GMC or GDC registration. |
Payroll |
|
| Country of Qualification | Comes from Country Obtained and is grouped for publication on the Medical Trend table into Scotland, Other UK / UK unspec, Other EEA Countries, Rest of world or Unspecified | HR | |
| NHS Board | Derived from Employer Code. | Payroll | |
| Region | Derived from Employer Code. Regions are North, East, West, and National Bodies and Special Health Boards. | Payroll | |
| Clinical Nurse Specialist | Identified using the CNS Indicator Y/N | HR | |
| CNS Specialty | Comes from Specialist Area | HR |
| Other SWISS variables | Use |
| Registration number | Used as a unique identification for dentists when SWISS data is merged with the General Dental Service data |
| Registration body | Used alongside the grade information to determine whether they are a dentist or a medic |
Exclusions made
1. Detail codes
2. NES specific requested exclusions, based on pay groups
3. Payscale exclusions
4. Medical and dental staff with no medical grade recorded, and cannot be matched using the grade
5. Board specific medical exclusions (for Borders, Greater Glasgow and Clyde and NHS National Services Scotland only)*
6. Board specific non-medical exclusions (for Ayrshire and Arran only)*
*under review