Setup for Standard Values

The FE Workforce Collection fields use certain codes dictated by its specification. These codes will be different to the IDs Databridge uses to identify items you have setup in Standard Values e.g. Ethnicity, Contract Types.

In order to ensure any changes made to the collection you are preparing for export can be both loaded from a Staff record in as much detail as possible and saved back to the Staff record effectively, you should set the relevant codes from the FE Workforce Collection specification accordingly.

Locating the Specification

In order to locate the relevant codes used by the specification, please navigate to the following URL: 

https://www.gov.uk/government/publications/further-education-workforce-data-collection.

From here you can open the latest specification and find the relevant item and code you are looking for.

For example, if using the URL above we open the specification PDF (located at the top of the page when writing this article), we can look through the contents and click on Ethnicity to be taken to the relevant page where it lists the available options and code.

Updating Standard Values

Using Ethnicity as an example still, navigate to Administration -> Standard Values in the left hand navigation menu. Under General Values, click on Ethnicity.

Click on the edit icon to open any values details, for example clicking for a value called 'Indian', to open the Ethnicity values in a modal.

Looking at the specification as described above, enter the relevant code in the Census Code field. For example, if 'Indian' was our Standard Value item, we would enter 39.

Continue to update the values you use in Standard Values according to the codes in the specification.

There are a few areas that need to be updated with a code from the specification: