Tribal asset management database

Julian Todd made this Freedom of Information request to Liverpool City Council

The request was successful.

From: Julian Todd

24 September 2009

Dear Sir or Madam,

I have extracted the following two statements from Liverpool City
Council documents concerning the existence of an electronic
register of all council assets:

* Page 87 of the Public reports pack for the Audit and Accounts
Committee meeting of 11 February 2009

http://councillors.liverpool.gov.uk/Publ...

"[T]he Audit Commission acknowledged that the Council was making
significant progress ... in recording all property information into
the new TRIBAL asset management system...

"[T]he Audit Commission highlighted ... that the Tribal property
database was incomplete and that Officers had already identified
that fixed assets were approximately overstated by £4 million as a
result of duplicate assets. Consequently, the Audit Commission
identified that there were still significant weaknesses in respect
of the Council's arrangements for the valuation, accounting and
reconciliation of its fixed assets."

* Page 5 of the Supplementary Agenda for the Audit and Accounts
Committee meeting of 25 June 2009 states:

http://councillors.liverpool.gov.uk/Publ...

"The migration of the City Council’s asset records to the new
TRIBAL system was completed by the 31st March 2009. A
reconciliation between the TRIBAL system and the asset register has
been undertaken and the relevant adjustments made to the Statement
of Accounts."

Under the Freedom of Information Act 2000, please may I be sent:

* Copies of the contract(s) signed with Tribal Group for the
procurement of their system, retaining consultants, and maintaining
the system in use.

* A copy of the communication or document where the £4 million
overstatement of assets was disclosed and explained.

* A full copy of this database in one of the common open data
formats (eg XML, SQLdump, etc).

If there are any reasons for not providing me with a satisfactory
copy of this database, then please send me copies of all the
operating manuals, help files included with the software, as well
as procedures for backing up and restoring this vital database so
that I am better able to target any future requests.

Yours faithfully,

Julian Todd

Link to this

From: Symm, Kevin
Liverpool City Council

24 September 2009

Attachment 76263 Todd ACK 240909.doc
481K Download View as HTML

Please find attached acknowledgement letter.

Regards,

Kevin Symm

Senior Information Officer

Legal Services

Liverpool City Council

Municipal Buildings

Dale Street

Liverpool

L2 2DH

TEL: 0151 225 3007

[1][email address]

show quoted sections

References

Visible links
1. mailto:[email address]

Link to this

From: Brown, Lawrence
Liverpool City Council

22 October 2009

Attachment Response to FOI request ref.76263.doc
461K Download View as HTML

Attachment FMS2608StatementofAccounts200708 docA ps.pdf
67K Download View as HTML

Attachment FOI Asset List LCC All BPdeed.csv.txt
386K Download View as HTML

Dear Mr Todd,

See attached response together with some of the attachments relating to
your recent Freedom of Information request. Due to the size of some of the
attachments, the remainder will follow on separate e-mails.

Regards

Lawrence Brown

Legal Services,

Municipal Buildings,

Dale Street,

Liverpool, L2 2DH

Tel: 0151-225 3007

Fax:0151-225 2392

Email: [1][email address]

Internet: [2]www.liverpool.gov.uk

Do you really need to print this e-mail?

Liverpool's Year of the Environment 2009 -

Our City Our Planet [3]www.ourcityourplanet.org.uk

show quoted sections

References

Visible links
1. mailto:[email address]
2. http://www.liverpool.gov.uk/
3. http://www.ourcityourplanet.org.uk/
http://www.ourcityourplanet.org.uk/

Link to this

From: Brown, Lawrence
Liverpool City Council

22 October 2009

Attachment FOI Asset List LCC All BProoms.csv.txt
717K Download View as HTML

Attachment FOI Asset List LCC All BPjobs.csv.txt
740K Download View as HTML

Dear Mr Todd,

Further enclosures attached.

Regards

Lawrence Brown

Legal Services,

Municipal Buildings,

Dale Street,

Liverpool, L2 2DH

Tel: 0151-225 3007

Fax:0151-225 2392

Email: [1][email address]

Internet: [2]www.liverpool.gov.uk

Do you really need to print this e-mail?

Liverpool's Year of the Environment 2009 -

Our City Our Planet [3]www.ourcityourplanet.org.uk

show quoted sections

References

Visible links
1. mailto:[email address]
2. http://www.liverpool.gov.uk/
3. http://www.ourcityourplanet.org.uk/
http://www.ourcityourplanet.org.uk/

Link to this

From: Brown, Lawrence
Liverpool City Council

22 October 2009

Attachment FOI Asset List LCC All BPblock.csv.txt
1.6M Download View as HTML

Dear Mr Todd,

Further enclosure attached.

Regards

Lawrence Brown

Legal Services,

Municipal Buildings,

Dale Street,

Liverpool, L2 2DH

Tel: 0151-225 3007

Fax:0151-225 2392

Email: [1][email address]

Internet: [2]www.liverpool.gov.uk

Do you really need to print this e-mail?

Liverpool's Year of the Environment 2009 -

Our City Our Planet [3]www.ourcityourplanet.org.uk

show quoted sections

References

Visible links
1. mailto:[email address]
2. http://www.liverpool.gov.uk/
3. http://www.ourcityourplanet.org.uk/
http://www.ourcityourplanet.org.uk/

Link to this

From: Brown, Lawrence
Liverpool City Council

22 October 2009

Attachment FOI AssetList BPpremise.csv.txt
5.4M Download View as HTML

Dear Mr Todd,

Final enclosure attached.

Regards

Lawrence Brown

Legal Services,

Municipal Buildings,

Dale Street,

Liverpool, L2 2DH

Tel: 0151-225 3007

Fax:0151-225 2392

Email: [1][email address]

Internet: [2]www.liverpool.gov.uk

Liverpool's Year of the Environment 2009 -

Our City Our Planet [3]www.ourcityourplanet.org.uk

show quoted sections

References

Visible links
1. mailto:[email address]
2. http://www.liverpool.gov.uk/
3. http://www.ourcityourplanet.org.uk/
http://www.ourcityourplanet.org.uk/

Link to this

Things to do with this request

Anyone:
Liverpool City Council only: