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	FALSE
observation_id	bigint	Internal EMIS observation identifier for this problem record	12345
observation_guid	varchar	EMIS observation GUID	’a1b2c3d4-e5f6-7890-abcd-ef1234567890’
observation_uuid	varchar	EXA-generated UUID5 derived from observation_id and organisation	’f47ac10b-58cc-4372-a567-0e02b2c3d479’
patient_id	bigint	Internal EMIS patient identifier	67890
patient_guid	varchar	EMIS patient GUID	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
patient_organisation_guid	varchar	EMIS GUID of the patient’s registered organisation	’c3d4e5f6-a7b8-9012-cdef-123456789012’
availability_datetime	timestamp(6) with time zone	The datetime the record became available	’2023-01-10 09:00:00.000000 UTC’
effective_datetime	timestamp(6) with time zone	The clinical effective datetime of the problem	’2023-01-10 09:00:00.000000 UTC’
effective_datetime_precision	varchar	Precision of the effective datetime; hardcoded to ‘YMDT'	'YMDT’
problem_end_datetime	timestamp(6) with time zone	The datetime the problem was resolved or ended	’2023-06-30 00:00:00.000000 UTC’
end_datetime_precision	varchar	Precision of the end datetime; hardcoded to ‘YMDT'	'YMDT’
last_review_date	date	Date of the last clinical review of this problem	’2023-03-15’
last_review_date_precision	varchar	Precision of the last review date; hardcoded to ‘YMD'	'YMD’
consultation_guid	varchar	EMIS GUID of the consultation linked to this problem	’d4e5f6a7-b8c9-0123-defa-234567890123’
consultation_uuid	varchar	EXA-generated UUID5 derived from consultation_id and organisation	’e5f6a7b8-c9d0-1234-efab-345678901234’
authorising_user_in_role_id	varchar	EMIS identifier of the authorising user in role	11223
entered_by_user_in_role_id	varchar	EMIS identifier of the user in role who entered the problem	33445
last_review_user_in_role_id	varchar	EMIS identifier of the user in role who last reviewed this problem	44556
problem_status_description	varchar	Status of the problem (Active Problem, Past Problem, Health Administration, or Potential)	‘Active Problem’
code_id	bigint	EMIS internal clinical code identifier	98765
original_term	varchar	Original clinical term as recorded in EMIS Web	’Essential hypertension’
consultation_source_code_id	bigint	EMIS code ID for the consultation source	45678
consultation_source_original_term	varchar	Original term for the consultation source code	’GP Surgery’
parent_problem_guid	varchar	EMIS GUID of the parent or linked problem observation	’b8c9d0e1-f2a3-1b2c-6d7e-8f9a0b1c2d3e’
parent_problem_uuid	varchar	EXA-generated UUID5 for the parent problem; null if no parent problem	’c9d0e1f2-a3b4-2c3d-7e8f-9a0b1c2d3e4f’
parent_problem_relationship_description	varchar	Relationship type to the parent problem (Combined, Grouped, Replaced, or Evolved)	‘Combined’
problem_significance_description	varchar	Significance of the problem (Significant Problem or Minor Problem)	‘Significant Problem’
expected_duration	integer	Expected duration of the problem in days	90
organisation_id	bigint	Internal EMIS identifier for the organisation	12345
observation_organisation_guid	varchar	EMIS GUID of the organisation associated with the observation	’a7b8c9d0-e1f2-0a1b-5c6d-7e8f9a0b1c2d’
is_sensitive	boolean	Indicates if the observation is currently flagged as sensitive	FALSE
was_sensitive	boolean	Indicates if the observation was previously flagged as sensitive	FALSE
is_confidential	boolean	Indicates if this record is currently marked as confidential	FALSE
was_confidential	boolean	Indicates if this record was previously marked as confidential	FALSE
problem_event_type	varchar	Type of observation event (allergy, immunisation, referral, or observation)	‘observation’
organisation	varchar	An identifier for the source of data (an organisation), relates 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 that 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

Vanilla

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this 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	✓	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
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	✗	✓
emis_last_review_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
last_review_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.
authorising_user_in_role_id	bigint	✗	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_original_term	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	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
problem_event_type	varchar	✓	✓
problem_status_description	varchar	✓	✓
fhir_significance	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_problem_significance	varchar	✓	✓
expected_duration_days	bigint	✓	✓
fhir_relation	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
parent_problem_relationship	varchar	✓	✓
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
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	✓	✗
sensitive_patient_flag	boolean	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Apollo

Not used in this schema

Artemis

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this 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	✓	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
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	✗	✓
emis_last_review_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
last_review_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.
authorising_user_in_role_id	bigint	✗	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_original_term	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	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
problem_event_type	varchar	✓	✓
problem_status_description	varchar	✓	✓
fhir_significance	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_problem_significance	varchar	✓	✓
expected_duration_days	bigint	✓	✓
fhir_relation	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
parent_problem_relationship	varchar	✓	✓
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_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	✓	✗
sensitive_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 this 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	✓	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
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	✗	✓
emis_last_review_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
last_review_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.
authorising_user_in_role_id	bigint	✗	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_original_term	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	✓	✓
effective_date_precision	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓
end_date	timestamp(6) with time zone	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
problem_event_type	varchar	✓	✓
problem_status_description	varchar	✓	✓
fhir_significance	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_problem_significance	varchar	✓	✓
expected_duration_days	bigint	✓	✓
fhir_relation	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
parent_problem_relationship	varchar	✓	✓
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
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	✓	✗
sensitive_patient_flag	boolean	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Themis

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this 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	✓	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
registration_ods_code	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	✗	✓
emis_last_review_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
last_review_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.
authorising_user_in_role_id	bigint	✗	✓
emis_code_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	✓	✓
end_date	timestamp(6) with time zone	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
problem_event_type	varchar	✓	✓
problem_status_description	varchar	✓	✓
fhir_significance	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_problem_significance	varchar	✓	✓
expected_duration_days	bigint	✓	✓
fhir_relation	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
parent_problem_relationship	varchar	✓	✓
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
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	✓	✗
sensitive_patient_flag	boolean	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Pseudo_Anon

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this 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	✓	✓
consultation_guid	varchar	✗	✓
consultation_uuid	varchar	✗	✓
parent_problem_observation_guid	varchar	✓	✓
parent_problem_uuid	varchar	✗	✓
patient_id	bigint	✗	✓
patient_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
observation_organisation_guid	varchar	✗	✓
patient_organisation_guid	varchar	organisation_guid	✓	Exists in v1 with a different name
code_id	bigint	✗	✓
end_date	date	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
expected_duration	bigint	✓	✓
problem_status_description	varchar	✓	✓
significance_description	varchar	✓	✓
last_review_user_in_role_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
last_review_user_in_role_id	varchar	✓	✓
parent_problem_relationship	varchar	✓	✓
processing_id	integer	✓	✓	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

Prometheus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this 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	✓	✓
emis_encounter_guid	varchar	✗	✓
exa_encounter_guid	varchar	✗	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
observation_organisation_guid	varchar	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
emis_last_review_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
last_review_user_in_role_id	bigint	✗	✓
code_id	bigint	✗	✓
end_date	date	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
problem_status_description	varchar	✓	✓
fhir_significance	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
problem_significance_description	varchar	✗	✓
expected_duration_in_days	bigint	✓	✓
parent_problem_relationship_description	varchar	✓	✓
processing_id	integer	✓	✓	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

Olympus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this 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	✓	✓
emis_encounter_guid	varchar	✗	✓
exa_encounter_guid	varchar	✗	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
observation_organisation_guid	varchar	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
emis_last_review_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
last_review_user_in_role_id	bigint	✗	✓
code_id	bigint	✗	✓
end_date	date	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
problem_status_description	varchar	✓	✓
fhir_significance	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
problem_significance_description	varchar	✗	✓
expected_duration_in_days	bigint	✓	✓
parent_problem_relationship_description	varchar	✓	✓
processing_id	integer	✓	✓	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	✓	✓

Zeus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this 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	✓	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_parent_observation_guid	varchar	✓	✓
exa_parent_observation_guid	varchar	✓	✓
pseudo_registration_guid_ourea	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions 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	✓	✓
end_date_precision	varchar	✓	✓
last_review_date	date	✓	✓
last_review_date_precision	varchar	✓	✓
problem_event_type	varchar	✓	✓
problem_status_description	varchar	✓	✓
fhir_significance	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_problem_significance	varchar	✓	✓
expected_duration_days	bigint	✓	✓
fhir_relation	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
parent_problem_relationship	varchar	✓	✓
fhir_status	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
other_code	varchar	✓	✗
emis_authorising_userinrole_guid	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
readv2_code	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
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	✓	✗
emis_enteredby_userinrole_guid	varchar	✓	✗
emis_last_review_userinrole_guid	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
data_filter	bigint	✓	✗