The main programme data dictionary for the Genomics England Research Environment.
TODO: The license URL
TODO: A human-readable description of rights
Genomics England Main Programme Data
definition
alternative term
source
database_cross_reference
comment
see also
answer type
formula
internal ID
measurement time
number of cohorts
question description
use cases requirements
value
is about
has target
measurement of
output of
GECKO:0000052
Administrative
administrative
GECKO:0000052
survey administration
GECKO:0000052
episode_matched
episode_matched
GECKO:0000052
survey administration
a score is attributed to each part of the linking process, where the quality of the match is denoted by the rank, with the lowest rank (i.e. 1) being the highest quality match. The scores for each possible match are compared and the highest match is chosen.
GECKO:0000052
EPISODE MATCH RANK
episode_match_rank
GECKO:0000052
survey administration
Indicates the date and time at which the record was last modified
GECKO:0000052
modified_date
modified_date
GECKO:0000052
survey administration
GECKO:0000052
Hesid Rank
hesid_rank
GECKO:0000052
survey administration
Indicates whether the patient has died since completing Q1 (taken from mortality data)
GECKO:0000052
patient_death
patient_death
GECKO:0000052
survey administration
Indicates whether or not an eligible PROMs procedure has been identified as a revision, as opposed to a primary, procedure. For those procedures (currently varicose vein and groin hernia) where the primary/revision distinction does not apply, this field will be set to 0.
GECKO:0000052
Procedure Revision Flag
proc_revision_flag
GECKO:0000052
survey administration
Code identifying the type of procedure the patient underwent
GECKO:0000052
Proms Procedure Code
proms_proc_code
GECKO:0000052
survey administration
Code identifying the type of procedure the patient underwent
GECKO:0000052
proms_proc_group
proms_proc_group
GECKO:0000052
survey administration
Unique Record Identifier
GECKO:0000052
proms_serial_no
proms_serial_no
GECKO:0000052
survey administration
Gender of participant
GECKO:0000060
Gender
gender
GECKO:0000060
gender
Code as shown in submission. Field undergoes hard validation during data submission process. Must contain one of the nationally defined codes otherwise data will not be uploaded. Valid codes are: 0,1,2,9
GECKO:0000060
Gender Code
did_gender_code
GECKO:0000060
gender
Descriptive field, based on submitted Gender Code and converted to one of the following groupings: 0: Not known 1: Male 2: Female 9: Not specified
GECKO:0000060
Gender Description
ic_gender_desc
GECKO:0000060
gender
GECKO:0000052
HESID Matched
hesid_matched
GECKO:0000052
survey administration
GECKO:0000052
Admissions; Period of Care
admissions_period_of_care
GECKO:0000052
survey administration
This field contains a code which identifies where the patient was immediately prior to admission. Most patients are admitted from home, but there are some significant exceptions. In particular, this field differentiates between patients admitted from home and patients transferred from another hospital provider or institution.
GECKO:0000052
Admission source
admisorc
GECKO:0000052
survey administration
This field contains a code which identifies how the patient was admitted to hospital. Admimeth is recorded on the first and also all subsequent episodes within the spell (ie where the spell is made up of more than one episode).
GECKO:0000052
Method of admission
admimeth
GECKO:0000052
survey administration
This field indicates whether the episode falls within a sequence of regular day and night admissions and, if so, whether it is the first or subsequent episode within the sequence.
GECKO:0000052
First regular day or night admission
firstreg
GECKO:0000052
survey administration
This field returns the elecdurd but excludes non-elective and planned admissions -
so only includes where the method of admission is 11 or 12. This is only calculated on the first episode in a hospital provider spell, and regular admissions are also excluded.
STATO:0000093
Calculation of Elecdur
elecdur_calc
STATO:0000093
date and time-related information
This submitted field contains the difference in days between the date on which it was decided to admit the patient (elecdate) and the actual admission date (admidate). Elecdur is only applicable where an elective admission (ie the admission method is 11, 12 or 13) was scheduled and took place.
STATO:0000093
Duration of elective wait (submitted)
elecdur
STATO:0000093
date and time-related information
This field contains the date the patient was admitted to hospital at the start of a hospital spell. Admidate is recorded on all episodes within a spell.
STATO:0000093
Date of admission
admidate
STATO:0000093
date and time-related information
This field contains the date on which a consultant, or another member of the clinical staff, decided to admit the patient to a hospital. The patient may or may not be admitted immediately. The time between elecdate and admidate (admission date) is known as the waiting time.
STATO:0000093
Date of decision to admit
elecdate
STATO:0000093
date and time-related information
Financial Year|Financial Year of activity
STATO:0000093
Financial Year
fyear
STATO:0000093
date and time-related information
PATO:0000011
Age Bands
age_bands
PATO:0000011
age/birthdate
Based on submitted Person Birthdate, converted to age bands: 0-9, 10-19, 20-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80-89, 90 and over, Age not known Person Birthdate is hard validated. This means it must be in the correct format CCYY-MM-DD and must be: <= Diagnostic Test Date‚Ä®<= Today‚Ä®<= Service Report Issue Date Person Birthdate can be left blank If values are incorrect data will not upload
PATO:0000011
Age Band 10 years
ic_age10
PATO:0000011
age/birthdate
Rules for deriving referrer type are: GP (where referrer code is G followed by a number) Consultant (where referrer code is C followed by a number, includes C9999998 - consultant general medical council reference number not known EXCLUDES CD999998) Nurse (where referrer code starts with a 2 digit number) Physio (where referrer code starts with PH followed by a number)Not known (null or X9999998)
PATO:0000011
Age Band 5 years
ic_age5
PATO:0000011
age/birthdate
Based on submitted Person Birthdate, converted to age bands: 0-15, 16-60, 61 and over, Age not known Person Birthdate is hard validated. This means it must be in the correct format CCYY-MM-DD and must be: <= Diagnostic Test Date‚Ä®<= Today‚Ä®<= Service Report Issue Date Person Birthdate can be left blank If values are incorrect data will not upload
PATO:0000011
ic_age17_60
ic_age17_60
PATO:0000011
age/birthdate
Based on submitted Person Birthdate, converted to age bands: 0-15, 16-60, 61 and over, Age not known Person Birthdate is hard validated. This means it must be in the correct format CCYY-MM-DD and must be: <= Diagnostic Test Date‚Ä®<= Today‚Ä®<= Service Report Issue Date Person Birthdate can be left blank If values are incorrect data will not upload
PATO:0000011
ic_age17_64
ic_age17_64
PATO:0000011
age/birthdate
Based on submitted Person Birthdate, converted to age bands: 0-18, 19 – 49, 50 – 74, 75 and over, Age not known Person Birthdate is hard validated. This means it must be in the correct format CCYY-MM-DD and must be: <= Diagnostic Test Date
<= Today
<= Service Report Issue Date Person Birthdate can be left blank If values are incorrect data will not upload
PATO:0000011
ic_age50_74
ic_age50_74
PATO:0000011
age/birthdate
Based on submitted Person Birthdate, converted to age bands: 0, 1-4, 5-9, 10-15, 16 and over, Age not known Person Birthdate is hard validated. This means it must be in the correct format CCYY-MM-DD and must be: <= Diagnostic Test Date
<= Today
<= Service Report Issue Date
Person Birthdate can be left blank
If values are incorrect data will not upload
PATO:0000011
ic_agechild
ic_agechild
PATO:0000011
age/birthdate
GECKO:0000052
Appointments
appointments
GECKO:0000052
survey administration
Describes the terms of reference for the referral request.
GECKO:0000052
Service type requested
servtype
GECKO:0000052
survey administration
The date when an appointment was scheduled.
STATO:0000093
Appointment date
apptdate
STATO:0000093
date and time-related information
A field derived from First Attendance (firstatt) and Attended or Did Not Attend (attended), used to identify if the attendance occurred and whether it was the first or subsequent.
GECKO:0000052
Attendance type
atentype
GECKO:0000052
survey administration
This indicates whether or not a patient attended for an appointment. If the patient did not attend it also indicates whether or not advanced warning was given.
GECKO:0000052
Attended or did not attend
attended
GECKO:0000052
survey administration
Gives information about the type of care professional staff dealing with the patient during a consultant outpatient attendance, or nurse or midwife contact.
GECKO:0000073
Medical staff type seeing patient
stafftyp
GECKO:0000073
physician/practitioner info
This records the outcome of an outpatient attendance.
GECKO:0000052
Outcome of attendance
outcome
GECKO:0000052
survey administration
This is the priority of a request for services; in the case of services to be provided by a consultant, it is as assessed by or on behalf of the consultant.
GECKO:0000052
Priority type
priority
GECKO:0000052
survey administration
A classification for use within CDS messages of the physical location within which the recorded patient event occurs.
GECKO:0000052
Location Class
locclass
GECKO:0000052
survey administration
This records the type of location. The definition of this field is currently under review.
GECKO:0000052
Location Tyoe
loctype
GECKO:0000052
survey administration
The General Medical Practitioner PPD code of the GP specified by the patient, which identifies the GP as an individual. This GP works within the General Medical Practice with which the patient is registered.
This field contains sensitive data. Access to it requires the approval of The Independent Group Advising on the Release of Data (IGARD).
GECKO:0000073
Code of patient's registered or referring general medical practitioner
reggmp
GECKO:0000073
physician/practitioner info
GECKO:0000052
Attendances
attendances
GECKO:0000052
survey administration
The source of referral for each A&E episode.
GECKO:0000052
Source of referral for A&E
aerefsource
GECKO:0000052
survey administration
Classification of the place where the incident occurred that led to an A&E episode.
GECKO:0000052
Incident location type
aeincloctype
GECKO:0000052
survey administration
The time that a patient's A&E attendance ends or when treatment in A&E is completed (whichever is the later).
STATO:0000093
Conclusion time
concltime
STATO:0000093
date and time-related information
The mode by which a patient arrived at an A&E department.
GECKO:0000052
Arrival mode
aearrivalmode
GECKO:0000052
survey administration
A "yes/no" flag, derived from AEATTENDCAT, enabling a count of unplanned attendances to be made.
GECKO:0000052
Attendances excluding planned
aeattend_exc_planned
GECKO:0000052
survey administration
An indication of whether a patient is making an initial or follow-up attendance within a particular A&E Department. The first attendance (1) is the first in a series, or the only attendance, in a particular A&E Episode. A planned follow-up A&E attendance (2) is a subsequent planned attendance at the same department, and for the same incident as the first attendance. An unplanned follow-up A&E attendance (3) is a subsequent unplanned attendance at the same department, and for the same incident as the first attendance.
GECKO:0000052
Attendance category
aeattendcat
GECKO:0000052
survey administration
The way in which an A&E attendance might end.
GECKO:0000052
Attendance disposal
aeattenddisp
GECKO:0000052
survey administration
The arrival date of a patient in the A&E department.
STATO:0000093
Arrival date
arrivaldate
STATO:0000093
date and time-related information
The time the patient self presented at the A&E Department or arrived in an ambulance at the A&E Department.
STATO:0000093
Arrival time
arrivaltime
STATO:0000093
date and time-related information
The time, recorded using a 24 hour clock, that the patient is seen by a health professional to diagnose the problem and arrange or start tests and start definite treatment as necessary.
STATO:0000093
Time seen for treatment
trettime
STATO:0000093
date and time-related information
The time (expressed as a whole number of minutes) between the patient‚Äö√Ñôs arrival and conclusion of their attendance or treatment (whichever is later).
STATO:0000093
Duration to conclusion
concldur
STATO:0000093
date and time-related information
The time (expressed as a whole number of minutes) between the patient‚Äö√Ñôs arrival, and the time the A&E attendance has concluded and the department is no longer responsible for the care of the patient.
STATO:0000093
Duration to departure
depdur
STATO:0000093
date and time-related information
The time (expressed as a whole number of minutes) between the patient‚Äö√Ñôs arrival and their initial assessment.
STATO:0000093
Duration to assessment
initdur
STATO:0000093
date and time-related information
The time (expressed as a whole number of minutes) between the patient‚Äö√Ñôs arrival (arrivaltime) and the start of their treatment (trettime).
STATO:0000093
Duration to treatment
tretdur
STATO:0000093
date and time-related information
A classification of A&E department type according to the activity carried out.
GECKO:0000052
Department type
aedepttype
GECKO:0000052
survey administration
A&E departure time is the time that a patient leaves the A&E department after an A&E attendance has concluded and the department is no longer responsible for the care of the patient. Temporary absences from the A&E department are ignored. For example, during an A&E attendance the patient may leave the department for a short time for an X-ray, but they remain under the care of an A&E consultant. Note that A&E Attendance Conclusion time and A&E Departure times will be different for patients who wait for transport or who are lodged patients prior to admission to a ward.
STATO:0000093
Departure time
deptime
STATO:0000093
date and time-related information
A coded classification to identify the reason for an Accident and Emergency Episode.
GECKO:0000052
Patient group
aepatgroup
GECKO:0000052
survey administration
The time when a patient is assessed by medical or nursing staff in an A&E department to determine priority for treatment. The assessment should be conducted by medical or nursing staff who have received appropriate training in triage.
STATO:0000093
Initial assessment time
inittime
STATO:0000093
date and time-related information
GECKO:0000052
Augmented/critical care period
augmented_critical_care_period
GECKO:0000052
survey administration
STATO:0000093
depdays_2
depdays_2
STATO:0000093
date and time-related information
STATO:0000093
depdays_3
depdays_3
STATO:0000093
date and time-related information
STATO:0000093
depdays_4
depdays_4
STATO:0000093
date and time-related information
STATO:0000093
intdays_8
intdays_8
STATO:0000093
date and time-related information
STATO:0000093
depdays_5
depdays_5
STATO:0000093
date and time-related information
STATO:0000093
depdays_6
depdays_6
STATO:0000093
date and time-related information
STATO:0000093
depdays_7
depdays_7
STATO:0000093
date and time-related information
STATO:0000093
depdays_8
depdays_8
STATO:0000093
date and time-related information
STATO:0000093
depdays_9
depdays_9
STATO:0000093
date and time-related information
Augmented care period data quality indicator
GECKO:0000052
ACPDQIND_N
acpdqind_1
GECKO:0000052
survey administration
This field gives the end date of a period of augmented care (a null entry indicates that this data is not applicable).
STATO:0000093
ACPEND_N
acpend_1
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_2
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_3
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_4
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_5
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_6
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_7
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_8
STATO:0000093
date and time-related information
STATO:0000093
ACPEND_N
acpend_9
STATO:0000093
date and time-related information
This field states the start date of a period of augmented care.
STATO:0000093
Augmented care period start date
acpstar_1
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_2
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_3
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_4
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_5
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_6
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_7
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_8
STATO:0000093
date and time-related information
STATO:0000093
Augmented care period start date
acpstar_9
STATO:0000093
date and time-related information
STATO:0000093
intdays_2
intdays_2
STATO:0000093
date and time-related information
STATO:0000093
intdays_3
intdays_3
STATO:0000093
date and time-related information
STATO:0000093
intdays_4
intdays_4
STATO:0000093
date and time-related information
STATO:0000093
intdays_5
intdays_5
STATO:0000093
date and time-related information
STATO:0000093
intdays_6
intdays_6
STATO:0000093
date and time-related information
STATO:0000093
intdays_7
intdays_7
STATO:0000093
date and time-related information
STATO:0000093
intdays_9
intdays_9
STATO:0000093
date and time-related information
This field contains the number of days of intensive care in a period of augmented care.
STATO:0000093
Intensive care level days
intdays_1
STATO:0000093
date and time-related information
This field contains the code for the main specialty of the consultant clinically managing the period of augmented care. This consultant is not necessarily the same as the one responsible for the hospital episode. Where a patient is cared for by a team of specialists within an Intensive Care rota, this field contains the specialty of the team's clinical director. Where there are several specialties involved but none is considered responsible, this field contains the specialty of the consultant admitting the patient to the period of augmented care. If no specific consultant or team can be identified as organising the care associated with the ACP, then this should be the same as for the related consultant episode.
GECKO:0000073
Augmented care period specialty function code
acpspef_1
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_2
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_3
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_4
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_5
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_6
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_7
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_8
GECKO:0000073
physician/practitioner info
GECKO:0000073
Augmented care period specialty function code
acpspef_9
GECKO:0000073
physician/practitioner info
This field contains the number of organ support systems used (up to five) during a period of augmented care.
GECKO:0000052
Number of organ systems supported
orgsup_1
GECKO:0000052
survey administration
GECKO:0000052
orgsup_2
orgsup_2
GECKO:0000052
survey administration
GECKO:0000052
orgsup_3
orgsup_3
GECKO:0000052
survey administration
GECKO:0000052
orgsup_4
orgsup_4
GECKO:0000052
survey administration
GECKO:0000052
orgsup_5
orgsup_5
GECKO:0000052
survey administration
GECKO:0000052
orgsup_6
orgsup_6
GECKO:0000052
survey administration
GECKO:0000052
orgsup_7
orgsup_7
GECKO:0000052
survey administration
GECKO:0000052
orgsup_8
orgsup_8
GECKO:0000052
survey administration
GECKO:0000052
orgsup_9
orgsup_9
GECKO:0000052
survey administration
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_1
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_2
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_3
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_4
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_5
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_6
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_7
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_8
GECKO:0000006
location
This field gives the destination of a discharged patient after a period of augmented care. Compare this field with disdest (destination on discharge from a hospital episode).
GECKO:0000006
ACPDISP_N
acpdisp_9
GECKO:0000006
location
This field gives the location of a patient during a period of augmented care.
GECKO:0000006
ACPLOC_N
acploc_1
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_2
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_3
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_4
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_5
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_6
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_7
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_8
GECKO:0000006
location
GECKO:0000006
ACPLOC_N
acploc_9
GECKO:0000006
location
This field contains a number representing the order of an episode within a sequence of episodes that make up a period of augmented care.
GECKO:0000052
ACPN_N
acpn_1
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_2
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_3
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_4
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_5
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_6
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_7
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_8
GECKO:0000052
survey administration
GECKO:0000052
ACPN_N
acpn_9
GECKO:0000052
survey administration
This field identifies whether a patient survived. For deaths it indicates whether organs were donated. Organs are defined as whole organs such as heart, lung, liver, kidney and pancreas. The value 03 does not include parts of organs such as corneas, heart valves, etc.
GECKO:0000052
ACPOUT_N
acpout_1
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_2
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_3
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_4
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_5
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_6
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_7
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_8
GECKO:0000052
survey administration
GECKO:0000052
ACPOUT_N
acpout_9
GECKO:0000052
survey administration
This field indicates whether any part of the ACP was planned in advance of admission to the ACP location.
GECKO:0000052
ACPPLAN_N
acpplan_1
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_2
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_3
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_4
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_5
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_6
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_7
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_8
GECKO:0000052
survey administration
GECKO:0000052
ACPPLAN_N
acpplan_9
GECKO:0000052
survey administration
This field defines where the patient was immediately before the period of augmented care. Compare this field with admisorc (source of patient for a hospital episode).
GECKO:0000006
ACPSOUR_N
acpsour_1
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_2
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_3
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_4
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_5
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_6
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_7
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_8
GECKO:0000006
location
GECKO:0000006
ACPSOUR_N
acpsour_9
GECKO:0000006
location
This derived field gives the number of augmented care periods (ACPs) within episode.
GECKO:0000052
Number of augmented care periods within episode
numacp
GECKO:0000052
survey administration
This field contains the number of days of high dependency care in a period of augmented care.
STATO:0000093
High-dependency care level
depdays_1
STATO:0000093
date and time-related information
MONDO:0004992
Cancer diagnosis
cancer_diagnosis
MONDO:0004992
cancer
Descriptive categorisation, based on a subset of submitted NICIP or SNOMED-CT imaging codes particularly used to diagnose or discount the following cancers, as identified by clinicians
MONDO:0004992
Early cancer diagnosis
ic_cancer_desc
MONDO:0004992
cancer
GECKO:0000073
CCG
ccg
GECKO:0000073
physician/practitioner info
Returns the CCG code of the referring organisation, derived from the submitted field General Medical Practice Code (Patient Registration)
GECKO:0000073
CCG Code
ic_ccgcode
GECKO:0000073
physician/practitioner info
Descriptive field (based on the CCG Code) returning the CCG title, derived from the submitted field General Medical Practice Code (Patient Registration)
GECKO:0000073
CCG Name
ic_ccgname
GECKO:0000073
physician/practitioner info
Clinical
clinical
External cause of injury or poisoning. This item is a copy of the first diagnosis code that represents an external cause.
MONDO:0000001
Cause Code
cause
MONDO:0000001
diseases
MONDO:0000001
diag_13
diag_13
MONDO:0000001
diseases
MONDO:0000001
diag_14
diag_14
MONDO:0000001
diseases
MONDO:0000001
diag_15
diag_15
MONDO:0000001
diseases
MONDO:0000001
diag_16
diag_16
MONDO:0000001
diseases
MONDO:0000001
diag_17
diag_17
MONDO:0000001
diseases
MONDO:0000001
diag_18
diag_18
MONDO:0000001
diseases
MONDO:0000001
diag_19
diag_19
MONDO:0000001
diseases
MONDO:0000001
diag_20
diag_20
MONDO:0000001
diseases
WAIT_IND indicates how and whether the field 'Days Waiting' (WAITING) has been calculated.
GECKO:0000052
Waiting calculation indicator
wait_ind
GECKO:0000052
survey administration
GECKO:0000092
opdate_02
opdate_02
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_03
opdate_03
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_04
opdate_04
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_05
opdate_05
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_06
opdate_06
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_07
opdate_07
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_08
opdate_08
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_09
opdate_09
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_10
opdate_10
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_11
opdate_11
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_12
opdate_12
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_13
opdate_13
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_14
opdate_14
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_15
opdate_15
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_16
opdate_16
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_17
opdate_17
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_18
opdate_18
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_19
opdate_19
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_20
opdate_20
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_21
opdate_21
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_22
opdate_22
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_23
opdate_23
GECKO:0000092
surgical interventions
GECKO:0000092
opdate_24
opdate_24
GECKO:0000092
surgical interventions
Status of operation.
GECKO:0000092
Operation status code
operstat
GECKO:0000092
surgical interventions
There are twenty-four fields (twelve before April 2007), oper_01 to oper_24, which contain information about a patient's operations. The field oper_01 contains the main (ie most resource intensive) procedure. The other fields contain secondary procedures. The codes are defined in the Tabular List of the Classification of Surgical Operations and Procedures. The current version is OPCS4. Procedure codes start with a letter and are followed by two or three digits. The third digit identifies variations on a main procedure code containing two digits. The third digit is preceded by a full stop in OPCS4, but this is not stored in the field. A single operation may contain more than one procedure.
GECKO:0000092
Operative procedure
opertn_01
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_02
opertn_02
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_03
opertn_03
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_04
opertn_04
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_05
opertn_05
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_06
opertn_06
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_07
opertn_07
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_08
opertn_08
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_09
opertn_09
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_10
opertn_10
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_11
opertn_11
GECKO:0000092
surgical interventions
The total number of procedure codes present on the record (maximum of 24)
GECKO:0000092
Count of procedures
opertn_count
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_12
opertn_12
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_13
opertn_13
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_14
opertn_14
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_15
opertn_15
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_16
opertn_16
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_17
opertn_17
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_18
opertn_18
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_19
opertn_19
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_20
opertn_20
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_21
opertn_21
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_22
opertn_22
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_23
opertn_23
GECKO:0000092
surgical interventions
GECKO:0000092
opertn_24
opertn_24
GECKO:0000092
surgical interventions
This derived field contains the difference in days between the date of the main procedure (opdate_01) and the date the episode ended (epiend).
GECKO:0000092
Post-operative duration
posopdur
GECKO:0000092
surgical interventions
This derived field contains the difference in days between the date the episode started (epistart) and the date of the main operation (opdte_01).
GECKO:0000092
Pre-operative duration
preopdur
GECKO:0000092
surgical interventions
This field contains the date of the procedure recorded in the respectively numbered procedure code (opertn_nn) field. There is room for twenty four dates (twelve prior to April 2007 and four before April 2002).
GECKO:0000092
Date of procedure
opdate_01
GECKO:0000092
surgical interventions
Clinical diagnoses
clinical_diagnoses
MONDO:0000001
diag2_02
diag2_02
MONDO:0000001
diseases
MONDO:0000001
diag2_03
diag2_03
MONDO:0000001
diseases
MONDO:0000001
diag2_04
diag2_04
MONDO:0000001
diseases
MONDO:0000001
diag2_05
diag2_05
MONDO:0000001
diseases
MONDO:0000001
diag2_06
diag2_06
MONDO:0000001
diseases
MONDO:0000001
diag2_07
diag2_07
MONDO:0000001
diseases
MONDO:0000001
diag2_08
diag2_08
MONDO:0000001
diseases
MONDO:0000001
diag2_09
diag2_09
MONDO:0000001
diseases
MONDO:0000001
diag2_10
diag2_10
MONDO:0000001
diseases
MONDO:0000001
diag2_11
diag2_11
MONDO:0000001
diseases
MONDO:0000001
diag2_12
diag2_12
MONDO:0000001
diseases
MONDO:0000001
diaga_02
diaga_02
MONDO:0000001
diseases
MONDO:0000001
diaga_03
diaga_03
MONDO:0000001
diseases
MONDO:0000001
diaga_04
diaga_04
MONDO:0000001
diseases
MONDO:0000001
diaga_05
diaga_05
MONDO:0000001
diseases
MONDO:0000001
diaga_06
diaga_06
MONDO:0000001
diseases
MONDO:0000001
diaga_07
diaga_07
MONDO:0000001
diseases
MONDO:0000001
diaga_08
diaga_08
MONDO:0000001
diseases
MONDO:0000001
diaga_09
diaga_09
MONDO:0000001
diseases
MONDO:0000001
diaga_10
diaga_10
MONDO:0000001
diseases
MONDO:0000001
diaga_11
diaga_11
MONDO:0000001
diseases
MONDO:0000001
diaga_12
diaga_12
MONDO:0000001
diseases
MONDO:0000001
diags_02
diags_02
MONDO:0000001
diseases
MONDO:0000001
diags_03
diags_03
MONDO:0000001
diseases
MONDO:0000001
diags_04
diags_04
MONDO:0000001
diseases
MONDO:0000001
diags_05
diags_05
MONDO:0000001
diseases
MONDO:0000001
diags_06
diags_06
MONDO:0000001
diseases
MONDO:0000001
diags_07
diags_07
MONDO:0000001
diseases
MONDO:0000001
diags_08
diags_08
MONDO:0000001
diseases
MONDO:0000001
diags_09
diags_09
MONDO:0000001
diseases
MONDO:0000001
diags_10
diags_10
MONDO:0000001
diseases
MONDO:0000001
diags_11
diags_11
MONDO:0000001
diseases
MONDO:0000001
diags_12
diags_12
MONDO:0000001
diseases
The Coding Scheme basis of the Diagnosis.
GECKO:0000052
Diagnosis Scheme in Use
diagscheme
GECKO:0000052
survey administration
The A&E diagnosis description at 2-character level covering the diagnosis condition. This field contains a description based on the diagnosis condition (first 2 characters) of the A&E diagnosis and only displays a code where it is unclassifiable against the A&E Diagnosis classification.
MONDO:0000001
A&E diagnosis: 2 character
diag2_01
MONDO:0000001
diseases
The A&E diagnosis anatomical area (a classification of parts of the human body). This field contains a description of the diagnosis anatomical area.
GECKO:0000052
A&E diagnosis - anatomical area
diaga_01
GECKO:0000052
survey administration
The A&E diagnosis anatomical side (an indication of the side of the human body). This field contains a description of the diagnosis anatomical side.
GECKO:0000052
A&E diagnosis - anatomical side
diags_01
GECKO:0000052
survey administration
The number of procedures in an episode. Prior to 2017-18 this was the number available in HES. From 2017-18 this is the number submitted to SUS even though HES does not receive all of them.
GECKO:0000092
Number of Procedures
noprocs
GECKO:0000092
surgical interventions
The number of diagnoses in an episode. Prior to 2017-18 this was the number available in HES. From 2017-18 this is the number submitted to SUS even though HES does not receive all of them.
MONDO:0000001
Number of Diagnoses
nodiags
MONDO:0000001
diseases
Clinical Investigations
clinical_investigations
CMO:0000000
GECKO:0000027
invest2_11
invest2_11
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_02
invest_02
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_03
invest_03
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_04
invest_04
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_05
invest_05
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_06
invest_06
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_07
invest_07
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_08
invest_08
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_09
invest_09
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_10
invest_10
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_11
invest_11
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest_12
invest_12
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_02
invest2_02
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_03
invest2_03
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_04
invest2_04
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_05
invest2_05
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_06
invest2_06
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_07
invest2_07
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_08
invest2_08
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_09
invest2_09
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
CMO:0000000
GECKO:0000027
invest2_10
invest2_10
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
The number of investigations in an episode. Prior to 2017-18 this was the number available in HES. From 2017-18 this is the number submitted to SUS even though HES does not receive all of them.
GECKO:0000052
Number of Investigations
noinvests
GECKO:0000052
survey administration
The A&E investigation recorded for an A&E attendance. The CDS allows an unlimited number of investigations to be submitted, however, only the first 12 investigations are available within HES. The A&E investigation is a six character code made up of, investigation (n2) and local sub-analysis (up to an4). As the sub-analysis is for local use it cannot be classified.
GECKO:0000052
A&E investigation
invest_01
GECKO:0000052
survey administration
The A&E investigation description. This field contains a description based upon the investigation (first 2 characters) of the A&E investigation code and only displays a code where it is unclassifiable against the A&E Investigation classification.
GECKO:0000052
A&E Investigation: 2 character
invest2_01
GECKO:0000052
survey administration
CMO:0000000
GECKO:0000027
invest2_12
invest2_12
CMO:0000000
physiological measurements
GECKO:0000027
laboratory measures
Clinical Treatments
clinical_treatments
GECKO:0000093
treat_02
treat_02
GECKO:0000093
medication
GECKO:0000093
treat_03
treat_03
GECKO:0000093
medication
GECKO:0000093
treat_04
treat_04
GECKO:0000093
medication
GECKO:0000093
treat_05
treat_05
GECKO:0000093
medication
GECKO:0000093
treat_06
treat_06
GECKO:0000093
medication
GECKO:0000093
treat_07
treat_07
GECKO:0000093
medication
GECKO:0000093
treat_08
treat_08
GECKO:0000093
medication
GECKO:0000093
treat_09
treat_09
GECKO:0000093
medication
GECKO:0000093
treat_10
treat_10
GECKO:0000093
medication
GECKO:0000093
treat_11
treat_11
GECKO:0000093
medication
GECKO:0000093
treat_12
treat_12
GECKO:0000093
medication
GECKO:0000093
treat2_02
treat2_02
GECKO:0000093
medication
GECKO:0000093
treat2_03
treat2_03
GECKO:0000093
medication
GECKO:0000093
treat2_04
treat2_04
GECKO:0000093
medication
GECKO:0000093
treat2_05
treat2_05
GECKO:0000093
medication
GECKO:0000093
treat2_06
treat2_06
GECKO:0000093
medication
The number of treatments in an episode. Prior to 2017-18 this was the number available in HES. From 2017-18 this is the number submitted to SUS even though HES does not receive all of them.
GECKO:0000052
Number of Treatments
notreats
GECKO:0000052
survey administration
GECKO:0000093
treat2_07
treat2_07
GECKO:0000093
medication
GECKO:0000093
treat2_08
treat2_08
GECKO:0000093
medication
GECKO:0000093
treat2_09
treat2_09
GECKO:0000093
medication
GECKO:0000093
treat2_10
treat2_10
GECKO:0000093
medication
GECKO:0000093
treat2_11
treat2_11
GECKO:0000093
medication
GECKO:0000093
treat2_12
treat2_12
GECKO:0000093
medication
The A&E treatment recorded for an A&E attendance. The Commissioning Dataset allows an unlimited number of treatments to be submitted, however, only the first 12 treatments are available within HES. The A&E treatment is a six character code made up of: treatment (n2), sub-analysis (n1) and a local use section (up to an3). As the local use section is used for local codes it cannot be classified.
A truncated version of the code from this field representing the first 2 and 3 characters can be found in the fields TREAT2_N and TREAT3_N,
GECKO:0000052
A&E treatment
treat_01
GECKO:0000052
survey administration
The first 2 characters of the A&E treatment code (TREAT_N) field, covering the treatment.
GECKO:0000052
A&E Treatment: 2 character
treat2_01
GECKO:0000052
survey administration
Clinical; Period of Care
clinical_period_of_care
This field identifies day cases, ordinary admissions, regular day and regular night attenders, and the special case of mothers and babies using only delivery facilities. Data about regular day and regular night attenders are not available for analysis prior to 2002-03. Since the introduction of the NHS wide clearing service in April 1996, this field has been derived from related items in the Commissioning Data Set (eg intended management).
GECKO:0000052
Patient classification
classpat
GECKO:0000052
survey administration
This field contains a code that defines the specialty in which the consultant was working during the period of care. It can be compared with mainspef, the specialty under which the consultant is contracted. Prior to 1 April 1996, this data item contained the code for the sub-specialty (subspef). From April 2004 a new list of treatment specialities was introduced (see below). The new list describes the specialised service within which the patient was treated.|This field contains a code that defines the specialty in which the consultant was working during the period of care. It can be compared with mainspef, the specialty under which the consultant is contracted. From April 2004 a new list of treatment specialties was introduced (see below). The new list describes the specialised service within which the patient was treated.
GECKO:0000073
Treatment specialty
tretspef
GECKO:0000073
physician/practitioner info
This field contains a code that defines what was planned to happen. The patient classification (classpat) defines what actually happened.
GECKO:0000052
Intended management
intmanig
GECKO:0000052
survey administration
This field contains a code that defines the specialty under which the consultant is contracted. It can be compared with tretspef, the specialty under which the consultant worked.|A code that defines the specialty under which the consultant is contracted. Compare with Treatment specialty (tretspef), the specialty under which the consultant worked.
GECKO:0000073
Main specialty
mainspef
GECKO:0000073
physician/practitioner info
MONDO:0000001
diag_02
diag_02
MONDO:0000001
diseases
MONDO:0000001
diag_03
diag_03
MONDO:0000001
diseases
MONDO:0000001
diag_04
diag_04
MONDO:0000001
diseases
MONDO:0000001
diag_05
diag_05
MONDO:0000001
diseases
MONDO:0000001
diag_06
diag_06
MONDO:0000001
diseases
MONDO:0000001
diag_07
diag_07
MONDO:0000001
diseases
MONDO:0000001
diag_08
diag_08
MONDO:0000001
diseases
MONDO:0000001
diag_09
diag_09
MONDO:0000001
diseases
MONDO:0000001
diag_10
diag_10
MONDO:0000001
diseases
MONDO:0000001
diag_11
diag_11
MONDO:0000001
diseases
MONDO:0000001
diag_12
diag_12
MONDO:0000001
diseases
There are twenty fields (fourteen before April 2007 and seven before April 2002), diag_01 to diag_20, which contain information about a patient's illness or condition. The field diag_01 contains the primary diagnosis. The other fields contain secondary/subsidiary diagnoses. The codes are defined in the International Statistical Classification of Diseases, Injuries and Causes of Death. HES records currently use the tenth revision (ICD-10). Prior to April 1995, the ninth revision was used (ICD-9). Diagnosis codes start with a letter and are followed by two or three digits. The third digit identifies variations on a main diagnosis code containing two digits. The third digit is preceded by a full stop in ICD-10, but this is not stored in the field.|Clinical Diagnosis|The A&E diagnosis code recorded for an A&E attendance. The CDS allows an unlimited number of diagnoses to be submitted, however, only the first 12 diagnoses are available within HES. The A&E diagnosis is a six character code made up of, diagnosis condition (n2), sub-analysis (n1), anatomical area (n2) and anatomical side (an1). Only certain diagnoses contain a sub-analysis.
MONDO:0000001
All Diagnosis codes
diag_01
MONDO:0000001
diseases
The organisation code of the patient pathway ID issuer. Where Choose and Book has been used, the Organisation Code for NHS Connecting For Health (X09) is used.|The organisation code of Patient Pathway ID issuer.
GECKO:0000052
Organisation code (patient pathway ID issuer)
orgpppid
GECKO:0000052
survey administration
GECKO:0000073
Commissioning Organisation
commissioning_organisation
GECKO:0000073
physician/practitioner info
Returns the Primary Care Trust code of the referring organisation, based on the submitted field General Medical Practice Code (Patient Registration)
GECKO:0000073
Commissioning Organisation Code
ic_pctcode
GECKO:0000073
physician/practitioner info
Descriptive field (based on the Commissioning Organisation Code) returning the Primacy Care Trust title of the referring organisation, based on the submitted field General Medical Practice Code (Patient Registration)
GECKO:0000073
Commissioning Organisation Name
ic_pctname
GECKO:0000073
physician/practitioner info
GECKO:0000052
Critical care admission and discharge data
critical_care_admission_and_discharge_data
GECKO:0000052
survey administration
The type of location the patient was in prior to the start of the critical care period.
GECKO:0000052
ccsorcloc
ccsorcloc
GECKO:0000052
survey administration
GECKO:0000052
Critical care adult activity data
critical_care_adult_activity_data
GECKO:0000052
survey administration
Multiple intravenous vasoactive and / or rhythm controlling drugs when used simultaneously to support or control arterial pressure, cardiac output or organ perfusion (e.g. inotropes, amiodarone, nitrates). To qualify for advanced support status, at least one drug needs to be vasoactive. Continuous observation or cardiac output and derived indices (e.g. pulmonary artery catheter, lithium dilution, pulse contour analyses, oesophageal doppler). Intra aortic balloon pumping and other assist devices. Insertion of a temporary cardiac pacemaker (criteria valid for each day of connection to a functioning external pacemaker unit).
STATO:0000093
acardsupdays
acardsupdays
STATO:0000093
date and time-related information
Number of days of basic cardiovascular support, defined as; Use of a central venous pressure (CVP) line for monitoring of central venous pressure and / or provision of central venous access to deliver titrated fluids to treat hypovolaemia. Use of an arterial line for monitoring of arterial pressure and / or sampling of arterial blood. Single intravenous vasoactive drug used to support or control arterial pressure, cardiac output or organ perfusion. Single intravenous rhythm controlling drug to support or control cardiac arrhythmias.
STATO:0000093
bcardsupdays
bcardsupdays
STATO:0000093
date and time-related information
Number of days of dermatological support, defined as;
Patients with major akin rashes, exfoliation or burns (e.g. greater than 30% body surface area affected).
Use of complex dressings (e.g. large skin area greater than 30% body surface area, open abdomen, vacuum dressings or large trauma such as multiple limb or limb and head dressings).
STATO:0000093
dermsupdays
dermsupdays
STATO:0000093
date and time-related information
Total calendar days during which level 3 care alone was provided during the period.
STATO:0000093
cclev3days
cclev3days
STATO:0000093
date and time-related information
Total calendar days during which level 2 care alone was provided during the period
STATO:0000093
cclev2days
cclev2days
STATO:0000093
date and time-related information
Number of days of neurological support, defined as;
*Central nervous system depression sufficient to prejudice the airway and protective reflexes, excepting that caused by sedation prescribed to facilitate mechanical ventilation or poisoning (e.g. deliberate or accidental overdose, alcohol, drugs etc.).
*Invasive neurological monitoring, e.g. intracranial pressure, jugular bulb sampling, external ventricular drain.
*Continuous intravenous medication to control seizures and / or continuous cerebral monitoring.
*Therapeutic hypothermia using coding protocols or devices.
STATO:0000093
neurosupdays
neurosupdays
STATO:0000093
date and time-related information
Number of days of renal support in the context of critical illness, defined as;
Acute renal replacement therapy (e.g. haemodialysis, haemofiltration etc.) or the provision of renal replacement therapy to a chronic renal failure patient who is requiring other acute organ support in a critical care situation.
STATO:0000093
rensupdays
rensupdays
STATO:0000093
date and time-related information
umber of days of advanced respiratory support, defined as; Invasive medical ventilatory support applied via a trans-laryngeal tracheal tube or applied via a tracheostomy. Bi-level positive airway pressure applied via a trans-laryngeal tracheal tube or applied via a tracheostomy. Continuous positive airway pressure via a trans-laryngeal tracheal tube. Extracorporeal respiratory support.
STATO:0000093
aressupdays
aressupdays
STATO:0000093
date and time-related information
Number of days of basic respiratory support defined as; More than 50% oxygen delivered by face mask. (Note: more than 50% has been chosen to identify the more seriously ill patients in a hospital). Short-term increases in the fraction of inspired oxygen (FiO2) to facilitate procedures such as transfers or physiotherapy do not quality. Close observation due to the potential for acute deterioration to the point of needing advanced respiratory support. (e.g. severely compromised airway or deteriorating respiratory muscle function). Physiotherapy or suction to clear secretions at least wo hourly, whether via tracheostomy, minitracheostomy or in the absence of an artificial airway. Patients recently (within 24 hours) extubated after a period (greater than 24 hours) of mechanical ventilation via endotracheal tube. Mask / hood continuous positive airway pressure (CPAP) or mark / hood Bi-level positive airway pressure ventilation (non-invasive ventilation). Patients who are intubated to protect the airway but needing no ventilatory support. Continuous positive airway pressure (CPAP) via a tracheostomy. Note. The presence of a tracheostomy used for long term airway access only does not quality for any respiratory support.
STATO:0000093
bressupdays
bressupdays
STATO:0000093
date and time-related information
Number of days of gastrointestinal support, defined as;
Feeding with parenteral or enteral nutrition (implies methods of feeding other than normal oral intake).
STATO:0000093
gisupdays
gisupdays
STATO:0000093
date and time-related information
Number of days of liver support where patients falls into one of the following categories;
*Acute on chronic Hepatocellular failure requiring management of coagulopathy and / or portal hypertension (including liver purification and detoxification techniques).
*Primary Acute Hepatocellular failure patients who are being considered for transplantation and require management of coagulopathy and / or portal hypertension (including liver purification and detoxification techniques)
STATO:0000093
liversupdays
liversupdays
STATO:0000093
date and time-related information
Maximum number of organ systems supported at any one time, at any point in the critical care period (note both basic and advanced categories cannot be counted at the same time). This may not be the same as the total number of organs supported throughout the critical care admission. The minimum for this variable is 00 and the maximum is 07 for the full data set.
GECKO:0000052
orgsupmax
orgsupmax
GECKO:0000052
survey administration
GECKO:0000052
Critical care adult admission and discharge data
critical_care_adult_admission_and_discharge_data
GECKO:0000052
survey administration
The composition of bed types for your unit based on maximum funded and intended use, e.g. some units plan to use staff and beds flexibly, others are organised to take a full complement of level three patients or only ‚ÄòHDU’ patients.
GECKO:0000052
unitbedconfig
unitbedconfig
GECKO:0000052
survey administration
Discharge date from unit if alive, date of death or date of declaration of brain stem death.
STATO:0000093
ccdisdate
ccdisdate
STATO:0000093
date and time-related information
The date on which the patient has been declared clinically ready for discharge or transfer from the critical care period and a formal request has been made to the Hospital Bed management system (or appropriate staff with authority to admit at the intended destination) and the date and time of this status is recorded as such in the clinical record.
STATO:0000093
ccdisrdydate
ccdisrdydate
STATO:0000093
date and time-related information
The time on which the patient has been declared clinically ready for discharge or transfer from the clinical car period and a formal request has been made to the Hospital Bed management system (or appropriate staff with authority to admit at the intended destination) and the date and time of this status is recorded as such in the clinical record.
STATO:0000093
ccdisrdytime
ccdisrdytime
STATO:0000093
date and time-related information
Discharge time from unit.
STATO:0000093
ccdistime
ccdistime
STATO:0000093
date and time-related information
Information on the source of the patient is of use in analysing unit workload and outcomes. Exactly the same classification is used as developed in collaboration with ICNARC (the Intensive Care National Audit and Research Centre).
Admission sequences are captured in two stages, i.e. there are two variables collected before unit admission, the critical care admission source and the location associated with the source (CCSORLOC).
GECKO:0000052
ccadmisorc
ccadmisorc
GECKO:0000052
survey administration
An indication of whether a critical are period was initiated as a result of a non- emergency treatment plan, for example, for none elective surgery. This relates only to the period of critical care and not to the nature of the hospital admission. For example, a planned hospital admission may unexpectedly require an emergency intensive care unit admission, in which case the classification will be ‚Äò01’.
GECKO:0000052
ccadmitype
ccadmitype
GECKO:0000052
survey administration
Destination of critical care discharge.
GECKO:0000052
ccdisdest
ccdisdest
GECKO:0000052
survey administration
The principal location that the patient is being discharge to for further care at the end of the critical care period.
GECKO:0000052
ccdisloc
ccdisloc
GECKO:0000052
survey administration
Status at time of discharge.
GECKO:0000052
ccdisstat
ccdisstat
GECKO:0000052
survey administration
GECKO:0000052
Critical care period of care
critical_care_period_of_care
GECKO:0000052
survey administration
A comparison of the dates of the critical care period and those of the associated admitted patient care episode. This is used in the derivation of the best match flag by producing a hierarchy of relationships.
STATO:0000093
ccapcrel
ccapcrel
STATO:0000093
date and time-related information
The type of area to which the patient was admitted during a critical care period. This is the principal clinical service provided within the ward
ccunitfun
ccunitfun
A flag stating whether the row represents the best match between the critical care and episode start and end dates for this critical care period. This flag is used to limit the data in instances where there is more than one row per critical care period. See Appendix C in the Critical Care 2008-09 publication for further details.
STATO:0000093
bestmatch
bestmatch
STATO:0000093
date and time-related information
Time at which the critical care period started.
STATO:0000093
ccstarttime
ccstarttime
STATO:0000093
date and time-related information
STATO:0000093
Critical care start date
critical_care_start_date
STATO:0000093
date and time-related information
Date on which the critical care period started.
STATO:0000093
ccstartdate
ccstartdate
STATO:0000093
date and time-related information
MONDO:0000001
Diagnosis
diagnosis
MONDO:0000001
diseases
Ambulatory Care Sensitive Condition flag is derived for finished APC episodes where the admission method is ‚Äòemergency’. The flag indicates whether the episode contains a diagnosis which is ambulatory care sensitive.
MONDO:0000001
Ambulatory Care Sensitive Condition Flag
acscflag
MONDO:0000001
diseases
The total number of diagnosis codes present on the record (maximum of 20)
MONDO:0000001
Count of diagnoses
diag_count
MONDO:0000001
diseases
This is recorded when patients who have been offered an appointment date have missed this date with or without advance notice.
STATO:0000093
Last DNA or patient cancelled date
dnadate
STATO:0000093
date and time-related information
Indicates the diagnosis code with the highest alcohol attributable fraction. Where
this applies to more than one code, the code that appears earliest in the sequence of diagnosis fields is used. Where no alcohol attributable diagnosis is present this field will be null. See "HES APC Data Dictionary - Supplementary Table" at http://content.digital.nhs.uk/hesdatadictionary
GECKO:0000069
Principal alcohol related diagnosis
alcdiag
GECKO:0000069
alcohol use history
Description
This provides the first four characters of the principle alcohol related diagnosis (ALCDIAG).
GECKO:0000069
Principal alcohol related diagnosis
alcdiag_4
GECKO:0000069
alcohol use history
Indicates the highest alcohol attributable fraction within the episode based on the principal alcohol related diagnosis. See "HES APC Data Dicitonary - Supplementary Table" athttp://content.digital.nhs.uk/hesdatadictionary
GECKO:0000069
Principal alcohol related fraction
alcfrac
GECKO:0000069
alcohol use history
STATO:0000093
Diagnostic Test Dates
diagnostic_test_dates
STATO:0000093
date and time-related information
The date as submitted that the diagnostic provider received the referral request. It must be in the correct CCYY-MM-DD format and meet the following validation rules: Date submitted must be:
<= Diagnostic Test Request Received Date If date submitted >1 year before Diagnostic Test Date an alert will be raised.
STATO:0000093
Diagnostic Test Request Date
did_date1
STATO:0000093
date and time-related information
The date as submitted that the diagnostic provider received the referral request. It must be in the correct CCYY-MM-DD format and meet the following validation rules:
STATO:0000093
Diagnostic Test Request Received Date
did_date2
STATO:0000093
date and time-related information
The date as submitted that the diagnostic test took place. It must be in the correct CCYY-MM-DD format and meet the following validation rules: Date of test must be: >= Diagnostic Test Request Received >= Diagnostic Test Request Date Date <= Service Report Issue Diagnostic Test Date is mandatory and cannot be left blank
STATO:0000093
Diagnostic Test Date
did_date3
STATO:0000093
date and time-related information
Based on submitted field Diagnostic Test Date, returning month art only
STATO:0000093
Month of Test
did_date3_month
STATO:0000093
date and time-related information
Based on submitted field Diagnostic Test Date, returning year part only
STATO:0000093
Year of Test
did_date3_year
STATO:0000093
date and time-related information
The date as submitted that the diagnostic provider issues the test report. It must be in the correct CCYY-MM-DD format and an alert raised if >1 month after Diagnostic Test Date
STATO:0000093
Service Report Issue Date
did_date4
STATO:0000093
date and time-related information
GECKO:0000052
Discharges; Period of Care
discharges_period_of_care
GECKO:0000052
survey administration
This field contains a code which identifies where the patient was due to go on leaving hospital. In most cases they return home. For many patients discharge destination is the same as source of admission (admisorc).
GECKO:0000006
Destination on discharge
disdest
GECKO:0000006
location
This field contains a code which defines the circumstances under which a patient left hospital. For the majority of patients this is when they are discharged by the consultant. This field is only completed for the last episode in a spell.
GECKO:0000052
Method of discharge
dismeth
GECKO:0000052
survey administration
The date that a patient was medically ready for discharge from a hospital bed, but couldn't be discharged, therefore qualifying for delayed discharge payments.
STATO:0000093
Discharge ready date
disreadydate
STATO:0000093
date and time-related information
This field contains the date on which the patient was discharged from hospital. ; It is only present in the record for the last episode of a spell.
STATO:0000093
Date of discharge
disdate
STATO:0000093
date and time-related information
GECKO:0000052
Episodes and spells; Period of care
episodes_and_spells_period_of_care
GECKO:0000052
survey administration
This field contains the number of the episode within the current spell. All spells start with an episode where epiorder is 01. Many spells finish with this episode, but if the patient moves to the care of another consultant, a new episode begins. Episode numbers increase by 1 for each new episode until the patient is discharged (this includes transfers to another NHS trust or primary care trust - ie the first episode in the new trust will have epiorder 01). If the same patient returns for a different spell in hospital, epiorder is again set to 01. Admissions are calculated by counting the number of times epiorder is 01. When studying long term care, remember that it is not unusual to transfer psychiatric patients from one hospital to another.
GECKO:0000052
Episode order
epiorder
GECKO:0000052
survey administration
This field tells you whether the episode had finished before the end of the HES data-year (ie whether the episode was still 'live' at midnight on 31 March). For example, if a patient was admitted on 25 March 2005 and was not discharged (or transferred to the care of another consultant) until 4 April 2005, there will be a record describing the unfinished episode (episode status = 1) in the 2004-05 data, and a separate record describing the finished episode (episode status = 3) in the 2005-06 data. Because hospital providers are advised not to include clinical data (diagnosis and operation codes) in unfinished records, these are normally excluded from analyses. Also, if unfinished episodes are included in time series analyses - where data for more than one year is involved - there is a danger of counting the same episode twice.
STATO:0000093
Episode status
epistat
STATO:0000093
date and time-related information
This field contains a code that defines the type of episode, so that groups of similar episodes can be formed.
GECKO:0000052
Episode type
epitype
GECKO:0000052
survey administration
This indicates whether the episode is a finished admission episode (the first
episode in a hospital provider spell). FAE is derived in HES, and is set to a value of 1 for finished admission episodes (where the Episode Status is 3 and Episode Order = 1 and Patient Classification is 1, 2 or 5).
GECKO:0000052
Finished Admission Episode
fae
GECKO:0000052
survey administration
Finished Admission Episode Flag where admission to hospital is from an emergency admission. This is set to a value of 1 for the admission episode where Patient Classification is 1,2 or 5 AND admission method begins with a 2*
GECKO:0000052
Finished Admission Episode, emergency classification
fae_emergency
GECKO:0000052
survey administration
This indicates whether the episode is a finished discharge episode (whether the
patient was discharged at the end of the episode). FDE is derived in HES, and is set to a value of 1 for finished discharge episodes (where the Episode Status is 3 and Discharge Method is 1-5 and Patient Classification is 1, 2 or 5, ).
GECKO:0000052
Finished In-Year Discharge Episode
fde
GECKO:0000052
survey administration
This derived field gives the duration of the spell in days. It contains the difference in days between the admission date (admidate) and the discharge date (epiend) provided the discharge method (dismeth) confirms that the spell has finished. If the episode has not finished it is calculated from the end of the year and admidate.
STATO:0000093
Duration of spell
speldur
STATO:0000093
date and time-related information
This derived field contains a code that defines whether the episode is the last of a spell. It is set on finished general, delivery and birth episodes (where epistat = 3 and epitype = 1, 2 or 3), provided the discharge method (dismeth) confirms that the spell has finished.
GECKO:0000052
End of spell indicator
spelend
GECKO:0000052
survey administration
This field contains a code that defines the characteristics of a ward. The code has six parts: AABCDEF.
GECKO:0000052
Ward type at start of episode
wardstrt
GECKO:0000052
survey administration
This derived field provides the duration of an episode in days within the HES data year. It is derived from epistart (episode start date) and epiend (episode end date). For episodes that both start and finish in the data year, bedyear has the same value as epidur (episode duration). If the episode is unfinished, bedyear is calculated from epistart and the end of the data year. If epistart is before the beginning of the data year, bedyear is calculated from the start of the data year and epiend. If the record type is other maternity events (episode type 5 or 6), bedyear is null.
GECKO:0000052
Bed days within the year
bedyear
GECKO:0000052
survey administration
This derived field contains a code that defines whether the episode is the first of a spell, and whether the spell started in the current year or a previous year. Other maternity events are excluded.
GECKO:0000052
Beginning of spell indicator
spelbgin
GECKO:0000052
survey administration
This field contains the difference in days between the episode start date (epistart) and the episode end date (epiend).
This is the full duration of a finished episode only. Episode duration is not applicable for
‚Äö√Ñ√≤other maternity events‚Äö√Ñô and shall therefore remain null.
STATO:0000093
Episode duration
epidur
STATO:0000093
date and time-related information
This field contains the date on which a patient left the care of a particular consultant, for one of the following reasons: Patient discharged from hospital (includes transfers) or moved to the care of another consultant. A null entry either indicates that the episode was unfinished at the end of the data year, or the date was unknown.
STATO:0000093
Date episode ended
epiend
STATO:0000093
date and time-related information
This field contains the date on which a patient was under the care of a particular consultant. If a patient has more than one episode in a spell, for each new episode there is a new value of epistart. However, the admission date which is copied to each new episode in a spell will remain unchanged and will be equal to the episode start date of the first episode in hospital.
STATO:0000093
Date episode started
epistart
STATO:0000093
date and time-related information
Finished consultant episode (FCE) is a continuous period of admitted patient care
under one consultant within one healthcare provider. FCEs do not represent the number of in-patients, as a person may have more than one period of care within the year. This field is derived in HES and it is set to a value of 1 for finished episodes i.e. where the Episode Status is 3 and the Patient Classification is 1, 2 or 5 (Ordinary admission, day case admission or mothers and babies using only delivery facilities).
GECKO:0000052
Finished Consultant Episode
fce
GECKO:0000052
survey administration
This field represents the year and month of the HES dataset in the format yyyymm. For example, 201601 represents the month 1 2016-17 HES dataset; 201602 represents the month 2 2016-17 HES dataset etc.
STATO:0000093
Year and month of HES dataset
partyear
STATO:0000093
date and time-related information
GECKO:0000061
Ethnic Category
ethnic_category
GECKO:0000061
ethnicity/race
Code as per submission. Field undergoes hard validation during data submission process. Field must contain one of the nationally defined codes. If the code supplied does not come from the following NHS Data Dictionary list, data will not be uploaded: A, B, C, D, E, F, G, H, I, J, K, L, M, N, P, R, S, Z
GECKO:0000061
Ethnic Category Code
did_ethcat
GECKO:0000061
ethnicity/race
Descriptive field, based on submitted Ethnic Category Code and converted into one of the following descriptive groupings: White (A,B,C) Mixed (D,E,F,G) Asian or Asian British (H,J,K,L) Black or Black British (M,N,P) Other Ethnic Groups (R,S) , Not stated (Z)
GECKO:0000061
Ethnic Category Group
did_ethcat_grp
GECKO:0000061
ethnicity/race
Descriptive field, based on submitted Ethnic Category
GECKO:0000061
Ethnic Category Description
ic_ethcat_desc
GECKO:0000061
ethnicity/race
Descriptive classification of imaging on fetal body structures, based on Fetal ID categorisation of submitted NICIP or SNOMED-CT codes
GECKO:0000052
Fetal
ic_fetal_desc
GECKO:0000052
survey administration
Based on submitted Based on submitted NICIP or SNOMED- CT codes and represented by an ID number, Fetal ID provides categorisation of imaging on fetal body structures as identified by Clinical Terminologists at HSCIC.
GECKO:0000055
Fetal ID
ic_fetal_id
GECKO:0000055
unique identifiers
GECKO:0000006
Geographical
geographical
GECKO:0000006
location
This derived field contains a code for the patient's county (first two characters) and
local authority district (last two characters) of residence. It is derived from the patient's postcode (homeadd). This field is used in conjunction with currward (current electoral ward) to produce a unique value indicating the ward within a given district where the patient resided (ie because identical Currward codes are allocated to many local authority districts, currward is meaningless in isolation). If the patient is resident within a Unitary Authority, the first two characters will be 00 (zero, zero) and the local authority component may not be useable.
GECKO:0000006
Field Name
Local authority district in 1998
lad98
GECKO:0000006
location
This derived field contains a code which defines the current local authority district of residence of the patient. It is derived from the patient's postcode in the field homeadd.
GECKO:0000006
Field Name
Local authority district of residence (ONS)
resladst_ons
GECKO:0000006
location
This derived field contains the code for the Area Team (AT) where the patient’s GP
practice is registered. It is derived from Code of GP practice (GPPRAC).
In 2015 following an NHS reorganisation, Area Teams were replaced by NHS England regions. This field has continued to be derived after this date as a ‚Äòfrozen’ geography. The NHS England region of the GP practice can be found in the field NER_GP_PRACTICE.
GECKO:0000006
Area Team of GP Practice
at_gp_practice
GECKO:0000006
location
This derived field contains the code for the Area Team (AT) where the patient lives.
It is derived from the CCG of residence.
In 2015 following an NHS reorganisation, Area Teams were replaced by NHS England regions. This field has continued to be derived after this date as a ‚Äòfrozen’ geography. The NHS Region of residence can be found in the field NER_RESIDENCE.
GECKO:0000006
Area Team of Residence
at_residence
GECKO:0000006
location
This derived field contains the code for the Area Team (AT) where the patient was
treated. It is derived from the CCG of Treatment.
In 2015 following an NHS reorganisation, Area Teams were replaced by NHS England regions. This field has continued to be derived after this date as a ‚Äòfrozen’ geography. The NHS England region of treatment can be found in the field NER_TREATMENT.
GECKO:0000006
Area Team of Treatment
at_treatment
GECKO:0000006
location
This field contains the patient's full frozen 1991 Census electoral ward and local authority of residence. It is derived from the patient's postcode in the field homeadd.|This field contains the patient‚Äö√Ñôs full frozen 1991 Census electoral ward and local authority of residence. It is derived from the patient's postcode in the field homeadd (postcode of patient).|The patient's electoral ward in 1991. This field contains the full frozen 1991 Census electoral ward of the patient. It is derived from the patient's postcode in the field homeadd.
GECKO:0000006
Electoral ward in 1991
ward91
GECKO:0000006
location
This field contains the patient's full frozen 1998 electoral ward and local authority of residence. It is derived from the patient's postcode in the field homeadd.
GECKO:0000006
Electoral ward in 1998
ward98
GECKO:0000006
location
This field, which is derived from the patient's postcode in the field HOMEADD, represents the 2001 Census Lower Layer SOA code for England and Wales, SOA code for Northern Ireland and data zone code for Scotland. Pseudo codes are included for Channel Islands and Isle of Man. The field will otherwise be blank for postcodes with no grid reference. The first character is either E for England or W for Wales The next two characters are 01 for Lower Super Output Area and the remaining six characters make up the unique 6-digit tag for each zone.
GECKO:0000006
Lower Super Output Area
lsoa01
GECKO:0000006
location
This field, which is derived from the patient's postcode in the field HOMEADD,
represents the 2011 Census lower layer SOA code for England and Wales, SOA code for Northern Ireland and data zone code for Scotland. Pseudo codes are included for Channel Islands and Isle of Man. The field will otherwise be blank for postcodes with no grid reference. N.B. this field remains blank for Scottish postcodes until this information is released. The first character is either E for England or W for Wales The next two characters are 01 for Lower Super Output Area and the remaining six characters make up the unique 6-digit tag for each zone.
GECKO:0000006
Lower Super Output Area
lsoa11
GECKO:0000006
location
This field, which is derived from the patient's postcode in the field HOMEADD,
represents the 2011 Census middle layer SOA (MSOA) code for England and Wales and intermediate zone for Scotland. Pseudo codes are included for Northern Ireland, Channel Islands and Isle of Man. The field will otherwise be blank for postcodes with no grid reference. N.B. this field remains blank for Scottish postcodes until this information is released. The first character is either E for England or W for Wales. The next two characters are 02 for Middle Layer and the remaining six characters make up the unique 6-digit tag for each zone.|This field, which is derived from the patient's postcode in the field HOMEADD, represents the 2011 Census middle layer SOA (MSOA) code for England and Wales and intermediate zone for Scotland. Pseudo codes are included for Northern Ireland, Channel Islands and Isle of Man. The field will otherwise be blank for postcodes with no grid reference. N.B. this field remains blank for Scottish postcodes until this information is released. The first character is either E for England or W for Wales. The next two characters are 02 for Middle Layer and the remaining six characters make up the unique 6-digit tag for each zone.
GECKO:0000006
Middle Super Output Area, 2011
msoa11
GECKO:0000006
location
For activity from 2011-12 onwards, HES users are advised to use the field
PCON_ONS instead of PCON.
This field, which is derived from the patient's postcode in the field HOMEADD, defines the code for the English Westminster Parliamentary Constituency where the patient resides. Note that this field uses old-style geographical codes that were superseded in 2011 and are now no longer supported by ONS - the new-style code can be found in the field PCON_ONS.|For activity from 2011-12 onwards, HES users are advised to use the field PCON_ONS instead of PCON.
This field, which is derived from the patient's postcode in the field HOMEADD, defines the code for the English Westminster Parliamentary Constituency where the patient resides. Note that this field uses old-style geographical codes that were superseded in 2011 and are now no longer supported by ONS - the new-style code can be found in the field PCON_ONS.
GECKO:0000006
Westminster parliamentary constituency
pcon
GECKO:0000006
location
This field, which is derived from the patient's postcode in the field HOMEADD, defines the code for the English Westminster Parliamentary Constituency where the patient resides.
GECKO:0000006
Westminster parliamentary constituency (ONS)
pcon_ons
GECKO:0000006
location
This field contains a code that defines the Health Authority of residence of the patient. It is derived from the patient's postcode in the field homeadd.
In 2002 following a reorganisation of health areas, Health Authorities were replaced by Strategic Health Authorities. This field has continued to be derived after this date as a ‚Äö√Ñ√≤frozen‚Äö√Ñô geography.
GECKO:0000006
Health Authority of residence
resha
GECKO:0000006
location
For activity from 2011-12 onwards, HES users are advised to use the field RESGOR_ONS instead of RESGOR
The Government Office Region of residence field contains a code that defines the Government Office Region of residence of the patient. It is derived from the patient's postcode in the field homeadd. The Government Office Regions closed on 31 March 2011, but this regional geography is maintained for statistical purposes and after this date referred to simply as 'regions'.
Note that this field uses old-style geographical codes that were superseded in 2011 and are now no longer supported by ONS. The field RESGOR_ONS represents the Government Office Region of residence using codes from the current ONS geographical coding system.
GECKO:0000006
Government Office region of residence
resgor
GECKO:0000006
location
The Government Office Region of residence field contains a code that defines the
Government Office Region of residence of the patient. It is derived from the patient's postcode in the field homeadd. The Government Office Regions closed on 31 March 2011, but this regional geography is maintained for statistical purposes and after this date referred to simply as 'regions'.|The Government Office Region of residence field contains a code that defines the Government Office Region of residence of the patient. It is derived from the patient's postcode in the field homeadd. The Government Office Regions closed on 31 March 2011, but this regional geography is maintained for statistical purposes and after this date referred to simply as 'regions'.
GECKO:0000006
Government office region of residence (ONS)
resgor_ons
GECKO:0000006
location
This derived field indicates the basis on which the CCG of Responsibility was assigned.
GECKO:0000006
Origin of CCG of Responsibility
ccg_responsibility_origin
GECKO:0000006
location
This derived field indicates the basis on which the CCG of Treatment was assigned.
GECKO:0000006
Origin of CCG of Treatment
ccg_treatment_origin
GECKO:0000006
location
Census output areas are small geographical areas that cover similar population sizes and are as socially homogenous as possible. This derived field represents the 2011 census output area code associated with the patient's postcode (homeadd). Pseudo codes are included for Channel Islands and Isle of Man. The field will otherwise be blank for postcodes with no grid reference.
This field contains sensitive data. Access to it requires the approval of The Independent Group Advising on the Release of Data (IGARD)
GECKO:0000006
Census Output Area, 2011
oacode01
GECKO:0000006
location
Census output areas are small geographical areas that cover similar population sizes and are as socially homogenous as possible. This derived field represents the 2011 census output area code associated with the patient's postcode (homeadd). Pseudo codes are included for Channel Islands and Isle of Man. The field will otherwise be blank for postcodes with no grid reference.
This field contains sensitive data. Access to it requires the approval of The Independent Group Advising on the Release of Data (IGARD)
GECKO:0000006
Census Output Area, 2011
oacode11
GECKO:0000006
location
This derived field represents the first six-characters from the Census Output Area 2001 (OACODE01) field, which identifies the local government ward of the patient's postcode. The structure is CCDDWW, where CC = county, DD = district or unitary authority, and WW=ward.
GECKO:0000006
Census output area, 2001 (6 character ward identifier)
oacode6
GECKO:0000006
location
GECKO:0000006
primerecp
primerecp
GECKO:0000006
location
This field contains a code that defines the Regional Office (RO) area where the treatment took place (in data prior to 1996 it contains the Regional Health Authority of treatment). It is derived from the hospital provider code in the field procode. Note: (1) for NHS trusts, care provided at subsidiary sites will be attributed to the main trust location.
ROs were abolished in 2002. This field has continued to be derived after this date as a 'frozen' geography.|This field contains a code that defines the Regional Office (RO) area where the treatment took place. It is derived from the hospital provider code in the field procode. Note: (1) for NHS trusts, care provided at subsidiary sites will be attributed to the main trust location.
ROs were abolished in 2002. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000006
Regional Office of treatment
rotreat
GECKO:0000006
location
Describes the nature of an Output Area in terms of its morphology (hamlet, town, urban, etc) and context (sparse or less sparse).
GECKO:0000006
Rural/Urban Indicator
rururb_ind
GECKO:0000006
location
This derived field contains the code for the Clinical Commissioning Group (CCG) where the patient was treated. It is derived from the postcode of the Site of Treatment firstly, but where not available the postcode of the Provider is used.
GECKO:0000006
CCG of Treatment
ccg_treatment
GECKO:0000006
location
This derived field contains the code for the Commissioning Region (CR) where the patient’s GP practice is registered. Where not available, the code for the Area Team is used. It is derived from gpprac.
GECKO:0000006
Commissioning Region of GP Practice
cr_gp_practice
GECKO:0000006
location
This derived field contains the code for the Commissioning Region (CR) where the patient was treated. Where not available, the code for the Area Team is used. It is derived from the CCG of Treatment.
GECKO:0000006
Commissioning Region of Treatment
cr_treatment
GECKO:0000006
location
This derived field contains the code for the Clinical Commissioning Group (CCG) where the patient’s GP practice is registered. It is derived from GP Pracrice (GGPRAC).
GECKO:0000006
GECKO:0000073
CCG of GP Practice
ccg_gp_practice
GECKO:0000006
location
GECKO:0000073
physician/practitioner info
This derived field contains the code for the strategic health authority (SHA) in which the patient lived immediately before admission. It is derived from the patient's postcode in the field homeadd.
In 2013 following a reorganisation of health areas, Strategic Health Authorities were abolished. This field has continued to be derived after this date as a 'frozen' geography.|This derived field contains the code for the strategic health authority (SHA) in which the patient lived immediately before admission. It is derived from the patient's postcode in the field homeadd (postcode of patient).
In 2013 following a reorganisation of health areas, Strategic Health Authorities were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
SHA of residence
resstha
GECKO:0000064
residence
This field contains a code that defines the Strategic Health Authority (SHA) of residence of the patient, based on historic SHA boundaries that existed between 2002 and 2006. It is derived from the patient's postcode in the field homeadd.
This structure was superseded in 2006 - the code representing the SHAs that were in place after this restructure can be found in the field RESSTHA06.
GECKO:0000064
SHA of residence (2002)
resstha02
GECKO:0000064
residence
This field contains a code that defines the Strategic Health Authority (SHA) of residence of the patient, based on historic SHA boundaries that existed between 2006 and 2013. It is derived from the patient's postcode in the field homeadd.
In 2013 following a reorganisation of health areas, Strategic Health Authorities were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
SHA of residence (2006)
resstha06
GECKO:0000064
residence
This field, which is derived from the patient's postcode in the field HOMEADD,
contains a code which defines the former cancer network area that the postcode falls within.
Cancer networks were abolished in 2013. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
Cancer network
cannet
GECKO:0000064
residence
This field, which is derived from the patient's postcode in the field HOMEADD, contains a code which defines the cancer registry area that the postcode falls within.
GECKO:0000064
Cancer registry
canreg
GECKO:0000064
residence
This derived field contains the code for the Clinical Commissioning Group (CCG) where the patient lived immediately before admission. It is derived from post code (HOMEADD).
GECKO:0000064
CCG of Residence
ccg_residence
GECKO:0000064
residence
This derived field contains the code for the most suitable Clinical Commissioning Group (CCG) of responsibility. It is derived firstly from the patient’s GP practice but if not available the patient’s CCG of residence then the CCG of treatment is used.
GECKO:0000064
CCG of Residence
ccg_responsibility
GECKO:0000064
residence
For activity from 2011-12 onwards, HES users are advised to use the field CURRWARD_ONS instead of CURRWARD.
This field, which is derived from the patient's postcode in the field HOMEADD, contains a code which defines the pre-2011 electoral ward of the patient. Note that this field uses old-style geographical codes that were superseded in 2011 and are now no longer supported by ONS - the new style code can be found in the field CURRWARD_ONS.
Because identical CURRWARD codes are allocated to many local authority districts, CURRWARD is meaningless in isolation. This field should be used in conjunction with RESLADST (local authority district) to produce a unique value indicating the ward within a given district where the patient resided.|For activity from 2011-12 onwards, HES users are advised to use the field CURRWARD_ONS instead of CURRWARD.
This field, which is derived from the patient's postcode in the field HOMEADD, contains a code which defines the pre-2011 electoral ward of the patient. Note that this field uses old-style geographical codes that were superseded in 2011 and are now no longer supported by ONS - the new style code can be found in the field CURRWARD_ONS.
Because identical CURRWARD codes are allocated to many local authority districts, CURRWARD is meaningless in isolation. This field should be used in conjunction with RESLADST (local authority district) to produce a unique value indicating the ward within a given district where the patient resided.
GECKO:0000064
Current electoral ward
currward
GECKO:0000064
residence
This derived field contains a code which defines the current electoral ward of the patient. It is derived from the patient's postcode in the field homeadd.
GECKO:0000064
Current electoral ward (ONS)
currward_ons
GECKO:0000064
residence
This field contains a code that defines the county of residence of the patient. It is derived from the patient's postcode in the field homeadd.
GECKO:0000064
County of residence (ONS)
rescty_ons
GECKO:0000064
residence
Government Office Region (GOR) of treatment. This field is derived from the hospital provider code (procode). It indicates the GOR area within which the treatment took place.
GECKO:0000064
Government office region of treatment
gortreat
GECKO:0000064
residence
The Primary Care Trust (PCT) of residence dependent on the data year.
If the HES data year is 2006 or later, it will return the value from the field RESPCT06. If the data year is earlier than 2006, it will return the value from the field RESPCT02.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
PCT of residence - mapped according to data year
respct
GECKO:0000064
residence
The Primary Care Trust (PCT) of residence dependent on the data year.
If the HES data year is 2006 or later, it will return the value from the field RESPCT06. If the data year is earlier than 2006, it will return the value from the field RESPCT02.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
PCT of residence - mapped according to data year
respct_his
GECKO:0000064
residence
This field contains a code that defines the Primary Care Trust (PCT) of residence of the patient, based on 2002-03 PCT boundaries. It is derived from the patient's postcode in the field homeadd.
This PCT structure was superseded in 2006 - the code representing the PCTs that were in place after this restructure can be found in the field RESPCT06.
GECKO:0000064
PCT of residence (2002)
respct02
GECKO:0000064
residence
This field contains a code that defines the Primary Care Trust (PCT) of residence of the patient, based on 2006-07 PCT boundaries. It is derived from the patient's postcode in the field homeadd.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
PCT of residence (2006)
respct06
GECKO:0000064
residence
This field contains a code that defines the Regional Office (RO) area of residence of the patient. It is derived from the patient's postcode in the field homeadd.
ROs were abolished in 2002. This field has continued to be derived after this date as a ‚Äö√Ñ√≤frozen‚Äö√Ñô geography.
GECKO:0000064
Regional Office of residence
resro
GECKO:0000064
residence
This derived field contains the code for the Commissioning Region (CR) where the patient lived immediately before admission. Where not available, the code for the Area Team is used. It is derived from the CCG of Residence.
GECKO:0000064
Commissioning Region of Residence
cr_residence
GECKO:0000064
residence
For activity from 2011-12 onwards, HES users are advised to use the field RESLADST_ONS instead of RESLADST.
This field contains a code that defines the county (first two characters) and local authority district (last two characters) of residence of the patient. It is derived from the patient's postcode in the field homeadd. Note that this field uses old-style geographical codes that were superseded in 2011 and are now no longer supported by ONS. The field RESLADST_ONS represents the local authority district of residence using codes from the current ONS geographical coding system.
RESLADST is used in conjunction with CURRWARD (current electoral ward) to produce a unique value indicating the ward within a given district where the patient resided (ie because identical CURRWARD codes are allocated to many local authority districts, CURRWARD is meaningless in isolation). If the patient is resident within a Unitary Authority, the first two characters will be 00 (zero, zero) and the local authority component may not be useable.
GECKO:0000064
Local authority district of residence
resladst
GECKO:0000064
residence
This field contains a code that defines the Strategic Health Authority (SHA) area where the treatment took place. It is derived from the hospital provider code in the field procode. Note: (1) for NHS trusts, care provided at subsidiary sites will be attributed to the main trust location.
SHAs were abolished in 2013. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000006
SHA area of treatment
sthatret
GECKO:0000006
location
For activity from 2011-12 onwards, HES users are advised to use the field RESCTY_ONS instead of RESCTY.
This field contains a code that defines the county of residence of the patient. It is derived from the patient's postcode in the field homeadd (postcode of patient).
Note that this field uses old-style geographical codes that were superseded in 2011 and are now no longer supported by ONS. The field RESCTY_ONS represents the county of residence using codes from the current ONS geographical coding system.
GECKO:0000064
County of residence
rescty
GECKO:0000064
residence
This field, which is derived from the patient's postcode in the field HOMEADD, contains a code which defines the Ordnance survey postcode grid reference of the patient's residence.
The Gridlink field in HES is only available to the NHS. Access to it requires the approval of The Independent Group Advising on the Release of Data (IGARD).|This field indicates the health authority (HA) where the treatment took place. It is derived from the hospital provider code (procode).
In 2002 following a reorganisation of health areas, Health Authorities were replaced by Strategic Health Authorities. This field has continued to be derived after this date as a ‚Äö√Ñ√≤frozen‚Äö√Ñô geography.|Provides the Strategic Health Authority (SHA) area in which the patient‚Äö√Ñôs GP is registered.
In 2013 following a reorganisation of health areas, Strategic Health Authorities were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
Ordnance Survey grid reference
hatreat
GECKO:0000064
residence
This field contains a code that defines the site on which the patient was treated within an organisation. The code recorded should be the one of the Health Care Provider actually carrying out the work.
It contains the first 3 digit of the Provider Code with the last two digits being the site identifier.
GECKO:0000006
Site code of treatment
sitetret
GECKO:0000006
location
This field, which is derived from the patient's postcode in the field HOMEADD, represents the 2001 Census Middle Layer SOA (MSOA) code for England and Wales and intermediate zone for Scotland. Pseudo codes are included for Northern Ireland, Channel Islands and Isle of Man. The field will otherwise be blank for postcodes with no grid reference. The first character is either E for England or W for Wales. The next two characters are 02 for Middle Layer and the remaining six characters make up the unique 6-digit tag for each zone.
GECKO:0000006
Middle Super Output Area, 2001
msoa01
GECKO:0000006
location
This field is derived from the hospital provider code (procode). It indicates the PCT area of the main provider of treatment. Note that the PCT itself may be the provider of treatment.
Note: This field was formerly known as ‚Äö√Ñ√∫Primary care trust area of treatment‚Äö√Ñù.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.|This derived field indicates the basis on which the code in the field PCTCODE06 was assigned.
GECKO:0000006
Primary Care Trust area of main provider
pcttreat
GECKO:0000006
location
GECKO:0000052
Healthcare resource groups (HRG) data
healthcare_resource_groups_hrg_data
GECKO:0000052
survey administration
The SUS PbR derived main healthcare resource group (HRG) code (HRG4 from 2009-10) at spell level.
Please note that due to possible disparities between the processing times of PbR and SUS Extract Mart, data submitted to SUS close to the deadline may have not yet been assigned a HRG. Also, analysing this field by episode in HES could lead to over-counting.
GECKO:0000052
SUS generated Core Spell HRG
suscorehrg
GECKO:0000052
survey administration
The SUS PbR derived healthcare resource group (HRG) code (HRG4 from 2009-10) at episode level.|The SUS PbR derived healthcare resource group (HRG) code (HRG4 from 2009-10).|The SUS PbR derived healthcare resource group (HRG) code.
GECKO:0000052
SUS generated HRG
sushrg
GECKO:0000052
survey administration
An additional SUS derived healthcare resource group (HRG) code, provided by SUS for information. For example, in 2009-10 this field is populated with HRG4 in preparation for the move to HRG4 for A&E activity in the following year.
GECKO:0000052
SUS generated HRG for information
sushrginfo
GECKO:0000052
survey administration
The version number for the SUS generated HRG code (sushrg).
GECKO:0000052
SUS generated HRG version number
sushrgvers
GECKO:0000052
survey administration
Contains the dominant procedure (operation) code assigned as part of the (NHS) HRG derivation process and submitted to SUS.|The procedure that the Healthcare Resource Group grouping algorithm has identified as having the greatest effect upon the resources consumed by a patient.
GECKO:0000052
Trust derived dominant procedure
domproc
GECKO:0000052
survey administration
GECKO:0000052
Trust derived HRG value v3.5
hrglate35
GECKO:0000052
survey administration
The version number for the Trust derived HRG value (hrgnhs).|The version number for NHS-generated HRG code (hrgnhs).|The version number for Trust generated HRG code
GECKO:0000052
Version No. of Trust derived HRG
hrgnhsvn
GECKO:0000052
survey administration
The NHS-generated HRG code as submitted to SUS takes into account the dominant grouping procedure (domproc) and may differ from the HES derived HRG (HRG_n.n).|The NHS-generated HRG code as submitted to SUS.|The Trust generated HRG code
GECKO:0000052
Trust derived HRG value
hrgnhs
GECKO:0000052
survey administration
GECKO:0000092
Hip Replacement
hip_replacement
GECKO:0000092
surgical interventions
Casemix-adjusted predicted post-operative OHS, derived using version 3 of the casemix-adjustment model.
GECKO:0000092
hr_score_expected_final_model3
hr_score_expected_final_model3
GECKO:0000092
surgical interventions
Hip Replacement - Q1
hip_replacement_q1
Each of the Hip Replacement question has 5 possible responses which each are attributable 0-4 points. The HR score is derived by adding the points for each question. The maximum number of points is 48 which would signify the best outcome, the minimum being 0.
GECKO:0000052
hr_q1_score
hr_q1_score
GECKO:0000052
survey administration
Indicates whether the submitted questionnaire has sufficient procedure specific data to derive a score
GECKO:0000052
hr_q1_score_complete
hr_q1_score_complete
GECKO:0000052
survey administration
During the past 4 weeks, have you been able to put on a pair of socks, stockings or tights?
OGMS:0000020
Q1-HR6
hr_q1_dressing
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been limping when walking, because of your hip?
OGMS:0000020
Q1-HR9
hr_q1_limping
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been troubled by pain from your hip in bed at night?
OGMS:0000020
Q1-HR3
hr_q1_night_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, how would you describe the pain you usually had from your hip?
OGMS:0000020
Q1-HR1
hr_q1_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, could you do the household shopping on your own?
OGMS:0000020
Q1-HR7
hr_q1_shopping
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been able to climb a flight of stairs?
OGMS:0000020
Q1-HR10
hr_q1_stairs
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had any sudden, severe pain - 'shooting', 'stabbing' or 'spasms' - from the affected hip?
OGMS:0000020
Q1-HR11
hr_q1_standing
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had any sudden, severe pain - 'shooting', 'stabbing' or 'spasms' - from the affected hip?
OGMS:0000020
Q1-HR2
hr_q1_sudden_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had any trouble getting in or out of your car or using public transport because of your hip?
OGMS:0000020
Q1-HR5
hr_q1_transport
OGMS:0000020
signs and symptoms
During the past 4 weeks, for how long have you been able to walk before pain from your hip becomes severe? (with or without a stick)
OGMS:0000020
Q1-HR8
hr_q1_walking
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had trouble washing and drying yourself (all over) because of your hip?
OGMS:0000020
Q1-HR4
hr_q1_washing
OGMS:0000020
signs and symptoms
During the past 4 weeks, how much has pain from your hip interfered with your usual work (including housework)?
OGMS:0000020
Q1-HR12
hr_q1_work
OGMS:0000020
signs and symptoms
Hip Replacement - Q2
hip_replacement_q2
Each of the Hip Replacement question has 5 possible responses which each are attributable 0-4 points. The HR score is derived by adding the points for each question. The maximum number of points is 48 which would signify the best outcome, the minimum being 0.
GECKO:0000052
hr_q2_score
hr_q2_score
GECKO:0000052
survey administration
During the past 4 weeks, have you been able to put on a pair of socks, stockings or tights?
OGMS:0000020
Q2-HR6
hr_q2_dressing
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been limping when walking, because of your hip?
OGMS:0000020
Q2-HR9
hr_q2_limping
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been troubled by pain from your hip in bed at night?
OGMS:0000020
Q2-HR3
hr_q2_night_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, how would you describe the pain you usually had from your hip?
OGMS:0000020
Q2-HR1
hr_q2_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, could you do the household shopping on your own?
OGMS:0000020
Q2-HR7
hr_q2_shopping
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been able to climb a flight of stairs?
OGMS:0000020
Q2-HR10
hr_q2_stairs
OGMS:0000020
signs and symptoms
During the past 4 weeks, after a meal (sat at a table), how painful has it been for you to stand up from a chair because of your hip?
OGMS:0000020
Q2-HR11
hr_q2_standing
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had any sudden, severe pain - 'shooting', 'stabbing' or 'spasms' - from the affected hip?
OGMS:0000020
Q2-HR2
hr_q2_sudden_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had any trouble getting in or out of your car or using public transport because of your hip?
OGMS:0000020
Q2-HR5
hr_q2_transport
OGMS:0000020
signs and symptoms
During the past 4 weeks, for how long have you been able to walk before pain from your hip becomes severe? (with or without a stick)
OGMS:0000020
Q2-HR8
hr_q2_walking
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had trouble washing and drying yourself (all over) because of your hip?
OGMS:0000020
Q2-HR4
hr_q2_washing
OGMS:0000020
signs and symptoms
During the past 4 weeks, how much has pain from your hip interfered with your usual work (including housework)?
OGMS:0000020
Q2-HR12
hr_q2_work
OGMS:0000020
signs and symptoms
Indicates whether the submitted questionnaire has sufficient procedure specific data to derive a score
GECKO:0000052
hr_q2_score_complete
hr_q2_score_complete
GECKO:0000052
survey administration
Imaging Codes
imaging_codes
Provides National Interim Clinical Imaging Procedure Code as submitted. It must be a valid active code. If the code is invalid or a valid but inactive NICIP code the record will be rejected. Imaging Code (NICIP) and Imaging Code (SNOMED-CT) are jointly mandatory, at least one of the two fields must be populated.
GECKO:0000052
Imaging Code (NICIP)
did_nicip_code
GECKO:0000052
survey administration
Provides Imaging Code (SNOMED-CT) as submitted. It must be a valid active code. If the code is invalid or a valid but inactive SNOMED-CT code the record will be rejected
GECKO:0000052
Imaging Code (SNOMED)
ic_snomedct_desc
GECKO:0000052
survey administration
Based on submitted field Imaging Code (NICIP), returning text description of NICIP Code
GECKO:0000052
Imaging Code (NICIP) Description
ic_nicip_desc
GECKO:0000052
survey administration
Indicators
indicators
Indicates that there is a complete Q1 and Q2.
GECKO:0000052
Complete
complete
GECKO:0000052
survey administration
Response to corresponding Q1 general health question:
Have you been told by a doctor that you have leg pain when walking due to poor circulation?
OGMS:0000020
Circulation
circulation
OGMS:0000020
signs and symptoms
Have you been told by a doctor that you have liver disease?
MONDO:0005151
Liver Disease
liver_disease
MONDO:0005151
endocrine system diseases
Response to corresponding Q1 general health question: Have you been told by a doctor that you have arthritis?
MONDO:0000001
Arthritis Indicator
arthritis
MONDO:0000001
diseases
Response to corresponding Q1 general health question:
Have you been told by a doctor that you have diabetes?
MONDO:0005151
Diabetes
diabetes
MONDO:0005151
endocrine system diseases
Response to corresponding Q1 general health question: Have you been told by a doctor that you have depression?
MONDO:0005084
Depression
depression
MONDO:0005084
mental and behaviour disorders
Have you been told by a doctor that you have diseases of the nervous system?
MONDO:0005071
nervous_system
nervous_system
MONDO:0005071
nervous system disorders
Have you been told by a doctor that you have problems caused by a stroke?
OGMS:0000020
stroke
stroke
OGMS:0000020
signs and symptoms
Response to corresponding Q1 general health question: Have you been told by a doctor that you have cancer?
MONDO:0004992
Cancer Indicator
cancer
MONDO:0004992
cancer
Have you been told by a doctor that you have lung disease?
MONDO:0005087
Lung Disease
lung_disease
MONDO:0005087
respiratory system diseases
Response to corresponding Q1 general health question: Have you been told by a doctor that you have heart disease?
MONDO:0004995
Heart Disease Indicator
heart_disease
MONDO:0004995
cardiovascular diseases
Response to corresponding Q1 general health question:
Have you been told by a doctor that you have high blood pressure?
OGMS:0000020
High Blood Pressiure Indicator
high_bp
OGMS:0000020
signs and symptoms
Have you been told by a doctor that you have kidney disease?
MONDO:0005151
Kidney Disease
kidney_disease
MONDO:0005151
endocrine system diseases
Knee Replacement - Q1
knee_replacement_q1
During the past 4 weeks, have you felt that your knee might suddenly 'give way' or let you down?
OGMS:0000020
Q1 - KR10
kr_q1_confidence
OGMS:0000020
signs and symptoms
During the past 4 weeks, could you kneel down and get up again afterwards
OGMS:0000020
Q1 - KR8
kr_q1_kneeling
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been limping when walking, because of your knee?
OGMS:0000020
Q1-KR7
kr_q1_limping
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been troubled by pain from your knee in bed at night?
OGMS:0000020
Q1-KR2
kr_q1_night_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, how would you describe the pain you usually had from your knee?
OGMS:0000020
Q1-KR1
kr_q1_pain
OGMS:0000020
signs and symptoms
value of appropraite score for Knee Replacement for Q1
OGMS:0000020
Q1-KR5
kr_q1_score
OGMS:0000020
signs and symptoms
During the past 4 weeks, could you do the household shopping on your own?
OGMS:0000020
Q1-KR11
kr_q1_shopping
OGMS:0000020
signs and symptoms
During the past 4 weeks, could you walk down one flight of stairs?
OGMS:0000020
Q1-KR12
kr_q1_stairs
OGMS:0000020
signs and symptoms
During the past 4 weeks, after a meal (sat at a table), how painful has it been for you to stand up from a chair because of your knee?
OGMS:0000020
Q1-KR6
kr_q1_standing
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had any trouble getting in or out of your car or using public transport because of your knee?
OGMS:0000020
Q1-KR4
kr_q1_transport
OGMS:0000020
signs and symptoms
During the past 4 weeks, for how long have you been able to walk before pain from your knee becomes severe? (with or without a stick)
OGMS:0000020
Q1-KR5
kr_q1_walking
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had trouble washing and drying yourself (all over) because of your knee
OGMS:0000020
Q1-KR3
kr_q1_washing
OGMS:0000020
signs and symptoms
During the past 4 weeks, how much has pain from your knee interfered with your usual work (including housework)?
OGMS:0000020
Q1-KR9
kr_q1_work
OGMS:0000020
signs and symptoms
Knee Replacement - Q2
knee_replacement_q2
Indicates whether the submitted questionnaire has sufficient procedure specific data to derive a score
GECKO:0000052
kr_q2_score_complete
kr_q2_score_complete
GECKO:0000052
survey administration
During the past 4 weeks, could you walk down one flight of stairs?
OGMS:0000020
kr_q2_stairs
kr_q2_stairs
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you felt that your knee might suddenly 'give way' or let you down?
OGMS:0000020
Q2-KR10
kr_q2_confidence
OGMS:0000020
signs and symptoms
During the past 4 weeks, could you kneel down and get up again afterwards?
OGMS:0000020
Q2-KR8
kr_q2_kneeling
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been limping when walking, because of your knee?
OGMS:0000020
Q2-KR7
kr_q2_limping
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you been troubled by pain from your knee in bed at night?
OGMS:0000020
Q2-KR2
kr_q2_night_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, how would you describe the pain you usually had from your knee?
OGMS:0000020
Q2-KR1
kr_q2_pain
OGMS:0000020
signs and symptoms
During the past 4 weeks, could you do the household shopping on your own?
OGMS:0000020
Q2-KR11
kr_q2_shopping
OGMS:0000020
signs and symptoms
During the past 4 weeks, after a meal (sat at a table), how painful has it been for you to stand up from a chair because of your knee?
OGMS:0000020
Q2-KR6
kr_q2_standing
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had any trouble getting in or out of your car or using public transport because of your knee?
OGMS:0000020
Q2-KR4
kr_q2_transport
OGMS:0000020
signs and symptoms
During the past 4 weeks, for how long have you been able to walk before pain from your knee becomes severe? (with or without a stick)
OGMS:0000020
Q2-KR5
kr_q2_walking
OGMS:0000020
signs and symptoms
During the past 4 weeks, have you had trouble washing and drying yourself (all over) because of your knee
OGMS:0000020
Q2-KR3
kr_q2_washing
OGMS:0000020
signs and symptoms
During the past 4 weeks, how much has pain from your knee interfered with your usual work (including housework)?
OGMS:0000020
Q2-KR9
kr_q2_work
OGMS:0000020
signs and symptoms
Location
location
Contains Lower Super Output Area code, derived from submitted field Postcode of Patient Usual Address. Postcode of Patient Usual Address undergoes hard validation during data submission processes to ensure that codes provided are formatted correctly. If the code differs in format in any way, the submitted data will not be uploaded. Postcode of Patient Usual Address can be left blank.
GECKO:0000064
Location - LSOA
ic_lsoa
GECKO:0000064
residence
Returns Middle Super Output Area code, derived from submitted field Postcode of Patient Usual Address. Postcode of Patient Usual Address undergoes hard validation during data submission processes to ensure that codes provided are formatted correctly. If the code differs in format in any way, the submitted data will not be uploaded.
GECKO:0000064
Location - MSOA
ic_msoa
GECKO:0000064
residence
Maternity
maternity
GECKO:0000052
Episode Type - Maternity
maternity_episode_type
GECKO:0000052
survey administration
This field contains the date when a pregnant woman was first assessed and arrangements were made for antenatal care. This is not necessarily the date when delivery arrangements were made.
GECKO:0000114
STATO:0000093
First antenatal assessment date
anasdate
GECKO:0000114
reproduction
STATO:0000093
date and time-related information
This field contains the age in days of a baby admitted as a patient. It is derived from admission date (admidate) and date of birth (dob). If the baby is older than 27 days, neodur is not calculated.
GECKO:0000114
PATO:0000011
Age of baby in days
neodur
GECKO:0000114
reproduction
PATO:0000011
age/birthdate
This field contains the mother's age in whole years on the date of delivery. It is calculated from the mother's date of birth and the first baby's date of birth.
GECKO:0000114
PATO:0000011
Mother‚Äö√Ñôs age at delivery
matage
GECKO:0000114
reproduction
PATO:0000011
age/birthdate
This field contains a code that defines the level of care given to a newborn child (under 28 days of age). For patients over 28 days old, default code '8' would apply. (Along with psychiatric patient status (admistat), this field replaced the V code indicator (vind) field in 1996).
GECKO:0000052
Neonatal level of care
neocare
GECKO:0000052
survey administration
On delivery records only (epitype 2 and 5), the number of valid baby groups
present on the record. A valid baby group is defined as one which has a valid birthweight and a valid delivery method. If no valid baby group is present on the delivery record, this field defaults to 1.
GECKO:0000114
Number of baby tails
numtailb
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_2
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_3
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_4
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_5
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_6
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_7
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_8
GECKO:0000114
reproduction
GECKO:0000114
BIRWEIT_N
birweit_9
GECKO:0000114
reproduction
This field contains a code that defines the reason for changing the delivery place type.
GECKO:0000052
Delivery place change reason
delchang
GECKO:0000052
survey administration
GECKO:0000114
delplac_5
delplac_5
GECKO:0000114
reproduction
GECKO:0000114
delplac_6
delplac_6
GECKO:0000114
reproduction
GECKO:0000114
delplac_7
delplac_7
GECKO:0000114
reproduction
GECKO:0000114
delplac_8
delplac_8
GECKO:0000114
reproduction
GECKO:0000114
delplac_9
delplac_9
GECKO:0000114
reproduction
GECKO:0000114
gestat_4
gestat_4
GECKO:0000114
reproduction
GECKO:0000114
gestat_5
gestat_5
GECKO:0000114
reproduction
GECKO:0000114
gestat_6
gestat_6
GECKO:0000114
reproduction
GECKO:0000114
gestat_7
gestat_7
GECKO:0000114
reproduction
This field contains a code that identifies the method used to get the baby breathing normally. This item appears for each baby on multiple birth delivery records.
GECKO:0000114
Resuscitation Method
biresus_1
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_2
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_3
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_4
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_5
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_6
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_7
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_8
GECKO:0000114
reproduction
GECKO:0000114
BIRESUS_N
biresus_9
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_2
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_3
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_4
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_5
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_6
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_7
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_8
GECKO:0000114
reproduction
GECKO:0000114
BIRORDR_N
birordr_9
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_2
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_3
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_4
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_5
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_6
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_7
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_8
GECKO:0000114
reproduction
GECKO:0000114
BIRSTAT_N
birstat_9
GECKO:0000114
reproduction
On delivery and birth records only (epitypes 2 and 3), this derived field calculates the number of days between the baby's birth and the end of the finished episode. It is calculated from the episode end date (epiend) and the baby's date of birth (dobbaby1 on delivery records, dob on birth records).
GECKO:0000114
STATO:0000093
Postnatal stay
postdur
GECKO:0000114
reproduction
STATO:0000093
date and time-related information
GECKO:0000114
delplac_2
delplac_2
GECKO:0000114
reproduction
GECKO:0000114
delplac_3
delplac_3
GECKO:0000114
reproduction
GECKO:0000114
delplac_4
delplac_4
GECKO:0000114
reproduction
GECKO:0000114
gestat_2
gestat_2
GECKO:0000114
reproduction
GECKO:0000114
gestat_3
gestat_3
GECKO:0000114
reproduction
This field contains a code which defines the method used to induce (initiate) labour, rather than to accelerate it.
GECKO:0000114
Labour/delivery onset method
delonset
GECKO:0000114
reproduction
This field contains a code that defines the sex of the baby. This item appears for each baby on multiple birth delivery records.
GECKO:0000114
PATO:0000047
Sex of baby
sexbaby_1
GECKO:0000114
reproduction
PATO:0000047
biological sex
GECKO:0000114
PATO:0000047
sexbaby_8
sexbaby_8
GECKO:0000114
reproduction
PATO:0000047
biological sex
GECKO:0000114
PATO:0000047
sexbaby_9
sexbaby_9
GECKO:0000114
reproduction
PATO:0000047
biological sex
GECKO:0000114
STATO:0000093
gestat_9
gestat_9
GECKO:0000114
reproduction
STATO:0000093
date and time-related information
This is the number of weeks completed gestation, based upon an average 40 week gestation, which may be derived from:
a) estimated date of delivery calculated by Ultrasound Scan measurements according to the trimester of the scan
b) estimated date of delivery measured from the first day of last menstrual period (LMP)
c) clinical assessment (in the absence of a or b) - antenatally for Maternity, postnatally for Neonatal
GECKO:0000114
STATO:0000093
Length of gestation
gestat_1
GECKO:0000114
reproduction
STATO:0000093
date and time-related information
This derived field contains the number of days between the start of the episode (epistart) and the date of delivery of the first baby (dobbaby1).
GECKO:0000114
STATO:0000093
Antenatal days of stay
antedur
GECKO:0000114
reproduction
STATO:0000093
date and time-related information
This field contains a code which defines the method used to deliver a baby that is a registrable birth.
This data item is derived from the main procedure code.
GECKO:0000114
Alternative Delivery method (Derived)
delmeth_1
GECKO:0000114
reproduction
This derived field is a flag to indicate a healthly baby based on episode type (EPITYPE) '3' (Birth Episode) and '6' (Other birth event) and SUS Generated HRG (SUSHRG) with a value of 'PB03Z' (Healthy Baby).
GECKO:0000114
Healthly Neonate Indicator
hneoind
GECKO:0000114
reproduction
GECKO:0000114
delstat_2
delstat_2
GECKO:0000114
reproduction
GECKO:0000114
delstat_3
delstat_3
GECKO:0000114
reproduction
GECKO:0000114
delstat_4
delstat_4
GECKO:0000114
reproduction
GECKO:0000114
delstat_5
delstat_5
GECKO:0000114
reproduction
GECKO:0000114
delstat_6
delstat_6
GECKO:0000114
reproduction
GECKO:0000114
delstat_7
delstat_7
GECKO:0000114
reproduction
GECKO:0000114
delstat_8
delstat_8
GECKO:0000114
reproduction
GECKO:0000114
delstat_9
delstat_9
GECKO:0000114
reproduction
This field normally provides the status of the person conducting the delivery. When a student delivers the baby, the code of the supervisor should be given. This item appears for each baby on multiple birth delivery records.
GECKO:0000114
Status of person conducting delivery
delstat_1
GECKO:0000114
reproduction
This field contains the number of babies delivered at the end of a single pregnancy. Both live and stillborn babies are counted. Until 2002-03, a maximum of 6 babies could be recorded in HES.
GECKO:0000114
Number of babies
numbaby
GECKO:0000114
reproduction
The number of previous pregnancies that resulted in a registrable birth (live or still born). This field only appears on delivery records (epitype 2 and 5).
GECKO:0000114
Number of previous pregnancies
numpreg
GECKO:0000114
reproduction
The position in the sequence of births. This item appears for each baby on multiple birth delivery records. From 1996-97 the same value (1) is used for a single birth or the first born of several. Up until March 2002, only the first six births were recorded.
GECKO:0000114
Birth Order
birordr_1
GECKO:0000114
reproduction
This field contains a code which indicates whether the baby was born alive or dead (still birth). A still birth is a birth after a gestation period of 24 weeks (168) days where the baby shows no sign of life when delivered. This item appears for each baby on multiple birth delivery records.
GECKO:0000114
Birth Status
birstat_1
GECKO:0000114
reproduction
GECKO:0000114
delmeth_2
delmeth_2
GECKO:0000114
reproduction
GECKO:0000114
delmeth_3
delmeth_3
GECKO:0000114
reproduction
GECKO:0000114
delmeth_4
delmeth_4
GECKO:0000114
reproduction
GECKO:0000114
delmeth_5
delmeth_5
GECKO:0000114
reproduction
GECKO:0000114
delmeth_6
delmeth_6
GECKO:0000114
reproduction
GECKO:0000114
delmeth_7
delmeth_7
GECKO:0000114
reproduction
GECKO:0000114
delmeth_8
delmeth_8
GECKO:0000114
reproduction
GECKO:0000114
delmeth_9
delmeth_9
GECKO:0000114
reproduction
GECKO:0000114
gestat_8
gestat_8
GECKO:0000114
reproduction
Codes in this field indicate whether the episode relates to a well baby (a neonate receiving normal levels of care, usually given by a mother or mother substitute).
GECKO:0000114
Well baby flag
well_baby_ind
GECKO:0000114
reproduction
GECKO:0000114
sexbaby_2
sexbaby_2
GECKO:0000114
reproduction
GECKO:0000114
sexbaby_3
sexbaby_3
GECKO:0000114
reproduction
GECKO:0000114
sexbaby_4
sexbaby_4
GECKO:0000114
reproduction
GECKO:0000114
sexbaby_5
sexbaby_5
GECKO:0000114
reproduction
GECKO:0000114
sexbaby_6
sexbaby_6
GECKO:0000114
reproduction
GECKO:0000114
sexbaby_7
sexbaby_7
GECKO:0000114
reproduction
This field contains a code which defines the intended type of delivery place. The initial intention is designated by the General Medical Practitioner (GMP) and midwife, or by the GMP and hospital staff. The decision is normally made when the mother is assessed for delivery. The actual delivery place type is in delplac.
GECKO:0000114
Delivery place (intended)
delinten
GECKO:0000114
reproduction
This field contains a code which defines the actual type of delivery place (The intended delivery place is in delinten). This item appears for each baby on multiple birth delivery records.
GECKO:0000114
Delivery place (actual)
delplac_1
GECKO:0000114
reproduction
This field contains the weight of the baby in grams immediately after birth. This item appears for each baby on multiple birth delivery records.
GECKO:0000114
Birth Weight
birweit_1
GECKO:0000114
reproduction
This field contains a code which defines the anaesthetic or analgesic administered after delivery.
GECKO:0000093
GECKO:0000114
Anaesthetic given post-labour or delivery
delposan
GECKO:0000093
medication
GECKO:0000114
reproduction
This field contains a code which defines the anaesthetic or analgesic administered before and during labour and delivery.
GECKO:0000093
GECKO:0000114
Anaesthetic given during labour or delivery
delprean
GECKO:0000093
medication
GECKO:0000114
reproduction
Gestation period in weeks at the date of the first antenatal assessment. This field is calculated from anadate, gestat and the dobbaby.
GECKO:0000114
STATO:0000093
Gestation period in weeks at first antenatal assessment
anagest
GECKO:0000114
reproduction
STATO:0000093
date and time-related information
Based on Modality categories derived from submitted NICIP or SNOMED-CT codes
GECKO:0000052
Modality
ic_modality_desc
GECKO:0000052
survey administration
Broad categories represented by an ID, grouping procedures or methods used for examination that may include procedures assisted by the method, e.g. biopsy or injection. These categories are derived from submitted NICIP or SNOMED-CT codes.
GECKO:0000055
Modality ID
ic_modality_id
GECKO:0000055
unique identifiers
Descriptive categorisation of imaging by morphology, based on Morphology ID categorisation of submitted NICIP or SNOMED-CT codes.
GECKO:0000052
Morphology
ic_morph_desc
GECKO:0000052
survey administration
Based on submitted NICIP or SNOMED-CT codes and represented by an ID number, Morphology ID provides categorisation of imaging conducted on morphologic abnormalities (alterations of the body structure from its original anatomical structure)
GECKO:0000055
Morphology ID
ic_morphology_id
GECKO:0000055
unique identifiers
GECKO:0000052
Organisation
organisation
GECKO:0000052
survey administration
Provides the Regional Office area in which the patient's GP is registered.|Provides the Regional Office area in which the patient‚Äö√Ñôs GP is registered.
GECKO:0000006
Regional Office area where patient‚Äö√Ñôs GP was registered
gppracro
GECKO:0000006
location
The organisation code of the organisation that submitted the record of the imaging event to DID, taken from Submitter Code attached to each record
GECKO:0000052
Organisation Code
ic_prov_orgcode
GECKO:0000052
survey administration
The organisation code of the organisation that submitted the record of the imaging event to DID, taken from Submitter Code attached to each record
GECKO:0000052
Organisation Code
ic_submit_orgcode
GECKO:0000052
survey administration
Descriptive field, based on the Organisation Code, which returns the organisation name which submitted the associated imaging event record to DID.
GECKO:0000052
Organisation Name
ic_submit_orgname
GECKO:0000052
survey administration
A derived field providing the Primary Care Group responsible for the patient.
GECKO:0000052
Primary care group
pcgcode
GECKO:0000052
survey administration
A pseudonymised version of the code of a patient's registered GP practice (registered GMP). Please note that the registered GP may not be the same as the referring GP (See Preferrer). The Code of GP Practice (Gpprac) field contains the actual practice code.
GECKO:0000073
Pseudonymised code of GP practice
pgpprac
GECKO:0000073
physician/practitioner info
The organisation code of the organisation acting as the health care provider. This
field contains the provider code (PROCODE) to 5-characters. Where the field PROCODE contains a 3-character code, it will be padded to the right with additional zeros in this field.
Note that details of the site code can be found in the field 'site code of treatment' (SITETRET).|The organisation code of the organisation acting as the health care provider. This field contains the provider code (PROCODE) to 5-characters. Where the field PROCODE contains a 3-character code, it will be padded to the right with additional zeros in this field.
Note that details of the site code can be found in the field 'site code of treatment' (SITETRET).
GECKO:0000073
Provider code (5 character)
procode5
GECKO:0000073
physician/practitioner info
Contains the commissioning serial number (used in HES to identify OATs - Out of Area Treatments). This is a number used to uniquely identify a NHS SERVICE AGREEMENT by an ORGANISATION acting as commissioner of patient care services.
GECKO:0000052
Commissioning serial number
csnum
GECKO:0000052
survey administration
This field contains a code for the organisation commissioning the patient's health care.
GECKO:0000052
Commissioner code
purcode
GECKO:0000052
survey administration
This field contains a code which identifies the Regional Office (RO) in which the commissioner is located. It is derived from the purcode field.
The codes include those used in 1995-96 and those used subsequently. There were alterations to the codes from April 1996 and April 1999 to reflect changes in the regional organisation.
GECKO:0000052
Commissioner's Regional Office
purro
GECKO:0000052
survey administration
This field contains a code which identifies the strategic health authority (SHA) in which the commissioner is located. It is derived from the purcode field.
In 2013 following a reorganisation of health areas, Strategic Health Authorities were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000052
Commissioner's Strategic Health Authority
purstha
GECKO:0000052
survey administration
A derived field that indicates whether the commissioner code (purcode) is one that is recognised throughout the NHS. If not, the code may have been agreed locally between the hospital provider and the health care purchaser.
GECKO:0000052
Commissioner code status
purval
GECKO:0000052
survey administration
Provides the Health authority area in which the patient‚Äö√Ñôs GP is registered.
In 2002 following a reorganisation of health areas, Health Authorities were replaced by Strategic Health Authorities. This field has continued to be derived after this date as a ‚Äö√Ñ√≤frozen‚Äö√Ñô geography.
GECKO:0000073
Health Authority area where patient's GP is registered
gppracha
GECKO:0000073
physician/practitioner info
GECKO:0000052
Organisation Data
organisation_data
GECKO:0000052
survey administration
A derived field providing the primary care trust responsible for the patient, based on 2002-03 PCT boundaries. Commissioning responsibility for individual patients rests with the primary care trust (PCT) with whom the patient is registered. This means that patients with a GP in one PCT area may reside in a neighbouring or other area but remain the responsibility of the PCT with whom their GP of registration is associated. PCTs are also responsible for non-registered patients who are resident within their boundaries.
The PCT structure used by this field was superseded in 2006 - the code representing the PCTs that were in place after this restructure can be found in the field PCTCODE06.
GECKO:0000052
PCT of responsibility (2002)
pctcode02
GECKO:0000052
survey administration
The organisation code of the organisation acting as the health care provider.
NHS organisations are allocated a main 3-character code, however this field may contain the 3-character organisation code or a full 5-character code (e.g. a site code, a HQ code ending 01 etc.). Independent providers will always be represented in this field by a 5-character code. Users wishing to group data at 3-character level (which will identify an individual organisation - e.g. NHS Trust) may wish to use the field PROCODE3.
Note that details of the site code can be found in the field 'site code of treatment' (SITETRET).
GECKO:0000052
Provider Code
procode
GECKO:0000052
survey administration
Provides the Strategic Health Authority (SHA) area in which the patient's GP is registered.
In 2013 following a reorganisation of health areas, Strategic Health Authorities were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000073
Strategic Health Authority area where patient‚Äö√Ñôs GP was registered
gpprstha
GECKO:0000073
physician/practitioner info
This field gives details of the primary care trust area in which the patient's GP is registered.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.|Provides the primary care trust area in which the patient‚Äö√Ñôs GP is registered.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.|The primary care trust (PCT) area in which the patient's GP is registered.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000073
Primary Care Trust area where patient‚Äö√Ñôs GP was registered
gpprpct
GECKO:0000073
physician/practitioner info
The organisation code of the organisation acting as the health care provider. This field contains the first 3-characters of the provider code (PROCODE) field, which can be used to identify an individual provider (e.g. NHS Trust or PCT* (*before April 2013)).
GECKO:0000073
Provider code (3 character)
procode3
GECKO:0000073
physician/practitioner info
This field gives a combination of 3-character and 5-character provider codes. Procodet enables you to view a combined list of codes, and related data, from:
1. Primary care trusts (3 character, beginning with 5)
2. NHS trusts (3 character, beginning with R or T. Trusts with associated treatment centres will have an '- X' following their code)
3. NHS trust treatment centres (5 character; listed separately to the NHS trusts)
4. Independent providers (5 character, beginning with 8)
5. Independent sector healthcare providers (5 character, beginning with N or A)
For 3-character codes only see procode (provider code (3 character)) and for 5-character codes only see procode5 (provider code (5 character)).|The organisation code of the organisation acting as the health care provider.
NHS organisations are allocated a main 3-character code, however this field may contain the 3-character organisation code or a full 5-character code (e.g. a site code, a HQ code ending 01 etc.). Independent providers will always be represented in this field by a 5-character code. Users wishing to group data at 3-character level (which will identify an individual organisation - e.g. NHS Trust) may wish to use the field PROCODE3.
Note that details of the site code can be found in the field 'site code of treatment' (SITETRET).
GECKO:0000052
Provider code of treatment
procodet
GECKO:0000052
survey administration
Healthcare provider type|The organisation code of the organisation acting as the health care provider. This field contains the first 3-characters of the provider code (PROCODE) field, which can be used to identify an individual provider (e.g. NHS Trust or PCT* (*before April 2013)).
GECKO:0000052
Provider type
protype
GECKO:0000052
survey administration
A derived field providing the primary care trust responsible for the patient, based on 2006-07 PCT boundaries. Commissioning responsibility for individual patients rests with the primary care trust (PCT) with whom the patient is registered. This means that patients with a GP in one PCT area may reside in a neighbouring or other area but remain the responsibility of the PCT with whom their GP of registration is associated. PCTs are also responsible for non-registered patients who are resident within their boundaries.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000052
PCT of responsibility (2006)
pctcode06
GECKO:0000052
survey administration
GECKO:0000073
Practitioner data
practitioner_data
GECKO:0000073
physician/practitioner info
PATO:0001995
Patient Data
patient_data
PATO:0001995
socio-demographic and economic characteristics
Administrative category on admission.
GECKO:0000052
ADMINCAT
admincat
GECKO:0000052
survey administration
GECKO:0000052
Admin category at start of episode
admincatst
GECKO:0000052
survey administration
This field is derived in HES as the patient's age in whole completed years, calculated from appointment date (apptdate) and date of birth (dob).
For patients under 1 year old, special codes in the range 7001 to 7007 apply.
PATO:0000011
Age on day of appointment
apptage
PATO:0000011
age/birthdate
Arrival age (ARRIVALAGE), with decimalised values for babies.
PATO:0000011
Age on arrival - babies decimalised
apptage_calc
PATO:0000011
age/birthdate
This field is derived in HES as the patient's age in whole completed years, calculated from the arrival date (arrivaldate) and date of birth (dob).
For patients under 1 year old, special codes in the range 7001 to 7007 apply.
PATO:0000011
Age on arrival
arrivalage
PATO:0000011
age/birthdate
Arrival age (ARRIVALAGE), with decimalised values for babies.
PATO:0000011
Age on arrival - babies decimalised
arrivalage_calc
PATO:0000011
age/birthdate
Many NHS hospitals have private wards where private patients may use the accommodation and services of the hospital provider. Some hospitals also provide amenity beds, usually located in small side wards for which a charge is made for the accommodation. Both of these categories of patient are defined by the NHS Act of 1977. Any categories of patient, whether NHS, private or amenity patients, can be formally detained under the provisions of the Mental Health Act 1983 and other legislation. Most patients in NHS hospitals or hospital units will come under category 10 (see below). Access to this field requires the approval of Data Access Advisory Group (DAAG).
GECKO:0000052
Administrative & legal status of patient
category
GECKO:0000052
survey administration
This derived field, calculated from episode start date (epistart) and date of birth (dob), contains the patient's age in whole years (From 1 to 115 (1990-91 to 1994-95) and from 1 to 120 (1995-96 onwards)). For patients under 1 year old, special codes in the range 7001 to 7007 apply.
PATO:0000011
Age at start of episode
startage
PATO:0000011
age/birthdate
Age at start of the episode (STARTAGE), with decimalised values for babies.
PATO:0000011
Age at start of episode - babies decimalised
startage_calc
PATO:0000011
age/birthdate
This field indicates whether the NHS Number supplied is valid or not.
GECKO:0000052
NHS Number valid flag
newnhsno_check
GECKO:0000052
survey administration
Ethnic category is supplied by the trusts as a two-character field. Ethrawl contains the right-hand character. The left-hand character should contain the national code. A copy of the raw data found in the left hand character is held in ethraw.
GECKO:0000061
Ethnic category (audit version)
ethrawl
GECKO:0000061
ethnicity/race
This field indicates whether the postcode in the field homeadd is valid or not.
GECKO:0000052
Postcode Found
pcfound
GECKO:0000052
survey administration
Contains the outward portion of the patient's postcode (ie all characters to the left of the space). The code ZZ99 indicates the postcode was either unavailable, or that the patient did not have one (eg because they were normally resident abroad).|This field is derived from the hospital provider code (procode). It indicates the PCT area of the main provider of treatment. Note that the PCT itself may be the provider of treatment.
Note: This field was formerly known as ‚Äö√Ñ√∫Primary care trust area of treatment‚Äö√Ñù.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000064
Postcode district
postdist
GECKO:0000064
residence
The patient's age, in years, at the time of activity, such as admission, discharge or birth.|Age, in years, at CDS activity date, i.e. the arrival date.
PATO:0000011
Age at activity date
activage
PATO:0000011
age/birthdate
A patient's age, in years, at the date of admission.
PATO:0000011
Age on admission
admiage
PATO:0000011
age/birthdate
This derived field contains the patient's age in whole years at the end of a finished episode (from 1 to 115 (1990-91 to 1994-95) and from 1 to 120 (1995-96 onwards)). It is calculated from the episode end date (epiend) and the patient's date of birth (dob).
For unfinished episodes it is calculated using the period end date, i.e. 31st March, instead of epiend. For patients under one year old, special codes apply.
The patient's age in years at the end of an episode is only relevant for General, Delivery or
Birth records. It is recorded as a whole number of years (i.e. any days or months produced
by the calculation are ignored, unless endage is less than 1 year).
PATO:0000011
Age at end of episode
endage
PATO:0000011
age/birthdate
The ethnicity of the patient, as specified by the patient.
From April 2001 the codes were changed to represent the ethnic data categories as defined in the 2001 census. However, HES continued to accept the old codes as well as the new codes for the 2001-02 and 2002-03 data years.|The ethnicity of the patient, as specified by the patient. This field uses the ethnic data categories as defined in the 2001 census.
Note that ETHNOS is very poorly populated on activity prior to the 2011-12 data year.
GECKO:0000061
Ethnic category
ethnos
GECKO:0000061
ethnicity/race
The patient's date of birth. This field contains sensitive data. Access to it requires the approval of The Independent Group Advising on the Release of Data (IGARD).|The patient's year of birth
PATO:0000011
Date of birth - patient
dob
PATO:0000011
age/birthdate
Defines the sex of the patient. The classification is phenotypical rather than genotypical, i.e. it does not provide codes for medical or scientific purposes.
Notes:
• National Code 'Not Known' means that the sex of a person has not been recorded
• National Code 'Not Specified' means indeterminate, i.e. unable to be classified as either male or female.|Defines the sex of the patient. The classification is phenotypical rather than genotypical, i.e. it does not provide codes for medical or scientific purposes.
Notes:
0= National Code 'Not Known' means that the sex of a person has not been recorded
9=National Code 'Not Specified' means indeterminate, i.e. unable to be classified as either male or female.
PATO:0000047
Sex of patient
sex
PATO:0000047
biological sex
GECKO:0000052
Patient Pathway
patient_pathway
GECKO:0000052
survey administration
The date of the earliest of the reasonable offers made to a patient for an
appointment or elective admission (a reasonable offer would include the offer of an appointment or admission for a time and date three or more weeks from the time that the offer was made; the patient accepting an appointment or admission date; the offer of a first appointment in a genitourinary consultant clinic in a sexual health and HIV episode; the offer of any appointment for treatment in a cancer treatment period).
If the patient cancels or does not attend an appointment or admission, EARLDATOFF for the rearranged appointment or admission will be the earliest reasonable offer date of the cancelled appointment or admission.
If the health care provider cancels and re-arranges the appointment or admission, EARLDATOFF for the re-arranged appointment or admission will be the date of the earliest reasonable offer made following the cancellation.
This field should only be recorded if the patient has declined at least two reasonable offers, and a patient pause is to be applied to a Referral to Treatment period by the Secondary Uses Service.|The date of the earliest of the reasonable offers made to a patient for an appointment or elective admission (a reasonable offer would include the offer of an appointment or admission for a time and date three or more weeks from the time that the offer was made; the patient accepting an appointment or admission date; the offer of a first appointment in a genitourinary consultant clinic in a sexual health and HIV episode; the offer of any appointment for treatment in a cancer treatment period).
If the patient cancels or does not attend an appointment or admission, EARLDATOFF for the rearranged appointment or admission will be the earliest reasonable offer date of the cancelled appointment or admission.
If the health care provider cancels and re-arranges the appointment or admission, EARLDATOFF for the re-arranged appointment or admission will be the date of the earliest reasonable offer made following the cancellation.
This field should only be recorded if the patient has declined at least two reasonable offers, and a patient pause is to be applied to a Referral to Treatment period by the Secondary Uses Service.
STATO:0000093
Earliest reasonable date offered
earldatoff
STATO:0000093
date and time-related information
‚ÄòWaiting’ gives the period in days between the date of the appointment date and either the referral request received date (reqdate) or the DNA (did not attend) date, if given. If the calculation returns a negative the waiting time is set as null. Waiting time is not calculated if reqdate is missing or invalid. (Waitind (see below) indicates how and whether waiting time has been calculated.) Note: As records can relate to DNAs, it is possible to have a waiting time for the record even where the patient didn’t attend.
STATO:0000093
Days waiting
waiting
STATO:0000093
date and time-related information
Calculation determining patients whose method of admission was from the waiting list
GECKO:0000052
Method of Admission - Waiting List
waitlist
GECKO:0000052
survey administration
The end date of a referral to treatment period.
Referral to Treatment Period End Date will be one of the following:
The activity date:
- when the Patient is admitted for First Definitive Treatment. If the start of a Patient's treatment is cancelled (by the Health Care Provider or Patient) after admission, the Referral to Treatment Period will continue.
- for First Definitive Treatment undertaken in an outpatient setting.
- for First Definitive Treatment undertaken by an NHS Allied Health Professional Service (Referral to Treatment Measurement).
- when the decision not to treat is made, with no further action at this time communicated to the Patient. This will include Discharge after Patient did not Attend and discharge back to primary care for treatment.
- when the Patient declines offered treatment.
- when the Patient did not attend for the first activity during a Referral to Treatment Period. See Referral to Treatment Period for guidance on Patients who do not attend.
- the clinical decision is made (and agreed with the Patient) that Active Monitoring will begin. If a Patient subsequently requires further treatment this decision would start a new Referral to Treatment Period as part of the same Patient pathway. This includes any treatment that is planned for a specific date in the future as ongoing monitoring.
- a clinical decision is made and has been communicated to the Patient, and subsequently their General Practitioner and/or other referring care professional without undue delay, to add the Patient to a transplant list.
or
- the person death date.
In the event that a Patient is booked into the wrong clinic and needs to be re- referred to the right one, this will not end the Referral to Treatment Period or restart it. The start of the Referral to Treatment Period is still the original referral request received date.|The end date of a referral to treatment period.In the event that a Patient is booked into the wrong clinic and needs to be re- referred to the right one, this will not end the Referral to Treatment Period or restart it. The start of the Referral to Treatment Period is still the original referral request received date.
Referral to Treatment Period End Date will be one of the following: The activity date:
- when the Patient is admitted for First Definitive Treatment. If the start of a Patient's treatment is cancelled (by the Health Care Provider or Patient) after admission, the Referral to Treatment Period will continue.
- for First Definitive Treatment undertaken in an outpatient setting.
- for First Definitive Treatment undertaken by an NHS Allied Health Professional Service (Referral to Treatment Measurement).
- when the decision not to treat is made, with no further action at this time communicated to the Patient. This will include Discharge after Patient did not Attend and discharge back to primary care for treatment.
- when the Patient declines offered treatment.
- when the Patient did not attend for the first activity during a Referral to Treatment Period. See Referral to Treatment Period for guidance on Patients who do not attend.
- the clinical decision is made (and agreed with the Patient) that Active Monitoring will begin. If a Patient subsequently requires further treatment this decision would start a new Referral to Treatment Period as part of the same Patient pathway. This includes any treatment that is planned for a specific date in the future as ongoing monitoring.
- a clinical decision is made and has been communicated to the Patient, and subsequently their General Practitioner and/or other referring care professional without undue delay, to add the Patient to a transplant list.
or
- the person death date.|The end date of a referral to treatment period.
Referral to Treatment Period End Date will be one of the following:
The activity date:
- when the Patient is admitted for First Definitive Treatment. If the start of a Patient's treatment is cancelled (by the Health Care Provider or Patient) after admission, the Referral to Treatment Period will continue.
- for First Definitive Treatment undertaken in an outpatient setting.
- for First Definitive Treatment undertaken by an NHS Allied Health Professional Service (Referral to Treatment Measurement).
- when the decision not to treat is made, with no further action at this time communicated to the Patient. This will include Discharge after Patient did not Attend and discharge back to primary care for treatment.
- when the Patient declines offered treatment.
- when the Patient did not attend for the first activity during a Referral to Treatment Period. See Referral to Treatment Period for guidance on Patients who do not attend.
- the clinical decision is made (and agreed with the Patient) that Active Monitoring will begin. If a Patient subsequently requires further treatment this decision would start a new Referral to Treatment Period as part of the same Patient pathway. This includes any treatment that is planned for a specific date in the future as ongoing monitoring.
- a clinical decision is made and has been communicated to the Patient, and subsequently their General Practitioner and/or other referring care professional without undue delay, to add the Patient to a transplant list.
or
- the person death date.
In the event that a Patient is booked into the wrong clinic and needs to be re-referred to the right one, this will not end the Referral to Treatment Period or restart it. The start of the Referral to Treatment Period is still the original referral request received date.
STATO:0000093
RTT period end date
rttperend
STATO:0000093
date and time-related information
The Start Date of a Referral to Treatment Period.
A referral to treatment period start date will be one of the following:
-Initial Referral:
- the referral request received date of a service request for a particular condition.
- This will include a patient being re-referred in to a Consultant Led Service or an Interface Service or an NHS Allied Health Professional Service (Referral To Treatment Measurement) as a new referral including after a Discharge After Patient Did Not Attend. The referral to treatment period status is 'National Code 10 - first activity'
-Following an appointment that the patient did not attend:
- the appointment accepted date (or the invitation offer date sent of the first appointment offer where the appointment offer is sent) for the first appointment following the patient not attending an appointment or elective admission. See referral to treatment period and Discharge After Patient Did Not Attend for guidance on patients who do not attend
- The appointment date of the appointment that the Patient did not attend should be used where it is not possible to identify the appointment accepted date or the invitation offer date sent. The Referral to Treatment Period Status is 'National Code 10 - first activity'
-Following active monitoring:
- the activity date of a care activity when a decision to treat was made following Active Monitoring and the Referral to Treatment Period Status is 'National Code 11 - active monitoring end'
- This will include a decision to start a substantively new or different treatment that does not already form part of that Patient's agreed care plan.
-On identifying a separate condition:
- the referral request received date of a service request when a decision has been made to refer the Patient directly to a Consultant Led Service or an NHS Allied Health Professional Service (Referral To Treatment Measurement) for a separate condition (the Referral to Treatment Period status for the first care activity with the new consultant or NHS Allied Health Professional Service (Referral To Treatment Measurement) is 'National Code 12 - consultant or NHS Allied Health Professional Service (Referral To Treatment) referral').
Referral to Treatment Consultant Led Waiting Times:
For most Patients, the start of the Referral to Treatment Period begins with a service request from a General Medical Practitioner to a Consultant.
Service requests to consultants who provide care services in community settings also start referral to treatment periods and the referral request received date will be the start of the referral to treatment period.
A referral to treatment period may also start from service requests to consultants from general dental practitioners, Practitioners with Special Interests, optometrists and Orthoptists, National Screening Programmes, specialist nurses, other care professionals where commissioning Organisations have approved these mechanisms locally. An 18-week clock also starts upon a self-referral by a Patient to the above services, where these pathways have been agreed locally by commissioners and providers and once the referral is ratified by a care professional.
A Referral to Treatment Period will also start where Patients are transferred to an elective Consultant Led Service through service requests from Accident and Emergency Departments including Minor injuries units and Walk In Centres.|The Start Date of a Referral to Treatment Period.
A referral to treatment period start date will be one of the following:
•Initial Referral:
• the referral request received date of a service request for a particular condition.
• This will include a patient being re-referred in to a Consultant Led Service or an Interface Service or an NHS Allied Health Professional Service (Referral To Treatment Measurement) as a new referral including after a Discharge After Patient Did Not Attend. The referral to treatment period status is 'National Code 10 - first activity'
•Following an appointment that the patient did not attend:
• the appointment accepted date (or the invitation offer date sent of the first appointment offer where the appointment offer is sent) for the first appointment following the patient not attending an appointment or elective admission. See referral to treatment period and Discharge After Patient Did Not Attend for guidance on patients who do not attend
• The appointment date of the appointment that the Patient did not attend should be used where it is not possible to identify the appointment accepted date or the invitation offer date sent. The Referral to Treatment Period Status is 'National Code 10 - first activity'
•Following active monitoring:
• the activity date of a care activity when a decision to treat was made following Active Monitoring and the Referral to Treatment Period Status is 'National Code 11 - active monitoring end'
• This will include a decision to start a substantively new or different treatment that does not already form part of that Patient's agreed care plan.
•On identifying a separate condition:
• the referral request received date of a service request when a decision has been made to refer the Patient directly to a Consultant Led Service or an NHS Allied Health Professional Service (Referral To Treatment Measurement) for a separate condition (the Referral to Treatment Period status for the first care activity with the new consultant or NHS Allied Health Professional Service (Referral To Treatment Measurement) is 'National Code 12 - consultant or NHS Allied Health Professional Service (Referral To Treatment) referral').
Referral to Treatment Consultant Led Waiting Times:
For most Patients, the start of the Referral to Treatment Period begins with a service request from a General Medical Practitioner to a Consultant.
Service requests to consultants who provide care services in community settings also start referral to treatment periods and the referral request received date will be the start of the referral to treatment period.
A referral to treatment period may also start from service requests to consultants from general dental practitioners, Practitioners with Special Interests, optometrists and Orthoptists, National Screening Programmes, specialist nurses, other care professionals where commissioning Organisations have approved these mechanisms locally.
An 18-week clock also starts upon a self-referral by a Patient to the above services, where these pathways have been agreed locally by commissioners and providers and once the referral is ratified by a care professional.
A Referral to Treatment Period will also start where Patients are transferred to an elective Consultant Led Service through service requests from Accident and Emergency Departments including Minor injuries units and Walk In Centres.
STATO:0000093
REFERRAL TO TREATMENT- RTT period start date
rttperstart
STATO:0000093
date and time-related information
The status of an activity, or anticipated activity, for the referral to treatment period.
GECKO:0000052
RTT period status
rttperstat
GECKO:0000052
survey administration
This field is derived in HES to calculate the number of days that a patient waited in a referral to treatment period - this is the difference between the Referral to Treatment Start Date (RTTPERSTART) and Referral to Treatment End Date (RTTPEREND).
STATO:0000093
Duration of wait (referral to treatment period)
waitdays
STATO:0000093
date and time-related information
Categorises the type of department or organisation making the referral for imaging activity. Codes returned are as per those submitted. Valid Codes are: 01, 02, 03, 04, 05, 06 and 07.Supplied value should match one of the permitted nationally defined codes (and include the leading zero) to be valid. If the code is wrong, or the leading zero dropped, the record would not be accepted in system.Patient Source Setting is a mandatory field and must be populated.
GECKO:0000052
Patient Source Setting
did_patsource_code
GECKO:0000052
survey administration
Descriptive field, taken from submitted Patient Source Setting code and converted into one of the following groups: 01 Admitted Patient Care - Inpatient (this Health Care Provider), 02 Admitted Patient Care - Day case (this Health Care Provider) ,03 Out-patient (this Health Care Provider) ,04 GP Direct Access, 05 Accident and Emergency Department (this Health Care Provider), 06 Other Health Care Provider, 07 Other
GECKO:0000052
Patient Source Setting Description
ic_patsource_desc
GECKO:0000052
survey administration
Post-Operative (Q2)
post_operative_q2
Response to third of the EQ-5D questions Corresponding Q2 general health question: Usual activities? Rates the patient's self-perceived ability to perform usual activities
OGMS:0000020
PostOp3
q2_activity
OGMS:0000020
signs and symptoms
Indicates any drug allergies after the operation. Corresponding Q2 general health question: Did you experience any of the following problems after your operation: Allergy or reaction to drug?
GECKO:0000096
q2_allergy
q2_allergy
GECKO:0000096
drug response(s)
Response to fifth of the EQ-5D questions Corresponding Q2 general health question: Anxiety/Depression? Rates the patient's self-perceived level of Anxiety/Depression
MONDO:0005084
PostOp5
q2_anxiety
MONDO:0005084
mental and behaviour disorders
Indicates whether the patient received any assistance in the completion of the questionnaire. Corresponding Q2 General question: Is anyone helping you fill in this questionnaire?
GECKO:0000052
q2_assisted
q2_assisted
GECKO:0000052
survey administration
Indicates the relationship of the patient with the person assisting in the completion of the questionnaire. Corresponding Q2 General question: If the answer is yes, please give the relationship to you of the person assisting you
GECKO:0000052
q2_assisted_by
q2_assisted_by
GECKO:0000052
survey administration
OGMS:0000020
q2_bleeding
q2_bleeding
OGMS:0000020
signs and symptoms
Indicates whether questionnaire 2 is complete
GECKO:0000052
q2_complete
q2_complete
GECKO:0000052
survey administration
Date on which questionnaire was completed Corresponding Q1 general health question: Today's Date Completed date is equal to the date entered for this question. If the completed date question is blank or invalid the scan date is used for subsequent analysis.
STATO:0000093
q2_completed_date
q2_completed_date
STATO:0000093
date and time-related information
Response to corresponding Q1 general health question: Do you consider yourself to have a disability?
OGMS:0000020
q2_disability
q2_disability
OGMS:0000020
signs and symptoms
Response to fourth of the EQ-5D questions Corresponding Q1 general health question: Pain/Discomfort? Rates the patient's self-perceived pain/discomfort
OGMS:0000020
PostOp4
q2_discomfort
OGMS:0000020
signs and symptoms
Indicates how well the patient rates themselves to be feeling on the day of completing questionnaire 2 on a scale of 0-100 (0 being worst, and 100 being best)
OGMS:0000020
q2_eq5d_health_scale
q2_eq5d_health_scale
OGMS:0000020
signs and symptoms
EQ-5D Index score derived from the EQ-5D profile. 11111= 1. For every 2 or 3 present a fraction is deducted, the lower the score the worse the patient reports on the EQ-5D questions
GECKO:0000052
q2_eq5d_index
q2_eq5d_index
GECKO:0000052
survey administration
EQ-5D Profile lists the responses to the EQ-5D questions
GECKO:0000052
q2_eq5d_profile
q2_eq5d_profile
GECKO:0000052
survey administration
Indicates whether the patient completed the EQ-5D questions of questionnaire 2
GECKO:0000052
q2_eq5d_profile_complete
q2_eq5d_profile_complete
GECKO:0000052
survey administration
Indicates whether the patient completed the health scale section of questionnaire 2
GECKO:0000052
q2_eq5d_scale_complete
q2_eq5d_scale_complete
GECKO:0000052
survey administration
Questionnaire 2 form version
GECKO:0000052
q2_form_version
q2_form_version
GECKO:0000052
survey administration
Response to corresponding Q1 general health question: In general would you say your health is?
OGMS:0000020
q2_general_health
q2_general_health
OGMS:0000020
signs and symptoms
Language in which Questionnaire 1 was administered
GECKO:0000052
q2_language
q2_language
GECKO:0000052
survey administration
Response to corresponding Q1 general health question: Which statement best describes your living arrangements?
GECKO:0000066
q2_living_arrangements
q2_living_arrangements
GECKO:0000066
family and household structure
Response to first of the EQ-5D questions Corresponding Q1 general health question: Mobility? Rates the patient's self-perceived mobility
OGMS:0000020
q2_mobility
q2_mobility
OGMS:0000020
signs and symptoms
GECKO:0000052
q2_readmitted
q2_readmitted
GECKO:0000052
survey administration
STATO:0000093
q2_received_date
q2_received_date
STATO:0000093
date and time-related information
OGMS:0000020
q2_satisfaction
q2_satisfaction
OGMS:0000020
signs and symptoms
OGMS:0000020
q2_scan_date
q2_scan_date
OGMS:0000020
signs and symptoms
OGMS:0000020
q2_self_care
q2_self_care
OGMS:0000020
signs and symptoms
GECKO:0000052
q2_success
q2_success
GECKO:0000052
survey administration
STATO:0000093
q2_surgery_date
q2_surgery_date
STATO:0000093
date and time-related information
OGMS:0000020
q2_urine
q2_urine
OGMS:0000020
signs and symptoms
OGMS:0000020
q2_wound
q2_wound
OGMS:0000020
signs and symptoms
GECKO:0000092
q2_further_surgery
q2_further_surgery
GECKO:0000092
surgical interventions
GECKO:0000073
Practitioner
practitioner
GECKO:0000073
physician/practitioner info
The organisation code of the organisation from which the referral is made, such as GP practice or NHS trust.
GECKO:0000073
Referring organisation code
referorg
GECKO:0000073
physician/practitioner info
The code for the person referring the patient. This may be the GMC code for the consultant, or the code that defines the practice of the patient's registered GMP or GDP.
This field contains sensitive data. Access to it requires the approval of The Independent Group Advising on the Release of Data (IGARD).
GECKO:0000052
Referrer code
referrer
GECKO:0000052
survey administration
The date the referral request was received by the healthcare provider.
STATO:0000093
Referral request received date
reqdate
STATO:0000093
date and time-related information
A code for the consultant, which identifies the consultant as an individual. This is represented as the GMC number of the consultant prefixed by 'C'; for dental consultants who do not have a GMC number, the General Dental Council Registration is used prefixed with "CD". Pseudo codes are used on all episodes or attendances where the patient is under the care of a midwife, nurse, or other health care professional rather than a consultant.
This field contains sensitive data. Access to it requires the approval of The Independent Group Advising on the Release of Data (IGARD).
GECKO:0000073
Consultant code
consult
GECKO:0000073
physician/practitioner info
Code of GP Practice (registered GMP). This field was introduced for the 1997-98 data year. It contains a code which defines the practice of the patient's registered GP. It allows the GP to be notified about treatment given to the patient. The registered GP may not be the same as the referring GP.|This field contains a code which defines the practice of the patient's registered GP. It allows the GP to be notified about treatment given to the patient. The registered GP may not be the same as the referring GP.|This field contains a code which defines the practice that the patient is registered with.
GECKO:0000073
Code of GP practice
gpprac
GECKO:0000073
physician/practitioner info
Pre-Operative (Q1)
pre_operative_q1
Usual activities? Rates the patient's self-perceived ability to perform usual activities
OGMS:0000020
PreOp3
q1_activity
OGMS:0000020
signs and symptoms
Anxiety/Depression? Rates the patient's self-perceived level of Anxiety/Depression
MONDO:0005084
PreOp5
q1_anxiety
MONDO:0005084
mental and behaviour disorders
Indicates whether the patient received any assistance in the completion of the questionnaire. Corresponding Q1 general health question: Is anyone helping you fill in this questionnaire?
GECKO:0000052
q1_assisted
q1_assisted
GECKO:0000052
survey administration
Indicates the relationship of the patient with the person assisting in the completion of the questionnaire. Corresponding Q1 general health question: If the answer is yes, please give the relationship to you of the person assisting you.
GECKO:0000052
q1_assisted_by
q1_assisted_by
GECKO:0000052
survey administration
Indicates whether questionnaire 1 is complete
GECKO:0000052
q1_complete
q1_complete
GECKO:0000052
survey administration
Date on which questionnaire was completed Corresponding Q1 general health question: Today's Date Completed date is equal to the date entered for this question. If the completed date question is blank or invalid the scan date is used for subsequent analysis.
STATO:0000093
q1_completed_date
q1_completed_date
STATO:0000093
date and time-related information
Response to corresponding Q1 general health question: Do you consider yourself to have a disability?
OGMS:0000020
q1_disability
q1_disability
OGMS:0000020
signs and symptoms
Response to fourth of the EQ-5D questions Corresponding Q1 general health question: Pain/Discomfort? Rates the patient's self-perceived pain/discomfort
OGMS:0000020
PO4
q1_discomfort
OGMS:0000020
signs and symptoms
Indicates how well the patient rates themselves to be feeling on the day of completing questionnaire 1 on a scale of 0-100 (0 being worst, and 100 being best)
OGMS:0000020
q1_eq5d_health_scale
q1_eq5d_health_scale
OGMS:0000020
signs and symptoms
EQ-5D Index score derived from the EQ-5D profile. 11111= 1. For every 2 or 3 present a fraction is deducted, the lower the score the worse the patient reports on the EQ-5D questions
GECKO:0000052
q1_eq5d_index
q1_eq5d_index
GECKO:0000052
survey administration
EQ-5D Profile lists the responses to the EQ-5D questions
GECKO:0000052
q1_eq5d_profile
q1_eq5d_profile
GECKO:0000052
survey administration
Indicates whether the patient completed the EQ-5D questions of questionnaire 1
GECKO:0000052
q1_eq5d_profile_complete
q1_eq5d_profile_complete
GECKO:0000052
survey administration
Indicates whether the patient completed the health scale section of questionnaire 1
GECKO:0000052
q1_eq5d_scale_complete
q1_eq5d_scale_complete
GECKO:0000052
survey administration
Questionnaire 1 form version
GECKO:0000052
q1_form_version
q1_form_version
GECKO:0000052
survey administration
Response to corresponding Q1 general health question: In general would you say your health is?
OGMS:0000020
q1_general_health
q1_general_health
OGMS:0000020
signs and symptoms
Language in which Questionnaire 1 was administered
GECKO:0000052
q1_language
q1_language
GECKO:0000052
survey administration
Response to corresponding Q1 general health question: Which statement best describes your living arrangements?
GECKO:0000066
q1_living_arrangements
q1_living_arrangements
GECKO:0000066
family and household structure
Response to first of the EQ-5D questions Corresponding Q1 general health question: Mobility? Rates the patient's self-perceived mobility
OGMS:0000020
q1_mobility
q1_mobility
OGMS:0000020
signs and symptoms
Indicates whether the patient has had previous surgery of the type they are going to undergo (exact wording of question varies dependent on procedure)
GECKO:0000092
q1_previous_surgery
q1_previous_surgery
GECKO:0000092
surgical interventions
A provider code is a unique code that identifies an organisation acting as a health care provider. The code is managed by the National Administrative Codes Service (NACS) and supports the identification of organisations exchanging information within the NHS. Procode contains the complete NHS provider code (ie organisation code plus site code).
GECKO:0000073
q1_procode
q1_procode
GECKO:0000073
physician/practitioner info
Date on which questionnaire 1 was received
STATO:0000093
q1_received_date
q1_received_date
STATO:0000093
date and time-related information
Date on which questionnaire 1 was scanned
STATO:0000093
q1_scan_date
q1_scan_date
STATO:0000093
date and time-related information
Response to second of the EQ-5D questions Corresponding Q1 general health question: Self-care? Rates the patient's self-perceived ability to care for themselves
OGMS:0000020
q1_self_care
q1_self_care
OGMS:0000020
signs and symptoms
Indicates the duration for which the patient has had symptoms. Corresponding Q1 Groin Hernia question: For how long have you had symptoms of a hernia?
OGMS:0000020
q1_symptom_period
q1_symptom_period
OGMS:0000020
signs and symptoms
GECKO:0000092
Procedure
procedure
GECKO:0000092
surgical interventions
GECKO:0000092
opcs43
opcs43
GECKO:0000092
surgical interventions
GECKO:0000073
Provider
provider
GECKO:0000073
physician/practitioner info
Descriptive field, returning the name of Providing Organisation, based on Provider Code which is derived from submitted field Site Code (of imaging). Hard validating of the field means only organisation site codes which have been notified to and issued by the Organisation Data Service are valid.
GECKO:0000073
Provider Name
ic_provname
GECKO:0000073
physician/practitioner info
GECKO:0000073
Provider SHA
provider_sha
GECKO:0000073
physician/practitioner info
Code representing the Strategic Health Authority with which the provider organisation is associated, as mapped to from submitted field Site Code (of imaging).
GECKO:0000073
Provider SHA Code
ic_prov_shacode
GECKO:0000073
physician/practitioner info
Descriptive field, based on the Provider SHA code, which returns the name of the Strategic Health Authority with which the provider organisation is associated, as mapped from the submitted field Site Code (of imaging).
GECKO:0000073
Provider SHA Name
ic_prov_shaname
GECKO:0000073
physician/practitioner info
GECKO:0000073
Provider Site
provider_site
GECKO:0000073
physician/practitioner info
Submitted field Site Code (of imaging) returning the site code of the organisation at which the imaging took place. Hard validating of the field means only organisation site codes which have been notified to and issued by the Organisation Data Service are valid.
GECKO:0000073
Provider Site Code
ic_sitecode
GECKO:0000073
physician/practitioner info
Descriptive field, based on submission of Site Code (of imaging), which returns the site name at which the imaging took place. Hard validating of the field means only organisation site codes which have been notified to and issued by the Organisation Data Service are valid
GECKO:0000073
Provider Site Name
ic_sitename
GECKO:0000073
physician/practitioner info
Psychiatric
psychiatric
This field contains a code which defines the characteristics of a ward. The code has six parts: AABCDEF.
Where:
AA Clinical Care Intensity, see INTENDED CLINICAL CARE INTENSITY
B Age, see AGE GROUP INTENDED
C Sex, see SEX OF PATIENTS
D Hospital provider, see HOSPITAL PROVIDER TYPE
E Number of days open only during the day, see WARD DAY PERIOD AVAILABILITY
F Number of days open at night, see WARD NIGHT PERIOD AVAILABILITY
GECKO:0000052
Ward type at psychiatric census date
cenward
GECKO:0000052
survey administration
This field contains a code which defines the legal status of the patient. It is derived from legal status (leglstat) and the length of stay recorded for the current spell.
GECKO:0000052
Status of patient included in psychiatric census
censtat
GECKO:0000052
survey administration
This derived field contains a code that indicates whether any of the diagnosis fields (diag_01 to diag_07) contains a valid V code (see diag_nn). For 1995-1996 only, U codes replaced the V codes. Although classed as Psychiatric data, values 1 to 3 indicate the level of neonatal care for a patient aged under 29 days.
GECKO:0000052
V code indicator
vind
GECKO:0000052
survey administration
This field contains a code which identifies previous psychiatric care for psychiatric patients. It applies only to patients admitted or transferred to a consultant in one of the psychiatric specialties during a spell in hospital. It is recorded for the first such consultant episode but not for subsequent psychiatric consultant episodes or any non-psychiatric episodes. This field is used to indicate the turnover for psychiatric patients, and identify first time psychiatric admissions and re-admissions. Where a patient has a history of admission to several hospital providers, priority is given to the current hospital provider (code 1), regardless of whether the preceding admission was to the same hospital provider. This field replaces special (UK NHS specific) diagnosis codes commencing U69 (1 April 1989 to 31 March 1995) and U51 (1 April 1995 to 31 march 1996), and also the HES derived V code indicator data item.
MONDO:0005084
Psychiatric history on admission
admistat
MONDO:0005084
mental and behaviour disorders
This field is calculated from date of birth (dob) and the date of the psychiatric census (31 March every year). It is only calculated for psychiatric census records; if the episode type is not for a formally detained patient (epitype is not 4) or one that was admitted more than one year previously, censage is null. The maximum permitted value is 120 years.
MONDO:0005084
Age at psychiatric census date
censage
MONDO:0005084
mental and behaviour disorders
Duration of care in days to the psychiatric census date. This field is calculated from admidate (admission date) and the date of the psychiatric census (31 March every year). The maximum permitted value is 29,200 days (approximately 80 years).
MONDO:0005084
STATO:0000093
Duration of care to psychiatric census date
cendur
MONDO:0005084
mental and behaviour disorders
STATO:0000093
date and time-related information
This derived field contains the number of days between the date the current detention commenced (detndate) and the date of the psychiatric census (31 March of cendate). The maximum period is 29,200 days (approximately 80 years).
MONDO:0005084
STATO:0000093
Duration of detention
detdur
MONDO:0005084
mental and behaviour disorders
STATO:0000093
date and time-related information
For patients under a detention order at the date of the census, this field contains the date at which the first order commenced in the current continuous period of detention. Where the detention order is held by a hospital other than where the patient is at the date of the census, the latter is responsible for obtaining information relating to the detention order, and submitting the data.
MONDO:0005084
STATO:0000093
Date detention commenced
detndate
MONDO:0005084
mental and behaviour disorders
STATO:0000093
date and time-related information
This field contains a code that defines a patient's marital status where the consultant's specialty (mainspef) is one of the psychiatric specialties. Although the numerical codes were retired on 1/10/2006, these are still flowing so both sets of codes are seen.
PATO:0001995
Marital status (psychiatric)
marstat
PATO:0001995
socio-demographic and economic characteristics
This field contains a code which states whether carer support is available to the patient at home or other normal residence. This does not include any paid support or support from a voluntary organisation unless the patient is normally resident in a nursing home, group home or residential care home.
GECKO:0000052
Care Support Indicator
carersi
GECKO:0000052
survey administration
GECKO:0000073
Referrer Organisation
referrer_organisation
GECKO:0000073
physician/practitioner info
Returns the submitted Referrer Organisation code of the organisation from which the referral is made, such as a GP practice or NHS Trust. In many cases the referring organisation will be the actual trust itself (for example in the case of ward and clinic requests). When this is a request from a GP, the referring organisation will be the site code of the practice, which is different from the referrer. Only those organisation codes which have been notified to and issued by the Organisation Data Service may be used. Local or individual site codes are not permitted. Hard validation is applied to field - if organisation codes are supplied incorrectly data will not upload. They must be in the format - min. an3, max. an6.If it is an NHS trust that is referring the patient the code must be 3 alpha-numeric characters. If it is a GP practice a 6 alpha-numeric character code would be expected.Referrer Organisation code can be left blank.
GECKO:0000052
Referrer Organisation code
did_refer_orgcode
GECKO:0000052
survey administration
Based on Region categories derived from submitted NICIP or SNOMED-CT codes. The following category descriptions have been defined: Abdomen, Head, Limb, Neck, None, Perlvic, Thoracic, Unknown
GECKO:0000006
Region
ic_region_desc
GECKO:0000006
location
Broad categories represented by an ID categorising submitted NICIP or SNOMED-CT by body region
GECKO:0000006
Region ID
ic_region_id
GECKO:0000006
location
GECKO:0000052
Scoring
scoring
GECKO:0000052
survey administration
Casemix-adjusted predicted post-operative EQ VAS score, constrained to range of valid values; derived using version 2 of the casemix-adjustment model.
GECKO:0000052
EQ5D HEALTH SCALE EXPECTED (FINAL MODEL1)
eq5d_index_expected_final_model3
GECKO:0000052
survey administration
Date on which status field was last updated
STATO:0000093
status_date
status_date
STATO:0000093
date and time-related information
Casemix-adjusted predicted post-operative EQ VAS score, derived using version 1 of the casemix- adjustment model.
GECKO:0000052
EQ5D HEALTH SCALE EXPECTED (MODEL1)
eq5d_health_scale_expected_final_model3
GECKO:0000052
survey administration
GECKO:0000052
eq5d_index_change
eq5d_index_change
GECKO:0000052
survey administration
EQ-5D index score on Q2 - EQ-5D index score on Q1. A positive value denotes an improvement, and a negative value a deterioration
GECKO:0000052
EQ5D INDEX CHANGE
eq5d_scale_change
GECKO:0000052
survey administration
Status of the questionnaire record
GECKO:0000052
status
status
GECKO:0000052
survey administration
Total score for the varicose vein specific questions answered divided by the maximum possible score for the questions answered ( VV Q1 Total Score / VV Q1 Maximum Score)
GECKO:0000052
vv_q2_score
vv_q2_score
GECKO:0000052
survey administration
GECKO:0000052
vv_q2_total_score
vv_q2_total_score
GECKO:0000052
survey administration
GECKO:0000052
score_change
score_change
GECKO:0000052
survey administration
Total score for the varicose vein specific questions answered divided by the maximum possible score for the questions answered ( VV Q1 Total Score / VV Q1 Maximum Score)
GECKO:0000052
vv_q1_score
vv_q1_score
GECKO:0000052
survey administration
Indicates whether the submitted questionnaire has sufficient procedure specific data to derive a score
GECKO:0000052
vv_q1_score_complete
vv_q1_score_complete
GECKO:0000052
survey administration
Total score for the varicose vein specific questions answered
GECKO:0000052
vv_q1_total_score
vv_q1_total_score
GECKO:0000052
survey administration
Indicates whether the submitted questionnaire has sufficient procedure specific data to derive a score
GECKO:0000052
vv_q2_score_complete
vv_q2_score_complete
GECKO:0000052
survey administration
Casemix-adjusted predicted post-operative score for the Aberdeen Varicose Vein Questionnaire measure, constrained to range of valid Aberdeen Varicose Vein Questionnaire values; derived using version 3 of the casemix-adjustment model.
GECKO:0000052
VV Score Final Predicted (Model 3)
vv_score_expected_final_model3
GECKO:0000052
survey administration
Casemix-adjusted predicted post-operative OKS, derived using version 3 of the casemix-adjustment model.
GECKO:0000052
kr_score_expected_final_model3
kr_score_expected_final_model3
GECKO:0000052
survey administration
Indicates whether the submitted questionnaire has sufficient procedure specific data to derive a score
OGMS:0000020
kr_q1_score_complete
kr_q1_score_complete
OGMS:0000020
signs and symptoms
Each of the KR question has 5 possible responses which each are attributable 0-4 points. The KR score is derived by adding the points for each question. The maximum number of points is 48 which would signify the best outcome, the minimum being 0.
OGMS:0000020
kr_q2_score
kr_q2_score
OGMS:0000020
signs and symptoms
PATO:0001995
Socio-economic
socio_economic
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains. The English Indices of Deprivation provide a relative measure of deprivation at small area level across England. Areas are ranked from least deprived to most deprived on seven different dimensions of deprivation and an overall composite measure of multiple deprivation. The domains used in the Indices of Deprivation are: income deprivation; employment deprivation; health deprivation and disability; education deprivation; crime deprivation; barriers to housing and services deprivation; and living environment deprivation. Each of these domains has its own scores and ranks, allowing users to focus on specific aspects of deprivation. In addition, two supplementary indices measure income deprivation amongst children - the Income Deprivation Affecting Children Index (IDACI) - and older people - the Income Deprivation Affecting Older People Index (IDAOPI).
The current HES version of the Index is 2010, although the current IMD version of the index is 2015 which can be found on the IMD website:
https://www.gov.uk/government/statistics/english-indices-of-deprivation-2015
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Index of Multiple Deprivation
imd04
PATO:0001995
socio-demographic and economic characteristics
This field uses the IMD Overall Ranking to identify which one of ten groups a Super Output Area belongs to, from most deprived through to least deprived.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Decile Group
imd04_decile
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Crime Domain. The purpose of the Crime domain is to measure the incidence of recorded crime for four major crime themes:
1. burglary
2. theft
3. criminal damage
4. violence
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Crime Domain. The purpose of the Crime domain is to measure the incidence of recorded crime for four major crime themes: 1. burglary ; 2. theft ; 3. criminal damage ; 4. violence
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Crime Domain
imd04c
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Education, Skills and training Domain. The purpose of the Education, Skills and training domain is to capture the extent of deprivation in terms of education, skills and training in a local area.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivations at Super Output Area level. The IMD has seven domains, one of which is the Education, Skills and training Domain. The purpose of the Education, Skills and training domain is to capture the extent of deprivation in terms of education, skills and training in a local area.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
GECKO:0000065
IMD Education Training and Skills Domain
imd04ed
GECKO:0000065
education
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Employment Deprivation Domain.
This domain measures employment deprivation conceptualised as involuntary exclusion of the working age population from the world of work.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) Employment domain
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Employment Deprivation Domain
imd04em
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Health Deprivation and Disability Domain. The purpose of the Health deprivation and disability domain is to identify areas with relatively high rates of:
1. premature deaths
2. impaired quality of life, due to poor health
3. people with disabilities
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Employment Deprivation Domain.
This domain measures employment deprivation conceptualised as involuntary exclusion of the working age population from the world of work.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Health Deprivation and Disability Domain. The purpose of the Health deprivation and disability domain is to identify areas with relatively high rates of: 1. premature deaths ; 2. impaired quality of life, due to poor health ; 3. people with disabilities.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Health and Disability Domain
imd04hd
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Barriers to Housing and Services Domain. The purpose of the Barriers to Housing and Services domain is to measure barriers to housing and key local services.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Health Deprivation and Disability Domain. The purpose of the Health deprivation and disability domain is to identify areas with relatively high rates of:
1. premature deaths
2. impaired quality of life, due to poor health
3. people with disabilities
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivations at Super Output Area level. The IMD has seven domains, one of which is the Barriers to Housing and Services Domain. The purpose of the Barriers to Housing and Services domain is to measure barriers to housing and key local services.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Barriers to Housing and Service Domain
imd04hs
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Income Deprivation Domain. The purpose of this Domain is to capture the proportions of the population experiencing income deprivation in an area.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Barriers to Housing and Services Domain. The purpose of the Barriers to Housing and Services domain is to measure barriers to housing and key local services.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivations at Super Output Area level. The IMD has seven domains, one of which is the Income Deprivation Domain. The purpose of this Domain is to capture the proportions of the population experiencing income deprivation in an area.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Income Domain
imd04i
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Income Deprivation Domain. The Income Deprivation Affecting Older People Index is a sub-set of the Income Deprivation Domain. The Index contains the percentage of a Super Output Area's population aged 60 and over who are claiming Income Support or Job Seeker's Allowance.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Income Deprivation Domain. The purpose of this Domain is to capture the proportions of the population experiencing income deprivation in an area.
The current HES version of the Index is 2010, although the current IMD version of the index is 2015 which can be found on the IMD website:
https://www.gov.uk/government/statistics/english-indices-of-deprivation-2015|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivations at Super Output Area level. The IMD has seven domains, one of which is the Income Deprivation Domain. The Income Deprivation Affecting Older People Index is a sub-set of the Income Deprivation Domain. The Index contains the percentage of a Super Output Areas population aged 60 and over who are claiming Income Support or Job Seeker's Allowance.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Income affecting Adults Domain
imd04ia
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Income Deprivation Domain. The Income Deprivation Affecting Children Index is a sub-set of the Income Deprivation Domain. The Index contains the percentage of a Super Output Area's children under 16 who were living in families receiving specific financial support, such as Income Support or Job Seeker's Allowance.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivations at Super Output Area level. The IMD has seven domains, one of which is the Income Deprivation Domain. The Income Deprivation Affecting Children Index is a sub-set of the Income Deprivation Domain. The Index contains the percentage of a Super Output Area's children under 16 who were living in families receiving specific financial support, such as Income Support or Job Seeker's Allowance.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Income affecting Children Domain
imd04ic
PATO:0001995
socio-demographic and economic characteristics
The Index of Multiple Deprivation (IMD) is a measure of multiple deprivation at Super Output Area level. The IMD has seven domains, one of which is the Living Environment domain. The Living Environment domain focuses on deprivation with respect to the characteristics of the living environment.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) is a measure of multiple deprivations at Super Output Area level. The IMD has seven domains, one of which is the Living Environment domain. The Living Environment domain focuses on deprivation with respect to the characteristics of the living environment.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
GECKO:0000066
IMD Living Environment Domain
imd04le
GECKO:0000066
family and household structure
The IMD overall ranking is made by combining the seven IMD Domain scores using the following weights:
- Income (22.5%)
- Employment (22.5%)
- Health Deprivation and Disability (13.5%)
- Education, Skills and Training (13.5%)
- Barriers to Housing and Services (9.3%)
- Crime (9.3%)
- Living Environment (9.3%)
The SOA (Super Output Area) with a rank of 1 is the most deprived, and 32482 the least deprived, on this overall measure.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.|The Index of Multiple Deprivation (IMD) overall ranking is made by combining the seven IMD Domain scores using the following weights: - Income (22.5%) ; - Employment (22.5%) ; - Health Deprivation and Disability (13.5%) ; - Education, Skills and Training (13.5%) ; - Barriers to Housing and Services (9.3%) ; - Crime (9.3%) ; - Living Environment (9.3%) ; The Super Output Area (SOA) with a rank of 1 is the most deprived, and 32482 the least deprived, on this overall measure.
This field uses IMD version 2004 on activity up to and including 2006-07; IMD version 2007 on activity between 2007-08 and 2009-10; IMD version 2010 on activity from 2010-11 to present.
PATO:0001995
IMD Overall Rank
imd04rk
PATO:0001995
socio-demographic and economic characteristics
Narrower categories represented by an ID, grouping procedures or methods used for examination that may include procedures assisted by the method, e.g. biopsy or injection, which are encompassed within each modality category. These categories are derived from submitted NICIP or SNOMED-CT codes.
GECKO:0000052
Sub Modality
ic_sub_modality_desc
GECKO:0000052
survey administration
Narrower categories represented by an ID, grouping procedures or methods used for examination that may include procedures assisted by the method, e.g. biopsy or injection, which are encompassed within each modality category. These categories are derived from submitted NICIP or SNOMED-CT codes.
GECKO:0000052
Sub Modality ID
ic_sub_modality_id
GECKO:0000052
survey administration
Based on Sub Region ID categories derived from submitted NICIP or SNOMED-CT codes. They provide a more complete descriptive categorisation of imaging such as:
GECKO:0000052
Sub Region
ic_sub_region_desc
GECKO:0000052
survey administration
Separation of lower and upper limb structures; breast or upper limb thoracic structures etc.
GECKO:0000052
Sub Region ID
ic_sub_region_id
GECKO:0000052
survey administration
Descriptive categorisation of imaging by body subsystem, based on Sub-system ID categories derived from submitted NICIP or SNOMED-CT codes.
GECKO:0000052
Sub System
ic_sub_sys_desc
GECKO:0000052
survey administration
Sub-classification within System categorisation of submitted NICIP or SNOMED-CT codes to provide a more complete categorisation by imaging by body subsystem.
GECKO:0000052
Sub System ID
ic_sub_sys_id
GECKO:0000052
survey administration
Descriptive categorisation of imaging by body sub-system components, based on Sub-System Component categories derived from submitted NICIP or SNOMED-CT codes.
GECKO:0000052
Sub-System Component
ic_sub_syscomp_desc
GECKO:0000052
survey administration
Further sub-classification within System and Sub-system categorisation of submitted NICIP or SNOMED-CT codes by body structure or system groups
GECKO:0000052
Sub-System Component ID
ic_sub_syscomp_id
GECKO:0000052
survey administration
Descriptive categorisation of imaging by Systems categories derived from submitted NICIP or SNOMED-CT codes. The following category descriptions have been defined:
GECKO:0000052
System
ic_system_desc
GECKO:0000052
survey administration
Broad categories represented by an ID categorising submitted NICIP or SNOMED-CT by body structure or system groups as identified by Clinical Terminologists at HSCIC
GECKO:0000052
System ID
ic_system_id
GECKO:0000052
survey administration
GECKO:0000052
System Data
system_data
GECKO:0000052
survey administration
Gives an indication of whether a patient is making a first attendance or follow-up attendance, and whether the consultation was face-to-face or via telephone/telemedicine consultation.
GECKO:0000052
First attendance
firstatt
GECKO:0000052
survey administration
Flags whether there is an AEKEY present on the record. This can be used to sum the number of A&E attendances.
GECKO:0000052
AEKEY flag
aekey_flag
GECKO:0000052
survey administration
Flags whether there is an ATTENDKEY present on the record. This can be used to sum the number of outpatient appointments.
GECKO:0000052
Attendence Key Flag
attendkey_flag
GECKO:0000052
survey administration
This is a system field that represents the date of the update event that resulted in the need to exchange the record with the Secondary Uses Service (SUS) database. This field is present on records submitted via the Net Change Protocol method only, and is used by SUS to process records in the correct sequence.
GECKO:0000052
Net applicable date
appdate
GECKO:0000052
survey administration
Code taken from submitted NHS Number Status field. Field is subject to hard validation during submission process. If supplied value does not match one of the permitted nationally defined codes the data upload will fail. This will include cases where the correct code has been used but the leading zero has been dropped. They must be preserved for the data to be validated. Permitted codes:01, 02, 03, 04, 05, 06, 07, 08
GECKO:0000052
NHS Number Status
did_nhsnum_stat
GECKO:0000052
survey administration
Derived field based on NHS Number Status: - 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 - 06 Trace in progress - 07 Number not present, trace not required - 08 Trace postponed (baby under six weeks old)
GECKO:0000052
NHS Number Status Description
ic_nhsnum_stat_desc
GECKO:0000052
survey administration
Codes in this field indicate whether the patients' NHS Number is present, and if it is verified. If the NHS Number is absent, the indicator gives the reason why.|Codes in this field indicate whether the patients‚Äö√Ñô NHS number is present, and if it is verified. If the NHS number is absent, the indicator gives the reason why.
GECKO:0000052
NHS number status indicator
nhsnoind
GECKO:0000052
survey administration
The version number for the SUS generated HRG code (sushrg).
GECKO:0000052
SUS generated HRG version number
sushrgverinfo
GECKO:0000052
survey administration
SUS generated spell identifier
GECKO:0000052
SUS generated spell identifier
susspellid
GECKO:0000052
survey administration
This field is present on A&E and APC linked records only. Linkage between these
two datasets enables patient pathways to be followed and provides additional information beyond what is available from the standalone datasets.
AEKEY represents the record identifier of the A&E attendance that the APC episode has been linked to.
Full details of the methodology used to link A&E and APC records can be found on the following page of our website: http://content.digital.nhs.uk/article/1824/How-do- we-collect-and-process-HES-data|This is a record identifier that is created by the HES system. The digits store a decimal number. This is commonly eight or nine digits but can be up to 14.
GECKO:0000052
Record identifier
aekey
GECKO:0000052
survey administration
This is a record identifier that is created by the HES system. The digits store a decimal number. This is commonly eight or nine digits but can be up to 14.
GECKO:0000052
Record identifier
attendkey
GECKO:0000052
survey administration
This is a system field that represents the date of the update event that resulted in
the need to exchange the data with the Secondary Uses Service (SUS) database. This field is present on records submitted via the Bulk Update Protocol method only, and is used to apply records correctly to SUS.
GECKO:0000052
CDS extract date
cdsextdate
GECKO:0000052
survey administration
The version of the commissioning data set (CDS) being used.
GECKO:0000052
CDS version number
cdsversion
GECKO:0000052
survey administration
Internal housekeeping|Refers to the match rank in the data linkage process from NHSD
GECKO:0000052
match_rank
match_rank
GECKO:0000052
survey administration
This derived field indicates the basis on which the primary care group (PCG) code was assigned.
GECKO:0000052
Origin of primary care group
pcgorig
GECKO:0000052
survey administration
The PCTCODE depending on the datayear. Where the data year is equal to or later than 2006, this field contains the code from the field PCTCODE06, otherwise it contains the code from the field PCTCODE02.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000052
PCT of responsibility dependent on the data year
pctcode_his
GECKO:0000052
survey administration
This derived field indicates the basis on which the primary care trust (PCT) of responsibility code was assigned.
GECKO:0000052
Origin of primary care trust of responsibility
pctorig
GECKO:0000052
survey administration
The origin of the primary care trust of responsibility dependent on the datayear. Where the data year is equal to or later than 2006, this field contains the code from the field PCTORIG06, otherwise it contains the code from the field PCTORIG02.
GECKO:0000052
Origin of primary care trust of responsibility dependent on the data year
pctorig_his
GECKO:0000052
survey administration
This derived field indicates the basis on which the code in the field PCTCODE02 was assigned.
GECKO:0000052
Origin of PCT of responsibility (2002)
pctorig02
GECKO:0000052
survey administration
This derived field indicates the basis on which the code in the field PCTCODE06 was assigned.|This derived field indicates the basis on which the code in the field PCTCODE02 was assigned.
GECKO:0000052
Origin of PCT of responsibility (2006)
pctorig06
GECKO:0000052
survey administration
This is a system field used for the purposes of submitting data to SUS. It defines the end date for the date range of the data contained within a SUS submission, and is present on records submitted via the Bulk Update Protocol method only.
GECKO:0000052
Reporting period end date
perend
GECKO:0000052
survey administration
The code of the organisation that submitted the record to the Secondary Uses Service (SUS). This is a system field used during the SUS submission process.
GECKO:0000052
CDS sender identity
sender
GECKO:0000052
survey administration
Ethnic character is supplied by the trusts as a two-character field. Ethraw contains the left-hand character. The right hand character is optional for use locally. A copy of the raw data found in the right hand character is held in ethrawl.
GECKO:0000052
Ethnic character (audit version)
ethraw
GECKO:0000052
survey administration
NHSD participant ID. Rreplaces HESID listed in the data dictionary and be equaivelent to the Pseudonymised HESID (PSEUDO_HESID)
GECKO:0000055
NHS Patient identifier
encrypted_hesid
GECKO:0000055
unique identifiers
This is a system field used to apply records correctly to SUS. It represents the mechanism that was used to submit the record to SUS (Bulk or Net).
GECKO:0000055
CDS protocol identifier
cdsverprotid
GECKO:0000055
unique identifiers
Participant's Identifier (supplied by Genomics England)
GECKO:0000055
Patient identifier
participant_id
GECKO:0000055
unique identifiers
DID Record ID|Record ID
GECKO:0000055
Record Identifier
submissiondataid
GECKO:0000055
unique identifiers
This is a record identifier that is created by the HES system. The digits store a decimal number. This is commonly eight or nine digits but can be up to 14.|This field is present on A&E and APC linked records only. Linkage between these two datasets enables patient pathways to be followed and provides additional information beyond what is available from the standalone datasets.
EPIKEY represents the record identifier of the APC episode that the A&E attendance has been linked to.
Full details of the methodology used to link A&E and APC records can be found on the following page of our website: http://content.digital.nhs.uk/article/1824/How-do- we-collect-and-process-HES-data
GECKO:0000055
Record identifier
epikey
GECKO:0000055
unique identifiers
The PCTCODE depending on the datayear. Where the data year is equal to or later than 2006, this field contains the code from the field PCTCODE06, otherwise it contains the code from the field PCTCODE02.
In 2013 following a reorganisation of health areas, Primary Care Trusts were abolished. This field has continued to be derived after this date as a 'frozen' geography.
GECKO:0000052
PCT of responsibility dependent on the data year
pctcode
GECKO:0000052
survey administration
Date on which the data used to generate the HES record was received by the Secondary Uses Service (or the NHS-Wide Clearing Service (NWCS) prior to December 2006).|Date on which the data used to generate the HES record was received by the Secondary Uses Service.
GECKO:0000052
Submission date
subdate
GECKO:0000052
survey administration
The date that the record was loaded into the SUS staging system.
GECKO:0000052
SUS loaded staging date
suslddate
GECKO:0000052
survey administration
The patient's health authority or primary care trust (PCT) of residence provided by the NHS.
GECKO:0000052
Primary care trust
pctnhs
GECKO:0000052
survey administration
NHSD participant ID. Rreplaces HESID listed in the data dictionary and be equaivelent to the Pseudonymised HESID (PSEUDO_HESID)|SUS generated record identifier.|SUS (Secondary Uses Service)-generated record identifier.
GECKO:0000055
SUS record ID
susrecid
GECKO:0000055
unique identifiers
Varicose Vein - Q1
varicose_vein_q1
Does the appearance of your varicose veins influence your choice of clothing including tights?
OGMS:0000020
Q1-VV4
vv_q1_clothing
OGMS:0000020
signs and symptoms
Does the appearance of your varicose veins cause you concern?
OGMS:0000020
Q1-VV3
vv_q1_concern
OGMS:0000020
signs and symptoms
Left leg (back) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q1-VV7
vv_q1_left_back_count
OGMS:0000020
signs and symptoms
Do you have purple discolouration caused by tiny blood vessles in the skin, in association with your varicose veins?
OGMS:0000020
Q1-VV11
vv_q1_left_discolour
OGMS:0000020
signs and symptoms
Left leg (front) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q1-VV7
vv_q1_left_front_count
OGMS:0000020
signs and symptoms
In the last two weeks, have you had any itching in association with your varicose veins?
OGMS:0000020
Q1-VV10
vv_q1_left_itch
OGMS:0000020
signs and symptoms
In the last two weeks, for how many days did your varicose veins cause you pain or ache?
OGMS:0000020
Q1-VV8
vv_q1_left_pain_days
OGMS:0000020
signs and symptoms
Do you have any rash or eczema in the area of your ankle?
OGMS:0000020
Q1-VV12
vv_q1_left_rash
OGMS:0000020
signs and symptoms
In the last two weeks have you worn support tights or stockings?
OGMS:0000020
Q1-VV9
vv_q1_left_support
OGMS:0000020
signs and symptoms
Do you have a skin ulcer associated with your varicose veins?
OGMS:0000020
Q1-VV13
vv_q1_left_ulcer
OGMS:0000020
signs and symptoms
During the last two weeks, have your varicose veins interfered with your leisure activities (including sport, hobbies and social life)?
OGMS:0000020
Q1-VV6
vv_q1_leisure
OGMS:0000020
signs and symptoms
During the last two weeks, on how many days did you take painkilling tablets for your varicose veins?
OGMS:0000020
Q1-VV1
vv_q1_painkiller_days
OGMS:0000020
signs and symptoms
Right leg (back) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q1-VV7
vv_q1_right_back_count
OGMS:0000020
signs and symptoms
Do you have purple discolouration caused by tiny blood vessles in the skin, in association with your varicose veins?
OGMS:0000020
Q1-VV11
vv_q1_right_discolour
OGMS:0000020
signs and symptoms
Right leg (front) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q1-VV7
vv_q1_right_front_count
OGMS:0000020
signs and symptoms
In the last two weeks, have you had any itching in association with your varicose veins?
OGMS:0000020
Q1-VV10
vv_q1_right_itch
OGMS:0000020
signs and symptoms
In the last two weeks, for how many days did your varicose veins cause you pain or ache?
OGMS:0000020
Q1-VV9
vv_q1_right_pain_days
OGMS:0000020
signs and symptoms
Do you have any rash or eczema in the area of your ankle?
OGMS:0000020
Q1-VV12
vv_q1_right_rash
OGMS:0000020
signs and symptoms
In the last two weeks have you worn support tights or stockings?
OGMS:0000020
Q1-VV
vv_q1_right_support
OGMS:0000020
signs and symptoms
Do you have a skin ulcer associated with your varicose veins?
OGMS:0000020
Q1-VV13
vv_q1_right_ulcer
OGMS:0000020
signs and symptoms
During the last two weeks, how much ankle swelling have you had?
OGMS:0000020
Q1-VV2
vv_q1_swelling
OGMS:0000020
signs and symptoms
During the last two weeks, have your varicose veins interfered with your work/housework or other daily activities?
OGMS:0000020
Q1-VV5
vv_q1_work
OGMS:0000020
signs and symptoms
GECKO:0000052
vv_q1_max_score
vv_q1_max_score
GECKO:0000052
survey administration
Varicose Vein - Q2
varicose_vein_q2
Does the appearance of your varicose veins influence your choice of clothing including tights?
OGMS:0000020
Q2-VV4
vv_q2_clothing
OGMS:0000020
signs and symptoms
Does the appearance of your varicose veins cause you concern?
OGMS:0000020
Q2-VV3
vv_q2_concern
OGMS:0000020
signs and symptoms
Left leg (back) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q2-VV7
vv_q2_left_back_count
OGMS:0000020
signs and symptoms
Do you have purple discolouration caused by tiny blood vessles in the skin, in association with your varicose veins?
OGMS:0000020
Q2-VV11
vv_q2_left_discolour
OGMS:0000020
signs and symptoms
Left leg (front) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q2-VV7
vv_q2_left_front_count
OGMS:0000020
signs and symptoms
n the last two weeks, have you had any itching in association with your varicose veins?
OGMS:0000020
Q2-VV10
vv_q2_left_itch
OGMS:0000020
signs and symptoms
In the last two weeks, for how many days did your varicose veins cause you pain or ache?
OGMS:0000020
Q2-VV8
vv_q2_left_pain_days
OGMS:0000020
signs and symptoms
Do you have any rash or eczema in the area of your ankle?
OGMS:0000020
Q2-VV12
vv_q2_left_rash
OGMS:0000020
signs and symptoms
In the last two weeks have you worn support tights or stockings?
OGMS:0000020
Q2-VV9
vv_q2_left_support
OGMS:0000020
signs and symptoms
Do you have a skin ulcer associated with your varicose veins?
OGMS:0000020
Q2-VV13
vv_q2_left_ulcer
OGMS:0000020
signs and symptoms
Do you have any visible varicose veins on your legs at the moment?
OGMS:0000020
Q2-VV2
vv_q2_left_visible
OGMS:0000020
signs and symptoms
During the last two weeks, have your varicose veins interfered with your leisure activities (including sport, hobbies and social life)?
OGMS:0000020
Q2-VV6
vv_q2_leisure
OGMS:0000020
signs and symptoms
During the last two weeks, on how many days did you take painkilling tablets for your varicose veins?
OGMS:0000020
Q2-VV1
vv_q2_painkiller_days
OGMS:0000020
signs and symptoms
Right leg (back) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q2-VV7
vv_q2_right_back_count
OGMS:0000020
signs and symptoms
Do you have purple discolouration caused by tiny blood vessles in the skin, in association with your varicose veins?
OGMS:0000020
Q2-VV11
vv_q2_right_discolour
OGMS:0000020
signs and symptoms
Right leg (front) response to Question 7 of the varicose vein specific questions which requests the patient to illustrate the number of visible varicose veins in each leg
OGMS:0000020
Q2-VV7
vv_q2_right_front_count
OGMS:0000020
signs and symptoms
In the last two weeks, have you had any itching in association with your varicose veins?
OGMS:0000020
Q2-VV10
vv_q2_right_itch
OGMS:0000020
signs and symptoms
In the last two weeks, for how many days did your varicose veins cause you pain or ache?
OGMS:0000020
Q2-VV9
vv_q2_right_pain_days
OGMS:0000020
signs and symptoms
Do you have any rash or eczema in the area of your ankle?
OGMS:0000020
Q2-VV12
vv_q2_right_rash
OGMS:0000020
signs and symptoms
In the last two weeks have you worn support tights or stockings?
OGMS:0000020
Q2-VV
vv_q2_right_support
OGMS:0000020
signs and symptoms
Do you have a skin ulcer associated with your varicose veins?
OGMS:0000020
Q2-VV13
vv_q2_right_ulcer
OGMS:0000020
signs and symptoms
Do you have any visible varicose veins on your legs at the moment?
OGMS:0000020
Q2-VV2
vv_q2_right_visible
OGMS:0000020
signs and symptoms
During the last two weeks, how much ankle swelling have you had?
OGMS:0000020
Q1-VV2
vv_q2_swelling
OGMS:0000020
signs and symptoms
During the last two weeks, have your varicose veins interfered with your work/housework or other daily activities?
OGMS:0000020
Q1-VV5
vv_q2_work
OGMS:0000020
signs and symptoms
GECKO:0000052
vv_q2_max_score
vv_q2_max_score
GECKO:0000052
survey administration
ICD9 coded causes of death
GECKO:0000052
icd9_multiple_cause_code_9
icd9_multiple_cause_code_9
GECKO:0000052
survey administration
ICD9 coded causes of death
GECKO:0000052
icd9_underlying_cause
icd9_underlying_cause
GECKO:0000052
survey administration
Height in meters
CMO:0000106
height_at_start_of_regimen
height_at_start_of_regimen
CMO:0000106
height
Refers to the data release process from NHSD
GECKO:0000052
hes_dids_version
hes_dids_version
GECKO:0000052
survey administration
Chronological order of SACT drug regimen since commencement of patient's disease management
GECKO:0000093
regimen_number
regimen_number
GECKO:0000093
medication
Gender of deceased
GECKO:0000060
gender_of_deceased
gender_of_deceased
GECKO:0000060
gender
Latest participant date of birth
PATO:0000011
latest_date_of_birth
latest_date_of_birth
PATO:0000011
age/birthdate
The DATE on which the Chemotherapy was administered to a PATIENT, an infusion commenced, or an oral drug was initially dispensed to the PATIENT.
PDRO:0010022
administration_date
administration_date
PDRO:0010022
administration
The prescribed method of delivery for each administration in a Systemic Anti-Cancer Drug Cycle.
PDRO:0010022
administration_route
administration_route
PDRO:0010022
administration
Date of birth
PATO:0000011
date_of_birth
date_of_birth
PATO:0000011
age/birthdate
Age
PATO:0000011
mhd_age
mhd_age
PATO:0000011
age/birthdate
Supplied participant date of birth
PATO:0000011
supplied_date_of_birth
supplied_date_of_birth
PATO:0000011
age/birthdate
The overall aim of the Anti Cancer Drug Programme
IAO:0000005
intent_of_treatment
intent_of_treatment
IAO:0000005
aims and objectives
Sex of Patients Code
PATO:0000047
mhd_sex_code
mhd_sex_code
PATO:0000047
biological sex
Latest participant gender
MONDO:0005151
latest_gender
latest_gender
MONDO:0005151
endocrine system diseases
Indicates whether the record has an open SCT episode at the end of the Reporting Period.
GECKO:0000061
ic_rec_endrp_sct_flag
ic_rec_endrp_sct_flag
GECKO:0000061
ethnicity/race
Ethnic Category
GECKO:0000061
mhd_ethnicity
mhd_ethnicity
GECKO:0000061
ethnicity/race
Person Gender Code Current
GECKO:0000060
mhd_gender
mhd_gender
GECKO:0000060
gender
Supplied participant gender
GECKO:0000060
supplied_gender
supplied_gender
GECKO:0000060
gender
Date of the participant's death
STATO:0000093
date_of_death
date_of_death
STATO:0000093
date and time-related information
This should be recorded if the First Definitive Treatment is Chemotherapy and/or other anti-cancer drug treatments.
GECKO:0000093
STATO:0000093
start_date_of_regimen
start_date_of_regimen
GECKO:0000093
medication
STATO:0000093
date and time-related information
DECISION TO TREAT DATE (ANTI-CANCER DRUG REGIMEN) is the DECISION TO TREAT DATE of the Planned Cancer Treatment with a PLANNED CANCER TREATMENT TYPE of National Code 'Chemotherapy' or 'Hormone Therapy' and where the FIRST DEFINITIVE TREATMENT PLANNED is classification 'First Definitive Treatment planned'.
STATO:0000093
date_decision_to_treat
date_decision_to_treat
STATO:0000093
date and time-related information
The date of the first drug administration in each Systemic Anti-Cancer Drug Cycle.
STATO:0000093
start_date_of_cycle
start_date_of_cycle
STATO:0000093
date and time-related information
Morphology (ICD-O on SACT initiation) for the cell type at the start of SACT drug programme.
MONDO:0004992
morphology_clean
morphology_clean
MONDO:0004992
cancer
Primary diagnosis (on SACT initiation)
MONDO:0004992
primary_diagnosis
primary_diagnosis
MONDO:0004992
cancer
Tumour Node and Metastasis stage grouping (final pretreatment)
MONDO:0004992
stage_at_start
stage_at_start
MONDO:0004992
cancer
Care professional main speciality code (start SACT)
GECKO:0000073
consultant_speciality_code
consultant_speciality_code
GECKO:0000073
physician/practitioner info
GP_Practice
GECKO:0000073
mhd_ccg_of_gp_practice
mhd_ccg_of_gp_practice
GECKO:0000073
physician/practitioner info
Organisation Code (GP Practice Responsibility)
GECKO:0000073
mhd_code_of_gp_practice
mhd_code_of_gp_practice
GECKO:0000073
physician/practitioner info
SACT regimen modification indicator - reduce the dose administered
PDRO:0000024
regimen_mod_dose_reduction
regimen_mod_dose_reduction
PDRO:0000024
prescription
GECKO:0000114
delmeth_d
delmeth_d
GECKO:0000114
reproduction
Actual chemotherapy dose in mh or other applicable units
PDRO:0000024
actual_dose_per_administration
actual_dose_per_administration
PDRO:0000024
prescription
An indication of¬†whether a¬†PATIENT’s overall physical state (i.e. other diseases and conditions) was a significant factor in deciding on the type of¬†Anti-Cancer Drug Regimen, for example a¬†Systemic Anti-Cancer Drug Regimen, or influencing whether a dose was reduced, or the time between cycles increased at the commencement of the¬†Anti-Cancer Drug Regimen.
PDRO:0000024
comorbidity_adjustment
comorbidity_adjustment
PDRO:0000024
prescription
County
GECKO:0000064
mhd_county
mhd_county
GECKO:0000064
residence
The name of the Chemotherapy (Systemic Anti-Cancer Therapy) drug given to a PATIENT during an Anti-Cancer Drug Regimen.
GECKO:0000093
drug_group
drug_group
GECKO:0000093
medication
This may be the number of Systemic Anti-Cancer Drug Cycles in the standard Systemic Anti-Cancer Drug Regimen or be modified by the prescriber.
PDRO:0000024
number_of_cycles_planned
number_of_cycles_planned
PDRO:0000024
prescription
The date of the start of the final cycle of SACT treatment within a regimen
PDRO:0000024
STATO:0000093
date_of_final_treatment
date_of_final_treatment
PDRO:0000024
prescription
STATO:0000093
date and time-related information
SACT regimen modification indicator - reduce administration days below the number planned
GECKO:0000093
regimen_mod_stopped_early
regimen_mod_stopped_early
GECKO:0000093
medication
SACT regimen modification indicator - extending time between administration dates
PDRO:0010022
regimen_mod_time_delay
regimen_mod_time_delay
PDRO:0010022
administration
An indicator of whether the treatment within an Anti-Cancer Drug Programme was completed as planned, and if not, the reason why
GECKO:0000093
regimen_outcome_summary
regimen_outcome_summary
GECKO:0000093
medication
Anti-Cancer Drug Cycles are numbered sequentially within an Anti-Cancer Drug Regimen.
GECKO:0000093
cycle_number
cycle_number
GECKO:0000093
medication
An indication of whether a regimen, such as a Systemic Anti-Cancer Drug Regimen, is given as part of a combined treatment with radiation.
GECKO:0000093
chemo_radiation
chemo_radiation
GECKO:0000093
medication
Weight in Kilos
CMO:0000012
weight_at_start_of_cycle
weight_at_start_of_cycle
CMO:0000012
weight
Weight in Kilos
CMO:0000012
weight_at_start_of_regimen
weight_at_start_of_regimen
CMO:0000012
weight
Regimen analysis grouping
GECKO:0000052
analysis_group
analysis_group
GECKO:0000052
survey administration
Number of days between Diagnostic Test Request Date and Diagnostic Test Request Received Date for all records that fall into defined dimensions.
STATO:0000093
Test Request to Test Request Received
ic_date1_to_date2
STATO:0000093
date and time-related information
Number of days between Diagnostic Test Request Date and Diagnostic Test Date for all records that fall into defined dimensions
STATO:0000093
Test Request to Test
ic_date1_to_date3
STATO:0000093
date and time-related information
Number of days between Diagnostic Test Request Date and Service Report Issue Date for all records that fall into defined dimensions
STATO:0000093
Test Request to Service (Test) Report Issue
ic_date1_to_date4
STATO:0000093
date and time-related information
Number of days between Diagnostic Test Request Received Date and Diagnostic Test Date for all records that fall into defined dimensions
STATO:0000093
Test Request Received to Test
ic_date2_to_date3
STATO:0000093
date and time-related information
Number of days between Diagnostic Test Request Received Sate and Service Report Issue Date for all records that fall into defined dimensions
STATO:0000093
Test Request Received to Service (test) Report Issue
ic_date2_to_date4
STATO:0000093
date and time-related information
Number of days between Diagnostic Test Date and Service Report Issue Date for all records that fall into defined dimensions
STATO:0000093
Test to Service (Test) Report Issue
ic_date3_to_date4
STATO:0000093
date and time-related information
MONDO:0000001
did_snomedct_code
did_snomedct_code
MONDO:0000001
diseases
SAC Rating C Score
GECKO:0000052
mhd_sacratingc_score
mhd_sacratingc_score
GECKO:0000052
survey administration
SAC Rating D Score
GECKO:0000052
mhd_sacratingd_score
mhd_sacratingd_score
GECKO:0000052
survey administration
SAC Rating E Score
GECKO:0000052
mhd_sacratinge_score
mhd_sacratinge_score
GECKO:0000052
survey administration
Secondary Diagnosis
MONDO:0000001
mhd_secondarydiagnosis
mhd_secondarydiagnosis
MONDO:0000001
diseases
Settled Accommodation Indicator for the patient
GECKO:0000052
mhd_settled_accommodation_indicator
mhd_settled_accommodation_indicator
GECKO:0000052
survey administration
Source of initial referral
GECKO:0000052
mhd_source_of_referral
mhd_source_of_referral
GECKO:0000052
survey administration
Spell Start Date
STATO:0000093
mhd_start_date_mhcs
mhd_start_date_mhcs
STATO:0000093
date and time-related information
Depending on Episode Source Table this could be: Mental Health Act Legal Status Start Time, Supervised Community Treatment Recall Start Time
GECKO:0000052
mhd_starttime
mhd_starttime
GECKO:0000052
survey administration
Status of Service Request (Mental Health)
GECKO:0000052
mhd_status_of_service_request
mhd_status_of_service_request
GECKO:0000052
survey administration
Mental Health Team Type
GECKO:0000052
mhd_teamtype
mhd_teamtype
GECKO:0000052
survey administration
Intervention (Read)
GECKO:0000052
mhd_treat
mhd_treat
GECKO:0000052
survey administration
Indicates that the NHS number submitted was valid (and not default)
GECKO:0000052
mhd_valid_nhs_number_flag
mhd_valid_nhs_number_flag
GECKO:0000052
survey administration
Indicates that the full postcode was a valid residential postcode
GECKO:0000052
mhd_valid_postcode_flag
mhd_valid_postcode_flag
GECKO:0000052
survey administration
Ward Security Level
GECKO:0000052
mhd_wardsec_level
mhd_wardsec_level
GECKO:0000052
survey administration
Weekly hours worked for a patient in employment
PATO:0001995
mhd_weekly_hours_worked
mhd_weekly_hours_worked
PATO:0001995
socio-demographic and economic characteristics
submitted, not derived
STATO:0000093
mhd_year_of_first_known_psychiatric_care
mhd_year_of_first_known_psychiatric_care
STATO:0000093
date and time-related information
The trace status of the NHS Number
GECKO:0000052
nhs_number_status
nhs_number_status
GECKO:0000052
survey administration
Descriptive sub-division of each identified cancer category. The following categories have been identified by clinicians.
MONDO:0004992
Sub Early cancer diagnosis
ic_sub_cancer_desc
MONDO:0004992
cancer
Date of registration of the event
STATO:0000093
date_of_registration
date_of_registration
STATO:0000093
date and time-related information
The ID that represents the financial year the YTD file falls within
GECKO:0000055
ic_annual_id
ic_annual_id
GECKO:0000055
unique identifiers
The number of days the episode was open (in the Reporting Period) based on the start and end dates of the episode. Where the episode start date is before the start or the reporting period, the start of the reporting period is used. Where end date is not present, date the episode was deemed to be inactive is used and if this is not present, the end of the reporting period is used.
STATO:0000093
ic_epi_rp_days
ic_epi_rp_days
STATO:0000093
date and time-related information
Indicates the length of an episode in days based on the start and end dates of the episode. Where end date is not present, the end of the reporting period is used.
STATO:0000093
ic_episode_epi_days
ic_episode_epi_days
STATO:0000093
date and time-related information
IC derivation name as csv column header name. Cleans primary diagnosis code using these steps; (a) clean code by removing full-stops (HES rule 460). (b) truncates code, replaces Os with 0s and removes codes shorter than three characters in length. (c) adds X to the end of three character codes, cleans codes with an X in 3rd position and change codes without a match within ICD 10 reference data to end in X. (d) change codes ending in X to 9 if no matching description. (e) class unmatched records as Invalid.
GECKO:0000052
ic_eve_primarydiagnosis
ic_eve_primarydiagnosis
GECKO:0000052
survey administration
IC derivation name as csv column header name. Cleans primary diagnosis code using these steps; (a) clean code by removing full-stops (HES rule 460). (b) truncates code, replaces Os with 0s and removes codes shorter than three characters in length. (c) adds X to the end of three character codes, cleans codes with an X in 3rd position and change codes without a match within ICD 10 reference data to end in X. (d) change codes ending in X to 9 if no matching description. (e) class unmatched records as Invalid.
GECKO:0000052
ic_eve_secondarydiagnosis
ic_eve_secondarydiagnosis
GECKO:0000052
survey administration
Used on record and episode. Not set for episodes and records where the IC_Source_Time_ID is the maximum held within the the YTD file. For others if the record / episode is open but the episode cannot be found in a superceding reporting period, record is stamped inactive with the first day of the next reporting period we would have expected to received the record / episode.
STATO:0000093
ic_inactive_timestamp
ic_inactive_timestamp
STATO:0000093
date and time-related information
Interim CCG Code
GECKO:0000052
ic_interim_ccg_code
ic_interim_ccg_code
GECKO:0000052
survey administration
This field is derived during processing. It shows the CCG of GP practice, for the patient, or if that was not provided, the CCG of residence.
GECKO:0000052
ic_rec_ccg
ic_rec_ccg
GECKO:0000052
survey administration
Indicates whether the record has an open Team episode with an AOT team at the end of the Reporting Period.
GECKO:0000052
ic_rec_endrp_aot_flag
ic_rec_endrp_aot_flag
GECKO:0000052
survey administration
Indicates whether the record has an open Team episode with an EIT team at the end of the Reporting Period.
GECKO:0000052
ic_rec_endrp_cluster_flag
ic_rec_endrp_cluster_flag
GECKO:0000052
survey administration
Shows the Cluster Code for the most recent Cluster episode that is open at the end of the reporting period for the record. Where more than 1 episode per record occurs records are prioritised by Episode ID.
GECKO:0000052
ic_rec_endrp_cluster_type
ic_rec_endrp_cluster_type
GECKO:0000052
survey administration
Indicates where the record has an open CPA episode that has been open for 365 days or more
GECKO:0000052
ic_rec_endrp_cpa_epi_12_months
ic_rec_endrp_cpa_epi_12_months
GECKO:0000052
survey administration
Indicates whether the record has an open CPA episode at the end of the Reporting Period.
GECKO:0000052
ic_rec_endrp_cpa_flag
ic_rec_endrp_cpa_flag
GECKO:0000052
survey administration
Indicates whether the record has an open spell at the end of the Reporting Period and a CPA review within the last 12 months
GECKO:0000052
ic_rec_endrp_cpa_review_within_12mnths
ic_rec_endrp_cpa_review_within_12mnths
GECKO:0000052
survey administration
Indicates whether the record has an open Team episode with an EIT team at the end of the Reporting Period.
GECKO:0000052
ic_rec_endrp_eit_flag
ic_rec_endrp_eit_flag
GECKO:0000052
survey administration
Shows the employment status for the most recent 'EMP' event within the last 12 months for each record with an open spell at the end of the reporting period
GECKO:0000052
ic_rec_endrp_employment_status
ic_rec_endrp_employment_status
GECKO:0000052
survey administration
Shows the settled accommodation Indicator for the most recent 'ACCOM' event within the last 12 months for each record with an open spell at the end of the reporting period
GECKO:0000052
ic_rec_endrp_honos_assessment_within_12mnths
ic_rec_endrp_honos_assessment_within_12mnths
GECKO:0000052
survey administration
Indicates where the record has an open WRDST or PROSP episode at the end of the reporting period
GECKO:0000052
ic_rec_endrp_hospital_spell_flag
ic_rec_endrp_hospital_spell_flag
GECKO:0000052
survey administration
Indicates whether the record has an open MHA episode at the end of the Reporting Period, where it has a valid legal status and has not expired. Codes accepted as valid for this derivation are:
'01','02','03','04','05','06','07','08','09','10','12','13','14','15','16','17','18','19','20','31','32','34','35','36'
GECKO:0000052
ic_rec_endrp_mha_flag
ic_rec_endrp_mha_flag
GECKO:0000052
survey administration
Indicates whether the record has an open spell at the end of the Reporting Period and a valid recorded primary diagnosis within the last 12 months
GECKO:0000052
ic_rec_endrp_pdiag_flag
ic_rec_endrp_pdiag_flag
GECKO:0000052
survey administration
Indicates whether the record has an open recall episode at the end of the Reporting Period and where the RECALL has not expired.
GECKO:0000052
ic_rec_endrp_recall_flag
ic_rec_endrp_recall_flag
GECKO:0000052
survey administration
Shows the settled accommodation Indicator for the most recent 'ACCOM' event within the last 12 months for each record with an open spell at the end of the reporting period
GECKO:0000052
ic_rec_endrp_settled_accommodation_indicator
ic_rec_endrp_settled_accommodation_indicator
GECKO:0000052
survey administration
Cleansed ethnic category code. Removes the second character (where value is not equal 9 or 99) which is optional for use locally leaving the national code. Otherwise 99.
GECKO:0000052
GECKO:0000061
ic_rec_ethnicity
ic_rec_ethnicity
GECKO:0000052
survey administration
GECKO:0000061
ethnicity/race
Organisation Code (GP Practice Responsibility)
GECKO:0000052
ic_rec_rp_admission
ic_rec_rp_admission
GECKO:0000052
survey administration
Calculates the number of admissions within the reporting period where there was a MHA episode starting on the same day and the MHD_LegStatCode had one of the following values:
'2', '02', ' 2', '3', '03', ' 3', '7', '07', ' 7', '8', '08', ' 8', '9', '09', ' 9', '10', '12', '13', '14', '15', '16', '17', '18', '31', '32', '34'
GECKO:0000052
ic_rec_rp_admission_formal
ic_rec_rp_admission_formal
GECKO:0000052
survey administration
Indicates where the record has an AWOL episode that starts in the reporting period and that lasts for more than 1 day
GECKO:0000052
ic_rec_rp_awol
ic_rec_rp_awol
GECKO:0000052
survey administration
Calculates, for the record, the number of distinct MHD_Commissioner_Codes for episodes of type COMMH
GECKO:0000052
ic_rec_rp_commissioners
ic_rec_rp_commissioners
GECKO:0000052
survey administration
Calculates the total number of HP contacts in the reporting period for the record.
GECKO:0000052
ic_rec_rp_contacts
ic_rec_rp_contacts
GECKO:0000052
survey administration
Calculates the number of attended HP contacts in the reporting period for the record.
GECKO:0000052
ic_rec_rp_contacts_att
ic_rec_rp_contacts_att
GECKO:0000052
survey administration
Calculates the total number of day attendance contacts in the reporting period for the record.
GECKO:0000052
ic_rec_rp_dayatt_contacts
ic_rec_rp_dayatt_contacts
GECKO:0000052
survey administration
Calculates the number of attended day attendance contacts in the reporting period for the record.
GECKO:0000052
ic_rec_rp_dayatt_contacts_att
ic_rec_rp_dayatt_contacts_att
GECKO:0000052
survey administration
Calculates the total numbers of days between the start and end date of a Delayed Discharge (DDISC) episode within the reporting period for the record regardless of overlapping episodes.
GECKO:0000052
ic_rec_rp_ddisc_days
ic_rec_rp_ddisc_days
GECKO:0000052
survey administration
This is an experimental construction and is likely to be revised. Calculates the number of IC_Rec_RP_Discharges_Net for the record where there is an event of type HPCON with a MHD_ConsultMedium not in ('05','06')
and the MHD_EventDate is between the discharge date and discharge date+7
GECKO:0000052
ic_rec_rp_disch_net_followup
ic_rec_rp_disch_net_followup
GECKO:0000052
survey administration
Calculates the total number of hospital discharges in the reporting period for the record.
GECKO:0000052
ic_rec_rp_discharges_gross
ic_rec_rp_discharges_gross
GECKO:0000052
survey administration
This is an experimental construction and is likely to be revised. Calculates the number of hospital discharges in the reporting period, excluding the last 7 days,
where the method of discharge is null or is not 'client died'.
There must also be a episode of type REF that is open in the reporting period or is discharged in the reporting period, excluding the last 7 days,
and not discharged due to transfer to another provider.
The date of hospital discharge must not be the same as the date of referral discharge.
GECKO:0000052
ic_rec_rp_discharges_net
ic_rec_rp_discharges_net
GECKO:0000052
survey administration
This field is empty and is a placeholder for a derivation that is currently in development.
GECKO:0000052
ic_rec_rp_readmissions
ic_rec_rp_readmissions
GECKO:0000052
survey administration
Calculates the total number of days between the start and end date of a wardstay episode within the reporting period, subtracting any overlaps.
STATO:0000093
ic_rec_rp_wrdst_days_cleansed
ic_rec_rp_wrdst_days_cleansed
STATO:0000093
date and time-related information
Calculates the total number of days between the start and end date of each Wardstay episode within the reporting period,where the end date is NULL the inactive date is used else the end of the reporting period is used.
STATO:0000093
ic_rec_rp_wrdst_days_gross
ic_rec_rp_wrdst_days_gross
STATO:0000093
date and time-related information
Calculates the total number of days between the start and end date of a Wardstay episode within the reporting period and subtracts Homeleave using the number generated in the Cleansed Wardstays field.
STATO:0000093
ic_rec_rp_wrdst_days_net
ic_rec_rp_wrdst_days_net
STATO:0000093
date and time-related information
Item derived on monthly record and carried through. Represents the MONTH ID the record was given on load|The number of days the episode was open (in the Reporting Period) based on the start and end dates of the episode. Where the episode start date is before the start or the reporting period, the start of the reporting period is used. Where end date is not present, date the episode was deemed to be inactive is used and if this is not present, the end of the reporting period is used.
GECKO:0000052
ic_source_period_id
ic_source_period_id
GECKO:0000052
survey administration
Indicates the length of an spell in days based on the start and end dates of the spell. Where the spell start date is before the start or the reporting period, the start of the reporting period is used. Where end date is not present, the end of the reporting period is used.
STATO:0000093
ic_spell_rp_days
ic_spell_rp_days
STATO:0000093
date and time-related information
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_1
icd10_multiple_cause_code_1
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_10
icd10_multiple_cause_code_10
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_11
icd10_multiple_cause_code_11
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_12
icd10_multiple_cause_code_12
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_13
icd10_multiple_cause_code_13
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_14
icd10_multiple_cause_code_14
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_15
icd10_multiple_cause_code_15
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_2
icd10_multiple_cause_code_2
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_3
icd10_multiple_cause_code_3
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_4
icd10_multiple_cause_code_4
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_5
icd10_multiple_cause_code_5
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_6
icd10_multiple_cause_code_6
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_7
icd10_multiple_cause_code_7
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_8
icd10_multiple_cause_code_8
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_multiple_cause_code_9
icd10_multiple_cause_code_9
MONDO:0000001
diseases
ICD10 coded causes of death
MONDO:0000001
icd10_underlying_cause
icd10_underlying_cause
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_1
icd9_multiple_cause_code_1
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_10
icd9_multiple_cause_code_10
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_11
icd9_multiple_cause_code_11
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_12
icd9_multiple_cause_code_12
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_13
icd9_multiple_cause_code_13
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_14
icd9_multiple_cause_code_14
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_15
icd9_multiple_cause_code_15
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_2
icd9_multiple_cause_code_2
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_3
icd9_multiple_cause_code_3
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_4
icd9_multiple_cause_code_4
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_5
icd9_multiple_cause_code_5
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_6
icd9_multiple_cause_code_6
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_7
icd9_multiple_cause_code_7
MONDO:0000001
diseases
ICD9 coded causes of death
MONDO:0000001
icd9_multiple_cause_code_8
icd9_multiple_cause_code_8
MONDO:0000001
diseases
Regimen grouping (benchmark reports)
GECKO:0000052
benchmark_group
benchmark_group
GECKO:0000052
survey administration
Returns the submitted Referrer Organisation name of the organisation from which the referral is made, such as a GP practice or NHS Trust. In many cases the referring organisation will be the actual trust itself (for example in the case of ward and clinic requests). When this is a request from a GP, the referring organisation will be the name of the practice, which is different from the referrer.
GECKO:0000052
Referrer
ic_refer_orgname
GECKO:0000052
survey administration
Referrer type is derived from submitted field Referrer Code and converted into categories: GP, Consultant, Nurse, Physio, Other health professional, Not known
GECKO:0000052
Referrer type
ic_reftype_desc
GECKO:0000052
survey administration
Identifier
GECKO:0000055
patient_pseudo_id
patient_pseudo_id
GECKO:0000055
unique identifiers
A World Health Organisation classification indicating a PERSON's status relating to activity/DISABILITY.
GECKO:0000052
perf_stat_start_of_cycle_clean
perf_stat_start_of_cycle_clean
GECKO:0000052
survey administration
A World Health Organisation classification indicating a PERSON's status relating to activity/DISABILITY.
GECKO:0000052
perf_stat_start_of_reg_clean
perf_stat_start_of_reg_clean
GECKO:0000052
survey administration
GECKO:0000052
primercp
primercp
GECKO:0000052
survey administration
Chronological order of SACT drug programme since commencement of patient's disease management
GECKO:0000093
programme_number
programme_number
GECKO:0000093
medication
STATO:0000093
reportingperiod_enddate
reportingperiod_enddate
STATO:0000093
date and time-related information
STATO:0000093
reportingperiod_startdate
reportingperiod_startdate
STATO:0000093
date and time-related information
GECKO:0000052
resstha_his
resstha_his
GECKO:0000052
survey administration
Identifier
GECKO:0000055
tumour_pseudo_id
tumour_pseudo_id
GECKO:0000055
unique identifiers
GECKO:0000052
acpdqind_2
acpdqind_2
GECKO:0000052
survey administration
GECKO:0000052
acpdqind_3
acpdqind_3
GECKO:0000052
survey administration
GECKO:0000052
acpdqind_4
acpdqind_4
GECKO:0000052
survey administration
GECKO:0000052
acpdqind_5
acpdqind_5
GECKO:0000052
survey administration
GECKO:0000052
acpdqind_6
acpdqind_6
GECKO:0000052
survey administration
GECKO:0000052
acpdqind_7
acpdqind_7
GECKO:0000052
survey administration
GECKO:0000052
acpdqind_8
acpdqind_8
GECKO:0000052
survey administration
GECKO:0000052
acpdqind_9
acpdqind_9
GECKO:0000052
survey administration
An indication of whether an individual episode of care is being delivered to a PATIENT as part of a CLINICAL TRIAL.
GECKO:0000052
clinical_trial
clinical_trial
GECKO:0000052
survey administration
Date of the event_type above
STATO:0000093
event_date
event_date
STATO:0000093
date and time-related information
D = Deceased, CAN = Cancelled Cipher, CA = Cancer, EMB = Embarkation, SCT = Registered in Scotland, NI = Registered in Northern Ireland
GECKO:0000052
event_type
event_type
GECKO:0000052
survey administration
Patient's gender currently
GECKO:0000060
gender_current_clean
gender_current_clean
GECKO:0000060
gender
Abuse Question Asked Indicator
GECKO:0000052
mhd_abusequestion_indicator
mhd_abusequestion_indicator
GECKO:0000052
survey administration
Accommodation Status of the patient
GECKO:0000052
mhd_accomodation_status
mhd_accomodation_status
GECKO:0000052
survey administration
Admission method
GECKO:0000052
mhd_admimet
mhd_admimet
GECKO:0000052
survey administration
Act under which assessed
GECKO:0000052
mhd_assessment
mhd_assessment
GECKO:0000052
survey administration
Indicator of whether the patient attended or did not attend
GECKO:0000052
mhd_attended_indicator
mhd_attended_indicator
GECKO:0000052
survey administration
Mental Health Care Cluster Super Class Code
GECKO:0000052
mhd_carecluster_superclass_code
mhd_carecluster_superclass_code
GECKO:0000052
survey administration
Indicates that the member of staff for this event was the service user's Care Coordinator
GECKO:0000052
mhd_carecoordinator_flag
mhd_carecoordinator_flag
GECKO:0000052
survey administration
Organisation Code (Residence Responsibility)
GECKO:0000052
mhd_ccg_of_residence
mhd_ccg_of_residence
GECKO:0000052
survey administration
Mental Health Clustering Tool Assessment Reason
GECKO:0000052
mhd_clusteringtool_assessment_reason
mhd_clusteringtool_assessment_reason
GECKO:0000052
survey administration
Commissioner Code
GECKO:0000052
mhd_code_of_commissioner
mhd_code_of_commissioner
GECKO:0000052
survey administration
End Date Episode
STATO:0000093
mhd_commissioner_code
mhd_commissioner_code
STATO:0000093
date and time-related information
Consultation Medium Used
GECKO:0000052
mhd_consultmedium
mhd_consultmedium
GECKO:0000052
survey administration
Contact Location Type Code
GECKO:0000052
mhd_contact_location_code
mhd_contact_location_code
GECKO:0000052
survey administration
Care Contact Subject
GECKO:0000052
mhd_contact_subject
mhd_contact_subject
GECKO:0000052
survey administration
Crisis Plan Creation Date
STATO:0000093
mhd_crisisplancreat_date
mhd_crisisplancreat_date
STATO:0000093
date and time-related information
Crisis Plan last Update Date
STATO:0000093
mhd_crisisplanupdate_date
mhd_crisisplanupdate_date
STATO:0000093
date and time-related information
Mental Health Delayed Discharge Start Date
STATO:0000093
mhd_delayed_dischend_date
mhd_delayed_dischend_date
STATO:0000093
date and time-related information
Mental Health Delayed Discharge Reason
GECKO:0000052
mhd_delayed_dischreason
mhd_delayed_dischreason
GECKO:0000052
survey administration
Mental Health Delayed Discharge End Date
STATO:0000093
mhd_delayed_dischstart_date
mhd_delayed_dischstart_date
STATO:0000093
date and time-related information
Discharge Date
STATO:0000093
mhd_dischdate
mhd_dischdate
STATO:0000093
date and time-related information
Discharge Method
GECKO:0000052
mhd_dischmet
mhd_dischmet
GECKO:0000052
survey administration
Discharge Reason
GECKO:0000052
mhd_dischreason
mhd_dischreason
GECKO:0000052
survey administration
Depending on Event source table this could be Duration of Contact, the duration of a period of physical restraint of the patient in minutes or Duration of Seclusion
GECKO:0000052
mhd_duration
mhd_duration
GECKO:0000052
survey administration
Electoral Ward of Usual Address
GECKO:0000064
mhd_electoral_ward_of_usual_address
mhd_electoral_ward_of_usual_address
GECKO:0000064
residence
Emergent Psychosis Date
STATO:0000093
mhd_emerpsych_date
mhd_emerpsych_date
STATO:0000093
date and time-related information
Employment Status of the patient
PATO:0001995
mhd_employment_status
mhd_employment_status
PATO:0001995
socio-demographic and economic characteristics
Spell End Date
STATO:0000093
mhd_end_date_mhcs
mhd_end_date_mhcs
STATO:0000093
date and time-related information
Cluster End Reason
GECKO:0000052
mhd_endreason
mhd_endreason
GECKO:0000052
survey administration
Mental Health Act Legal Status Expiry Time
GECKO:0000052
mhd_endtime
mhd_endtime
GECKO:0000052
survey administration
End Date Episode
STATO:0000093
mhd_epiend_date
mhd_epiend_date
STATO:0000093
date and time-related information
Unique ID in the Episode file
GECKO:0000055
mhd_episode_id
mhd_episode_id
GECKO:0000055
unique identifiers
Start Date of Episode
STATO:0000093
mhd_epistart_date
mhd_epistart_date
STATO:0000093
date and time-related information
Indicates the source Episode Table for the row. This value is derived during processing and references the source tables as follows:
Episode type Source Table
REF 5 - REFER
TMEP 6 - TEAMEP
DAYEP 7 - DAYEP
OPEP 8 - OPEP
HBCAR 9 - HBCAREEP
CAREH 10- NHSCAREHOMEEP
PROSP 11 - PROVSPELL
INPAT 12 - INPATEP
WRDST 13 - WARDSTAYS
DDISC 14 - DELAYEDDISCHARGE
CCASS 17 - CCASS
RCASS 18 - RCASS
CPA 24 - CPAEP
CLUST 27 - CLUSTER
HOMEL 41 - HOMELEAVE
COMMH 46 - COMMHIST
NB The episode type will dictate what values in addition to Date could appear in this row.
GECKO:0000052
mhd_epitype
mhd_epitype
GECKO:0000052
survey administration
Unique ID in the Event file
GECKO:0000055
mhd_event_id
mhd_event_id
GECKO:0000055
unique identifiers
Event date
STATO:0000093
mhd_eventdate
mhd_eventdate
STATO:0000093
date and time-related information
Indicates the source Event Table for the row. This value is derived during processing and references the source tables as follows:
GECKO:0000052
mhd_eventtype
mhd_eventtype
GECKO:0000052
survey administration
Depending on Source Table this could be: Mental Health Act Legal Status Expiry Date, Supervised Community Treatment Expiry Date
STATO:0000093
mhd_expirydate
mhd_expirydate
STATO:0000093
date and time-related information
Mental Health Act Legal Status Expiry Time
STATO:0000093
mhd_expirytime
mhd_expirytime
STATO:0000093
date and time-related information
Spell End Reason
GECKO:0000052
mhd_health_care_spell_end_reason
mhd_health_care_spell_end_reason
GECKO:0000052
survey administration
Indicates that the HoNOS record was valid.
GECKO:0000052
mhd_honos_flag
mhd_honos_flag
GECKO:0000052
survey administration
HoNOS Rating 1 Score
GECKO:0000052
mhd_honos_honosrating1_score
mhd_honos_honosrating1_score
GECKO:0000052
survey administration
HoNOS Rating 10 Score
GECKO:0000052
mhd_honos_honosrating10_score
mhd_honos_honosrating10_score
GECKO:0000052
survey administration
HoNOS Rating 11 Score
GECKO:0000052
mhd_honos_honosrating11_score
mhd_honos_honosrating11_score
GECKO:0000052
survey administration
HoNOS Rating 12 Score
GECKO:0000052
mhd_honos_honosrating12_score
mhd_honos_honosrating12_score
GECKO:0000052
survey administration
HoNOS Rating 2 Score
GECKO:0000052
mhd_honos_honosrating2_score
mhd_honos_honosrating2_score
GECKO:0000052
survey administration
HoNOS Rating 3 Score
GECKO:0000052
mhd_honos_honosrating3_score
mhd_honos_honosrating3_score
GECKO:0000052
survey administration
HoNOS Rating 4 Score
GECKO:0000052
mhd_honos_honosrating4_score
mhd_honos_honosrating4_score
GECKO:0000052
survey administration
HoNOS Rating 5 Score
GECKO:0000052
mhd_honos_honosrating5_score
mhd_honos_honosrating5_score
GECKO:0000052
survey administration
HoNOS Rating 6 Score
GECKO:0000052
mhd_honos_honosrating6_score
mhd_honos_honosrating6_score
GECKO:0000052
survey administration
HoNOS Rating 7 Score
GECKO:0000052
mhd_honos_honosrating7_score
mhd_honos_honosrating7_score
GECKO:0000052
survey administration
HoNOS Rating 8 Score
GECKO:0000052
mhd_honos_honosrating8_score
mhd_honos_honosrating8_score
GECKO:0000052
survey administration
HoNOS Rating 8 Type
GECKO:0000052
mhd_honos_honosrating8_type
mhd_honos_honosrating8_type
GECKO:0000052
survey administration
HoNOS Rating 9 Score
GECKO:0000052
mhd_honos_honosrating9_score
mhd_honos_honosrating9_score
GECKO:0000052
survey administration
Indicates that the HoNOS Secure record was valid.
GECKO:0000052
mhd_honos_secure_flag
mhd_honos_secure_flag
GECKO:0000052
survey administration
Indicates that the HoNOS65 record was valid.
GECKO:0000052
mhd_honos65_flag
mhd_honos65_flag
GECKO:0000052
survey administration
HoNOS65+ Rating 1 Score
GECKO:0000052
mhd_honos65_rating1_score
mhd_honos65_rating1_score
GECKO:0000052
survey administration
HoNOS65+ Rating 10 Score
GECKO:0000052
mhd_honos65_rating10_score
mhd_honos65_rating10_score
GECKO:0000052
survey administration
HoNOS65+ Rating 11 Score
GECKO:0000052
mhd_honos65_rating11_score
mhd_honos65_rating11_score
GECKO:0000052
survey administration
HoNOS65+ Rating 12 Score
GECKO:0000052
mhd_honos65_rating12_score
mhd_honos65_rating12_score
GECKO:0000052
survey administration
HoNOS65+ Rating 2 Score
GECKO:0000052
mhd_honos65_rating2_score
mhd_honos65_rating2_score
GECKO:0000052
survey administration
HoNOS65+ Rating 3 Score
GECKO:0000052
mhd_honos65_rating3_score
mhd_honos65_rating3_score
GECKO:0000052
survey administration
HoNOS65+ Rating 4 Score
GECKO:0000052
mhd_honos65_rating4_score
mhd_honos65_rating4_score
GECKO:0000052
survey administration
HoNOS65+ Rating 5 Score
GECKO:0000052
mhd_honos65_rating5_score
mhd_honos65_rating5_score
GECKO:0000052
survey administration
HoNOS65+ Rating 6 Score
GECKO:0000052
mhd_honos65_rating6_score
mhd_honos65_rating6_score
GECKO:0000052
survey administration
HoNOS65+ Rating 7 Score
GECKO:0000052
mhd_honos65_rating7_score
mhd_honos65_rating7_score
GECKO:0000052
survey administration
HoNOS65+ Rating 8 Score
GECKO:0000052
mhd_honos65_rating8_score
mhd_honos65_rating8_score
GECKO:0000052
survey administration
HoNOS65+ Rating 8 Type
GECKO:0000052
mhd_honos65_rating8_type
mhd_honos65_rating8_type
GECKO:0000052
survey administration
HoNOS65+ Rating 9 Score
GECKO:0000052
mhd_honos65_rating9_score
mhd_honos65_rating9_score
GECKO:0000052
survey administration
Indicates that the HoNOS65 record was valid.
GECKO:0000052
mhd_honosca_flag
mhd_honosca_flag
GECKO:0000052
survey administration
HoNOS-CA Rating 1 Score
GECKO:0000052
mhd_honoscarating1_score
mhd_honoscarating1_score
GECKO:0000052
survey administration
HoNOS-CA Rating 10 Score
GECKO:0000052
mhd_honoscarating10_score
mhd_honoscarating10_score
GECKO:0000052
survey administration
HoNOS-CA Rating 11 Score
GECKO:0000052
mhd_honoscarating11_score
mhd_honoscarating11_score
GECKO:0000052
survey administration
HoNOS-CA Rating 12 Score
GECKO:0000052
mhd_honoscarating12_score
mhd_honoscarating12_score
GECKO:0000052
survey administration
HoNOS-CA Rating 13 Score
GECKO:0000052
mhd_honoscarating13_score
mhd_honoscarating13_score
GECKO:0000052
survey administration
HoNOS-CA Rating B14 Score
GECKO:0000052
mhd_honoscarating14_score
mhd_honoscarating14_score
GECKO:0000052
survey administration
HoNOS-CA Rating B15 Score
GECKO:0000052
mhd_honoscarating15_score
mhd_honoscarating15_score
GECKO:0000052
survey administration
HoNOS-CA Rating 2 Score
GECKO:0000052
mhd_honoscarating2_score
mhd_honoscarating2_score
GECKO:0000052
survey administration
HoNOS-CA Rating 3 Score
GECKO:0000052
mhd_honoscarating3_score
mhd_honoscarating3_score
GECKO:0000052
survey administration
HoNOS-CA Rating 4 Score
GECKO:0000052
mhd_honoscarating4_score
mhd_honoscarating4_score
GECKO:0000052
survey administration
HoNOS-CA Rating 5 Score
GECKO:0000052
mhd_honoscarating5_score
mhd_honoscarating5_score
GECKO:0000052
survey administration
HoNOS-CA Rating 6 Score
GECKO:0000052
mhd_honoscarating6_score
mhd_honoscarating6_score
GECKO:0000052
survey administration
HoNOS-CA Rating 7 Score
GECKO:0000052
mhd_honoscarating7_score
mhd_honoscarating7_score
GECKO:0000052
survey administration
HoNOS-CA Rating 8 Score
GECKO:0000052
mhd_honoscarating8_score
mhd_honoscarating8_score
GECKO:0000052
survey administration
HoNOS-CA Rating 9 Score
GECKO:0000052
mhd_honoscarating9_score
mhd_honoscarating9_score
GECKO:0000052
survey administration
HoNOS-SECURE Rating A Score
GECKO:0000052
mhd_honossecureratinga_score
mhd_honossecureratinga_score
GECKO:0000052
survey administration
HoNOS-SECURE Rating B Score
GECKO:0000052
mhd_honossecureratingb_score
mhd_honossecureratingb_score
GECKO:0000052
survey administration
HoNOS-SECURE Rating C Score
GECKO:0000052
mhd_honossecureratingc_score
mhd_honossecureratingc_score
GECKO:0000052
survey administration
HoNOS-SECURE Rating D Score
GECKO:0000052
mhd_honossecureratingd_score
mhd_honossecureratingd_score
GECKO:0000052
survey administration
HoNOS-SECURE Rating E Score
GECKO:0000052
mhd_honossecureratinge_score
mhd_honossecureratinge_score
GECKO:0000052
survey administration
HoNOS-SECURE Rating F Score
GECKO:0000052
mhd_honossecureratingf_score
mhd_honossecureratingf_score
GECKO:0000052
survey administration
HoNOS-SECURE Rating G Score
GECKO:0000052
mhd_honossecureratingg_score
mhd_honossecureratingg_score
GECKO:0000052
survey administration
Intended Clinical Care Intensity Code (Mental Health)
GECKO:0000052
mhd_int_clincare_intensity_code
mhd_int_clincare_intensity_code
GECKO:0000052
survey administration
Main Specialty code (Mental Health)
GECKO:0000052
mhd_intended_agegroup
mhd_intended_agegroup
GECKO:0000052
survey administration
Job Role
GECKO:0000052
mhd_jobrole
mhd_jobrole
GECKO:0000052
survey administration
Local Authority District/Unitary Authority
GECKO:0000052
mhd_lad_ua
mhd_lad_ua
GECKO:0000052
survey administration
Main Specialty code (Mental Health)
GECKO:0000052
mhd_mainspecialty
mhd_mainspecialty
GECKO:0000052
survey administration
Manifest Psychosis Date
STATO:0000093
mhd_manpsych_date
mhd_manpsych_date
STATO:0000093
date and time-related information
Person Marital Status
PATO:0001995
mhd_marital_status
mhd_marital_status
PATO:0001995
socio-demographic and economic characteristics
Mental Health Act 2007 Mental Category following event
GECKO:0000052
mhd_mencat07
mhd_mencat07
GECKO:0000052
survey administration
Mental Health Team Type
GECKO:0000052
mhd_mhc_team_type
mhd_mhc_team_type
GECKO:0000052
survey administration
Indicates that the MHCT record was correctly recorded.
GECKO:0000052
mhd_mhct_flag
mhd_mhct_flag
GECKO:0000052
survey administration
HoNOS Rating 1 Score
GECKO:0000052
mhd_mhct_honosrating1_score
mhd_mhct_honosrating1_score
GECKO:0000052
survey administration
HoNOS Rating 10 Score
GECKO:0000052
mhd_mhct_honosrating10_score
mhd_mhct_honosrating10_score
GECKO:0000052
survey administration
HoNOS Rating 11 Score
GECKO:0000052
mhd_mhct_honosrating11_score
mhd_mhct_honosrating11_score
GECKO:0000052
survey administration
HoNOS Rating 12 Score
GECKO:0000052
mhd_mhct_honosrating12_score
mhd_mhct_honosrating12_score
GECKO:0000052
survey administration
HoNOS Rating 2 Score
GECKO:0000052
mhd_mhct_honosrating2_score
mhd_mhct_honosrating2_score
GECKO:0000052
survey administration
HoNOS Rating 3 Score
GECKO:0000052
mhd_mhct_honosrating3_score
mhd_mhct_honosrating3_score
GECKO:0000052
survey administration
HoNOS Rating 4 Score
GECKO:0000052
mhd_mhct_honosrating4_score
mhd_mhct_honosrating4_score
GECKO:0000052
survey administration
HoNOS Rating 5 Score
GECKO:0000052
mhd_mhct_honosrating5_score
mhd_mhct_honosrating5_score
GECKO:0000052
survey administration
HoNOS Rating 6 Score
GECKO:0000052
mhd_mhct_honosrating6_score
mhd_mhct_honosrating6_score
GECKO:0000052
survey administration
HoNOS Rating 7 Score
GECKO:0000052
mhd_mhct_honosrating7_score
mhd_mhct_honosrating7_score
GECKO:0000052
survey administration
HoNOS Rating 8 Score
GECKO:0000052
mhd_mhct_honosrating8_score
mhd_mhct_honosrating8_score
GECKO:0000052
survey administration
HoNOS Rating 8 Type
GECKO:0000052
mhd_mhct_honosrating8_type
mhd_mhct_honosrating8_type
GECKO:0000052
survey administration
HoNOS Rating 9 Score
GECKO:0000052
mhd_mhct_honosrating9_score
mhd_mhct_honosrating9_score
GECKO:0000052
survey administration
Unique pseudo ID for the service user - can be used across Spells, Providers and Reporting Periods
GECKO:0000055
mhd_mhmds_person_id
mhd_mhmds_person_id
GECKO:0000055
unique identifiers
Unique ID for this Mental Health Care Spell - can be used to link spells across Reporting Periods and is the Primary Key linking to event and episode rows that form part of this spell of care. Unique to the patient and the provider.
GECKO:0000055
mhd_mhmds_spell_id
mhd_mhmds_spell_id
GECKO:0000055
unique identifiers
NHS Occupation Code
GECKO:0000052
mhd_nhs_occupcode
mhd_nhs_occupcode
GECKO:0000052
survey administration
PbR Care Cluster assigned to the patient|PbR Care Cluster
GECKO:0000052
mhd_pbr_cluster
mhd_pbr_cluster
GECKO:0000052
survey administration
PCT of GP Practice
GECKO:0000073
mhd_pct_of_gp_practice
mhd_pct_of_gp_practice
GECKO:0000073
physician/practitioner info
PCT of residence
GECKO:0000064
mhd_pct_of_residence
mhd_pct_of_residence
GECKO:0000064
residence
PHQ-9 Question 1 Score
GECKO:0000052
mhd_phq9_q1_score
mhd_phq9_q1_score
GECKO:0000052
survey administration
PHQ-9 Question 2 Score
GECKO:0000052
mhd_phq9_q2_score
mhd_phq9_q2_score
GECKO:0000052
survey administration
PHQ-9 Question 3 Score
GECKO:0000052
mhd_phq9_q3_score
mhd_phq9_q3_score
GECKO:0000052
survey administration
PHQ-9 Question 4 Score
GECKO:0000052
mhd_phq9_q4_score
mhd_phq9_q4_score
GECKO:0000052
survey administration
PHQ-9 Question 5 Score
GECKO:0000052
mhd_phq9_q5_score
mhd_phq9_q5_score
GECKO:0000052
survey administration
PHQ-9 Question 6 Score
GECKO:0000052
mhd_phq9_q6_score
mhd_phq9_q6_score
GECKO:0000052
survey administration
PHQ-9 Question 7 Score
GECKO:0000052
mhd_phq9_q7_score
mhd_phq9_q7_score
GECKO:0000052
survey administration
PHQ-9 Question 8 Score
GECKO:0000052
mhd_phq9_q8_score
mhd_phq9_q8_score
GECKO:0000052
survey administration
PHQ-9 Question 9 Score
GECKO:0000052
mhd_phq9_q9_score
mhd_phq9_q9_score
GECKO:0000052
survey administration
PHQ-9 Total Score
GECKO:0000052
mhd_phq9_total_score
mhd_phq9_total_score
GECKO:0000052
survey administration
Postcode District
GECKO:0000064
mhd_postcode_district
mhd_postcode_district
GECKO:0000064
residence
Primary Diagnosis
MONDO:0000001
mhd_primarydiagnosis
mhd_primarydiagnosis
MONDO:0000001
diseases
Prodrome Psychosis Date
STATO:0000093
mhd_propsych_date
mhd_propsych_date
STATO:0000093
date and time-related information
Derived on submission from the Provider's Open Exeter account
GECKO:0000052
mhd_provider_org_code
mhd_provider_org_code
GECKO:0000052
survey administration
Emergent Psychosis Date
STATO:0000093
mhd_psychpresc_date
mhd_psychpresc_date
STATO:0000093
date and time-related information
Psychosis Treatment Start Date
STATO:0000093
mhd_psychtreat_start_date
mhd_psychtreat_start_date
STATO:0000093
date and time-related information
Referral Request Status Date
STATO:0000093
mhd_referral_request_status_date
mhd_referral_request_status_date
STATO:0000093
date and time-related information
Referral Request Received Date
STATO:0000093
mhd_refrec_date
mhd_refrec_date
STATO:0000093
date and time-related information
SAC Rating 13 Score
GECKO:0000052
mhd_sacrating13_score
mhd_sacrating13_score
GECKO:0000052
survey administration
SAC Rating A Score
GECKO:0000052
mhd_sacratinga_score
mhd_sacratinga_score
GECKO:0000052
survey administration
SAC Rating B Score
GECKO:0000052
mhd_sacratingb_score
mhd_sacratingb_score
GECKO:0000052
survey administration
OPCS code to identify delivery
GECKO:0000052
opcs_delivery_code
opcs_delivery_code
GECKO:0000052
survey administration
OPCS code to identify procurement
GECKO:0000052
opcs_procurement_code
opcs_procurement_code
GECKO:0000052
survey administration