Data from the Fujitsu Oracle database system that is used to store the County Council accounts.

Lisa Evans made this Freedom of Information request to Cambridgeshire County Council

The request was partially successful.

From: Lisa Evans

11 May 2010

Dear Cambridgeshire County Council,

I would like to request a copy of the Fujitsu Oracle database
system that is used to store the County Council accounts, in an
appropriate electronic format. It is not necessary to include any
records of:

- individual citizen's council tax records -- just the sums of
council tax received from the county as a whole.

- individual council worker's details -- but sum salary by
department.

I would also like to request the absolute size of the Fujitsu
Oracle database system were it to be backed up and released in the
form of portable media such as hard disks or DVDs.

Yours faithfully,

Lisa Evans

Link to this

Andy Pellew left an annotation ( 2 June 2010)

I'm not sure the County will agree to this as it will be difficult to split out personally identifiable data. For example the way Oracle works is that Employees become suppliers when they are paid expenses so the supplier records in the database will contain the name, address, and contact details of every Council employee that has ever claimed expenses.

Not to mention Bank Details, Credit Card Numbers, etc.

You will get more meaningful data back if you request everything from the following tables; GL_JE_LINES, Gl_SETS_OF_BOOKS, GL_JE_HEADERS, FND_USER(*), GL_JE_BATCHES, GL_CODE_COMBINATIONS, FND_FLEX_VALUES, FND_FLEX_VALUES_TL, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ALL, PO_HEADERS_ALL, PO_VENDORS(*), and PO_VENDOR_SITES_ALL(*).

*- These would probably be anonymised removing employee details and bank details.

Link to this

From: FOI
Cambridgeshire County Council

3 June 2010

Attachment 680896 Evans 2010 06 03 Response.pdf
208K Download View as HTML

Attachment Charging Policy.pdf
60K Download View as HTML

Dear Ms Evans

Please find attached Cambridgeshire County Council's response to your
request for information.

Please contact me if you have any further queries about your request.

Yours sincerely,

Jo Withey
Information Governance officer
Information Governance

Response

<<680896_Evans_2010_06_03_Response.pdf>>

Charging Policy

<<Charging Policy.pdf>>
The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. If you receive this email by mistake please notify the sender and delete it immediately. Opinions expressed are those of the individual and do not necessarily represent the opinion of Cambridgeshire County Council. All sent and received email from Cambridgeshire County Council is automatically scanned for the presence of computer viruses and security issues.

Visit www.cambridgeshire.gov.uk

Link to this

From: Lisa Evans

10 June 2010

Dear FOI,

I would like clarify my request above by making a more specific
request for the data from the Fujitsu Oracle database system that
is used to store the County Council accounts, if that is possible.

I would like to request everything from the following tables in the
Fujitsu Oracle database system;

GL_JE_LINES, Gl_SETS_OF_BOOKS, GL_JE_HEADERS, FND_USER(*),
GL_JE_BATCHES, GL_CODE_COMBINATIONS, FND_FLEX_VALUES,
FND_FLEX_VALUES_TL, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL,
PO_DISTRIBUTIONS_ALL, PO_HEADERS_ALL, PO_VENDORS(*), and
PO_VENDOR_SITES_ALL(*).

*- These would probably be anonymised removing employee details and
bank details.

Please could you let me know if any further, more specific
instructions are required or if it would be easier if I made a new
FOI request for this data, rather than clarify this existing one.

Yours sincerely,

Lisa Evans

Link to this

From: FOI
Cambridgeshire County Council

10 June 2010

Dear Ms Evans

Re: Freedom of Information Request ref 721022

Thank you for your email of 10 June 2010 in which you asked for
information about the Oracle database. I can confirm that
Cambridgeshire County Council treat any revised requests as new requests
and, as such, this is being dealt with as a new case. I apologise for
not explaining this in my earlier response.

Your request will be dealt with in line with the Freedom of Information
Act and its regulations. In accordance with the Act, the Council aims
to respond to all requests within 20 working days, in this instance, by
8 July 2010.

If we require further information, clarification or a fee in order to
fulfil your request we will contact you again. Please quote the
reference number above in all future correspondence concerning this
request.

Yours sincerely,

Jo Withey
Information Governance Officer

RES1405
Babbage House
Castle Hill
Cambridge
CB3 0AP

01223 729164

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. If you receive this email by mistake please notify the sender and delete it immediately. Opinions expressed are those of the individual and do not necessarily represent the opinion of Cambridgeshire County Council. All sent and received email from Cambridgeshire County Council is automatically scanned for the presence of computer viruses and security issues.

Visit www.cambridgeshire.gov.uk

Link to this

From: FOI
Cambridgeshire County Council

25 June 2010

Attachment 721022 Evans 2010 06 24 Response.pdf
211K Download View as HTML

Dear Ms Evans

Please find attached Cambridgeshire County Council's response to your
request for information.

Please contact me if you have any further queries about your request.

Yours sincerely,

Jo Withey
Information Governance officer
Information Governance

<<721022_Evans_2010_06_24_Response.pdf>>
The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. If you receive this email by mistake please notify the sender and delete it immediately. Opinions expressed are those of the individual and do not necessarily represent the opinion of Cambridgeshire County Council. All sent and received email from Cambridgeshire County Council is automatically scanned for the presence of computer viruses and security issues.

Visit www.cambridgeshire.gov.uk

Link to this

Lisa Evans left an annotation (26 June 2010)

The council state they do have the information I requests, but reject my request on the grounds that:

"to provide you with all the information you have requested will exceed the appropriate limit and we are refusing your request on these grounds, under section 12(2) of the Act.

The appropriate limit is specified in regulations and for local government is set at £450 as specified by
The Freedom of Information and Data Protection (Appropriate Limit and Fees) Regulations 2004."

Link to this

From: Lisa Evans

28 June 2010

Dear FOI,

Thank you for this reply. I'm very keen to meet Gary Lythgoe, of
the Council’s Finance, Property and Performance service.

Would it be possible to meet him on Wednesday 7th July after 3:30?
If it is possible I'd like to also be joined by Andy Pellow.

Many thanks for your help,

Yours sincerely,

Lisa Evans

Link to this

From: FOI
Cambridgeshire County Council

29 June 2010

Dear Ms Evans,

Thank you for your email.

I can confirm that Gary is available to meet with you after three thirty
pm on Wednesday 7 July. I have booked the time out in his diary and
will contact you in the next couple of days to confirm the details.

Yours sincerely,

Jo Withey
Information Governance Officer

RES1405
Babbage House
Castle Hill
Cambridge
CB3 0AP

01223 729164

Try to water your garden in the cool of the early morning or evening as
this will reduce the amount of water lost to evaporation. Mulches such
as wood chips, bark and gravel help to prevent water evaporation and
also suppress weed growth, saving you both water and time spent weeding.
http://www.environment-agency.gov.uk/hom...

Thank you for this reply. I'm very keen to meet Gary Lythgoe, of the
Council's Finance, Property and Performance service.

Would it be possible to meet him on Wednesday 7th July after 3:30? If
it is possible I'd like to also be joined by Andy Pellow.

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. If you receive this email by mistake please notify the sender and delete it immediately. Opinions expressed are those of the individual and do not necessarily represent the opinion of Cambridgeshire County Council. All sent and received email from Cambridgeshire County Council is automatically scanned for the presence of computer viruses and security issues.

Visit www.cambridgeshire.gov.uk

Link to this

From: Lisa Evans

29 June 2010

Dear FOI,

Great news! I look forward to getting confirmation on the meeting.
Thank you for arranging this.

Yours sincerely,

Lisa Evans

Link to this

From: FOI
Cambridgeshire County Council

6 July 2010

Attachment ShireHallSiteMap.pdf
431K Download View as HTML

Dear Ms Evans,

Please accept my apologies for the delay in sending you the details of
tomorrow's meeting.

I can confirm that Gary Lythgoe and Vernice Key will attend a meeting
with you tomorrow from three thirty pm at Shire Hall in Cambridge. On
arrival at Shire Hall, please go to Reception who will let Gary know you
have arrived. I have attached a map of the Shire Hall site for your
information.

<<ShireHallSiteMap.pdf>>

Please let me know if you need any further information.

Yours sincerely,

Jo

Jo Withey
Information Governance Officer

RES1405
Babbage House
Castle Hill
Cambridge
CB3 0AP

01223 729164

Try to water your garden in the cool of the early morning or evening as
this will reduce the amount of water lost to evaporation. Mulches such
as wood chips, bark and gravel help to prevent water evaporation and
also suppress weed growth, saving you both water and time spent weeding.
http://www.environment-agency.gov.uk/hom...

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. If you receive this email by mistake please notify the sender and delete it immediately. Opinions expressed are those of the individual and do not necessarily represent the opinion of Cambridgeshire County Council. All sent and received email from Cambridgeshire County Council is automatically scanned for the presence of computer viruses and security issues.

Visit www.cambridgeshire.gov.uk

Link to this

Things to do with this request

Anyone:
Cambridgeshire County Council only:
 
Would you like to work with the team that built this site? We’re recruiting.