[wdmmg-discuss] a good e.g. of obtaining council accounts

Tue Jul 6 12:07:17 UTC 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 
Council.

I found out the database used to store the council's accounts is a Fujitsu 
Oracle system. Oracle Applications is on version 11.5.10.2 and the 
database version is 10.2.0.3.0. I got this from here:
http://www.whatdotheyknow.com/request/databases_used_to_store_county_c#incoming-82248

I've got some of the accounts database schema information:
http://www.whatdotheyknow.com/request/schema_for_the_fujitsu_oracle_da#incoming-82932

I've got some idea of which tables are important:
http://www.whatdotheyknow.com/request/data_from_the_fujitsu_oracle_dat#comment-11028

I have the training notes for using the accounting database:
http://www.archive.org/details/CambridgeshireCountyCouncilAccountsDatabaseTrainingMaterials

That's all for now,

Lisa

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:
>
> http://www.whatdotheyknow.com/request/data_from_the_fujitsu_oracle_dat
>
> 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.
>
> Lisa
>
>
> _______________________________________________
> wdmmg-discuss mailing list
> wdmmg-discuss at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/wdmmg-discuss
>
>