---

Departmental Databases

Answer

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.

Secondary information

Type

Written question

Reference

485 c940-4W; 242227

Session

2008-09

Subjects

Databases Solicitor General

Contains statistics

Yes

Link

View this Written question on www.publications.parliament.uk