Food Standards Agency - Non-consolidated Performance Related Pay
Food Standards Agency
@ukgov.food_standards_agency_non_consolidated_performance_related_pay
Food Standards Agency
@ukgov.food_standards_agency_non_consolidated_performance_related_pay
CREATE TABLE non_consolidated_performance_related_payments_made_to__2904a7af (
"organisation" VARCHAR,
"annualpaybilldelegatedgradesforfinancialyear2022_23gbp" BIGINT,
"headcountdelegatedgradesasat31march2023" BIGINT,
"costofinyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT,
"medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
"costofendofyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
"delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT,
"medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT,
"overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
"costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
"annualscspaybillforthosescsonstandardcontractsforfinan_8322ae11" BIGINT,
"numberofscsonstandardcontractsheadcountasat31march2023" BIGINT,
"costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT,
"medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT,
"costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
"scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE,
"valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT,
"medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT,
"overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT,
"costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE,
"numberofscsonnonstandardperformancepaytermsheadcountas_3145b965" BIGINT,
"valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT
);
CREATE TABLE non_consolidated_performance_related_payments_made_to__2af67098 (
"organisation" VARCHAR,
"annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
"headcountdelegatedgradesasat31march2018" BIGINT,
"costofinyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT,
"medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
"costofendofyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
"delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT,
"medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT,
"overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
"costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
"annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT,
"numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
"costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT,
"medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT,
"costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
"scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE,
"valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT,
"medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT,
"overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT,
"costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE,
"numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT,
"valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT
);
CREATE TABLE non_consolidated_performance_related_payments_made_to__320bbdad (
"organisation" VARCHAR,
"annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
"headcountdelegatedgradesasat31march2018" BIGINT,
"costofinyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT,
"medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
"costofendofyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
"delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT,
"medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT,
"overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
"costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
"annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT,
"numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
"costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT,
"medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT,
"costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
"scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE,
"valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT,
"medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT,
"overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT,
"costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE,
"numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT,
"valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT
);
CREATE TABLE non_consolidated_performance_related_payments_made_to__8875b96d (
"organisation" VARCHAR,
"annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
"headcountdelegatedgradesasat31march2018" BIGINT,
"costofinyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT,
"medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
"costofendofyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
"delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" DOUBLE,
"valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT,
"medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT,
"overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
"costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
"annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT,
"numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
"costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" BIGINT,
"valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT,
"medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT,
"costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
"scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE,
"valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT,
"medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT,
"overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT,
"costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE,
"numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT,
"valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT
);
CREATE TABLE non_consolidated_performance_related_payments_made_to__b0ffdf6f (
"organisation" VARCHAR,
"annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
"headcountdelegatedgradesasat31march2018" BIGINT,
"costofinyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT,
"medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
"costofendofyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
"delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT,
"medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT,
"overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
"costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
"annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT,
"numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
"costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT,
"medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT,
"costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
"scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE,
"valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT,
"medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT,
"overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT,
"costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE,
"numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT,
"valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT
);
CREATE TABLE non_consolidated_performance_related_payments_made_to__b8967e73 (
"organisation" VARCHAR,
"annualpaybilldelegatedgradesforfinancialyear2017_18gbp" BIGINT,
"headcountdelegatedgradesasat31march2018" BIGINT,
"costofinyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprp" BIGINT,
"numberofstaffindelegatedgradesreceivinganinyearncprpas_07702389" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofstaffinthedele_2c09e942" BIGINT,
"medianncprpforthosesreceivinganinyearncprpfordelegatedgradesgbp" BIGINT,
"costofendofyearncprpfordelegatedgradesgbp" BIGINT,
"numberofstaffindelegatedgradesreceivinganendofyearncprp" BIGINT,
"delegatedgradestaffreceivinganendofyearncprpasapercent_7d0a982b" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofstaffinthed_333b6826" BIGINT,
"medianncprpforthosereceivinganendofyearncprpfordelegat_b80e99e0" BIGINT,
"overallcostofncprpinyearandendofyearfordelegatedgradesgbp" BIGINT,
"costofncprpasapercentofpaybillfordelegatedgradesasadecimal" DOUBLE,
"annualscspaybillforthosescsonstandardcontractsforfinan_d06c7835" BIGINT,
"numberofscsonstandardcontractsheadcountasat31march2018" BIGINT,
"costofinyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp" BIGINT,
"numberofscsstandardcontractstaffreceivinganinyearncprp_dafcd464" DOUBLE,
"valueofmaximuminyearncprppaidtoamemberofscsstandardcon_05a3327b" BIGINT,
"medianncprpforthosescsstandardcontractstaffreceivingan_f37d6ed6" BIGINT,
"costofendofyearncprpforscsstandardcontractstaffgbp" BIGINT,
"numberofscsstandardcontractstaffreceivinganendofyearncprp" BIGINT,
"scsstandardcontractstaffreceivinganendofyearncprpasape_d4431079" DOUBLE,
"valueofmaximumendofyearncprppaidtoamemberofscsstandard_cdbdf5fc" BIGINT,
"medianendofyearncprpforthosescsstandardcontractstaffre_a9f4045d" BIGINT,
"overallcostofncprpinyearandendofyearforscsonstandardco_1b5d29ca" BIGINT,
"costofncprpasapercentofpaybillforscsonstandardcontract_dd37cfa7" DOUBLE,
"numberofscsonnonstandardperformancepaytermsheadcountas_d6af47a7" BIGINT,
"valueofmaximuminyearncprppaidtoamemberofscsonnonstanda_1e4fad72" BIGINT,
"valueofmaximumendofyearncprppaidtoamemberofscsonnonsta_8ce8d61c" BIGINT
);
Anyone who has the link will be able to view this.