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 away from being an 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 immunisation 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’
consultation_id	bigint	Internal identifier of the consultation in which the immunisation 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’
problem_observation_id	bigint	Internal identifier of the parent problem observation linked to this immunisation	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 immunisation record	11223
entered_by_user_in_role_id	bigint	Identifier of the user who entered the immunisation record	33445
organisation_id	bigint	Internal identifier of the organisation where the immunisation was recorded	54321
observation_organisation_guid	varchar	GUID of the organisation where the observation was recorded	’b8c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
patient_organisation_guid	varchar	GUID of the organisation where the patient is registered	’c9d0e1f2-a3b4-2c5d-7e8f-9a0b1c2d3e4f’
code_id	bigint	Internal identifier for the clinical code associated with the immunisation	1001
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’
original_term	varchar	The original clinical term used to record the immunisation	’Influenza vaccination’
associated_text	varchar	Free text associated with the immunisation observation	’Patient tolerated well’
batch_number	varchar	The batch or lot number of the vaccine administered	’BN12345A’
manufacturer	varchar	The manufacturer of the vaccine	’Pfizer’
expiry_date	date	The expiry date of the vaccine batch	’2024-12-31’
injection_site	varchar	The anatomical site where the vaccine was administered	’Left deltoid’
gms	boolean	General Medical Services indicator flag	TRUE
qualifiers	varchar	Raw XML-like qualifier data associated with the immunisation observation	’<qualifiers>…</qualifiers>‘
qualifier_mapping	map(varchar, array(varchar))	Parsed qualifier key-value mapping from the qualifiers field, providing structured access to immunisation-specific data	{‘batch’: [‘BN12345A’]}
numeric_unit	varchar	Unit for the numeric measurement value	’mg’
unit_of_measure	varchar	Description of the unit of measure	’milligrams’
numeric_operator	varchar	Operator for numeric value comparison (e.g. =, >, <)	’=‘
numeric_value	double	Numeric measurement value associated with the observation	0.5
ucum_code	varchar	Unified Code for Units of Measure (UCUM) code for the measurement unit	’mg’
range_minimum_operator	varchar	Comparison operator for the minimum range value	’>=‘
range_minimum	double	Minimum value of the reference range	0.0
range_minimum_text	varchar	Text representation of the minimum range value	’0.0’
range_maximum_operator	varchar	Comparison operator for the maximum range value	’<=‘
range_maximum	double	Maximum value of the reference range	1.0
range_maximum_text	varchar	Text representation of the maximum range value	’1.0’
range_units	varchar	Units used for the reference range	’mg’
range_qualifier_description	varchar	Description of the range qualifier (e.g. Normal, High, Low)	‘Normal’
is_abnormal	boolean	Indicates whether the observation value is outside the normal reference range	FALSE
effective_datetime	timestamp(6) with time zone	The clinical date and time when the immunisation was administered	’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’
problem_end_datetime	timestamp(6) with time zone	The date and time the immunisation problem ended, if applicable	NULL
episodicity	bigint	Numeric code representing the episodicity of the observation	1
episodicity_description	varchar	Description of the episodicity (e.g. First, New, Review)	‘First’
is_parent	boolean	Indicates whether this observation is a parent (template header) observation	FALSE
is_sensitive	boolean	Indicates whether the immunisation record is flagged as sensitive	FALSE
is_confidential	boolean	Indicates whether the immunisation record is confidential	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	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✗	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
problem_observation_guid	varchar	✗	✓
problem_observation_uuid	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	✓	✓
entered_by_user_in_role_id	bigint	✗	✓
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorising_user_in_role_id	bigint	✗	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
batch_number	array(varchar)	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
problem_end_datetime	timestamp(6) with time zone	✗	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
expiry_date	array(varchar)	✓	✓
gms	array(varchar)	✓	✓
injection_site	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
consultation_source_original_term	varchar	✗	✓
emis_original_term	varchar	✓	✓
associated_text	varchar	✗	✓
qualifiers	varchar	✓	✓
uom	varchar	✓	✓
uom_dmd	varchar	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
ucum_code	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	decimal(19,3)	✗	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
qualifier_mapping	map(varchar, array(varchar))	✗	✓
is_abnormal	boolean	✗	✓
episodicity	bigint	✗	✓
episodicity_description	varchar(8)	✗	✓
is_parent	boolean	✗	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
sensitive_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
other_display	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
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	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
other_code	varchar	✓	✗
dummy_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
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	✗	✓
parent_observation_uuid	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	✓	✓
batch_number	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
expiry_date	array(varchar)	✓	✓
injection_site	array(varchar)	✓	✓
gms	array(varchar)	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	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	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✗	✓
parent_observation_uuid	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	✓	✓
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	✗	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
emis_original_term	varchar	✓	✓
batch_number	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
expiry_date	array(varchar)	✓	✓
gms	array(varchar)	✓	✓
injection_site	array(varchar)	✓	✓
qualifiers	varchar	✓	✓
uom	varchar	✓	✓
uom_dmd	varchar	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	decimal(19,3)	✗	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
readv2_code	varchar	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
sensitive_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_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	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✗	✓
parent_observation_uuid	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	✓	✓
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	✗	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
emis_original_term	varchar	✓	✓
batch_number	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
expiry_date	array(varchar)	✓	✓
gms	array(varchar)	✓	✓
injection_site	array(varchar)	✓	✓
qualifiers	varchar	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	decimal(19,3)	✗	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
other_code	varchar	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
snomed_description_id	bigint	✓	✗
readv2_code	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
confidential_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
other_code_system	varchar	✓	✗
sensitive_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
other_display	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	✗	✓
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	✗	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓
exa_consultation_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
problem_observation_guid	varchar	✗	✓
problem_observation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
pseudo_registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
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	✗	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
emis_original_term	varchar	✓	✓
batch_number	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
expiry_date	array(varchar)	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	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.
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
other_code	varchar	✓	✗
readv2_code	varchar	✓	✗
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓
_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	✗	✓
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	✗	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓
exa_consultation_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
problem_observation_guid	varchar	✗	✓
problem_observation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
pseudo_registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
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.
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	✓	✓
emis_original_term	varchar	✓	✓
batch_number	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
expiry_date	array(varchar)	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	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.
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
other_code	varchar	✓	✗
readv2_code	varchar	✓	✗
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	✗	✓
load_datetime	timestamp(6) with time zone	✗	✓
observation_id	bigint	✗	✓
id_type5	varchar	✓	✓
id	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✗	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
batch_number	varchar	✓	✓
manufacturer	varchar	✓	✓
expiry_date	date	✓	✓
snomed_concept_id	varchar	✓	✗
snomed_description_id	varchar	✓	✗
code_id	bigint	✓	✓
patient_guid	varchar	✓	✓
recorded_date	varchar	✓	✓
effective_date	varchar	✓	✓
practitioner_id	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.
consultation_guid	varchar	✓	✓
consultation_uuid	varchar	✗	✓
problem_observation_id	bigint	✗	✓
problem_observation_guid	varchar	✗	✓
problem_observation_uuid	varchar	✗	✓
patient_id	bigint	✗	✓
observation_organisation_id	bigint	✗	✓
observation_organisation_guid	varchar	✗	✓
patient_organisation_guid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
effective_date_precision	varchar	✗	✓
readv2_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_code	varchar	✓	✗
other_display	varchar	✓	✗
rubric	varchar	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	double	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	double	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	double	✗	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar	✗	✓
is_parent	boolean	✗	✓
is_confidential	boolean	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	execution_date	✓

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	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✗	✓
parent_observation_uuid	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	✓	✓
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	✗	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
emis_original_term	varchar	✓	✓
batch_number	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
expiry_date	array(varchar)	✓	✓
gms	array(varchar)	✓	✓
injection_site	array(varchar)	✓	✓
qualifiers	varchar	✓	✓
uom	varchar	✓	✓
uom_dmd	varchar	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	decimal(19,3)	✗	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
readv2_code	varchar	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
sensitive_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
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	✗	✓
observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
parent_observation_id	bigint	✗	✓
parent_observation_guid	varchar	✗	✓
parent_observation_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
problem_observation_id	bigint	✗	✓
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	✓	✓
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.
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
consultation_source_emis_code_id	bigint	✓	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
emis_original_term	varchar	✓	✓
batch_number	array(varchar)	✓	✓
manufacturer	array(varchar)	✓	✓
expiry_date	array(varchar)	✓	✓
gms	array(varchar)	✓	✓
injection_site	array(varchar)	✓	✓
qualifiers	varchar	✓	✓
uom	varchar	✓	✓
uom_dmd	varchar	✓	✓
numeric_operator	varchar	✗	✓
numeric_value	decimal(19,3)	✗	✓
numeric_unit	varchar	✗	✓
range_minimum_operator	varchar	✗	✓
range_minimum	decimal(19,3)	✗	✓
range_minimum_text	varchar	✗	✓
range_maximum_operator	varchar	✗	✓
range_maximum	decimal(19,3)	✗	✓
range_maximum_text	varchar	✗	✓
range_units	varchar	✗	✓
range_qualifier_description	varchar(20)	✗	✓
is_parent	boolean	✗	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
regular_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
dummy_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
registration_guid	varchar	✓	✗
other_display	varchar	✓	✗
other_code_system	varchar	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
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	✓	✗
snomed_concept_id	bigint	✓	✗
readv2_code	varchar	✓	✗
emis_patient_id	bigint	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
data_filter	bigint	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓