Children and Young People (CYP) Access measures quick guide to submitting data
This guide was updated in May 2024 to reflect Version 6.0 of the dataset. Author: Mental Health, NHS Talking Therapies and Learning Disability and Autism Analysis Team, NHS England
Summary
NHS England publishes two access measures for Children and Young People (CYP; a two-contact measure and a one-contact measure:
MHS69 – The number of CYP receiving at least two contacts, where their first contact occurs before their 18th birthday
MHS95 – The number of CYP aged under 18 with at least one contact in a 12-month rolling period
These are published in the MHSDS monthly publication.
Either measure may be used for monitoring purposes. Ensure that all parties agree on which measure is being used in any discussions on performance.
MHSDS data items needed for these measures
The table below lists all MHSDS fields needed by NHS England to compile these measures, alongside the mandatory tables and data items needed to make a submission to the MHSDS. More information can be found in the MHSDS User Guidance and Technical Output Specification.
Data needed for recording CYP Access
| Table | Field | Notes specific to CYP Access |
|---|---|---|
| MHS001MPI | LocalPatientId | Locally generated and used to uniquely identify a patient in your organisation. This should not be the NHS number. |
| MHS001MPI | OrgIDLocalPatientId | ODS code of your organisation. |
| MHS001MPI | NHSNumber | Please submit if you have it. Used with Gender and PersonBirthDate to identify the patient. |
| MHS001MPI | PersonBirthDate | Used to calculate patient age. |
| MHS001MPI | Postcode |
Used to derive the sub-ICB of the patient when GP is unknown for MHS95 (one contact measure) and MHS69 (two contacts measure). |
| MHS001MPI | Gender | Please submit all three Gender fields if you have the information (GenderIDCode, GenderSameAtBirth, Gender). Gender is used to identify the patient, but the other gender fields are best practice on how to record this data. For more information see Guidance on collecting and submitting data for the data items on gender within the MHSDS v5.0. |
| MHS002GP | LocalPatientId | Locally generated and used to uniquely identify a patient in your organisation. This should not be the NHS number. |
| MHS002GP | GMPReg |
This is the organisation code of the GP practice the patient is registered with. It is used to derive the CCG of the patient for MHS69 (two contacts measure). If you do not know the code, these can be found in the epraccur file on our GP and GP practice related data page. Default codes accepted are:
|
| MHS101Referral | ServiceRequestId | Locally generated and used to uniquely identify a referral for a patient in your organisation. |
| MHS101Referral | LocalPatientId | Locally generated and used to uniquely identify a patient in your organisation. This should not be the NHS number. |
| MHS101Referral | ReferralRequestReceivedDate | Used alongside PersonBirthDate to assess age at referral. |
| MHS101Referral | OrgIDComm | ODS code of organisation commissioning the care. |
| MHS201CareContact | CareContactId | Locally generated and used to uniquely identify the care contact for this referral in your organisation. |
| MHS201CareContact | ServiceRequestId | Locally generated and used to uniquely identify a referral for a patient in your organisation. |
| MHS201CareContact | CareContDate | Used to identify contacts in the reporting period. |
| MHS201CareContact | ConsMechanismMH |
Only contacts where the following codes have been used are counted. If this field is blank the contacts will not be counted. 01 – Face to Face |
| MHS201CareContact | AttendStatus |
Only contacts where the following codes have been used are counted. If this field is blank the contacts will not be counted. 5 – Attended on time or, if late, before the relevant professional was ready to see the patient |
For a patient referral, if there is activity by clinicians that directly benefits the patient but where the patient is not present, this can be recorded in the table MHS204IndirectActivity. For example, this could include where multi-disciplinary teams meet to discuss a patient who is not present at the meeting. Data that relates to contact with family members and carers (not as a proxy for the patient) would also be recorded in this table.
You only need to populate this table if you have indirect activity in your organisation.
| Table | Field | Notes specific to CYP Access |
|---|---|---|
| MHS204IndirectActivity | ServiceRequestId | Used to identify the referral for this patient. |
| MHS204IndirectActivity | IndirectActDate | Used to identify indirect activity in the reporting period. |
The following 4 tables need to be submitted in each submission with their respective mandatory and required fields. More information can be found in the MHSDS User Guidance and Technical Output Specification.
| Table | Description |
|---|---|
| MHS000Header | Uniquely identifies each MHSDS submission made by the provider. |
| MHS001MPI | Uniquely identifies every patient and records personal details of each patient. |
| MHS002GP | Records details of the GP of every patient. |
| MHS101Referral | Records details of referrals made for the patient. |
Additional information about the measures
Consultation Mechanism MH and Attend or DNA Code must be filled in with the values in the table above for the contacts to count.
If a provider has made resubmissions since the publication cut-off date, this data will be included in the monthly publication when the files are refreshed at the end of the financial year and labelled as End of Year Final. Only data submitted before the relevant cut-off date for publication is included in the data files labelled as Performance and Provisional.
Measure calculation
The full SQL code for both measures can be found in the MHSDS monthly metadata file. MHS69 can be found in the ‘Access and Waits’ tab and MHS95 is in the ‘NHSE measures’ tab.
How Sub-ICB is assigned
MHS69 and MHS95 both the postcode of the GP to assign Sub-ICB, or the postcode of the patient if GP is unknown. Previously Sub-ICB (CCG) for MHS95 was based on the postcode of the patient. The change to Sub-ICB allocation for MHS95 was implemented in April 2024. Learn more about the methodological change notice.
If there are no records against a Sub-ICB for a certain provider, this may be because the number of patients meeting the criteria is 0, which when suppressed becomes *. The lack of records for MHS69 for a provider may be because a person can only appear once per financial year. If they were already recorded by another provider then they would not be included again, or if a contact was booked but not attended then this also would not count.
An alternative explanation is that the Sub-ICB is unknown because the GP and postcode of the patient are unknown. If the Sub-ICB cannot be derived from these fields, then the data can be reported on at the level of the provider but not at the commissioner breakdown.
How the second contact is allocated for MHS69
MHS69 counts the second contact each financial year. If a patient has already had two contacts, then the counts reset each financial year, so they need two contacts within the year. In other words, a patient’s second ever contact will count regardless of when their first contact was (as long as it was before their 18th birthday). After that, they will be counted again only if they have two contacts in the same financial year. Therefore, if one organisation sees a patient for their second contact first, that patient won’t be counted again towards a different organisation that financial year.
For example:
- Person age 17 has one contact in 19/20. Person turns 18 and has second contact in 20/21. This contact counts as the second contact. In 21/22, person is now 19, has two more contacts – doesn’t count.
- Person age 16 has two contacts in 19/20 – counts as second contact. Person turns 17 and has two more contacts in 20/21 – counts as second contact.
- Person age 16 has two contacts in 19/20 – counts as second contact. Person turns 17 and has one contact in 20/21 – doesn’t count because already had second contact and didn’t have two in one financial year. Person turns 18 in 21/22 and has two contacts – doesn’t count because they weren’t under 18 for the first of these two contacts.
Last edited: 7 April 2025 11:10 am