Schema

Column Name	Data Type	Description
unique_patient_id	varchar	A globally unique patient identifier.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
is_deleted	boolean	Whether this record should be considered deleted. Data deleted at source has non-key columns set to null while primary keys are retained.
patient_id	integer	Unique patient identifier.
pharmacy_id	integer	Id of the pharmacy.
patient_full_name	varchar	Patient full name. E.g. “COLE, Molly Gary (Mr)”, “COLON, Lucas Shari (Dr)”, “DELGADO, Nick Shanda (Ms)“.
sex	varchar	Patient gender.
ethnicity	varchar	Patient ethnicity.
last_activity_date_time	timestamp	The latest activity date and time for the patient.
last_dispensing_date	date	Date the patient had their last pharmacy item dispensed on, if applicable, otherwise null.
birth_date	date	The date the patient was born.
death_date	date	The date the patient died.
is_deceased	boolean	Whether or not the patient has died.
added_date_time	timestamp	The date and time the patient was added.
exemption_code	varchar	Either a single digit code representing the type of exemption or “Not Exempt”.
is_active	boolean	Whether or not the patient has had any dispensing activity in the last 1 year by checking last_dispensing_date. They will automatically be considered inactive if they are deceased.
is_new	boolean	Whether or not the patient has been registered in the last 6 months.
patient_age	integer	The difference between the date of birth and either the date of death or the last modelled date.
patient_age_bucket	varchar	The patient age grouped into named buckets, for example “Newborns (0 days to 30 days)”, “Children (2 years to 12 years)”, “Older adults (65 to 78)“.
patient_nhs_number	varchar	NHS number. 10-digit number, like 3347775786 or 334-777-5786.
patient_nhs_number_hashed	varchar	Hashed value of the patient NHS number.
eps_registration_status_id	integer	Integer identifier for EPS registration status.
eps_registration_status	varchar	EPS registration status (like ‘Not Registered’, ‘Registration Pending’).
additional_service_type	varchar	How the patient receives their products (Collection, Delivery, Collection & Delivery, Walk-in).
is_collection	boolean	Whether or not the additional service type is collection.
is_delivery	boolean	Whether or not the additional service type is delivery.
is_pmr_locked	boolean	Whether or not this patient has had the PMR lock applied to it or not. This lock prevents dispensing.
pharmacy_name	varchar	The name of the pharmacy.
branch_identifier	varchar	Branch identifier assigned by head office for data exchange workflows.
national_practice_code	varchar	Pharmacy NacsCode used to identify the pharmacy when the user logs in.
imd_decile	integer	Index of Multiple Deprivation decile of the patient.
email	varchar	Patient email contact address.
home_phone_number	varchar	Patient home phone number.
mobile_phone_number	varchar	Patient mobile phone number.
work_phone_number	varchar	Patient work phone number.
fax_number	varchar	Patient fax number.
row_id	varchar	Unique hash generated based on column values, used to identify data changes.
last_updated_date	date	Date that this record was last updated by the orchestration process.