Schema

Schema Overview

Column Name	Data Type	Description	Example
age	integer	Patient age in years	43
date_of_birth	timestamp(6)	Patient date of birth, rounded to the first of the month	2023-05-01 00:00:00.000000 UTC
date_of_death	timestamp(6)	Patient date of death	2023-05-12 00:00:00.000000 UTC
ethnicity_code_id	bigint	EMIS code ID of ethnicity code	3
has_carer	boolean	Indicates whether the patient has a carer	true
has_died	boolean	Indicates if the patient has died	false
imd_rounded	double	Rounded index of multiple deprivation	21100
index_of_multiple_deprivation_decile	bigint	Indicates the official measure of relative deprivation in the UK	5
is_active	boolean	Indicates if the patient record is active	true
is_consent_93c1	boolean	Indicates whether a patient has consented for data sharing; FALSE = Patient HAS a type 1 opt-out, TRUE/NULL = Patient DOES NOT have a type 1 opt-out	true
is_deleted	boolean	If this record should be considered soft deleted; all columns excluding primary keys will be NULL if TRUE; in GP England practices patient records will not be deleted but it is theoretically possible	false
is_national_data_opted_in	boolean	Indicates if the patient opted in to national data sharing; FALSE = Patient is OPTED OUT, TRUE/NULL = Patient is OPTED IN	true
middle_level_super_output_area	varchar	Patient middle super output area (MSOA)	E02000001
model_updated_datetime	timestamp(6)	Date and time the model last updated this record	2023-05-12 14:30:15.000000 UTC
nhs_number	varbinary	Pseudonymised National Health Service number	F422B34E0AC397B6 [16]
organisation	varchar	The organisation that this data was replicated from	CDB-12345
patient_id	varbinary	Unique patient identifier	F422B34E0AC397B6 [16]
preferred_language_code_id	bigint	EMIS code ID of preferred language code	1
registration_end_datetime	timestamp(6)	Date and time the patient registration ended with the practice	2023-05-12 14:30:15.000000 UTC
registration_start_datetime	timestamp(6)	Date and time the patient registered with the practice	2023-05-12 14:30:15.000000 UTC
residential_institute_code	varchar	Provides both current and legacy residential institute codes	RI001
sex	varchar	Patient sex	Male
sexual_orientation_code_id	bigint	EMIS code ID of sexual orientation code	2
transform_datetime	timestamp(6)	Date and time the data was made available in the model with a relevant change	2023-05-12 14:30:15.000000 UTC