View
HistoryThe 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
Resources
Field details for each of the dimensions in the multidimentional COINS database
The bodies spending is allocated to
http://www.parliament.uk/deposits/depositedpapers/2009/DEP2009-2345.xls
Additional Information
| Field | Value |
|---|---|
| Source | http://www.whatdotheyknow.com/request/schema_for_coins_database |
| Author | HM Treasury |
| Maintainer | Maintainer not given |
| Version | Jan 2010 |