About this Dataset

Workforce Management Information - Ministry Of Defence January To December 2017

Ministry of Defence (MOD) publishes details about headcount and payroll costs for permanent staff and contractors on a monthly basis. These figures are not official statistics. They are internal workforce management information published in the interests of transparency.
Publisher name: Ministry of Defence
Last updated: 2024-09-14T15:11:30Z

Tables

MOD's Workforce Management Information: April 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_april_2017

42.07 kB
8 rows
41 columns

CREATE TABLE mod_s_workforce_management_information_april_2017 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" BIGINT,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" BIGINT,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" DOUBLE,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" BIGINT,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);

MOD's Workforce Management Information: August 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_august_2017

31.57 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_august_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MOD's Workforce Management Information: December 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_december_2017

31.3 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_december_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MOD's Workforce Management Information: July 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_july_2017

31.48 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_july_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MOD's Workforce Management Information: June 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_june_2017

31.28 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_june_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MOD's Workforce Management Information: May 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_may_2017

31.41 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_may_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MOD's Workforce Management Information: November 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_november_2017

31.23 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_november_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MOD's Workforce Management Information: October 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_october_2017

31.33 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_october_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

MOD's Workforce Management Information: September 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.mod_s_workforce_management_information_september_2017

31.31 kB
49 rows
42 columns

CREATE TABLE mod_s_workforce_management_information_september_2017 (
  "please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR  -- Please Read The Additional Data Fields Descriptions Before Entering Information Into This Template. Completed Templates Must Be Returned To Your Organisation's Main, Parent Or Sponsoring Department. They Will Provide One Return To Cabinet Office Capturing Information For All Their Relevant Organisations. (NB: This Data Sheet Is Password Protected. Contact Cabinet Office If You Require The Password.,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41
);

Workforce Management Information - Ministry Of Defence January To December 2017

@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593.workforce_management_information_ministry_of_defence_j_b3c11593

42.69 kB
8 rows
41 columns

CREATE TABLE workforce_management_information_ministry_of_defence_j_b3c11593 (
  "organisation_name" VARCHAR,
  "organisation_type" VARCHAR,
  "main_parent_or_sponsoring_department" VARCHAR  -- Main, Parent Or Sponsoring Department,
  "payroll_staff_ao_aa_headcount" BIGINT,
  "payroll_staff_ao_aa_full_time_equivalent" DOUBLE,
  "payroll_staff_eo_headcount" BIGINT,
  "payroll_staff_eo_full_time_equivalent" DOUBLE,
  "payroll_staff_seo_heo_headcount" BIGINT,
  "payroll_staff_seo_heo_full_time_equivalent" DOUBLE,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" DOUBLE,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" BIGINT  -- Payroll Staff Other, Unknown Or Unspecified Headcount,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" DOUBLE  -- Payroll Staff Other, Unknown Or Unspecified Full-time Equivalent,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "non_payroll_staff_agency_staff_clerical_admin_headcount" BIGINT  -- Non-payroll Staff Agency Staff (clerical/admin) Headcount,
  "non_payroll_staff_agency_staff_clerical_admin_full_tim_093c8891" DOUBLE  -- Non-payroll Staff Agency Staff (clerical/admin) Full-time Equivalent,
  "non_payroll_staff_intermin_managers_headcount" BIGINT,
  "non_payroll_staff_interim_managers_full_time_equivalent" BIGINT,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" DOUBLE,
  "non_payroll_staff_consultants_consultancy_headcount" BIGINT,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" DOUBLE,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" DOUBLE,
  "grand_total_workforce_numbers_headcount" BIGINT  -- Grand Total (workforce Numbers) Headcount,
  "grand_total_workforce_numbers_full_time_equivalent" DOUBLE  -- Grand Total (workforce Numbers) Full-time Equivalent,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" BIGINT,
  "payroll_staff_costs_overtime" DOUBLE,
  "payroll_staff_costs_employer_pension_contributions" DOUBLE,
  "payroll_staff_costs_employer_national_insurance_contributions" DOUBLE,
  "payroll_staff_costs_total_paybill_for_payroll_staff" DOUBLE,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE  -- Non-payroll Staff Total Cost Of Contingent Labour: Agency (clerical And Admin) Staff, Interim Managers And Specialist Contractors,
  "non_payroll_staff_total_cost_of_consultants_consultancy" BIGINT,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE  -- Non-payroll Staff Total Non-payroll (CCL) Staff Costs,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE  -- Grand Total Paybill/staffing (payroll And Non-payroll) Costs,
  "comments" VARCHAR
);