The validator lets you select which fields you are using to meet optional and mandatory requirements in your datasets.
When you have picked the fields, you can generate documentation and a template CSV file.
You can also validate a CSV dataset.
The schema guidance document provides more details.
Pick a schema
LGA suggested format to comply with DCLG Transparency Code requirement on local authorities to publish data on organisation structure
| Minor version | Date | Description |
|---|---|---|
| 2.00 | 09/08/2016 | Salary band changed to string |
Validate your CSV against the schema
Pick the fields that you wish to validate against below, then validate your file.
| Requirement | Field |
|---|---|
|
Organisation
 |
Label of the organisation the structure describes
A unique code to identify the organisation the structure describes. For LAs this can be the URI from Open Data Communities.
|
|
Applicable date
 |
Date at which the information provided is true
|
|
Level
|
Level of grade within the organisation. Used to distinguish levels and enable comparison between organisations
|
Job title
|
Job title of the individual holding the position
|
|
Job number
|
Job number of the post to uniquely identify the post within the organisation
|
|
Name
|
Name of the individual. Only required for senior officers with a salary in excess of £150,000
|
|
Grade
|
The individuals pay grade
|
|
Local authority department and team
|
To identify the directorate/department
within the local authority to which the employee
belongs in the organisation structure
To identify the service area within the local authority to which the employee belongs
|
|
Type of contract
|
To indicate the type of contract based on standard contract categories such as permanent, temporary, fixed term etc.:
|
|
Shared post
|
To indicate if the post is shared with another organisation
|
|
Contact details
|
e-mail address or telephone number of the individual. This can be a generic e-mail if the employee does
not need to be named.
|
|
Salary band
|
Salary in £5000 brackets based on FTE
|
|
Salary ceiling
|
The maximum salary for the grade
|
|
Vacancy
|
Indicates whether the post is currently vacant
|
Selection has been saved
