Back to Recent Schemas

Schema Information

https://raw.githubusercontent.com/datagovuk/schemas/master/organogram/organogram-junior-staff-csv-schema.json

Download schema

Fields

Index Column Heading Required Unique Type Value Constraints Title/Description
1 Parent Department Yes No String Name of the central government department that oversees the organisation (or if the organisation is a department, just name it again here).
2 Organisation Yes No String The department or agency for whom the role(s) is for. Not abbreviated.
3 Unit Yes No String Where the organisation's staff are split into functional units (or teams/sections etc), give the name of the unit.
4 Reporting Senior Post Yes No String The 'post unique reference' of the post in the Senior Staff that this one reports to (directly or indirectly). Cannot be blank.
5 Grade Yes No String Grade of role.
6 Payscale Minimum (£) Yes No Integer Lowest annual pay for this grade, according to the payscale.
7 Payscale Maximum (£) Yes No Integer Highest annual pay for this grade, according to the payscale.
8 Generic Job Title Yes No String
9 Number of Posts in FTE Yes No Float Number of Full Time Equivalents in this role. If this is one full time post then put '1'. Part time roles are a decimal fraction with 2 decimal places.
10 Professional/Occupational Group Yes No String The professional/occupational group relates to the post and not the person. Select the professional/occupational group that best describes the teams' function. This list has been taken from the professional skills for government and at present there are no plans to amend/add to the list. The titles are very generic and should cover the scope of roles within government.
Download Example CSV File