Teachers’ Pension Scheme (TPS) Payments In The Department For Education
Department for Education
@ukgov.teachers_pension_scheme_tps_payments_in_the_department_3a022970
Department for Education
@ukgov.teachers_pension_scheme_tps_payments_in_the_department_3a022970
CREATE TABLE teachers_pension_scheme_payments_april_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_april_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_april_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_august_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_august_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_august_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_december_2018 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_december_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_december_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_december_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_february_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_february_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_february_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_february_2022 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_january_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_january_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_january_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_january_2022 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_july_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_july_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_july_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_june_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" DOUBLE,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_june_2020 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_june_2021 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE teachers_pension_scheme_payments_march_2019 (
"departmental_family" VARCHAR,
"entity" VARCHAR,
"date" TIMESTAMP,
"expense_type_for_publicatiion" VARCHAR,
"expense_area_for_publication" VARCHAR,
"supplier" VARCHAR,
"transaction_number" BIGINT,
"amount" DOUBLE,
"description" VARCHAR
);
Anyone who has the link will be able to view this.