[wdmmg-discuss] a good e.g. of obtaining council accounts
lisa.evans at okfn.org
Tue Jul 6 13:07:17 BST 2010
I'm meeting with 2 people from Cambridgeshire County Council tomorrow, to
talk about their accounting data and what they can share with us.
If you have any questions then I'll ask for you -- just let me know.
Here's some background on the accounting system they have at Cams County
I found out the database used to store the council's accounts is a Fujitsu
Oracle system. Oracle Applications is on version 18.104.22.168 and the
database version is 10.2.0.3.0. I got this from here:
I've got some of the accounts database schema information:
I've got some idea of which tables are important:
I have the training notes for using the accounting database:
That's all for now,
On Mon, 28 Jun 2010, Lisa Evans wrote:
> I've mentioned before on this mailing list that I've been requesting details
> of a few different council's accounts.
> My best result so far has been with Cambridgeshire County Council, as you can
> see here:
> Mostly this is because I've been lucky to meet Andy on 'What do they know',
> who knows the account database tables well.
> So, I've got a meeting at Cambridgeshire county council to discuss the data
> we want -- this gives me a chance to show the wdmmg visualisations and
> explain the project.
> Let me know if you have suggestions for what to ask. I should be meeting
> them with Andy, hopefully this Wednesday, and I'll keep you posted on how
> this goes.
> wdmmg-discuss mailing list
> wdmmg-discuss at lists.okfn.org
More information about the openspending-discuss