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 April 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_april_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_april_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 April 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_april_2020

38.77 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_april_2020 (
  "organisationname" VARCHAR,
  "organisationtype" VARCHAR,
  "mainparentorsponsoringdepartment" VARCHAR,
  "payrollstaffao_aaheadcount" DOUBLE,
  "payrollstaffao_aafull_timeequivalent" DOUBLE,
  "payrollstaffeoheadcount" DOUBLE,
  "payrollstaffeofull_timeequivalent" DOUBLE,
  "payrollstaffseo_heoheadcount" DOUBLE,
  "payrollstaffseo_heofull_timeequivalent" DOUBLE,
  "payrollsatffgrade6_7headcount" DOUBLE,
  "payrollstaffgrade6_7full_timeequivalent" DOUBLE,
  "payrollstaffscsheadcount" DOUBLE,
  "payrollstaffscsfull_timeequivalent" DOUBLE,
  "payrollstaffotherunknownorunspecifiedheadcount" DOUBLE,
  "payrollstaffotherunknownorunspecifiedfull_timeequivalent" DOUBLE,
  "payrollstafftotalemployessheadcount" DOUBLE,
  "payrollstafftotalemployeesfull_timeequivalent" DOUBLE,
  "non_payrollstaffagencystaff_clerical_admin_headcount" DOUBLE,
  "non_payrollsatffagencystaff_clerical_admin_full_timeequivalent" DOUBLE,
  "non_payrollstaffinterimmanagersheadcount" DOUBLE,
  "non_payrollstaffinterimmanagersfull_timeequivalent" DOUBLE,
  "non_payrollstaffspecialistcontractorsheadcount" DOUBLE,
  "non_payrollstaffspecialistcontractorsfull_timeequivalent" DOUBLE,
  "non_payrollstaffconsultants_consultancyheadcount" DOUBLE,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" DOUBLE,
  "non_payrollstafftotalemployeesheadcount" DOUBLE,
  "non_payrollstafftotalemployeesfull_timeequivalent" DOUBLE,
  "grandtotal_workforcenumbers_headcount" DOUBLE,
  "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" DOUBLE,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" DOUBLE,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information April 2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_april_2021

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_april_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" 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 August 2018

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_august_2018

38.64 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_august_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 August 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_august_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_august_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 August 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_august_2020

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_august_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" 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 August 2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_august_2021

38.66 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_august_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" 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 December 2018

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_december_2018

38.64 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_december_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 December 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_december_2019

38.69 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_december_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 December 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_december_2020

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_december_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 February 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_february_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_february_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 February 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_february_2020

38.69 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_february_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" 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 February2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_february2021

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_february2021 (
  "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 January 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_january_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_january_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 January 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_january_2020

38.69 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_january_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" 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 January 2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_january_2021

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_january_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" 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 July 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_july_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_july_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 July 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_july_2020

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_july_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 July 2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_july_2021

38.69 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_july_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" 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" BIGINT,
  "non_payrollstafftotalcostofconsultants_consultancy" BIGINT,
  "non_payrollstafftotalnon_payroll_ccl_staffcosts" BIGINT,
  "grandtotalpaybill_staffing_payrollandnon_payroll_costs" DOUBLE,
  "comments" VARCHAR
);

FSA Workforce Information June 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_june_2019

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_june_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 June 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_june_2020

38.69 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_june_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" 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 June 2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_june_2021

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_june_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" 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 March 2019

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_march_2019

38.7 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_march_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" DOUBLE,
  "non_payrollstaffconsultants_consultancyfull_timeequivalent" DOUBLE,
  "non_payrollstafftotalemployeesheadcount" DOUBLE,
  "non_payrollstafftotalemployeesfull_timeequivalent" DOUBLE,
  "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 March 2020

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_march_2020

39.34 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_march_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" BIGINT,
  "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 March 2021

@ukgov.fsa_workforce_managment_information.fsa_workforce_information_march_2021

38.68 KB
1 row
41 columns


CREATE TABLE fsa_workforce_information_march_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" 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
);