Patient

A snapshot of the specified elements of the patient record. The patient resource carries limited de-identified demographic information and registration details.

Table 1. Patient

Database Field Name	Field Description	Sensitive Field	Identifiable Field	Field Type	Field Length	Optionality
date_of_birth_deid	Date of birth de-identified	Yes	No	String	an200	M
date_of_death_deid	Date of death de-identified	Yes	No	String	an200	O
ethnic_category	Ethnicity of a person as stated by person	Yes	No	String	min n6 max n18	O
gender	Patient gender record as stated by patient or observation in cases where patient unable to state gender	Yes	No	String	n1	M
id	The unique supplier generated persistent technical key for the registration	Yes	No	String	an36	M
interpreter_required	Whether interpreter required	Yes	No	Boolean	min an4 max an5	O
language_preferred	Preferred language of patient for communication	Yes	No	String	min n6 max n18	O
local_id_deid	Local patient identifier de-identified	Yes	No	String	an200	O
lsoa	The Lower Layer Super Output Area (LSOA) derived from postcode and obtained by lookup of an appropriate mapping resource e.g. https://digital.nhs.uk/services/organisation-data-service/data-downloads/office-for-national-statistics-data	Yes	No	String	an 9	O
named_gp	The patient's named general practitioner	Yes	No	String	an36	O
online_appointment_status	Specifies whether the patient is registered for online appointment booking	Yes	No	Boolean	min an4 max an5	O
online_prescription_status	Specifies whether the patient is registered for online prescription service	Yes	No	Boolean	min an4 max an5	O
online_record_status	Specifies whether the patient is registered for online record access	Yes	No	Boolean	min an4 max an5	O
patient_id_deid	NHS number DE-IDENTIFIED	Yes	No	String	an200	O
postcode_deid	Postcode de-identified	Yes	No	String	an200	O
postcode_sector	Sector of patient postcode derived at source	Yes	No	String	min an3 max an6	O
practice	Reference to the Organisation record for the practice	Yes	No	String	an36	M
recorded_date	The source system audit trail timestamp of when the source record was created, amended or deleted	Yes	No	Timestamp	min an4 max an23	M
registered_date	Start date of registration with practice	Yes	No	Timestamp	min an4 max an23	M
registration_end_date	End date of registration with practice	Yes	No	Timestamp	min an4 max an23	O
registration_status	Status of registration held at practice	Yes	No	Boolean	min an4 max an5	O
registration_type	Type of registration held at practice	Yes	No	String	min an1 max an2	M
sexual_orientation	Person stated sexual orientation as per DCB2094	Yes	No	String	an1	O
source_registration_type	The displayed registration type in the source system	Yes	No	String	min an1 max an32	M
week_of_birth	Derived week and year of patient birth	Yes	No	String	n6	M
week_of_death	Derived week and year of patient death	Yes	No	String	n6	O