Mental Health Datasets contain historic data on patients receiving care in NHS specialist mental health services.

MDW Discover  > Genomics England - Secondary Data - MHSDS @ 383

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://re-docs.genomicsengland.co.uk/

https://vimeo.com/811271386/c516b8e82e

HDR UK

Genomics England

Participant Identifier (supplied by Genomics England)

participant_id

mhsds_assigned_care_professional

A nationally unique ID for the patient in the MHSDS generated from an index held by the BSP.

uniqmhsdspersid

A unique ID applied when original data file was uploaded to the Bureau Service Portal. Where a single upload is used to provide data for different reporting periods, there will be a separate BSPUniqueID assigned to each reporting period.

bspuniqid

The end date of an assignment of a Care Professional responsible for the care of the patient.

enddateasscareprof

An indication of whether the submitted file is a "Primary" or "Refresh" submission.

file_type

Financial year for which YTD data is based on

financialyear_identifier

An indication of the last good file for the provider

ic_use_submission_flag

A unique row count for this table. This continues across reporting periods and across providers. This uniquely identifies a row of data within this table.

mhs503uniqid

An incremental month number, with month 0001 being April 1900.

month_id

A representation of the month e.g. M01 = April

month_identifier

Calendar month for which YTD extract was based on

month_name

This is the Organisation Code of the Organisation acting as a Health Care Provider. Derived from submitted Header record within submission.

orgcodeprov

This is the Organisation Identifier of the Organisation acting as a Health Care Provider. Derived from submitted Header record within submission.

orgidprov

A unique local Care Professional Identifier within a Health Care Provider which may be assigned automatically by the computer system.

pcareproflocalid

A unique identifier for each Hospital Provider Spell for a Health Care Provider.

phospprovspellnum

To uniquely identify the hospital provider spell

puniqhospprovspellnum

puniqservreqid

This is a unique ID, which identifies each flowed MHSDS record. The rows in the MHS001MPI and associated episode and event tables that make up a single MHSDS record are linked via the Record Number

recordnumber

The start date of an assignment of a Care Professional responsible for the care of the patient.

startdateasscareprof

This is the Treatment Function under which the Patient is treated. It may be the same as the Main Specialty Code or a different Treatment Function which will be the Care Professional's treatment interest.

treatfunccodemh

mhsds_care_activity

A unique ID applied when original data file was uploaded to the Bureau Service Portal.

The duration of a care activity in minutes, excluding any administration time prior to or after the care activity and the care professional's travelling time to the location where the care activity was provided. This is calculated from the Start Time and End Time of the care activity.

clincontactdurofcareact

A unique identifier for a finding from a specific classification or clinical terminology.

codefind

A unique identifier for an observation from a specific clinical terminology.

codeobs

codeproc

The SNOMED CT expression which is used to identify a procedure plus the status of the procedure.

codeprocandprocstatus

findschemeinuse

mhs202uniqid

A representation of the most recent final data e.g. M01 = April

Calendar month representation of most recent final data

obsschemeinuse

The numeric value resulting from a clinical observation.

obsvalue

This is the Organisation Code of the Organisation acting as a Health Care Provider. This is the organisation code that will be concatenated with any Local Patient Identifiers to form a unique "Local Patient Identifier" within the national database

This is the organisation identifier of the organisation acting as a Health Care Provider. Derived from submitted Header record within submission.

The unique identifier for a Care Activity. It would normally be automatically generated by the local system upon recording a new activity, although could be manually assigned.

pcareactid

The Care Contact Identifier is used to uniquely identify the Care Contact within the Health Care Provider. It would normally be automatically generated by the local system upon recording a new Care Contact, although could be manually assigned.

pcarecontactid

procschemeinuse

puniqcareactid

puniqcarecontid

mhsds_care_cluster

Adult Mental Health Care Cluster Code (Final) is the final allocation of the Adult Mental Health Care Cluster Code by the Care Professional. The determination of the Adult Mental Health Care Cluster Code may or may not have involved the use of the National Tariff Payment System clustering algorithm.

amhcareclustcodefin

Child and Adolescent Mental Health Care Cluster Code (Final), is the final allocation of the Child and Adolescent Mental Health Care Cluster Code by the Care Professional.

camhcareclustcodefin

The Child and Adolescent Mental Health Needs Based Grouping code allocated to the child or young person by the Care Professional.

camhneedsbasedgroupingcode

Number of days the Care Cluster was open within the reporting period.

clusterdaysrp

A flag to indicate whether the Care Cluster ended within the reporting period.

clusterendrpflag

A flag to indicate whether the Care Cluster  was open at the end of the reporting period.

clusteropenendrpflag

A flag to indicate whether the Care Cluster started within the reporting period.

clusterstartrpflag

The date on which the assignment of a patient to a Care Cluster ended.

enddatecareclust

The time on which the assignment of a patient to a Care Cluster ended.

endtimecareclust

Forensic Learning Disabilities Care Cluster Code (Final) is the final allocation of the Forensic Learning Disabilities Care Cluster Code by the Care Professional.

fldcareclustcodefin

Forensic Mental Health Care Cluster Code (Final) is the final allocation of the Forensic Mental Health Care Cluster Code by the Care Professional.

fmhcareclustcodefin

Where this field is populated, it indicates what date this open episode would become inactive if it didn't flow again. The date will be set as the last date of the month in which the record flowed plus 1 day. Where the Inactive_Timestamp is null, this indicates the episode was ended in the submission and is not expected to flow again

inactive_timestamp

Learning Disabilities Care Cluster Code (Final) is the final allocation of the Learning Disabilities Care Cluster Code by the Care Professional.

ldcareclustcodefin

mhs803uniqid

A unique identifier for each clustering tool assessment that takes place for each patient.

pclustid

puniqclustid

The date on which the assignment of a patient to a Care Cluster started.

startdatecareclust

The time on which the assignment of a patient to a Care Cluster started.

starttimecareclust

mhsds_care_contact

This is recorded for Patient Activity. A Patient who is an Overseas Visitor does not qualify for free NHS healthcare and can choose to pay for NHS treatment or for private treatment. If they pay for NHS treatment then they should be recorded as NHS Patients. The Patient's Administrative Category Code may change during an episode or spell. For example, the Patient may opt to change from NHS to private health care. In this case, the start and end dates for each new Administrative Category Period (episode or spell) should be recorded. The category 'amenity Patient' is only applicable to Patients using a Hospital Bed.

admincatcode

agecarecontdate

This indicates whether or not an Appointment for a Care Contact took place. If the Appointment did not take place it also indicates whether or not advanced warning was given.

attendordnacode

The date that a Care Contact was cancelled by the Provider or Patient.

carecontcanceldate

The reason that a Care Contact was cancelled.

carecontcancelreas

The date on which a Care Contact took place, or, if cancelled, was scheduled to take place.

carecontdate

The person who was the subject of the Care Contact.

carecontsubj

The time at which a Care Contact took place.

careconttime

The total duration of the direct clinical contact at a Care Contact in minutes, excluding any administration time prior to or after the Care Contact and the Care Professional's travelling time to the Care Contact. Clinical Contact Duration of Care Contact includes the time spent on the different Care Activities that may be performed in a single Care Contact. The duration of each Care Activity is recorded in Clinical Contact Duration of Care Activity. This should be recorded in minutes.

clincontdurofcarecont

Identifies the communication mechanism used to relay information between the Care Professional and the Person who is the subject of the consultation, during a Care Activity. The telephone or telemedicine consultation should directly support diagnosis and care planning and must replace a face to face Out-Patient Attendance Consultant, Clinic Attendance Nurse or Clinic Attendance Midwife, types of Care Activity. A record of the telephone or telemedicine consultation must be retained in the Patient's records. Telephone contacts solely for informing Patients of results are excluded.

consmediumused

The type of consultation between the Care Professional and the Patient.

constype

The earliest Date that it was clinically appropriate for an Activity to take place.

earliestclinappdate

The date of the earliest of the Reasonable Offers made to a Patient for an Appointment or Elective Admission.

earliestreasonofferdate

An indicator of whether a Care Activity was delivered as Group Therapy. Group Therapy is a Session where more than one Patient attends at the same time, to see one or more Care Professionals. Clinical notes are recorded in each individual Patients's casenotes.

grouptherapyind

Local Area Team (Organisation Code (Code of Commissioner))

locareateamorgcodecomm

mhs201uniqid

Genomics England - Secondary Data - MHSDS

mhsds_curated_inpatient

mhsds_indirect_activity

mhsds_ward_stay

mhsds_service_or_team_type_referred_to

mhsds_care_programme_approach_review

mhsds_secondary_diagnosis

mhsds_other_in_attendance

mhsds_primary_diagnosis

mhsds_care_plan_type

mhsds_onward_referral

mhsds_care_coordinator

mhsds_gp_practice_registration

mhsds_master_patient_index

mhsds_provisional_diagnosis

mhsds_service_or_team_referral

mhsds_patient_indicators

mhsds_responsible_clinician_assignment

mhsds_care_programme_approach_care_episode

mhsds_discharge_plan_agreement

mhsds_referral_to_treatment

mhsds_medical_history_previous_diagnosis

mhsds_curated_assessment_diagnoses_and_cluster

mhsds_crisis_plan

mhsds_coded_score_assessment_clustering_tool

Carries details of each Commissioner Assignment Period during a Hospital Provider Spell. One record per commissioner assignment period.

Genomics England - Secondary Data - MHSDS

Documentation

Coverage

Provenance

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin