Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Ingest timestamp	’20240603101655’
pseudo_registration_guid	varchar	Hashed registration identifier	’a1b2c3d4-e5f6-7890-abcd-ef1234567890’
pseudo_patient_id	varchar	Hashed patient identifier	’f47ac10b-58cc-4372-a567-0e02b2c3d479’
emis_registration_organisation_guid	varchar	Organisation identifier	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
emis_usualgp_userinrole_guid	varchar	Usual GP user-in-role identifier	’c3d4e5f6-a7b8-9012-cdef-123456789012’
gender	varchar(1)	Patient gender (M / F / I / U)	‘F’
ethnic_category_snomed_concept_id	bigint	Ethnicity SNOMED concept identifier	186019001
ethnicity_emis_code_id	bigint	EMIS ethnicity code identifier	7334778019
date_of_birth	varchar	Year and month of birth (YYYY-MM)	‘1985-06’
date_of_death	date	Date of death where recorded	’2025-01-01’
registration_date	date	Date of registration	’2010-03-15’
pseudo_nhs_no	varchar	Hashed NHS number	’d0e1f2a3-b4c5-6789-0123-def012345678’
emis_no	bigint	EMIS patient number	12345
emis_registration_type_description	varchar	Registration type	’GMS’
dummy_patient_flag	boolean	Indicates a dummy/test patient	false
postcode	varchar	Postcode - shortened to outward code for anon	’AB12’
residential_institute_code	boolean	Whether a residential institute code is present	false
nhs_number_status	varchar	NHS number status	’Verified’
pseudo_person_guid	varchar	Hashed person GUID	’f2a3b4c5-d6e7-8901-2345-67890abcdef0’
legacy_pseudo_person_guid	varchar	Hashed legacy person GUID	’f2a3b4c5-d6e7-8901-2345-67890abcdef0’
registration_end_date	date	Date registration ended	’2026-01-01’
imd_decile	bigint	Index of Multiple Deprivation decile	3
sensitive_patient_flag	boolean	Sensitivity indicator	false
confidential_patient_flag	boolean	Confidentiality indicator	false
email_flag	boolean	Whether an email address is present	false
mobile_number_flag	boolean	Whether a mobile number is present	false
home_phone_number_flag	boolean	Whether a home phone number is present	false
carer_name_flag	boolean	Whether a carer name is present	false
carer_relation_flag	boolean	Whether a carer relation is present	false
external_usualgp_guid	varchar	External usual GP GUID	’d4e5f6a7-b8c9-0123-4567-890abcdef012’
_execution_date	varchar(14)	Extract execution date	’20260521042151’
organisation	varchar	Organisation identifier	’CDB-0001’
study_id	varchar	Study identifier from included patients view	’study-12345’