Schema

Schema Overview

Column	Data Type	Description
consultation_section_id	bigint	Pseudo-identifier generated via generate_pseudo_id using the section identifier and organisation to create a single primary key column.
consultation_section_original_heading	varchar	Original section heading text; human-readable description associated with the heading code identifier.
event_id	bigint	Pseudo-identifier generated via generate_pseudo_id using the event identifier and organisation; links to observation, recall, or issue_record models.
consultation_id	bigint	Pseudo-identifier generated via generate_pseudo_id using the consultation identifier and organisation; foreign key referencing the consultation model.
consultation_section_category_code	varchar	Section category code produced in the serving layer via @section_category_code(consultation_section_category_id) to align with the iPCV v2 serving layer.
emis_patient_id	bigint	Patient identifier hashed by concatenating patient ID with organisation.
consultation_source_emis_code_id	bigint	Code representing the purpose for the consultation; used for categorisation (e.g., 1572871000006117 – Long Term Conditions Management).
recorded_date	timestamp(6) with time zone	Date and time when the entry for this consultation section was made in EMIS Web.
effective_date	timestamp(6) with time zone	Date and time when the consultation section came into effect.
complete	boolean	Indicates whether this consultation section is complete.
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.