Workforce Management Information - Department For Work And Pensions

unnamed_0 Unnamed: 0	unnamed_1 Unnamed: 1	unnamed_2 Unnamed: 2	admin_officers_admin_assistants Admin Officers/admin Assistants	unnamed_4 Unnamed: 4	executive_officers Executive Officers	unnamed_6 Unnamed: 6	higher_executive_officers_senior_executive_officers Higher Executive Officers/Senior Executive Officers	unnamed_8 Unnamed: 8	grade_6_7 Grade 6/7	unnamed_10 Unnamed: 10	senior_civil_service Senior Civil Service	unnamed_12 Unnamed: 12	other_unknown_or_unspecified Other, Unknown, Or Unspecified	unnamed_14 Unnamed: 14	total_employees Total Employees	unnamed_16 Unnamed: 16	agency_staff_clerical_admin Agency Staff (clerical/admin)	unnamed_18 Unnamed: 18	interim_managers Interim Managers	unnamed_20 Unnamed: 20	specialist_contractors Specialist Contractors	unnamed_22 Unnamed: 22	consultants_consultancy Consultants/consultancy	unnamed_24 Unnamed: 24	total Total	unnamed_26 Unnamed: 26	unnamed_27 Unnamed: 27	unnamed_28 Unnamed: 28	salary Salary	allowances Allowances	non_consolidated_performance_payments Non-consolidated Performance Payments	overtime Overtime	employer_pension_contributions Employer Pension Contributions	employer_national_insurance_contributions Employer National Insurance Contributions	total_paybill_for_payroll_staff Total Paybill For Payroll Staff	total_cost_of_contingent_labour_agency_clerical_and_ad_841da9c8 Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors	total_cost_of_consultants_consultancy Total Cost Of Consultants/ Consultancy	total_non_payroll_ccl_staff_costs Total Non-payroll (CCL) Staff Costs	unnamed_39 Unnamed: 39
			Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent	Headcount	Full-time equivalent
Department for Work and Pensions	Ministerial Department	Department for Work and Pensions	28,912	24,396.31	37,173	32,867.72	9,586	9,039.87	2,537	2,432.67	210	204.75	.	.	78,418	68,941.32	.	.	491	491.00	.	.	.	.	491	491.00	78,909	69,432.32	œ156,105,400.83	œ2,030,013.21	œ548,803.73	œ3,869,564.63	œ42,134,426.96	œ14,385,244.02	œ219,073,453.38	œ7,796,639.58	œ44,183.50	œ7,840,823.08	œ226,914,276.46
Health and Safety Executive	Crown Non Departmental Public Body	Department for Work and Pensions	311	269.93	379	346.11	1,330	1,257.24	455	434.45	27	26.60	.	.	2,502	2,334.33	4	4.00	28	28.00	.	.	.	.	32	32.00	2,534	2,366.33	œ8,359,491.60	œ145,136.47	œ0.00	œ8,596.93	œ2,297,102.28	œ963,629.42	œ11,773,956.70	œ262,334.23	œ0.00	œ262,334.23	œ12,036,290.93
The Pensions Regulator	Executive Non-Departmental Public Body	Department for Work and Pensions	.	.	.	.	.	.	.	.	.	.	726	705.00	726	705.00	49	47.00	.	.	.	.	6	5.00	55	52.00	781	757.00	œ2,914,258.71	œ0.00	œ94,875.00	œ18,132.85	œ824,250.97	œ346,715.58	œ4,198,233.11	œ770,270.39	œ156,309.30	œ926,579.69	œ5,124,812.80
Money and Pensions Service	Executive Non-Departmental Public Body	Department for Work and Pensions	.	.	.	.	.	.	.	.	.	.	331	318.20	331	318.20	37	34.80	5	5.00	.	.	.	.	42	39.80	373	358.00	œ1,361,551.21	œ45,653.77	œ0.00	œ751.45	œ162,338.50	œ160,924.78	œ1,731,219.71	œ571,825.12	œ0.00	œ571,825.12	œ2,303,044.83


CREATE TABLE february_2020 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "admin_officers_admin_assistants" VARCHAR,
  "unnamed_4" VARCHAR,
  "executive_officers" VARCHAR,
  "unnamed_6" VARCHAR,
  "higher_executive_officers_senior_executive_officers" VARCHAR,
  "unnamed_8" VARCHAR,
  "grade_6_7" VARCHAR,
  "unnamed_10" VARCHAR,
  "senior_civil_service" VARCHAR,
  "unnamed_12" VARCHAR,
  "other_unknown_or_unspecified" VARCHAR,
  "unnamed_14" VARCHAR,
  "total_employees" VARCHAR,
  "unnamed_16" VARCHAR,
  "agency_staff_clerical_admin" VARCHAR,
  "unnamed_18" VARCHAR,
  "interim_managers" VARCHAR,
  "unnamed_20" VARCHAR,
  "specialist_contractors" VARCHAR,
  "unnamed_22" VARCHAR,
  "consultants_consultancy" VARCHAR,
  "unnamed_24" VARCHAR,
  "total" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "salary" VARCHAR,
  "allowances" VARCHAR,
  "non_consolidated_performance_payments" VARCHAR,
  "overtime" VARCHAR,
  "employer_pension_contributions" VARCHAR,
  "employer_national_insurance_contributions" VARCHAR,
  "total_paybill_for_payroll_staff" VARCHAR,
  "total_cost_of_contingent_labour_agency_clerical_and_ad_841da9c8" VARCHAR,
  "total_cost_of_consultants_consultancy" VARCHAR,
  "total_non_payroll_ccl_staff_costs" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR
);