Appendix G: Edit specification
|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
|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
if C6 is more than 3 times greater than A1 if A1 is between 5 and 49
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.
There is a problem
Thanks for your feedback