Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	varchar	The datetime that the record was ingested, format YYYYMMDDHHMMSS	’20230512143015’
is_deleted	boolean	Indicates if this record should be considered soft deleted. Also set to true when a record transitions to being an allergy or immunisation	FALSE
load_datetime	timestamp(6) with time zone	Formatted ingest time for filtering	’2023-05-12 14:30:15.000000 UTC’
observation_id	bigint	Internal identifier for the observation record, unique within a source database	987654
observation_guid	varchar	The EMIS globally unique identifier for the observation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
observation_uuid	varchar	Deterministic UUID generated from the observation for cross-system referencing	’b2c3d4e5-f6a7-5b6c-0d1e-2f3a4b5c6d7e’
patient_id	bigint	Internal identifier for the patient	12345
patient_guid	varchar	Globally unique identifier for the patient	’c3d4e5f6-a7b8-6c7d-1e2f-3a4b5c6d7e8f’
patient_organisation_guid	varchar	GUID of the organisation where the patient is registered	’c9d0e1f2-a3b4-2c5d-7e8f-9a0b1c2d3e4f’
consultation_id	bigint	Internal identifier of the consultation in which the observation was recorded	55678
consultation_guid	varchar	EMIS globally unique identifier of the consultation	’d4e5f6a7-b8c9-7d0e-2f3a-4b5c6d7e8f9a’
consultation_uuid	varchar	Deterministic UUID for the consultation	’e5f6a7b8-c9d0-8e1f-3a4b-5c6d7e8f9a0b’
consultation_source_code_id	bigint	Identifier of the code describing the consultation source (e.g. GP Surgery, Telephone)	2002
consultation_source_original_term	varchar	Original term for the consultation source code	’GP Surgery’
problem_observation_id	bigint	Internal identifier of the parent problem observation linked to this observation	33211
problem_observation_guid	varchar	EMIS GUID of the parent problem observation	’f6a7b8c9-d0e1-9f2a-4b5c-6d7e8f9a0b1c’
problem_observation_uuid	varchar	Deterministic UUID of the parent problem observation	’a7b8c9d0-e1f2-0a3b-5c6d-7e8f9a0b1c2d’
parent_observation_id	bigint	Internal identifier of the parent observation	22100
parent_observation_guid	varchar	EMIS GUID of the parent observation	’b1c2d3e4-f5a6-4b5c-8d9e-0f1a2b3c4d5e’
parent_observation_uuid	varchar	Deterministic UUID of the parent observation	’c2d3e4f5-a6b7-5c6d-9e0f-1a2b3c4d5e6f’
authorising_user_in_role_id	bigint	Identifier of the clinician who authorised or authored the observation record	11223
entered_by_user_in_role_id	bigint	Identifier of the user who entered the observation record	33445
organisation_id	bigint	Internal identifier of the organisation where the observation was recorded	54321
observation_organisation_guid	varchar	GUID of the organisation where the observation was recorded	’b8c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
code_id	bigint	Internal identifier for the clinical code associated with the observation	1001
original_term	varchar	The original clinical term used to record the observation	’Type 2 diabetes mellitus’
associated_text	varchar	Free text associated with the observation	’Patient reviewed and stable’
observation_type_id	bigint	Numeric identifier for the observation type	5
observation_type_description	varchar	Description of the observation type (e.g. OBS, TR, INV, VAL, FH)	‘VAL’
numeric_operator	varchar	Operator for numeric value comparison (e.g. =, >, <)	’=‘
numeric_value	double	Numeric measurement value associated with the observation	7.4
numeric_unit	varchar	Unit for the numeric measurement value	’mmol/L’
unit_of_measure	varchar	Description of the unit of measure	’millimoles per litre’
ucum_code	varchar	Unified Code for Units of Measure (UCUM) code for the measurement unit	’mmol/L’
range_minimum_operator	varchar	Comparison operator for the minimum range value	’>=‘
range_minimum	double	Minimum value of the reference range	4.0
range_minimum_text	varchar	Text representation of the minimum range value	’4.0’
range_maximum_operator	varchar	Comparison operator for the maximum range value	’<=‘
range_maximum	double	Maximum value of the reference range	10.0
range_maximum_text	varchar	Text representation of the maximum range value	’10.0’
range_units	varchar	Units used for the reference range	’mmol/L’
range_qualifier_description	varchar	Description of the range qualifier (e.g. Normal, High, Low)	‘Normal’
qualifiers	varchar	Raw XML qualifier data associated with the observation	’<qualifiers>…</qualifiers>‘
qualifier_mapping	map(varchar, array(varchar))	Parsed qualifier key-value mapping from the qualifiers field, providing structured access to observation-specific data	{‘dose’: [‘5mg’]}
family_member_qualifier_mapping	map(varchar, array(varchar))	Qualifier mapping for family history observations	{‘relation’: [‘Father’]}
is_abnormal	boolean	Indicates whether the observation value is outside the normal reference range	FALSE
abnormal_reason	varchar	Description of why the observation is considered abnormal	’Above upper limit’
episodicity	bigint	Numeric code representing the episodicity of the observation	1
episodicity_description	varchar	Description of the episodicity (e.g. first, new, review, flare up, end)	‘first’
is_parent	boolean	Indicates whether this observation is a parent (template header) observation	FALSE
problem_end_datetime	timestamp(6) with time zone	The date and time the linked problem ended, if applicable	NULL
effective_datetime	timestamp(6) with time zone	The clinical date and time when the observation was recorded	’2023-09-01 10:00:00.000000 UTC’
effective_datetime_precision	varchar	Precision of the effective datetime (e.g. YMDT, YMD, YM, Y)	‘YMDT’
availability_datetime	timestamp(6) with time zone	The date and time the record was made available (corresponds to recorded date in flavours)	‘2023-09-01 10:30:00.000000 UTC’
is_sensitive	boolean	Indicates whether the observation record is flagged as sensitive	FALSE
was_sensitive	boolean	Indicates whether the observation was previously flagged as sensitive	FALSE
is_confidential	boolean	Indicates whether the observation record is confidential	FALSE
was_confidential	boolean	Indicates whether the observation was previously confidential	FALSE
is_problem	boolean	Indicates whether this observation is also recorded as a problem	FALSE
is_referral	boolean	Indicates whether this observation is also a referral	FALSE
is_allergy	boolean	Indicates whether this observation is also an allergy	FALSE
was_allergy	boolean	Indicates whether this observation was previously an allergy	FALSE
is_immunisation	boolean	Indicates whether this observation is also an immunisation	FALSE
was_immunisation	boolean	Indicates whether this observation was previously an immunisation	FALSE
organisation	varchar	An identifier for the source of data (an organisation) relating to a given GP practice	’CDB-12345’
transform_datetime	timestamp(6) with time zone	The datetime the data was made available in the model with a relevant change	’2023-09-01 10:30:15.000000 UTC’
_execution_date	varchar	Formatted transform datetime for versioning	’20230901103015’

Vanilla

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
load_datetime	timestamp(6) with time zone	✗	✓
emis_observation_id	bigint	✓	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
consultation_source_emis_original_term	varchar	✓	✓
associatedtext	varchar	✓	✓
comparator	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_episodicity	bigint	✓	✓
emis_episodicity_description	varchar(8)	✓	✓
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_interpretation_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
observation_type	varchar	✓	✓
emis_observationtypeid	bigint	✓	✓
emis_original_term	varchar	✓	✓
numeric_operator	varchar	✗	✓
unit_of_measure	varchar	✗	✓
uom	varchar	✓	✓
uom_ucum	varchar	✓	✓
numericvalue	decimal(19,3)	✓	✓
qualifier_mapping	map(varchar, array(varchar))	✗	✓
qualifiers	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum_text	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_upper	decimal(19,3)	✓	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
value_pq_2	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
user_selected	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
is_parent_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
abnormal	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
other_code	varchar	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Apollo

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
load_datetime	timestamp(6) with time zone	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✗	✓
exa_parent_observation_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
problem_observation_guid	varchar	✗	✓
problem_observation_uuid	varchar	✗	✓
patient_id	bigint	✗	✓
registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
observation_organisation_guid	varchar	✗	✓
patient_organisation_guid	varchar	✗	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_code_id	bigint	✓	✓
effective_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
numericvalue	decimal(19,3)	✓	✓
comparator	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
uom	varchar	✓	✓
uom_ucum	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_upper	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
snomed_concept_id	bigint	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Artemis

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
load_datetime	timestamp(6) with time zone	✗	✓
emis_observation_id	bigint	✓	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
emis_observationtypeid	bigint	✓	✓
observationtype	varchar	✓	✓
parent_observation_id	bigint	✗	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
problem_observation_guid	varchar	✗	✓
problem_observation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_emis_original_term	varchar	✓	✓
emis_code_id	bigint	✓	✓
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
emis_episodicity	bigint	✓	✓
emis_original_term	varchar	✓	✓
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_interpretation_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
abnormal	boolean	✓	✓
numericvalue	decimal(19,3)	✓	✓
comparator	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
qualifiers	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_upper	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
uom	varchar	✓	✓
uom_ucum	varchar	✓	✓
user_selected	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
value_pq_2	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
is_parent_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
snomed_description_id	bigint	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
readv2_code	varchar	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Hestia

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
load_datetime	timestamp(6) with time zone	✗	✓
emis_observation_id	bigint	✓	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
problem_observation_guid	varchar	✗	✓
problem_observation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_emis_original_term	varchar	✓	✓
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
emis_episodicity	bigint	✓	✓
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_interpretation_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
hestia_event_type	varchar(3)	✓	✓
observation_type	varchar	✓	✓
numericvalue	decimal(19,3)	✓	✓
comparator	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
uom	varchar	✓	✓
uom_ucum	varchar	✓	✓
abnormal	boolean	✓	✓
qualifiers	varchar	✓	✓
associated_text	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_upper	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
regular_patient_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
confidential_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
snomed_description_id	bigint	✓	✗
sensitive_patient_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Olympus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
emis_parent_observation_guid	varchar	✓	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
observation_organisation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓
exa_consultation_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
pseudo_registration_guid	varchar	✓	✓
observation_organisation_guid	varchar	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
emis_original_term	varchar	✓	✓
numericvalue	decimal(19,3)	✓	✓
uom	varchar	✓	✓
observation_type	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_upper	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
confidential_flag	boolean	✓	✓
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Prometheus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
emis_parent_observation_guid	varchar	✓	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
observation_organisation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓
exa_consultation_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
pseudo_registration_guid	varchar	✓	✓
observation_organisation_guid	varchar	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
emis_original_term	varchar	✗	✓
observation_type	varchar	✓	✓
numericvalue	decimal(19,3)	✓	✓
uom	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_upper	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
confidential_flag	boolean	✓	✓
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	execution_date	✓	Exists in v1 with a different name

Pseudo_Anon

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
observation_id	bigint	✗	✓
observation_guid	varchar	✓	✓
id_type5	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✓	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
consultation_guid	varchar	✓	✓
consultation_uuid	varchar	✗	✓
problem_observation_id	bigint	✗	✓
problem_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
patient_id	bigint	✗	✓
patient_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
observation_organisation_guid	varchar	✗	✓
organisation_guid	varchar	✓	✓
code_id	bigint	✓	✓
clinician_user_in_role_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
observation_type	varchar	✓	✓
value	decimal(19,3)	✓	✓
numeric_unit	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
numeric_range_low	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
numeric_range_high	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
is_confidential	boolean	✓	✓
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	execution_date	✓	Exists in v1 with a different name

Themis

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
load_datetime	timestamp(6) with time zone	✗	✓
emis_observation_id	bigint	✓	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
consultation_source_emis_code_id	bigint	✓	✓
emis_code_id	bigint	✓	✓
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
consultation_source_emis_original_term	varchar	✓	✓
emis_original_term	varchar	✓	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
associatedtext	varchar	✓	✓
observation_type	varchar	✓	✓
emis_observationtypeid	bigint	✓	✓
emis_episodicity	bigint	✓	✓
emis_episodicity_description	varchar(8)	✓	✓
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_interpretation_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
uom	varchar	✓	✓
uom_ucum	varchar	✓	✓
comparator	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
numericvalue	decimal(19,3)	✓	✓
qualifiers	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_upper	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
user_selected	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
value_pq_2	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
is_parent_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
abnormal	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
regular_and_current_active_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
other_code	varchar	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
other_display	varchar	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Zeus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
load_datetime	timestamp(6) with time zone	✗	✓
emis_observation_id	bigint	✓	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
pseudo_registration_guid_ourea	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
document_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
consultation_source_emis_original_term	varchar	✓	✓
emis_original_term	varchar	✓	✓
associatedtext	varchar	✓	✓
observation_type	varchar	✓	✓
emis_observationtypeid	bigint	✓	✓
emis_episodicity	bigint	✓	✓
emis_episodicity_description	varchar(8)	✓	✓
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_interpretation_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
comparator	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
numericvalue	decimal(19,3)	✓	✓
uom	varchar	✓	✓
uom_ucum	varchar	✓	✓
qualifiers	varchar	✓	✓
range_minimum_operator	varchar	✗	✓
range_lower	decimal(19,3)	✓	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_upper	decimal(19,3)	✓	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
value_pq_2	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
user_selected	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
is_parent_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
abnormal	boolean	✓	✓
data_filter	bigint	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
registration_guid	varchar	✓	✗
snomed_description_id	bigint	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
readv2_code	varchar	✓	✗
emis_patient_id	bigint	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
sensitive_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
confidential_patient_flag	boolean	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓