Phoenix Futures - Janus Database

Phoenix Futures is one of the largest providers of drug and alcohol treatment across the UK. Their Sheffield Community service originally commissioned MJ Software to build a small database several years ago. The organisation was so impressed with this that they brought MJ Software in to design a new database named Janus to cover the whole charity. This database operates at over 30 services and has over 300 users nationwide.

One of the key things about the database was that it has to report a complex "data set" to the National Drug Treatment Monitoring System.

Dan Richter, Head of Quality from Phoenix Futures said: -

"This is a difficult operation which in turn makes the database structure complicated, but MJ Software has achieved this and we have continued faith in MJ Software that they will continue to adapt our database to complex external demands.

We have found that MJ Software has been flexible to meet our needs, and has built a working relationship with us based on courtesy and respect."

 

Features provided to Phoenix Futures, via the Janus Database: -

• A database application that enabled the efficient storage and retrieval of information.
• Each service/office to be given the appropriate rights to their own cases, restricting them from accessing clients outside of their area.
• Output data and validation of information for submission to NDTMS (National Drug Treatment Monitoring Service).
• User friendly data filtering, querying facilities.
• Document linking - PDFs, Word Documents, Letters, etc. can all be linked to the client's records.
• Actions can be recorded against groups, or individual clients.
• Complex data validation, ensuring information is keyed in accurately.
• When creating new clients, an "advanced pattern match" query is used to identify whether or not the client already exists, minimising duplicate data.

Useful Links: -

www.phoenix-futures.org.uk