C.8.3 Preliminary RAS processes Generating the pay and hours – ‘targets’ The basic data are taken from the ONS website which publishes headline figures for all the main totals (by region, industry, occupation, etc.). An initial step is needed to ensure the targets for industry, occupation and qualification are themselves consistent. This requires a scaling of the three sets of wage bill targets (average wage * employment), by industry, by 2 or 4-digit occupations and by qualifications, to match the overall wage bill for all categories (and analogously for total hours worked (hours * employment). For this purpose employment is based on the estimates. Working Futures It also is necessary to fill some of the gaps in the more detailed breaks used as ‘targets’. These targets (for wage bills or total hours) can be generated as follows (the example shown is for wage bill and wage/pay rates): Wage rate for the industry (or occupation) * regional differential * gender/status differential) * relevant employment number, where: Regional (r) differential = wage rate (r)/wage rate for all regions; Gender (g)/status (s) differential = wage rate (g/s)/wage rate for all gender status categories. Note that if employment is zero the wage bill (or total hours) will therefore be zero. In the main LMI for All database estimates of pay are generated for full-time and part-time employees separately. The estimates cover just a single year (currently 2013). Within the database, weekly pay (excluding overtime) * employment for the following dimensions (focusing on industry) are included: Overall total (all gender-status, all industries, UK); Totals for 4 gender-status (all industries, UK); Totals for males and females separately (all industries, UK); Totals by 12 regions (all gender-status, all industries); Totals by 75 industries (all gender-status, UK); Industry (75) by region (11) by gender-status (4). The same output is repeated for hours worked. For occupations, there are the following outputs for total hours worked: Overall total (all gender-status, all occupations, UK); Totals for 4 gender-status (all occupations, UK); Totals for males and females separately (occupations, UK); Totals by 12 regions (all gender-status, all occupations);
C.8.3 Preliminary RAS processes – Generating the pay and hours ‘targets’ The basic data are taken from the ONS website which publishes headline figures for all the main totals (by region, industry, occupation, etc.). An initial step is needed to ensure the targets for industry, occupation and qualification are themselves consistent. This requires a scaling of the three sets of wage bill targets (average wage * employment), by industry, by 2 or 4-digit occupations and by qualifications, to match the overall wage bill for all categories (and analogously for total hours worked (hours * employment). For this purpose employment is based on the Working Futures estimates. It also is necessary to fill some of the gaps in the more detailed breaks used as ‘targets’. These targets (for wage bills or total hours) can be generated as follows (the example shown is for wage bill and wage/pay rates): Wage rate for the industry (or occupation) * regional differential * gender/status differential) * relevant employment number, where: Regional (r) differential = wage rate (r)/wage rate for all regions; Gender (g)/status (s) differential = wage rate (g/s)/wage rate for all gender status categories. Note that if employment is zero the wage bill (or total hours) will therefore be zero. In the main LMI for All database estimates of pay are generated for full-time and part-time employees separately. The estimates cover just a single year (currently 2013). Within the database, weekly pay (excluding overtime) * employment for the following dimensions (focusing on industry) are included: Overall total (all gender-status, all industries, UK); Totals for 4 gender-status (all industries, UK); Totals for males and females separately (all industries, UK); Totals by 12 regions (all gender-status, all industries); Totals by 75 industries (all gender-status, UK); Industry (75) by region (11) by gender-status (4). The same output is repeated for hours worked. For occupations, there are the following outputs for total hours worked: Overall total (all gender-status, all occupations, UK); Totals for 4 gender-status (all occupations, UK); Totals for males and females separately (occupations, UK); Totals by 12 regions (all gender-status, all occupations);