About

The Combined Online Information System (COINS) is the Treasury's accounting database.

This was the Treasury's response to a FOI request for the schema to the COINS database.

The COINS database is not relational so it was not possible to provide the schema. COINS is a multidimensional database and so, to be helpful the Treasury provided the 'fields' of each of the dimensions as of Jan 2010.

The information is presented in 8 worksheets, the tab of which shows the name of the specific dimension.

More description of the spreadsheets is given at:

http://www.whatdotheyknow.com/request/25039/response/67260/attach/2/foi%20eva.pdf

Acronyms explained

EL is Estimate Lines
RFR is Request For Resources
AA is Accounting Authority
Cost Center - part of departmental spending

Download & API

100111%20COINS%20Schema%20for%20FOI%209%201049.xlsxls

Field details for each of the dimensions in the multidimentional COINS database

Download

c2b216e9-ee73-4a4f-9b1c-8506a563c06fgdocs/ccc

List of fields from 2010-06 COINS csv

Download

DEP2009-2345.xlsxls

The bodies spending is allocated to

Download

Oranisation%20list%20ex%20COINS%2022%20Jan%2010.pdfpdf

List of Public Bodies in the COINS Database

Download

Sources & license

Sources

http://www.whatdotheyknow.com/request/schema_for_coins_database