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.
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 |
| 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 |
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 an 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 [email protected]
Last edited: 23 October 2024 8:46 am