Payment Performance Statistics
Leeds City Council
@ukgov.payment_performance_statistics
Leeds City Council
@ukgov.payment_performance_statistics
CREATE TABLE late_payment_interest_2016_17 (
"extractdate" TIMESTAMP,
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"servicetypeuri" VARCHAR,
"servicetypelabel" VARCHAR,
"financialyear" VARCHAR,
"invoicespaidlatecount" BIGINT,
"totalliability" BIGINT,
"interestpaid" BIGINT
);
CREATE TABLE late_payment_interest_2017_18 (
"extractdate" TIMESTAMP,
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"servicetypeuri" VARCHAR,
"servicetypelabel" VARCHAR,
"financialyear" VARCHAR,
"invoicespaidlatecount" BIGINT,
"totalliability" BIGINT,
"interestpaid" BIGINT
);
CREATE TABLE late_payment_interest_2018_19 (
"extractdate" TIMESTAMP,
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"servicetypeuri" VARCHAR,
"servicetypelabel" VARCHAR,
"financialyear" VARCHAR,
"invoicespaidlatecount" BIGINT,
"totalliability" BIGINT,
"interestpaid" BIGINT
);
CREATE TABLE late_payment_interest_2019_20 (
"extractdate" TIMESTAMP,
"organisationuri" VARCHAR,
"organisationlabel" VARCHAR,
"servicetypeuri" VARCHAR,
"servicetypelabel" VARCHAR,
"financialyear" VARCHAR,
"invoicespaidlatecount" BIGINT,
"totalliability" BIGINT,
"interestpaid" BIGINT
);
Anyone who has the link will be able to view this.