Understanding how the Canonical (Common) Data Model supports reporting on equipment and assistive technology provision

The following CDM data tables are relevant to the provision of equipment and assistive technology.

This table contains the data items relating to a specific issuing of equipment to a subject of care. It is linked to an individual patient. The content of the table includes a SNOMED CT term relating to the item of equipment, an asset identifier and the issue date. It also includes the return date.

Data Item Name Data Item Definition National Code National Code Definition
Local Subject Of Care Identifier A number used to identify a Subject Of Care uniquely within a Health Care Provider. n/a n/a
Coded Physical Object (SNOMED CT) CODED PHYSICAL OBJECT (SNOMED CT) is the SNOMED CT® concept ID which is used to identify the Equipment Asset used during Patient Treatment or issued to Patient to support patient. n/a n/a
Equipment Asset Identifier The unique identifier for the Equipment Asset used during Patient Treatment or issued to Patient to support patient. n/a n/a
Equipment Issue Date The date equipment was issued to the Patient. n/a n/a
Equipment Returned Date The date equipment was returned by the Patient. n/a n/a
This table includes the SNOMED CT term relating the Assistive technology that is prescribed to a subject of care. It also includes the prescription date.

Data Item Name Data Item Definition National Code National Code Definition
Local Subject Of Care Identifier A number used to identify a Subject Of Care uniquely within a Health Care Provider. n/a n/a
Assistive Technology Finding (SNOMED CT) The SNOMED CT concept ID which is used to identify the Finding relating to the Assistive Technology that a PATIENT is dependent on. n/a n/a
Prescription Date (Assistive Technology) The date on which the PRESCRIPTION was signed by the CARE PROFESSIONAL for the prescription of Assistive Technology. n/a n/a
Details of a subject of care’s disability are held in this table. The information is held as a high-level disability code, which records a formal diagnosis of a disability or where the subject of care (or their proxy) considers themselves to be disabled.

Data Item Name Data Item Definition National Code National Code Definition
Local Subject Of Care Identifier A number used to identify a Subject Of Care uniquely within a Health Care Provider. n/a n/a
Disability Code The DISABILITY of a PERSON. This could be where: the PERSON has been diagnosed as disabled or the PERSON considers themself to be disabled. 01 Behaviour and Emotional
02 Hearing
03 Manual Dexterity
04 Memory or ability to concentrate, learn or understand (Learning Disability)
05 Mobility and Gross Motor
06 Perception of Physical Danger
07 Personal, Self Care and Continence
08 Progressive Conditions and Physical Health (such as HIV, cancer, multiple sclerosis, fits etc)
09 Sight
10 Speech
XX Other (not listed)
NN No DISABILITY
ZZ Not Stated (PERSON  asked but declined to provide a response)
Disability Impact Perception The patient’s perception of whether their day-to-day activities are limited because of a health problem or disability which has lasted, or is expected to last, at least 12 months. 01 Yes – limited a lot
02 Yes – limited a little
03 No – not limited
04 Prefer not to say (PATIENT asked but declined to provide a response)
The subject of care table holds the details of people who are in receipt of care.

Data Item Name Data Item Definition National Code National Code Definition
Local Subject Of Care Identifier A number used to identify a Subject Of Care uniquely within a Health Care Provider. n/a n/a
Organisation Identifier (Local Subject Of Care Identifier) ORGANISATION IDENTIFIER (LOCAL SUBJECT OF CARE IDENTIFIER) is the ORGANISATION IDENTIFIER of the Organisation that assigned the LOCAL SUBJECT OF CARE IDENTIFIER. n/a n/a
Organisation Identifier (Educational Establishment) ORGANISATION IDENTIFIER (EDUCATIONAL ESTABLISHMENT) is the ORGANISATION IDENTIFIER of the Educational Establishment, including Schools. n/a n/a
NHS Number The NHS NUMBER, the primary identifier of a PERSON, is a unique identifier for a PATIENT within the NHS in England and Wales. n/a n/a
NHS Number Status Indicator Code The trace status of the NHS number. 01 Number present and verified
02 Number present but not traced
03 Trace required
04 Trace attempted – No match or multiple match found
05 Trace needs to be resolved – (NHS Number or PATIENT detail conflict)
06 Trace in progress
07 Number not present and trace not required
08 Trace postponed (baby under six weeks old)
Subject Of Care Full Name The preferred FULL NAME of the Subject Of Care. n/a n/a
Lead Contact Full Name Subject Of Care LEAD CONTACT Full Name. n/a n/a
Subject Of Care Contact Primary Telephone Number Primary Phone Number used by the Subject Of Care. n/a n/a
Contact Email Address (Subject Of Care or Lead Contact) INTERNET E-MAIL ADDRESS of the Subject Of Care or the Subject Of Care lead contact who is the designated contact. n/a n/a
Subject Of Care Birth Date The date on which a Subject Of Care was born or is officially deemed to have been born. n/a n/a
Subject Of Care Stated Gender Code The gender of a Subject Of Care. SUBJECT OF CARE STATED GENDER CODE is self declared or inferred by observation for those unable to declare their SUBJECT OF CARE STATED GENDER. 1 Male
2 Female
9 Indeterminate (unable to be classified as either male or female)
X Not Known (PERSON STATED GENDER CODE not recorded)
Ethnic Category 2001 The 16+1 ethnic data categories defined in the 2001 census. A White – British
B White – Irish
C White – Any other White background
D Mixed – White and Black Caribbean
E Mixed – White and Black African
F Mixed – White and Asian
G Mixed – Any other mixed background
H Asian or Asian British – Indian
J Asian or Asian British – Pakistani
K Asian or Asian British – Bangladeshi
L Asian or Asian British – Any other Asian background
M Black or Black British – Caribbean
N Black or Black British – African
P Black or Black British – Any other Black background
R Other Ethnic Groups – Chinese
S Other Ethnic Groups – Any other ethnic group
Z Not stated
99 Not known
Ethnic Category The ethnic data categories defined in the latest approved data standard. (Note: This field is currently expected to contain the 2021 census list which needs to be approved). A01 White – English, Welsh, Scottish, Northern Irish or British
A02 White – Irish
A03 White – Gypsy or Irish Traveller
A04 White – Roma
A99 White – Any other White background
B01 Mixed – White and Black Caribbean
B02 Mixed – White and Black African
B03 Mixed – White and Asian
B99 Mixed – Any other Mixed or multiple ethnic background
C01 Asian or Asian British – Indian
C02 Asian or Asian British – Pakistani
C03 Asian or Asian British – Bangladeshi
C04 Asian or Asian British – Chinese
C99 Asian or Asian British – Any other Asian background
D01 Black, Black British, Caribbean or African – Caribbean
D01 Black, Black British, Caribbean or African – African
D99 Black, Black British, Caribbean or African – Any other Black, Black British, or Caribbean background
E01 Other ethnic group – Arab
E99 Other ethnic group – Any other ethnic group
Z98 Not stated
Z99 Not known
Language Code (Preferred) LANGUAGE CODE (PREFERRED) is the language the Subject of Care prefers to use for communication with a Health Care Provider. LANGUAGE CODE is based on the ISO 639-1 two character language codes, see the ISO 639.2 Registration Authority website, plus five communication method extensions. – For spoken languages, see ISO 639-1 codes at http://www.loc.gov/standards/iso639-2/php/code_list.php
– Extensions
q1 Braille (for people who are unable to see)
q2 American Sign Language
q3 Australian Sign Language
q4 British Sign Language
q5 Makaton (devised for children and adults with a variety of communication and Learning Disabilities)
Death Location Type Code (Preferred) The preferred location of death as specified by the PATIENT, Patient Proxy or Carer. 10 Hospital
20 Private Residence
21 PATIENT’s own home
22 Other private residence (e.g. relative’s home, Carer’s home)
30 Hospice
40 Care Home
41 Care Home Services with Nursing
42 Care Home Services without Nursing
50 Other (not listed)
99 The CARE PROFESSIONAL did not discuss the preferred LOCATION of death prior to the death of the PATIENT
Subject Of Care Death Date The date on which a Subject Of Care died or is officially deemed to have died, as recorded on the death certificate. n/a n/a
Death Location Type Code (Actual) The actual location where the Subject of Care died. 10 Hospital
20 Private Residence
21 PATIENT’s own home
22 Other private residence (e.g. relative’s home, Carer’s home)
30 Hospice
40 Care Home
41 Care Home Services with Nursing
42 Care Home Services without Nursing
50 Other (not listed)
Death Not at Preferred Location Reason The reason why the Subject of Care did not die at their preferred LOCATION of death. 01 Family decided to move PATIENT to hospital
02 PATIENT was moved to hospital for clinical reasons
03 PATIENT changed their mind
04 Capacity not available at preferred LOCATION
05 Transfer delays
06 Social support issues
07 Need for access to adequate pain relief
98 Other (not listed)
Religious Or Other Belief System Affiliation Code The RELIGIOUS OR OTHER BELIEF SYSTEM AFFILIATION of a PERSON, as specified by a PERSON. – For current list of RELIGIOUS OR OTHER BELIEF SYSTEM AFFILIATION CODEs see https://www.datadictionary.nhs.uk/data_elements/religious_or_other_belief_system_affiliation_code.html?hl=religious%2Cother%2Cbelief%2Csystem%2Caffiliation%2Ccode
Subject Of Care Stated Sexual Orientation Code The sexual orientation stated by a Subject Of Care. 1 Heterosexual or Straight
2 Gay or Lesbian
3 Bisexual
4 Other sexual orientation not listed
U PERSON asked and does not know or is not sure
Z Not Stated (PERSON asked but declined to provide a response)
9 Not Known (Not Recorded)

Personalised care and support planning for people with severe mental illness

A review of a sample of current care plans, and the way they have been developed, may be helpful in identifying the priorities for this improvement. The PRSB Implementation Guide provides more detailed explanations about each element of the plan, including advice on how the planning process might be best conducted.
These questions might form a checklist for current plans to be compared with. 

1. Does the plan include an About Me section in which the service user, in their own words, can indicate the information they want to be available about their lives, their values, their interests, and priorities, available for all those who may care for them?
2. Is the approach to developing a care plan patient centred and engaging, allowing plans to be based on patient priorities goals, and aspirations, along with the actions they plan to take and the support that they will receive?
3. Is there space for a “formulation” to be recorded in which the person receiving care and the professionals who provide it, share and record the personal meaning and the origins of the person’s difficulties?
4. Are relevant procedures and therapies recorded?
5. Where relevant, are one or more contingency plans included for anticipatable disruptions, exacerbations, or deterioration, and do they include advice on what to do and points of contact for those called upon to respond?
6. Where relevant are additional supporting plans incorporated, (an example being an “educational and health plan” for someone with a neurodevelopment disorder)
7. Is a version of the plan available to a service user (if they wish to have it) in a form and format that they can understand and find to be of value?
8. How is a version of the plan available to the GP and other key parts of the health and care system?

Work conducted by PRSB and partners recently has looked specifically at the suitability of this approach to the development and documentation of care and support plans for people with Severe Mental Illness. This resulted in an updated version of the standard (v1.4), for use by any service and for any group of service users, but with some modifications to ensure that it meets the needs of this community. The approach to a patient centred process of identifying goals, hopes, and values, and the support needed to achieve them, is fully compatible with and can be conducted using, specific tools in use in mental health, such as DIALOG, DIALOG+, and ReQoL, for example. 

Where analysis indicates the need for improvement in the content and process of personalised care and support planning for patients with Severe Mental Illness, specific improvement projects should be instituted to co-design with service users and their representatives, and the relevant staff groups, new approaches, and documentation that would be of value in delivering improvement. The toolkit includes a range of existing resources that could be used to engage in this improvement work, including signposting to relevant existing approaches informed by patient experience-based design.

Moving to a single holistic plan

A review of a sample of current care plans, and the way they have been developed, may be helpful in identifying the priorities for this improvement. The PRSB Implementation Guide provides A key development, consistent with national policy on support for Personalised Care across all health and care sectors, is the move towards an individual with complex needs having a single, integrated, care plan, rather than a series of plans developed by different parts of the health and social care system in isolation of one another. For a patient with severe mental illness, the related concerns and challenges might form a very prominent part of such an integrated plan; many will also have concurrent health challenges and needs. The intention is that the relevant services work together to plan and wrap support around the patient and their family in an integrated way, rather than as a series of sequential or disconnected encounters in which the service user or their friends and family have to adopt the role of the integrator.

A starting point would be to agree priority groups of service users who may already have more than one care plan because they need care from more than one part of the system of health and social care. This could be initiated by looking at service users registered with some sentinel practices or PCNs. Alternatively, the approach might focus initially on people with defined co-morbidity or risk that entails collaborative care with agencies beyond specialist mental health services.

The focus here is on the process of care planning and agreement on what should be shared, rather than solely on the technology used;

1. What is the process to agree which professional will initiate care planning and act as the “lead point of contact” for the service user?
2. Will initial plans be agreed with the service user in joint consultations or sequentially? Where and how will they be conducted?
3. What will be the process to agree the elements of the plans which should be available to professionals and potential authorised users beyond the immediate care teams, (A&E services, Ambulance Services, Social services, etc.) with the service user’s consent?
4. How will elements of the plan be updated following consultations in a way which is proportionate, to allow contact and progress notes to be maintained by the service conducting the consultation, whilst avoiding unnecessary work for partners in care if there is no significant change to the personalised care and support plan?
5. What are the implications for workload, logistics, and administration arising out of these decisions?

The answers to these questions and others will best be elicited through focused joint working, grounded in real, or at least realistic examples. This will entail process mapping, and co-design with a range of professionals, service users, and families. Resources from the toolkit and outputs from the Simulation element of this project will be valuable. Some organisations would adopt an approach such as a Rapid Process Improvement Workshop, planned over several weeks and conducted over a number of sequential days, to develop prototype ways of working that could be tested in the field.

“If someone’s been working for a period of time, in a form of therapy, for instance, where there’s an agreed plan for the locality when they may present in an emergency situation … then it’s really important for us to be able to see that that information and be able to act appropriately according to that because, you know, there isn’t and there shouldn’t be a stock response to that. These plans are designed to be individualised and personalised.  All services should be giving that personalised approach to care wherever possible. And a standard such as [PCSP standard] definitely moves us closer towards being able to do that. [Not acting on agreed plans] is a key finding in terms of emergency responses over the years where responses have been inappropriate.” – Mental Health Nurse

“Following a particular plan that’s been put into place will result in much better outcomes and prevent the sort of poor outcome which would otherwise be leading to an unplanned hospital admission.” – General Practitioner