Workforce Management Information - Ministry Of Defence January To December 2017
Ministry of Defence
@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593
Ministry of Defence
@ukgov.workforce_management_information_ministry_of_defence_j_b3c11593
CREATE TABLE mod_s_workforce_management_information_april_2017 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"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_full_time_equivalent" DOUBLE,
"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_full_tim_093c8891" BIGINT,
"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_full_time_equivalent" DOUBLE,
"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_consultants_consultancy" BIGINT,
"non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
"comments" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_august_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_december_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_july_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_june_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_may_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_november_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_october_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE mod_s_workforce_management_information_september_2017 (
"please_read_the_additional_fields_descriptions_before__64a3292c" VARCHAR,
"unnamed_1" VARCHAR,
"unnamed_2" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"unnamed_16" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" VARCHAR,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" VARCHAR,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" VARCHAR
);
CREATE TABLE workforce_management_information_ministry_of_defence_j_b3c11593 (
"organisation_name" VARCHAR,
"organisation_type" VARCHAR,
"main_parent_or_sponsoring_department" VARCHAR,
"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_full_time_equivalent" DOUBLE,
"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_full_tim_093c8891" DOUBLE,
"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_full_time_equivalent" DOUBLE,
"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_consultants_consultancy" BIGINT,
"non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
"grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.