| observation_id | varbinary | Unique identifier for the observation record |
| organisation | varchar | An identifier for the source of data (an organisation) relating to a given GP practice |
| is_deleted | boolean | If this record should be considered soft deleted |
| transform_datetime | timestamp(6) with time zone | The date that the data was made available in the model with a relevant change |
| model_updated_datetime | timestamp(6) with time zone | The date that the model record was last updated in the source system |
| problem_is_deleted | boolean | Indicates whether the linked problem observation is soft deleted |
| effective_datetime | timestamp(6) with time zone | The clinically effective date and time of the observation |
| patient_id | varbinary | Unique identifier for the patient associated with this observation |
| code_id | bigint | Identifier for the clinical code associated with this observation |
| consultation_source_code_id | bigint | Identifier for the consultation source code |
| snomed_concept_id | bigint | SNOMED CT concept identifier for the coded observation |
| numeric_operator | varchar | Operator used with the numeric value (for example =, <, >) |
| numeric_value | decimal(18,6) | Numeric value recorded for the observation |
| numeric_unit | varchar | Unit text associated with the numeric value |
| ucum_code | varchar | UCUM code for the observation unit, where available |
| unit_of_measure | varchar | Unit of measure associated with the recorded value |
| range_minimum_operator | varchar | Operator associated with the lower bound of a range value |
| range_minimum | decimal(18,6) | Lower bound numeric value where a range is recorded |
| range_minimum_text | varchar | Text representation of the lower bound, where provided |
| range_maximum_operator | varchar | Operator associated with the upper bound of a range value |
| range_maximum | decimal(18,6) | Upper bound numeric value where a range is recorded |
| range_maximum_text | varchar | Text representation of the upper bound, where provided |
| range_units | varchar | Units associated with the recorded range |
| range_qualifier_description | varchar | Description qualifying the meaning of the recorded range |
| episodicity | bigint | Episodicity identifier/classification value for the observation |
| episodicity_description | varchar | Description of episodicity classification |
| consultation_section_id | varbinary | Identifier of the consultation section linked to this observation, if applicable |
| consultation_id | varbinary | Identifier of the consultation linked to this observation, if applicable |
| observation_type_id | bigint | Identifier for the observation type classification |
| observation_type_description | varchar | Description of the observation type classification |
| is_parent | boolean | Indicates whether this observation is a parent observation |
| parent_observation_id | varbinary | Identifier of the parent observation, if this record is a child |
| problem_observation_id | varbinary | Identifier of the linked problem observation, where applicable |
| problem_end_datetime | timestamp(6) with time zone | Date and time the linked problem observation ended, where applicable |
| is_problem | boolean | Indicates whether this observation represents a problem |
| is_referral | boolean | Indicates whether this observation represents a referral |
