About this Dataset

Online System For Central Accounting And Reporting - OSCAR

Online System for Central Accounting and Reporting (OSCAR) - is a cross government project to replace the COINS public spending database with a robust, user-friendly system that will provide the Treasury with key management information and data for public reporting. The intention is that OSCAR will improve the quality of data the system holds by simplifying data structures, developing validation and strengthening control processes and accountabilities. We have now published the second set of in-year data recorded on the new OSCAR reporting System which covers the first six months of 2012-13 (April-September). This dataset, in addition to the previous COINS releases, provide the means to make public spending data more directly accessible and can be used with standard spreadsheet software.
Publisher name: HM Treasury
Last updated: 2024-09-15T11:50:10Z

Tables

Online System For Central Accounting And Reporting - OSCAR

@ukgov.oscar.online_system_for_central_accounting_and_reporting_oscar

208.42 KB
21177 rows
17 columns


CREATE TABLE online_system_for_central_accounting_and_reporting_oscar (
  "organisation_code" VARCHAR,
  "organisation" VARCHAR,
  "control_budget_code" VARCHAR,
  "control_budget_detail_code" VARCHAR,
  "segment_department_long_name" VARCHAR,
  "sub_segment_code" VARCHAR,
  "sub_segment_long_name" VARCHAR,
  "economic_category_code" VARCHAR,
  "economic_category_long_name" VARCHAR,
  "economic_budget_code" VARCHAR,
  "pesa_economic_group_code" VARCHAR,
  "pesa_economic_group_long_name" VARCHAR,
  "version" VARCHAR,
  "year" VARCHAR,
  "quarter" VARCHAR,
  "month" VARCHAR,
  "amount" BIGINT
);