Schema

Schema Overview

Column Name	Data Type	Description	Example
code_id	bigint	EMIS code ID - internal identifier	348898019
consultation_id	varbinary	Unique identifier for the linked consultation for this observation entry or its parent if it is a child entry	F422B34E0AC397B6 [16]
consultation_section_id	varbinary	Unique identifier for the linked consultation section for this observation entry	F422B34E0AC397B6 [16]
consultation_source_code_id	bigint	EMIS code ID representing the consultation purpose; used for categorisation	1672871000006114
effective_datetime	timestamp(6) with time zone	Date and time when the observation became clinically effective	2023-05-12 14:30:15.000000 UTC
episodicity	bigint	Episodicity identifier/classification value for the observation	1
episodicity_description	varchar	Description of episodicity classification (‘first’, ‘new’, ‘review’, ‘flare up’ or ‘end’)	first
is_deleted	boolean	If this record should be considered soft deleted; all columns excluding primary keys will be NULL if TRUE	false
is_parent	boolean	Indicates whether this observation is a parent observation	true
is_problem	boolean	Indicates whether this observation represents a problem	true
is_referral	boolean	Indicates whether this observation represents a referral	false
model_updated_datetime	timestamp(6) with time zone	Date and time the model last updated this record	2023-05-12 14:30:15.000000 UTC
numeric_operator	varchar	Operator used with the numeric value (e.g. =, <, >, etc.)	>
numeric_unit	varchar	Unit text associated with the numeric value	kg
numeric_value	decimal(19,3)	Numeric value recorded for the observation	80
observation_id	varbinary	Unique identifier for the observation record	F422B34E0AC397B6 [16]
observation_type_description	varchar	Description of the observation type classification (e.g. ‘Test Request’, ‘Investigation’, etc.)	Value
observation_type_id	bigint	Identifier for the observation type classification	5
organisation	varchar	The organisation that this data was replicated from	CDB-12345
parent_observation_id	varbinary	Identifier of the parent observation, if this record is a child	F422B34E0AC397B6 [16]
patient_id	varbinary	Unique patient identifier	F422B34E0AC397B6 [16]
problem_end_datetime	timestamp(6) with time zone	Date and time the linked problem observation ended, where applicable	2023-05-12 14:30:15.000000 UTC
problem_is_deleted	boolean	Indicates whether the linked problem observation is soft deleted	false
problem_observation_id	varbinary	Unique identifier for the linked problem observation, where applicable	F422B34E0AC397B6 [16]
range_maximum	decimal(19,3)	Upper bound numeric value where a range is recorded	80000
range_maximum_operator	varchar	Operator associated with the upper bound of a range value	<
range_maximum_text	varchar	Text representation of the upper bound, where provided	80000
range_minimum	decimal(19,3)	Lower bound numeric value where a range is recorded	1000
range_minimum_operator	varchar	Operator associated with the lower bound of a range value	>=
range_minimum_text	varchar	Text representation of the lower bound, where provided	1000
range_qualifier_description	varchar	Description qualifying the meaning of the recorded range (‘Unqualified’, ‘Therapeutic Interval’, ‘Toxic Interval’ or ‘Recommended Interval’)	Toxic Interval
range_units	varchar	Units associated with the recorded range	umol/L
snomed_concept_id	bigint	SNOMED CT concept identifier	123456789
transform_datetime	timestamp(6) with time zone	Date and time the data was made available in the model with a relevant change	2023-05-12 14:30:15.000000 UTC
ucum_code	varchar	UCUM code for the observation unit, where available	[iU]/mL
unit_of_measure	varchar	Unit of measure associated with the recorded value	iu/ml