Scottish Employer Skills Survey 2020: Technical Report

Technical report for the Scottish Employer Skills Survey 2020.


Appendix G: Edit specification

Table 13: Specification of edits applied to the data
Edit number Objective of edit Condition Force/actions
1 Check that all SICs given at A7 are valid SIC07 codes If A6 = 2 Any records where A6=2 will need to have the SIC at A7 validated. Recode where possible, recontact if necessary.
2 To ensure that all SOC codes are valid at C7
(4 DIGITS)
If SOC at C7 is not in full SOC file provided Recode where possible, recontact if necessary. Coding to 1 or 2 digit SOC is acceptable if there is not sufficient information, although this should only be the case for a small minority of records (i.e. less than 1%).
For any records that are entirely uncodable, use four zeros "0000."
3 To check that public sector ('local or central government financed body') definition given at SA8 is consistent with SIC code If SA8 is '3' or '4' and first two digits of SIC are not '84', '85' or ''86' Each record to be judged on an individual basis by company name and activity.
4 To check legitimacy of high numbers of employment If A1 is greater than 1500 Each record to be judged on an individual basis. Call-backs may be necessary if number of employees seems excessively high for business activity.
5 To check legitimacy of high numbers of vacancies in relation to size of establishment If C6 is more than 5 times greater than A1 if A1 < 5
or
if C6 is more than 3 times greater than A1 if A1 is between 5 and 49
or
if C6 is more than 1.5 times greater than A1 if A1 ≥ 50
Call-backs usually necessary to confirm high numbers of vacancies.
6 To investigate establishments where all employees have been allocated to one occupational group If only one of D5, D6, D8_1-7 / D5C_1-9 is greater than 0 and A1 is more than 10 Each record to be judged on an individual basis. Call-backs may be necessary.
7 To check high values of individual occupational groups If D5 / D5C_1 (managers) is greater than 50 or
If D8_7 / D5C_9 (professionals) is greater than 100 or
If D8_6 / D5C_8 (associate prof/technical) is greater than 100 or
If D6 / D5C_2 (admin/clerical) is greater than 100 or
If D8_5 / D5C_7 (skilled trades) is greater than 100 or
If D8_4 / D5C_6 (caring/leisure) is greater than 100 or
If D8_3 / D5C_5 (sales/customer service) is greater than 100 or
If D8_2 / D5C_4 (machine operatives) is greater than 100 or
If D8_1 / D5C_3 (elementary) is greater than 100
Each record to be judged on an individual basis. Call-backs may be necessary.
8 To check high values of underemployed (both qualifications and skills) staff If D15a is greater than half of the sum of D9 (number of proficient employees) and SA1>5 Each record to be judged on an individual basis. Call-backs may be necessary.
9 To ensure all postcodes given by respondents are valid If postcode=2 Check that postcode is valid and given in full. Invalid postcodes will need to be investigated as each record must have a full valid postcode in the final data file.
10 To sense check establishments with a high proportion of EU, non-UK staff If A1 > 10 and (D1b = A1) [i.e., all staff are EU, non-UK citizens]

Or if A1 > 10 and D1bran=6 ("all of them")
Each record to be judged on an individual basis. Consider whether it seems plausible that no staff would be UK citizens.
Call-backs may be necessary.

Contact

Email: FHEstatistics@gov.scot

Back to top