Skip to main content

Departmental Databases

Volume 485: debated on Thursday 18 December 2008

To ask the Solicitor-General what databases the Law Officers’ Departments (a) own and (b) maintain. (242227)

The Crown Prosecution Service (CPS) has a 10 year Public Finance Initiative Partnership with LogicaCMG to modernise information technology within the Service. This is known as the COMPASS Programme.

The contract with LogicaCMG covers the provision, support and maintenance of the hardware and software applications used by the CPS. This includes: the case management databases; the COMPASS Case Management System; the Management Information System; the Witness Management System; and the Payroll, Graduated Counsel Fee Scheme and the Corporate Information Systems. The corporate databases provided by suppliers outside of the COMPASS contract are the Finance and Human Resources databases.

The other databases in use by small numbers of HQ users are:

Database

Use

Respond

To track correspondence

CPS Direct Rota

To rota CPS Direct crown prosecutor coverage

Teleware

Call distribution system for CPS Direct

Gateway 2000

Document numbering system for distributing documents nationally

Unicorn

Online library loans system

Druid

Record of archived cases requiring review

ReMS

Storage details of long-term interest cases

FMBC Tracker

Facilities Management Business Centre (FMBC) database to plan and track progress of building maintenance

MAB

FMBC management of Area budgets database to monitor area building maintenance costs

FMBC Project

FMBC database used by regional project managers to track facilities management projects

STC Navigator

To analyse energy usage

The suite of desktop applications provided to all users through the COMPASS contract includes Microsoft Access database software for the development of databases for individual use.

The CPS owns the data contained within its databases.

The following table shows the databases (a) owned and (b) maintained by the Serious Fraud Office:

Database

Description

Docman

Document management system holding scanned evidence that forms part of SFO cases (also cases closed and pending).

DCS2

Document management system holding descriptions of evidence that forms part of SFO cases (also cases closed and pending).

Introspect

Document management system holding scanned evidence that forms part of SFO cases (also cases closed and pending).

Alphascan

Document management system holding scanned evidence that forms part of SFO cases (also cases closed and pending).

DBTextworks

Document management system holding evidence that forms part of SFO cases (also cases closed and pending).

Valid Archive

Document management system holding evidence that forms part of SFO cases (also cases closed and pending).

Registry Database

Database used to register files across the organisation.

Case Tracking

Database containing summary information of all SFO cases, past and present.

Section 2 Register

List of all Section 2 Notices.

Efin

Database used to process Purchase Ledger and General Ledger transactions for the SFO.

TRENT

List of staff (permanent, temporary and leavers) and all related personal details.

Infobasis

Database containing information about staff training (please note that this system is not fully operational yet).

Task Management System

List of tasks related to each case and their allocation to case team members (not used on every case).

Adlib

Database containing information about all books in the library catalogue.

Access Control Database

Facilitates access to all areas of the SFO.

Electronic Visitor System

Facilitates access to visitors to all areas of the SFO.

Analyst Notebook

Investigation tool used to help visualise transactions.

Healthwise

Health and Safety and Risk Assessment Training.

Casewise

Planning tool used by Case Management Reform.

Touchpaper

Records details of IT help desk calls and inventory.

LanDesk

Hardware inventory and management.

ActiveXperts

Server monitoring.

Norad Surveillance

Database monitoring.

Rightfax

Faxes.

ArcServe

Backup and restore management.

Active Directory

User management.

Ms Exchange

E-mails.

Websense

Internet activity monitor.

The Treasury Solicitor’s Department:

(a) Owns the following databases:

Database name

Function

Database management system

High profile case list

High Profile case List

MySQL

ODQ Subset of Datix

Reporting tool for time recording and billing

MySQL

BVFAIS

Legacy data from FAIS (the old Bona Vacantia database) to be kept for 40 Years

MySQL

Client Database

Client Information

MySQL

European Database

Judgments and Observations about European matters

MySQL

IJRT

Immigration Judicial review team

MS Access

Costs

Manage costs distribution

MS Access

Paperroom database

Tracks physical files

MS Access

GPL database

Ex GPL (Government Property Lawyers) data Very old Datix

MySQL

(b) Maintains the following databases:

SQL Server Database Management system

System

Function

Version

Password Safe

Electronic Password Maintenance

2000 Enterprise Edition SP4

Archive Manager

Back Up and Security facility for email

2005 Enterprise Edition RTM

Tracklt

Helpdesk

2005 Enterprise Edition RTM

BigFix

Software distribution management

2005 Standard Edition SP2

QFM

Facilities Management

2000 Standard Edition RTM

QTP

Test software

2000 Enterprise Edition RTM

CommVault

Backup

2005 Express Edition

E-Policy Orchestrator

Security management

MSDE

iPatch Manager

Secure Patch management

MSDE

Infra

New Service Desk

2005 Enterprise Edition RTM

ForeFront

Network security

2005 Standard Edition SP2

System Centre Configuration Manager

Microsoft control centre

2005 Standard Edition SP2 and SP1

Stream

Risk Management software

2005 Standard Edition SP2

Image Deployment Server

Media Distribution

MSDE

SharePoint

File and information repository

2005 Enterprise Edition SP1

SecureWave

PC security

2005 Standard Edition SP2

VMWare Virtual Centre

Virtualisation control

2000 Personal Edition SP4

HP Jet Admin

Printer management

2005 Express Edition

Monitoring Server

Network traffic monitoring

2005 Workgroup Edition SP1

Vantage

Network Checking

2005 Standard Edition SP1

Oracle Database Management system

System

Function

Version

E-Financials

Accounting

Oracle 8i, 81, l0gRAC

R/KYV

Document management

Oracle l0g

Carpe Diem Litigation and European

Time recording

Oracle 9i, l0g

Grid Control

Infrastructure management

Oracle l0g

Informix Database Management system

System

Function

Version

Datix

Billing

Informix IDS 7.31

Tsolacd

Automated Call Distribution

Informix IDS 10

The Revenue and Customs Prosecutions Office owns, and is responsible for maintaining, the data held on each of the databases detailed as follows, although the administration may be outsourced to a third party.

1. SOLAR—case management database

2. SUMMATION—document storage

3. CASESTAT—summary of case data

4. HERMES—HR information

5. E-Financials—Financial

6. PEOPLEFINDER—Internal directory

HM Crown Prosecution Service Inspectorate has no databases which it maintains.