About this Dataset

Food Standards Agency - Non-consolidated Performance Related Pay

Information on Non-Consolidated Performance Related Payments made to SCS and Non-SCS Staff.
Publisher name: Food Standards Agency
Last updated: 2024-12-18T04:00:13Z

Tables

Non-Consolidated Performance Related Payments Made To SCS And Non-SCS Staff For The Performance Year 2022-23

@ukgov.food_standards_agency_non_consolidated_performance_related_pay.non_consolidated_performance_related_payments_made_to__2904a7af

35.84 kB
1 row
32 columns

CREATE TABLE non_consolidated_performance_related_payments_made_to__2904a7af (
  "organisation" VARCHAR,
  "annualpaybilldelegatedgradesforfinancialyear2022_23gbp" BIGINT,
  "headcountdelegatedgradesasat31march2023" BIGINT,
  "costofinyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE  -- NumberOfStaffInDelegatedGradesReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
  "costofendofyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
  "delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT  -- DelegatedGradeStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT  -- MedianNCPRPForThoseReceivingAnEndOfYearNCPRPForDelegatedGradesGBP,
  "overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
  "costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
  "annualscspaybillforthosescsonstandardcontractsforfinan_8322ae11" BIGINT  -- AnnualSCSPaybillForThoseSCSOnStandardContractsForFinancialYear2022-23GBP,
  "numberofscsonstandardcontractsheadcountasat31march2023" BIGINT,
  "costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE  -- NumberOfSCSStandardContractStaffReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT  -- MedianNCPRPForThoseSCSStandardContractStaffReceivingAnInYearNCPRPForDelegatedGradesGBP,
  "costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
  "scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE  -- SCSStandardContractStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT  -- MedianEndOfYearNCPRPForThoseSCSStandardContractStaffReceivingAnEndOfYearNCPRPFGBP,
  "overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT  -- OverallCostOfNCPRPInYearAndEndOfYearForSCSOnStandardContractsGBP,
  "costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE  -- CostOfNCPRPAsAPercentOfPaybillForSCSOnStandardContractsAsADecimal,
  "numberofscsonnonstandardperformancepaytermsheadcountas_3145b965" BIGINT  -- NumberOfSCSOnNonStandardPerformancePayTermsHeadcountAsAt31March2023,
  "valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP,
  "valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP
);

Non-Consolidated Performance Related Payments Made To SCS And Non-SCS Staff For The Performance Year 2021-22

@ukgov.food_standards_agency_non_consolidated_performance_related_pay.non_consolidated_performance_related_payments_made_to__2af67098

35.84 kB
1 row
32 columns

CREATE TABLE non_consolidated_performance_related_payments_made_to__2af67098 (
  "organisation" VARCHAR,
  "annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
  "headcountdelegatedgradesasat31march2018" BIGINT,
  "costofinyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE  -- NumberOfStaffInDelegatedGradesReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
  "costofendofyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
  "delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT  -- DelegatedGradeStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT  -- MedianNCPRPForThoseReceivingAnEndOfYearNCPRPForDelegatedGradesGBP,
  "overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
  "costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
  "annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT  -- AnnualSCSPaybillForThoseSCSOnStandardContractsForFinancialYear2017-18GBP,
  "numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
  "costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE  -- NumberOfSCSStandardContractStaffReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT  -- MedianNCPRPForThoseSCSStandardContractStaffReceivingAnInYearNCPRPForDelegatedGradesGBP,
  "costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
  "scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE  -- SCSStandardContractStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT  -- MedianEndOfYearNCPRPForThoseSCSStandardContractStaffReceivingAnEndOfYearNCPRPFGBP,
  "overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT  -- OverallCostOfNCPRPInYearAndEndOfYearForSCSOnStandardContractsGBP,
  "costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE  -- CostOfNCPRPAsAPercentOfPaybillForSCSOnStandardContractsAsADecimal,
  "numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT  -- NumberOfSCSOnNonStandardPerformancePayTermsHeadcountAsAt31March2018,
  "valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP,
  "valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP
);

Non-Consolidated Performance Related Payments Made To SCS And Non-SCS Staff For The Performance Year 2018-19

@ukgov.food_standards_agency_non_consolidated_performance_related_pay.non_consolidated_performance_related_payments_made_to__320bbdad

35.84 kB
1 row
32 columns

CREATE TABLE non_consolidated_performance_related_payments_made_to__320bbdad (
  "organisation" VARCHAR,
  "annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
  "headcountdelegatedgradesasat31march2018" BIGINT,
  "costofinyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE  -- NumberOfStaffInDelegatedGradesReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
  "costofendofyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
  "delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT  -- DelegatedGradeStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT  -- MedianNCPRPForThoseReceivingAnEndOfYearNCPRPForDelegatedGradesGBP,
  "overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
  "costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
  "annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT  -- AnnualSCSPaybillForThoseSCSOnStandardContractsForFinancialYear2017-18GBP,
  "numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
  "costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE  -- NumberOfSCSStandardContractStaffReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT  -- MedianNCPRPForThoseSCSStandardContractStaffReceivingAnInYearNCPRPForDelegatedGradesGBP,
  "costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
  "scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE  -- SCSStandardContractStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT  -- MedianEndOfYearNCPRPForThoseSCSStandardContractStaffReceivingAnEndOfYearNCPRPFGBP,
  "overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT  -- OverallCostOfNCPRPInYearAndEndOfYearForSCSOnStandardContractsGBP,
  "costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE  -- CostOfNCPRPAsAPercentOfPaybillForSCSOnStandardContractsAsADecimal,
  "numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT  -- NumberOfSCSOnNonStandardPerformancePayTermsHeadcountAsAt31March2018,
  "valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP,
  "valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP
);

Non-Consolidated Performance Related Payments Made To SCS And Non-SCS Staff For The Performance Year 2017-18

@ukgov.food_standards_agency_non_consolidated_performance_related_pay.non_consolidated_performance_related_payments_made_to__8875b96d

35.84 kB
1 row
32 columns

CREATE TABLE non_consolidated_performance_related_payments_made_to__8875b96d (
  "organisation" VARCHAR,
  "annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
  "headcountdelegatedgradesasat31march2018" BIGINT,
  "costofinyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE  -- NumberOfStaffInDelegatedGradesReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
  "costofendofyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
  "delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" DOUBLE  -- DelegatedGradeStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT  -- MedianNCPRPForThoseReceivingAnEndOfYearNCPRPForDelegatedGradesGBP,
  "overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
  "costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
  "annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT  -- AnnualSCSPaybillForThoseSCSOnStandardContractsForFinancialYear2017-18GBP,
  "numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
  "costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" BIGINT  -- NumberOfSCSStandardContractStaffReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT  -- MedianNCPRPForThoseSCSStandardContractStaffReceivingAnInYearNCPRPForDelegatedGradesGBP,
  "costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
  "scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE  -- SCSStandardContractStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT  -- MedianEndOfYearNCPRPForThoseSCSStandardContractStaffReceivingAnEndOfYearNCPRPFGBP,
  "overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT  -- OverallCostOfNCPRPInYearAndEndOfYearForSCSOnStandardContractsGBP,
  "costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE  -- CostOfNCPRPAsAPercentOfPaybillForSCSOnStandardContractsAsADecimal,
  "numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT  -- NumberOfSCSOnNonStandardPerformancePayTermsHeadcountAsAt31March2018,
  "valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP,
  "valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP
);

Non-Consolidated Performance Related Payments Made To SCS And Non-SCS Staff For The Performance Year 2020-21

@ukgov.food_standards_agency_non_consolidated_performance_related_pay.non_consolidated_performance_related_payments_made_to__b0ffdf6f

35.84 kB
1 row
32 columns

CREATE TABLE non_consolidated_performance_related_payments_made_to__b0ffdf6f (
  "organisation" VARCHAR,
  "annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
  "headcountdelegatedgradesasat31march2018" BIGINT,
  "costofinyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE  -- NumberOfStaffInDelegatedGradesReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
  "costofendofyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
  "delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT  -- DelegatedGradeStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT  -- MedianNCPRPForThoseReceivingAnEndOfYearNCPRPForDelegatedGradesGBP,
  "overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
  "costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
  "annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT  -- AnnualSCSPaybillForThoseSCSOnStandardContractsForFinancialYear2017-18GBP,
  "numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
  "costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE  -- NumberOfSCSStandardContractStaffReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT  -- MedianNCPRPForThoseSCSStandardContractStaffReceivingAnInYearNCPRPForDelegatedGradesGBP,
  "costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
  "scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE  -- SCSStandardContractStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT  -- MedianEndOfYearNCPRPForThoseSCSStandardContractStaffReceivingAnEndOfYearNCPRPFGBP,
  "overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT  -- OverallCostOfNCPRPInYearAndEndOfYearForSCSOnStandardContractsGBP,
  "costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE  -- CostOfNCPRPAsAPercentOfPaybillForSCSOnStandardContractsAsADecimal,
  "numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT  -- NumberOfSCSOnNonStandardPerformancePayTermsHeadcountAsAt31March2018,
  "valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP,
  "valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP
);

Non-Consolidated Performance Related Payments Made To SCS And Non-SCS Staff For The Performance Year 2019-20

@ukgov.food_standards_agency_non_consolidated_performance_related_pay.non_consolidated_performance_related_payments_made_to__b8967e73

35.84 kB
1 row
32 columns

CREATE TABLE non_consolidated_performance_related_payments_made_to__b8967e73 (
  "organisation" VARCHAR,
  "annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
  "headcountdelegatedgradesasat31march2018" BIGINT,
  "costofinyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE  -- NumberOfStaffInDelegatedGradesReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
  "costofendofyearncprpfordelegatedgradesgbp" BIGINT,
  "numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
  "delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT  -- DelegatedGradeStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfStaffInTheDelegatedGradesGBP,
  "medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT  -- MedianNCPRPForThoseReceivingAnEndOfYearNCPRPForDelegatedGradesGBP,
  "overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
  "costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
  "annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT  -- AnnualSCSPaybillForThoseSCSOnStandardContractsForFinancialYear2017-18GBP,
  "numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
  "costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE  -- NumberOfSCSStandardContractStaffReceivingAnInYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT  -- MedianNCPRPForThoseSCSStandardContractStaffReceivingAnInYearNCPRPForDelegatedGradesGBP,
  "costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
  "numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
  "scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE  -- SCSStandardContractStaffReceivingAnEndOfYearNCPRPAsAPercentOfHeadcountAsADecimal,
  "valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSStandardContractStaffGBP,
  "medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT  -- MedianEndOfYearNCPRPForThoseSCSStandardContractStaffReceivingAnEndOfYearNCPRPFGBP,
  "overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT  -- OverallCostOfNCPRPInYearAndEndOfYearForSCSOnStandardContractsGBP,
  "costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE  -- CostOfNCPRPAsAPercentOfPaybillForSCSOnStandardContractsAsADecimal,
  "numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT  -- NumberOfSCSOnNonStandardPerformancePayTermsHeadcountAsAt31March2018,
  "valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT  -- ValueOfMaximumInYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP,
  "valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT  -- ValueOfMaximumEndOfYearNCPRPPaidToAMemberOfSCSOnNonStandardPerformancePayTermsGBP
);