Baselight
Sign In

Crown Prosecution Service Workforce Management Information

Crown Prosecution Service

@ukgov.https_www_cps_gov_uk_publication_expenditure_data

Loading...
Loading...

About this Dataset

Crown Prosecution Service Workforce Management Information

This data shows staff numbers for the CPS (both payroll and non-payroll staff) expressed in Full Time Equivalents by Civil Service Grade in addition to payroll costs during the relevant periods.
Publisher name: Crown Prosecution Service
Last updated: 2022-11-11T04:04:07Z

Tables

Cps Monthly Workforce Management Information 2018-19 February

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2018_19_february
  • 39.21 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2018_19_february (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-april

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_april
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_april (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-august

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_august
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_august (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-december

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_december
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_december (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-february

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_february
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_february (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-january

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_january
  • 39.33 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_january (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-july

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_july
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_july (
  "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" BIGINT,
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" BIGINT,
  "non_payroll_staff_total_cost_of_contingent_labour_agen_c060a235" DOUBLE,
  "non_payroll_staff_total_cost_of_consultants_consultancy" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

Cps-monthly-workforce-management-information-2019-20-june

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_june
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_june (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-march

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_march
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_march (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS Monthly Workforce Management Information 2019-20 May

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_may
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_may (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-november

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_november
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_november (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-october

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_october
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_october (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2019-20-september

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2019_20_september
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2019_20_september (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-april

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_april
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_april (
  "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" BIGINT,
  "payroll_staff_grade_6_7_headcount" BIGINT,
  "payroll_staff_grade_6_7_full_time_equivalent" BIGINT,
  "payroll_staff_scs_headcount" BIGINT,
  "payroll_staff_scs_full_time_equivalent" DOUBLE,
  "payroll_staff_other_unknown_or_unspecified_headcount" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-august

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_august
  • 39.33 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_august (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

Cps-monthly-workforce-management-information-2020-21-december

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_december
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_december (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

Cps-monthly-workforce-management-information-2020-21-february

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_february
  • 39.21 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_february (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

Cps-monthly-workforce-management-information-2020-21-january

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_january
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_january (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-july

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_july
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_july (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-june

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_june
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_june (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

Cps-monthly-workforce-management-information-2020-21-march

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_march
  • 39.21 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_march (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-may

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_may
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_may (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-november

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_november
  • 39.41 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_november (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-october

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_october
  • 39.21 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_october (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

CPS-monthly-workforce-management-information-2020-21-september

@ukgov.https_www_cps_gov_uk_publication_expenditure_data.cps_monthly_workforce_management_information_2020_21_september
  • 39.07 KB
  • 1 row
  • 41 columns
Loading... 

CREATE TABLE cps_monthly_workforce_management_information_2020_21_september (
  "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" VARCHAR,
  "payroll_staff_other_unknown_or_unspecified_full_time_equivalent" VARCHAR,
  "payroll_staff_total_employees_headcount" BIGINT,
  "payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "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" VARCHAR,
  "non_payroll_staff_interim_managers_full_time_equivalent" VARCHAR,
  "non_payroll_staff_specialist_contractors_headcount" BIGINT,
  "non_payroll_staff_specialist_contractors_full_time_equivalent" BIGINT,
  "non_payroll_staff_consultants_consultancy_headcount" VARCHAR,
  "non_payroll_staff_consultants_consultancy_full_time_equivalent" VARCHAR,
  "non_payroll_staff_total_employees_headcount" BIGINT,
  "non_payroll_staff_total_employees_full_time_equivalent" BIGINT,
  "grand_total_workforce_numbers_headcount" BIGINT,
  "grand_total_workforce_numbers_full_time_equivalent" BIGINT,
  "payroll_staff_costs_salary" DOUBLE,
  "payroll_staff_costs_allowances" DOUBLE,
  "payroll_staff_costs_non_consolidated_performance_payments" VARCHAR,
  "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" VARCHAR,
  "non_payroll_staff_total_non_payroll_ccl_staff_costs" DOUBLE,
  "grand_total_paybill_staffing_payroll_and_non_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

Share link

Anyone who has the link will be able to view this.