Schema

Patient Schema

Field	Type	Description
patient_id	varbinary	Unique identifier for the patient
nhs_number	varbinary	National Health Service number
date_of_birth	varchar	Date of birth of the patient
date_of_death	varchar	Date of death of the patient
sex	varchar	Sex of the patient
age	bigint	Age of the patient
has_carer	boolean	Indicates if the patient has a carer
middle_level_super_output_area	varchar	Middle level super output area
lower_level_super_output_area	varchar	Lower level super output area
imd_rounded	decimal(31,0)	Rounded index of multiple deprivation
index_of_multiple_deprivation_decile	bigint	Index of multiple deprivation decile
residential_institute_code	varchar	Residential institute code
registration_start_datetime	timestamp(6) with time zone	Registration start date and time
registration_end_datetime	timestamp(6) with time zone	Registration end date and time
preferred_language_code_id	bigint	Preferred language code identifier
sexual_orientation_code_id	bigint	Sexual orientation code identifier
ethnicity_code_id	bigint	Ethnicity code identifier
is_active	boolean	Indicates if the patient is active
has_died	boolean	Indicates if the patient has died
is_consent_93c1	boolean	Indicates if the patient has given consent under section 93c1
is_national_data_opted_in	boolean	Indicates if the patient has opted in to national data sharing
organisation	varchar	Organisation associated with the patient
transform_datetime	timestamp(6) with time zone	Transformation date and time
model_updated_datetime	timestamp(6) with time zone	Model updated date and time