About this Dataset

FSA Workforce Managment Information

Monthly information on staff numbers and paybill costs in the FSA, both payroll and non-payroll including consultants. Split between full-time equivalents (FTE) and headcount and mapped to standard Civil Service grades. Costs are broken down by salaries, allowances and contributions, or costs for consultancy.
Publisher name: Food Standards Agency
Last updated: 2024-10-22T04:01:10Z

Tables

FSA Workforce Information May 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_may_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_may_2019 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" DOUBLE,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information May 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_may_2020

38.7 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_may_2020 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" DOUBLE,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" DOUBLE,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" DOUBLE,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" DOUBLE,
  "non_payrollstafftotalcostofconsultants_consultancy" DOUBLE,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" DOUBLE,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information May 2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_may_2021

38.69 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_may_2021 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" BIGINT,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" DOUBLE,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" DOUBLE,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" DOUBLE,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information November 2014 To November 2017

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_november_2014_to_november_2017

46.02 KB
37 rows
42 columns


CREATE TABLE fsa_workforce_information_november_2014_to_november_2017 (
  "date" TIMESTAMP,
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" DOUBLE,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" DOUBLE,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" DOUBLE,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" DOUBLE,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" DOUBLE,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" DOUBLE,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information November 2018

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_november_2018

38.64 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_november_2018 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" BIGINT,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" BIGINT,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" BIGINT,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" BIGINT,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" BIGINT,
  "payrollstaffcostsallowances" BIGINT,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" BIGINT,
  "payrollstaffcostsemployerpensioncontributions" BIGINT,
  "payrollstaffcostsemployernationalisureancecontributions" BIGINT,
  "payrollstaffcoststotalpaybillforpayrollstaff" BIGINT,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" BIGINT,
  "comments" VARCHAR
);

FSA Workforce Information November 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_november_2019

38.69 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_november_2019 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" DOUBLE,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" DOUBLE,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information November 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_november_2020

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_november_2020 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" BIGINT,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" DOUBLE,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information October 2018

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_october_2018

38.64 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_october_2018 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" BIGINT,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" BIGINT,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" BIGINT,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" BIGINT,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" BIGINT,
  "payrollstaffcostsallowances" BIGINT,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" BIGINT,
  "payrollstaffcostsemployerpensioncontributions" BIGINT,
  "payrollstaffcostsemployernationalisureancecontributions" BIGINT,
  "payrollstaffcoststotalpaybillforpayrollstaff" BIGINT,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" BIGINT,
  "comments" VARCHAR
);

FSA Workforce Information October 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_october_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_october_2019 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" DOUBLE,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" BIGINT,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information September 2018

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_september_2018

38.64 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_september_2018 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" BIGINT,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" BIGINT,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" BIGINT,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" BIGINT,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" BIGINT,
  "payrollstaffcostsallowances" BIGINT,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" BIGINT,
  "payrollstaffcostsemployerpensioncontributions" BIGINT,
  "payrollstaffcostsemployernationalisureancecontributions" BIGINT,
  "payrollstaffcoststotalpaybillforpayrollstaff" BIGINT,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" BIGINT,
  "comments" VARCHAR
);

FSA Workforce Information September 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_september_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_september_2019 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" DOUBLE,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" BIGINT,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information September 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_september_2020

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_september_2020 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" BIGINT,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" DOUBLE,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Managment Information

@ukgov.fsa_workforce_managment_information.fsa_workforce_managment_information

38.66 KB
1 row
41 columns


CREATE TABLE fsa_workforce_managment_information (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" BIGINT,
  "payrollstaffao_aafull_timeequivalent" BIGINT,
  "payrollstaffeoheadcount" BIGINT,
  "payrollstaffeofull_timeequivalent" BIGINT,
  "payrollstaffseo_heoheadcount" BIGINT,
  "payrollstaffseo_heofull_timeequivalent" BIGINT,
  "payrollsatffgrade6_7headcount" BIGINT,
  "payrollstaffgrade6_7full_timeequivalent" BIGINT,
  "payrollstaffscsheadcount" BIGINT,
  "payrollstaffscsfull_timeequivalent" BIGINT,
  "payrollstaffotherunknownorunspecifiedheadcount" BIGINT,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" BIGINT,
  "payrollstafftotalemployessheadcount" BIGINT,
  "payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "non_payrollstaffagencystaff_clerical_admin_headcount" BIGINT,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" BIGINT,
  "non_payrollstaffinterimmanagersheadcount" BIGINT,
  "non_payrollstaffinterimmanagersfull_timeequivalent" BIGINT,
  "non_payrollstaffspecialistcontractorsheadcount" BIGINT,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" BIGINT,
  "non_payrollstaffconsultants_consultancyheadcount" BIGINT,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" BIGINT,
  "non_payrollstafftotalemployeesheadcount" BIGINT,
  "non_payrollstafftotalemployeesfull_timeequivalent" BIGINT,
  "grandtotal_workforcenumbers_headcount" BIGINT,
  "grandtotal_workforcenumbers_full_timeequivalent" BIGINT,
  "payrollstaffcostssalary" DOUBLE,
  "payrollstaffcostsallowances" DOUBLE,
  "payrollstaffcostsnon_consolidatedperformancepayments" BIGINT,
  "payrollstaffcostsovertime" DOUBLE,
  "payrollstaffcostsemployerpensioncontributions" DOUBLE,
  "payrollstaffcostsemployernationalisureancecontributions" DOUBLE,
  "payrollstaffcoststotalpaybillforpayrollstaff" DOUBLE,
  "non_payrollstafftotalcostofcontingentlabour_agency_cle_8e4643e3" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);