Skip to main content

Quick guide to submitting Children and Young People (CYP) Access measures

This guide was updated in May 2022 to reflect Version 5.0 of the dataset. Author: MHSDS Data Quality.

Summary

NHS Digital publishes two access measures for Children and Young People; 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 Digital 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 CCG of the patient for MHS95 (one contact measure).

Used to derive the CCG of the patient when GP is unknown for 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 GMPCodeReg

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: 

  • GP Practice Code not applicable - V81998 
  • GP Practice Code not known - V81999 
  • No Registered GP Practice - V81997
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
02 – Telephone
11 – Video consultation
04 – Talk type for a person unable to speak

MHS201CareContact AttendOrDNACode

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 
6 – Arrived late, after the relevant professional was ready to see the patient, but was seen

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.

Furthermore, 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 CCG is assigned

MHS69 uses the postcode of the GP to assign CCG, or the postcode of the patient if GP is unknown. MHS95 uses the postcode of the patient.

If there are no records against a CCG 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, so 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 wouldn’t count.

An alternative explanation is that the CCG is unknown because the GP and postcode of the patient are unknown (for MHS69) or because the postcode of the patient is unknown (for MHS95). If the CCG 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:

  1. 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.
  2. 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.
  3. 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: 11 May 2022 3:15 pm