Non-consolidated Performance Related Payments For The FCO And FCO Services
Foreign and Commonwealth Office
@ukgov.non_consolidated_performance_related_payments_oct_2011
Foreign and Commonwealth Office
@ukgov.non_consolidated_performance_related_payments_oct_2011
CREATE TABLE fco_non_consolidated_performance_related_pay_2017_18 (
"main_department" VARCHAR,
"organisation" VARCHAR,
"delegated_grades" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"scs_on_standard_contracts" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"information_for_scs_on_non_standard_terms" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE non_consolidated_performance_related_pay_2018_19 (
"main_department" VARCHAR,
"organisation" VARCHAR,
"delegated_grades" VARCHAR,
"unnamed_3" VARCHAR,
"unnamed_4" VARCHAR,
"unnamed_5" VARCHAR,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR,
"unnamed_8" VARCHAR,
"unnamed_9" VARCHAR,
"unnamed_10" VARCHAR,
"unnamed_11" VARCHAR,
"unnamed_12" VARCHAR,
"unnamed_13" VARCHAR,
"unnamed_14" VARCHAR,
"unnamed_15" VARCHAR,
"scs_on_standard_contracts" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"unnamed_19" VARCHAR,
"unnamed_20" VARCHAR,
"unnamed_21" VARCHAR,
"unnamed_22" VARCHAR,
"unnamed_23" VARCHAR,
"unnamed_24" VARCHAR,
"unnamed_25" VARCHAR,
"unnamed_26" VARCHAR,
"unnamed_27" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"information_for_scs_on_non_standard_terms" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" VARCHAR,
"comments" VARCHAR
);
CREATE TABLE non_consolidated_performance_related_payments_for_the__d8b124c4 (
"main_department" VARCHAR,
"organisation" VARCHAR,
"annual_paybill_delegated_grades_for_financial_year_2014_15" VARCHAR,
"headcount_delegated_grades_as_at_31_march_2015" BIGINT,
"in_year_cost_of_in_year_ncprp_for_delegated_grades_only" VARCHAR,
"in_year_number_of_staff_in_delegated_grades_receiving__dcdd1498" BIGINT,
"in_year_number_of_staff_in_delegated_grades_receiving__41c65dd9" VARCHAR,
"in_year_value_of_maximum_in_year_ncprp_paid_to_a_membe_3d22f6e7" VARCHAR,
"in_year_median_ncprp_for_those_receiving_an_in_year_nc_4e4e149c" VARCHAR,
"end_of_year_cost_of_end_of_year_ncprp_for_delegated_gr_7b1b4680" VARCHAR,
"end_of_year_number_of_staff_in_delegated_grades_receiv_0ec921b4" BIGINT,
"end_of_year_delegated_grade_staff_receiving_an_end_of__8d8228bc" VARCHAR,
"end_of_year_value_of_maximum_end_of_year_ncprp_paid_to_0e891936" VARCHAR,
"end_of_year_median_ncprp_for_those_receiving_an_end_of_87dfbc0f" VARCHAR,
"total_overall_cost_of_ncprp_in_year_and_end_of_year_fo_5b549edf" VARCHAR,
"total_cost_of_ncprp_as_a_of_paybill_for_delegated_grades_only" VARCHAR,
"scs_on_standard_contracts_end_of_year_ncprp_annual_scs_f616845d" VARCHAR,
"scs_on_standard_contracts_end_of_year_ncprp_number_of__b2844d92" DOUBLE,
"scs_on_standard_contracts_end_of_year_ncprp_cost_of_nc_35e21f8e" VARCHAR,
"scs_on_standard_contracts_end_of_year_ncprp_cost_of_nc_d54a9f09" VARCHAR,
"scs_on_standard_contracts_end_of_year_ncprp_number_of__8270a5ba" DOUBLE,
"scs_on_standard_contracts_end_of_year_ncprp_scs_standa_84e4e985" VARCHAR,
"scs_on_standard_contracts_end_of_year_ncprp_value_of_m_caead551" VARCHAR,
"scs_on_standard_contracts_end_of_year_ncprp_median_ncp_30ce5fb2" VARCHAR,
"information_for_scs_on_non_standard_contracts_number_o_d789bf6d" DOUBLE,
"information_for_scs_on_non_standard_contracts_value_of_f850c28d" VARCHAR,
"comments" VARCHAR
);
Anyone who has the link will be able to view this.