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:
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
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
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.