Schema

Schema Overview

Column	Data Type	Description
emis_consultation_id	bigint	Composite primary key when combined with organisation in iPCV models. Not unique across organisations.
emis_patient_id	bigint	Patient identifier hashed by concatenating patient ID with organisation.
location_type_emis_code_id	bigint	EMIS code ID linking the location type back to the MKB database.
consultation_source_emis_code_id	bigint	Code representing the consultation purpose; used for categorisation (e.g., 1572871000006117 – Long Term Conditions Management).
recorded_date	timestamp(6) with time zone	Date and time when the entry was made in EMIS Web.
effective_date	timestamp(6) with time zone	Date and time when the consultation came into effect.
complete	boolean	Indicates whether the consultation is complete.
has_sections_flag	boolean	Indicates whether the consultation has linked sections in the consultation_section model.
model_last_update	timestamp(6) with time zone	Timestamp indicating when the model last updated this record (data type to be confirmed).
is_deleted	boolean	Soft-delete flag; include in queries to exclude deleted records.
transform_datetime	timestamp(6) with time zone	Datetime when the data was made available in the model due to an entry or relevant change.
organisation	varchar	Organisation identifier required for Ranger to apply DSA.