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 allergy	FALSE
observation_id	bigint	Internal identifier for the allergy 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 allergy 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 allergy	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’
authorising_user_in_role_id	bigint	Identifier of the clinician who authorised or authored the allergy record	11223
entered_by_user_in_role_id	bigint	Identifier of the user who entered the allergy record	33445
organisation_id	bigint	Internal identifier of the organisation where the allergy 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 allergy	1001
code_category	varchar	Whether the allergy is to a medication or environment substance, derived from EMIS code category	’medication’
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 allergy	’Penicillin allergy’
associated_text	varchar	Free text associated with the allergy observation	’Severe rash on exposure’
numeric_operator	varchar	Operator for numeric value comparison (e.g. =, >, <)	’=‘
numeric_value	double	Numeric measurement value associated with the observation	7.5
numeric_unit	varchar	Unit for the numeric measurement value	’mg/dL’
ucum_code	varchar	Unified Code for Units of Measure (UCUM) code for the measurement unit	’mg/dL’
unit_of_measure	varchar	Description of the unit of measure	’milligrams per decilitre’
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	10.0
range_maximum_text	varchar	Text representation of the maximum range value	’10.0’
range_units	varchar	Units used for the reference range	’mg/dL’
range_qualifier_description	varchar	Description of the range qualifier (e.g. Normal, High, Low)	‘Normal’
qualifiers	varchar	Raw XML-like qualifier data associated with the observation	’<qualifiers>…</qualifiers>‘
qualifier_mapping	map(varchar, array(varchar))	Parsed qualifier key-value mapping from the qualifiers field	{‘site’: [‘Left arm’]}
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 allergy was first noted or became effective	’2020-03-15 09: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)	‘2020-03-15 10:30:00.000000 UTC’
problem_end_datetime	timestamp(6) with time zone	The date and time the allergy ended, if applicable	’2023-01-01 00:00:00.000000 UTC’
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
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’
is_sensitive	boolean	Indicates whether the allergy record is flagged as sensitive	FALSE
was_sensitive	boolean	Indicates whether the allergy record was previously sensitive	FALSE
is_confidential	boolean	Indicates whether the allergy record is confidential	FALSE
was_confidential	boolean	Indicates whether the allergy record was previously confidential	FALSE
organisation	varchar	An identifier for the source of data (an organisation) relating to a given GP practice	’CDB-12345’
load_datetime	timestamp(6) with time zone	Formatted ingest time for filtering	’2023-05-12 14:30:15.000000 UTC’
transform_datetime	timestamp(6) with time zone	The datetime the data was made available in the model with a relevant change	’2023-05-12 14:30:15.000000 UTC’
_execution_date	varchar	Formatted transform datetime for versioning	’20230512143015’

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	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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	✓	✓
emis_episodicity	bigint	✓	✓
emis_episodicity_description	varchar	✓	✓
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
associated_text	varchar	✗	✓
consultation_source_original_term	varchar	✗	✓
emis_original_term	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
numeric_operator	varchar	✗	✓
numeric_value	double	✗	✓
numeric_unit	varchar	✗	✓
ucum_code	varchar	✗	✓
unit_of_measure	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	✗	✓
qualifiers	varchar	✗	✓
is_abnormal	boolean	✗	✓
is_parent	boolean	✗	✓
qualifier_mapping	map(varchar, array(varchar))	✗	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
sensitive_patient_flag	boolean	✓	✗
snomed_concept_id	varchar	✓	✗
snomed_description_id	varchar	✓	✗
readv2_code	varchar	✓	✗
regular_current_active_and_inactive_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	✗	✓
emis_code_id	bigint	✓	✓
patient_organisation_guid	varchar	✗	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
effective_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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	varchar	✓	✗
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	✓	✓
end_date	timestamp(6) with time zone	✓	✓
emis_episodicity	bigint	✓	✓
emis_original_term	varchar	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
readv2_code	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
snomed_concept_id	varchar	✓	✗
snomed_description_id	varchar	✓	✗
non_regular_and_current_active_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	✓	✓
end_date	timestamp(6) with time zone	✓	✓
emis_episodicity	bigint	✓	✓
emis_original_term	varchar	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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_and_current_active_flag	boolean	✓	✗
snomed_concept_id	varchar	✓	✗
readv2_code	varchar	✓	✗
snomed_description_id	varchar	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
other_code_system	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
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_guid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
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	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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	✓	✓
snomed_concept_id	varchar	✓	✗
snomed_description_id	varchar	✓	✗
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	✓	✓

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_guid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
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	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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	✓	✓
snomed_concept_id	varchar	✓	✗
readv2_code	varchar	✓	✗
other_code_system	varchar	✓	✗
snomed_description_id	varchar	✓	✗
other_display	varchar	✓	✗
other_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	✗	✓
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_observation_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.
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	✓	✓
end_date	timestamp(6) with time zone	✓	✓
category	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	✗	✓
status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
is_confidential	boolean	✓	✓
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	✗	✓
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	✓	✓
end_date	timestamp(6) with time zone	✓	✓
emis_episodicity	bigint	✓	✓
emis_episodicity_description	varchar(8)	✓	✓
emis_original_term	varchar	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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	✓	✓
snomed_concept_id	varchar	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_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	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
readv2_code	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	✗	✓
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.
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	✓	✓
end_date	timestamp(6) with time zone	✓	✓
emis_original_term	varchar	✓	✓
emis_episodicity	bigint	✓	✓
emis_episodicity_description	varchar(8)	✓	✓
code_category	varchar	✗	✓
fhir_category	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_episodicity	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
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	✓	✓
data_filter	varchar	✓	✗
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	✓	✗
other_display	varchar	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
snomed_description_id	varchar	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
other_code_system	varchar	✓	✗
snomed_concept_id	varchar	✓	✗
readv2_code	varchar	✓	✗
emis_patient_id	bigint	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓