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 procurement information
Minor version | Date | Description |
---|---|---|
1.00 | 19/12/2014 | Formal release following consultation |
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 contracting organisation (Local Authority)
A unique code to identify the contracting organisation. For LAs this can be the URI from Open Data Communities.
|
![]()
Contract Reference number / ID
![]() |
![]()
This should be the OJEU contract ID, unless the contract is below the OJEU threshold, whereby the councils own ID should be used
|
Open Contracting ID
![]() |
Open Contracting ID
|
![]()
Title of the Agreement
![]() |
![]()
Name of contract being awarded as per definition in original tender.
|
Contract type
![]() |
The contract type specifies whether a contract is a single award contract, multiple award contract, framework agreement, dynamic purchasing system, grant agreement or other.
|
![]()
Local authority directorate/service responsible
![]() |
![]()
Name of the department, directorate or service incurring the expenditure
|
Service category
![]() Represents the highest level to which costs are charged. Enables aggregation and comparison of data between spending organisations
|
CIPFA SerCOP objective category label
CIPFA SerCOP objective category URI from ODC
|
![]()
Description of goods and services
![]() |
![]()
Statement of what is covered by the contract e.g. services being provided to whom, by whom and where
|
Procurement classification
![]() General headings that describe the nature of the contract, for example, Adult social care staff
|
Local procurement category code used to identify goods and services purchased
A description of the Common Procurement Vocabulary category of spend
CPV code used to identify the goods and services purchased
A description of the Proclass category of goods and services purchased
Proclass code used to identify the category of goods and services purchased
|
![]()
Start, end and review dates
![]() |
![]()
Date the contract commenced
![]()
Date the contract is due to end
![]()
Date the contract is due to be reviewed (if any)
|
Extension Period
![]() |
Last date to which the contract could optionally be extended
|
![]()
Contract value
![]() |
![]()
Actual value or estimated annual value of the contract award / framework
|
Fixed cost / estimated cost
![]() |
Whether the cost is estimated or a fixed cost
|
![]()
Irrecoverable VAT
![]() |
![]()
Amount of VAT which is not recoverable
|
![]()
Supplier name and details
![]() Information about the supplier organisation
|
![]()
The full name of the supplier
Registered Companies House number of supplier
![]()
Registered charity number of supplier
The local authority?s own reference for the supplier or other ID
|
![]()
SME supplier
![]() |
![]()
Is the supplier an SME or not?
|
![]()
VCSE supplier
![]() |
![]()
Is the supplier is a voluntary or community sector body?
|
VCSE supplier type
![]() |
VCSE supplier disaggregated by voluntary and community sector category
|
Supplier nominated contact details
![]() Contact information for a nominated contact in the supplier organisation who can deal with queries
|
Name of nominated contact ito respond to queries in supplier organisation
email address of nominated contact in supplier organisation
URL for supplier organisation
|
![]()
Tender type
![]() |
![]()
Whether the contract resulted from a request for quotation or a published invitation to tender
|
Original tender document
![]() |
URL for the original tender document
|
Contract document URL
![]() |
URL for the original contract document
|
Performance information URL
![]() |
A URL to further information about the contact including performance against key indicators
|
Location served
![]() Details of the geographical coverage of contracts entered into by the authority
|
Nmae of predefined spatial area such as ward or neighbourhood
URI of administrative area, ward or neighbourhood
|
Selection has been saved