Skip to main content

Part of Step-by-Step Guide: from registration to successful submission of the Mental Health Services Data Set (MHSDS)

Expanding your submission

A detailed description of how to expand your Mental Health Services Data Set (MHSDS) data submission using additional tables and key measures.  

Current Chapter

Current chapter – Expanding your submission


Summary

A detailed description of how to expand your Mental Health Services Data Set (MHSDS) data submission using additional tables and key measures.  


Submit additional tables

This section of the guidance assumes that you have made a successful submission of the mandatory tables and are now looking to increase the data you provide to us. This is important because the measures we use for reporting and monitoring take information from across the whole dataset, not just the mandatory tables or fields.

As mentioned in the mandatory tables section, there are 62 tables in the MHSDS. You will not need to submit data to all of these tables, but you are required to submit all tables for which you have relevant information. This will depend on what services you provide and what data you collect locally.

The most likely next steps for your organisation after the mandatory tables are patient appointments and/or inpatient stays.

Patient appointments are covered by tables MHS201 – MHS204.

Inpatient stays are covered by tables MHS501 – MHS514.

The user guidance and Technical Output Specification describe every table and field in detail, so this guidance does not aim to replace those resources. You do not need to read them cover to cover, but you must become familiar with the areas that are relevant to you, as they are an invaluable resource. The more you work with the MHSDS, the more comfortable you will become with these documents.

As a starting point, we have created plain English explanations for whether a table is likely to be relevant to your organisation. However, this cannot be a comprehensive guide for everybody, due to the size of the MHSDS and the amount of variation across providers.

My organisation: Therefore I need to submit:
Is in scope to submit to the MHSDS MHS000Header
Is in scope to submit to the MHSDS MHS001MPI
Is in scope to submit to the MHSDS MHS002GP
Holds data on where a patient usually lives

MHS003

AccommStatus

Holds data on a patient's employment status

MHS004

EmpStatus

Holds data on personal details on a patient, for example if they are a carer, a looked after child, ex-armed forces

MHS005

PatInd

Treats patients who have a care coordinator

MHS006MH

CareCoord

Holds data on whether a patient has a disability

MHS007

DisabilityType

Treats patients who have a care plan

MHS008

CarePlanType

Treats patients who have a care plan

MHS009

CarePlanAgreement

Holds data on what technology is used to assist a patient with a disability

MHS010

AssTechToSupportDisTyp

Holds data on a patient's religious beliefs or sexual orientation

MHS011

SocPerCircumstances

Treats overseas visitors

MHS012

OverseasVisitorChargCat

 

MHS013MH

CurrencyModel (PILOT - do not submit)

Is in scope to submit to the MHSDS

MHS101

Referral

Has referrals to community services

MHS102

ServiceTypeReferredTo

Treats patients who have more than one reason for being referred

MHS103

OtherReasonReferral

Conducts Allied Health Professional Referral to Treatment (AHP RTT) activity MHS104RTT
Refers patients to other organisations, including Out of Area Placements (OAPs) MHS105OnwardReferral
Creates discharge plans for patients

MHS106

DischargePlanAgreement

 

MHS107

MedicationPrescription (PILOT - do not submit)

Provides direct care to patients MHS201CareContact
Provides direct care to patients MHS202CareActivity
Provides direct care to patients when another person is present MHS203OtherAttend
Provides indirect care to patients, e.g. seeking advice from other clinicians, training a patient's carer MHS204IndirectActivity
Provides care to groups of anonymous patients MHS301GroupSession
Provides a drop-in service to anonymous patients, for example crisis lines

MHS302

MHDropInContact

Treats patients subject to the Mental Health Act1 MHS401MHActPeriod
Treats patients subject to the Mental Health Act1

MHS402

RespClinicianAssignPeriod

Treats patients subject to the Mental Health Act1 who have periods of Conditional Discharge

MHS403

ConditionalDischarge

Treats patients subject to the Mental Health Act1 who are given a Community Treatment Order MHS404CommTreatOrder
Treats patients subject to the Mental Health Act1 who are given a Community Treatment Order

MHS405

CommTreatOrderRecall

Cares for inpatients MHS501HospProvSpell
Cares for inpatients MHS502WardStay
Records who cares for each inpatient MHS503AssignedCareProf
Sometimes has to delay sending an inpatient to a new setting or home MHS504DelayedDischarge
Sometimes has to implement restrictive interventions on inpatients

MHS505RestrictiveInterventInc

Sometimes has to implement restrictive interventions on inpatients

MHS515

RestrictiveInterventType

Sometimes has to request police assistance with an inpatient

MHS516

PoliceAssistanceRequest

Sometimes has inpatients who are assaulted by other patients MHS506Assault
Sometimes has inpatients who self harm while in our care MHS507SelfHarm
Grants leave to inpatients, with the expectation that they will return to their bed MHS509HomeLeave
Grants leave to inpatients subject to the Mental Health Act1, with the expectation that they will return to their bed MHS510LeaveOfAbsence
Sometimes has Mental Health Act1 inpatients who leave without authorisation

MHS511

AbsenceWithoutLeave

Can have a commissioner for inpatient stays that is different to other parts of a referral

MHS512
HospSpellCommAssPer

Sometimes has inpatients who misuse substances while in our care

MHS513

SubstanceMisuse

Moves inpatients to less secure wards on a trial basis MHS514TrialLeave
Is commissioned to provide a Specialised Mental Health Exceptional Package of Care to an inpatient MHS517 SMHExceptionalPackOfCare
Holds data on any previous diagnosis (i.e. before referral) MHS601MedHistPrevDiag
Conducts a provisional diagnosis (i.e. a working diagnosis) MHS603ProvDiag
Conducts a primary diagnosis (i.e. the main condition being treated in the referral) MHS604PrimDiag
Treats patients who have more than one diagnosis MHS605SecDiag
Conducts scored assessments2 for patients outside of a care contact

MHS606

CodedScoreAssessmentRefer

Conducts scored assessments2 for patients during a care contact

MHS607

CodedScoreAssessmentAct

Conducts scored assessments2 for patients anonymously

MHS608

AnonSelfAssess

Treats patients on the Care Programme Approach MHS701CPACareEpisode
Treats patients on the Care Programme Approach MHS702CPAReview
Conducts cluster tool assessments3

MHS801

ClusterTool

Conducts cluster tool assessments3

MHS802

ClusterAssess

Conducts cluster tool assessments3 MHS803CareCluster
Conducts Five Forensic Pathway assessments

MHS804

FiveForensicPathways

Holds data on our staff members MHS901StaffDetails
Foot notes

1. Some tables are only relevant for certain Sections of the Mental Health Act; please see the User Guidance for more information.

2. Only reportable if the assessment tool is listed in the tab 'MH Assessment Scales' in the Technical Output Specification.

3. Only reportable if the cluster tool is listed in the tab 'Cluster Tools for MH' in the Technical Output Specification.


Key measures

Out of Area Placements (OAPs)

An Out of Area Placement is when a patient is admitted to a unit that is not part of the usual local network of services. OAPs are currently submitted to NHS Digital via a separate collection on the Clinical Audit Platform (CAP), as well as via the MHSDS. In order to reduce burden on providers, we are working to eliminate the CAP collection so that you only have to submit this data once.

However, data on OAPs submitted to the MHSDS is not yet of sufficient quality to retire the separate collection. It is therefore vital that you use the resources below to familiarise yourself with how to report OAPs, as both the sender and the receiver of a patient in these circumstances.

You only need to report OAPs for adults whose care is commissioned by CCGs (i.e. not specialist care). Therefore, only OAPs within the following bed types should be reported to both the MHSDS and CAP:

  • general adult acute mental health
  • older adult acute mental health
  • Psychiatric intensive care unit (PICU)

Quick guide to submitting Out of Area Placements (OAPs) – high level summary of the required fields

Improving data quality of Out of Area Placements (OAPs) – more detail on how to report OAPs in the MHSDS

8 June 2021: Mental Health Services Dataset – Out of Area Placements (OAPs) webinar - overview of requirements and discussion of data quality issues

Out of Area Placements (OAPs)  - the CAP collection and background on OAPs. 

DQMI

The DQMI is the Data Quality Maturity Index and is a measure of completeness of the data you send to us. The fields that impact your DQMI score are listed in the DQMI Methodology guidance.  

Children and Young People (CYP) Access Measure

There are two measures that can be used to monitor the access of children and young people to mental health services:

MHS69 – The number of children and young people, regardless of when their referral started, receiving at least two contacts (including indirect contacts) and where their first contact occurs before their 18th birthday

MHS95 – Number of CYP aged under 18 supported through NHS funded mental health with at least one contact (12 month rolling)

Both measures require you to submit the tables MHS201CareContact and/or MHS204IndirectActivity. Contacts must have been attended (AttendOrDNACode is 5 or 6) and ConsMechanismMH must be 01 (Face to face), 02 (Telephone), 04 (Talk type) or 11 (Video call).

For more information see our Quick guide to submitting Children and Young People (CYP) Access measures.


Specialised commissioning

A dedicated workspace is available on the FutureNHS website to support data quality improvement for specialised commissioning.

To access the area:

  • if you already have a FutureNHS account, visit the workspace homepage
  • if you do not have a FutureNHS account but have an nhs.net or nhs.uk email account, you can register for access to the website
  • other users can request access by emailing Data-manager@future.nhs.uk

Last edited: 11 May 2022 5:57 pm