Schema

Core

The core schema represents the Diary schema derived from EMIS source system.

Column Name	Data Type	Description	Example
is_deleted	boolean	Indicates if this record should be considered soft deleted	false
load_datetime	timestamp(6) with time zone	The datetime that the record was last upserted into the EXA data lake from EMIS source system with a relevant change from source system.	‘2023-05-12 14:30:15.000000 UTC’
_ingest_time	varchar	The load_datetime formatted as yyyyMMddHHmmss. This column is provided only for backward compatibility.	‘20230512143015’
diary_id	bigint	The unique internal identifier for the diary record within an organisation.	345678
diary_guid	varchar	The GUID for the diary record within an organisation	‘b1c2d3e4-f5a6-4b5c-8d9e-0f1a2b3c4d5e’
diary_uuid	varchar	The UUID derived from diary_id and organisation, providing a stable unique identifier.	‘d4e5f6a7-b8c9-7d0e-2f3a-4b5c6d7e8f9a’
patient_id	bigint	The unique internal identifier for the patient record within the organisation for whom the diary entry was recorded.	123456
patient_guid	varchar	The GUID for the patient record within an organisation	‘e5f6a7b8-c9d0-8e1f-3a4b-5c6d7e8f9a0b’
patient_uuid	varchar	The UUID derived from patient_id and organisation, providing a stable unique identifier.	‘a7b8c9d0-e1f2-0a3b-5c6d-7e8f9a0b1c2d’
patient_organisation_id	bigint	The unique internal identifier for the organisation where the patient is registered	98765
patient_organisation_guid	varchar	The GUID of the organisation where the patient is registered	‘c2d3e4f5-a6b7-5c6d-9e0f-1a2b3c4d5e6f’
patient_organisation_uuid	varchar	The UUID derived from patient_organisation_id and organisation, providing a stable unique identifier.	‘e44c…f2’
diary_organisation_id	bigint	The unique internal identifier of the organisation where the diary event was recorded	98765
diary_organisation_guid	varchar	The GUID of the organisation where the diary event was recorded	‘f47ac10b-58cc-4372-a567-0e02b2c3d479’
diary_organisation_uuid	varchar	The UUID derived from diary_organisation_id and organisation, providing a stable unique identifier.	‘a1b2c3d4-e5f6-7890-abcd-ef1234567890’
consultation_id	bigint	The unique internal identifier for the consultation record within an organisation in which the diary entry was recorded.	456789
consultation_guid	varchar	The GUID for the consultation record within an organisation	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
consultation_uuid	varchar	The UUID derived from consultation_id and organisation, providing a stable unique identifier.	‘e5f6a7b8-c9d0-8e1f-3a4b-5c6d7e8f9a0b’
consultation_section_id	bigint	The unique internal identifier for the consultation section within an organisation.	12345
consultation_section_uuid	varchar	The UUID derived from consultation_section_id and organisation, providing a stable unique identifier.	‘c9d0e1f2-a3b4-2c5d-7e8f-9a0b1c2d3e4f’
consultation_source_code_id	bigint	The identifier of the code describing the consultation source (e.g. GP Surgery, Telephone)	1672851000006116
authorising_user_in_role_id	bigint	The unique identifier of the clinician who authorised or authored the diary record	111
authorising_user_in_role_uuid	varchar	The UUID derived from authorising_user_in_role_id and organisation, providing a stable unique identifier.	‘c9d0e1f2-a3b4-2c5d-7e8f-9a0b1c2d3e4f’
entered_by_user_in_role_id	bigint	The unique identifier of the user who entered the diary record	222
entered_by_user_in_role_uuid	varchar	The UUID derived from entered_by_user_in_role_id and organisation, providing a stable unique identifier.	‘f6a7b8c9-d0e1-9f2a-4b5c-6d7e8f9a0b1c’
code_id	bigint	The unique EMIS code identifier for the clinical code associated with the diary entry	1776891000006116
location_type_id	bigint	Internal identifier for the location type	27
location_type_description	varchar	Location type description	‘Surgery’
is_active	boolean	Indicates whether the diary record is currently active or no longer active	true
is_complete	boolean	Indicates whether the diary event has been completed or is still outstanding	false
original_term	varchar	The EMISl term used to record the diary entry	‘Medication review’
associated_text	varchar	Free text associated with the diary entry	‘Recall in 3 months’
duration_term	varchar	Duration attached to the diary entry, for example how long until an action is due or planned	‘3 months’
effective_datetime	timestamp(6) with time zone	The date and time when the diary entry came into effect	‘2025-01-05 09:00:00+00’
effective_datetime_precision	varchar	Precision of the effective datetime; set to ‘YMDT’.	‘YMDT’
availability_datetime	timestamp(6) with time zone	The date and time the diary entry was recorded in the source system	‘2025-01-01 09:00:00+00’
is_sensitive	boolean	Indicates whether the diary record is flagged as sensitive. The sensitive reference set codes are 999004351000000109( gender related issues), 999004371000000100(assisted fertilisation), 999004361000000107(termination of pregnancy) and 999004381000000103 (sexually transmitted disease)	false
confidentiality_policy_id	bigint	Confidentiality policy id	4
is_confidential	boolean	Indicates whether the diary record is confidential. This is based on confidentiality set against the patient, consultation section or diary record.	false
organisation	varchar	An identifier for the source of data (an organisation) relating to a given GP practice	‘A12345’
transform_datetime	timestamp(6) with time zone	The timestamp indicating when the record was last processed and updated in the data model.	‘2025-01-01 12:40:00+00’
_execution_date	varchar	The transform_datetime formatted as yyyyMMddHHmmss. This column is provided only for backward compatibility.	‘20250101124000’

Vanilla

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
diary_id	bigint	✗	✓
emis_diary_guid	varchar	✓	✓	diary_guid
exa_diary_guid	varchar	✓	✓	diary_uuid
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
diary_organisation_id	bigint	✗	✓
diary_organisation_guid	varchar	✗	✓
diary_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
is_active_flag	boolean	✓	✓	is_active
is_complete_flag	boolean	✓	✓	is_complete
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
location_type_id	bigint	✗	✓
location_type_description	varchar	✓	✓
associated_text	varchar	✓	✓
entered_by_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
confidential_flag	boolean	✓	✓	is_confidential
sensitive_flag	boolean	✓	✓	is_sensitive
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_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	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
_record_version	varchar	✓	✗
_update_date	varchar	✓	✗
_update_hour	varchar	✓	✗

Apollo

Not used in this schema

Artemis

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
diary_id	bigint	✗	✓
emis_diary_guid	varchar	✓	✓	diary_guid
exa_diary_guid	varchar	✓	✓	diary_uuid
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
diary_organisation_id	bigint	✗	✓
diary_organisation_guid	varchar	✗	✓
diary_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
is_active_flag	boolean	✓	✓	is_active
is_complete_flag	boolean	✓	✓	is_complete
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
location_type_id	bigint	✗	✓
location_type_description	varchar	✓	✓
entered_by_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
recorded_date	timestamp(6) with time zone	✓	✓	availability_datetime
duration_term	varchar	✓	✓
confidential_flag	boolean	✓	✓	is_confidential
sensitive_flag	boolean	✓	✓	is_sensitive
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
readv2_code	varchar	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
_record_version	varchar	✓	✗
_update_date	varchar	✓	✗
_update_hour	varchar	✓	✗

Hermes

The table below presents the flavour specific schema.

Column Name	Data Type	Core Mapping
is_deleted	boolean
pseudo_diary_uuid	varchar	diary_uuid
pseudo_patient_uuid	varchar	patient_uuid
pseudo_patient_organisation_uuid	varchar	patient_organisation_uuid
pseudo_diary_organisation_uuid	varchar	diary_organisation_uuid
pseudo_consultation_uuid	varchar	consultation_uuid
availability_datetime	timestamp(6) with time zone
effective_datetime	timestamp(6) with time zone
effective_datetime_precision	varchar
duration_term	varchar
original_term	varchar
consultation_source_code_id	bigint
code_id	bigint
location_type_id	bigint
location_type_description	varchar
confidentiality_policy_id	bigint
is_active	boolean
is_complete	boolean
is_sensitive	boolean
is_confidential	boolean
organisation	varchar
transform_datetime	timestamp(6) with time zone

Hestia

Not used in this schema

Olympus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
emis_diary_guid	varchar	✓	✓	diary_guid
exa_diary_guid	varchar	✓	✓	diary_uuid
diary_id	bigint	✗	✓
is_deleted	boolean	✓	✓		Renamed from `deleted`in V1
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓	consultation_guid
consultation_uuid	varchar	✓	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
location_type_id	bigint	✗	✓
location_type_description	varchar	✓	✓
pseudo_registration_guid	varchar	✓	✓	patient_guid
pseudo_patient_uuid	varchar	✗	✓	patient_uuid
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	date	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
entered_date	date	✓	✓	availability_datetime
entered_time	varchar	✓	✓	availability_datetime
confidential_flag	boolean	✓	✓	is_confidential
is_active_flag	boolean	✓	✓	is_active
is_complete_flag	boolean	✓	✓	is_complete
processing_id	bigint	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Prometheus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
emis_diary_guid	varchar	✓	✓	diary_guid
exa_diary_guid	varchar	✓	✓	diary_uuid
diary_id	bigint	✗	✓
is_deleted	boolean	✓	✓		Renamed from `deleted`in V1
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓	consultation_guid
consultation_uuid	varchar	✓	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
location_type_id	bigint	✗	✓
location_type_description	varchar	✓	✓
pseudo_registration_guid	varchar	✓	✓	patient_guid
pseudo_patient_uuid	varchar	✗	✓	patient_uuid
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	date	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
entered_date	date	✓	✓	availability_datetime
entered_time	varchar	✓	✓	availability_datetime
confidential_flag	boolean	✓	✓	is_confidential
is_active_flag	boolean	✓	✓	is_active
is_complete_flag	boolean	✓	✓	is_complete
processing_id	bigint	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓		Renamed from `execution_date`in V1

Pseudo_Anon

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✓	✓		Renamed from `deleted`in V1
diary_id	bigint	✗	✓
diary_guid	varchar	✓	✓
id_type5	varchar	✓	✓	diary_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
consultation_guid	varchar	✓	✓
consultation_uuid	varchar	✗	✓
patient_id	bigint	✗	✓
patient_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
diary_organisation_id	bigint	✗	✓
diary_organisation_guid	varchar	✗	✓
diary_organisation_uuid	varchar	✗	✓
organisation_guid	varchar	✓	✗
code_id	bigint	✓	✓
original_term	varchar	✓	✓
location_type_id	bigint	✗	✓
location_type_description	varchar	✓	✓
clinician_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	date	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
entered_date	date	✓	✓	availability_datetime
entered_time	varchar	✓	✓	availability_datetime
is_confidential	boolean	✓	✓
is_active	boolean	✓	✓
is_complete	boolean	✓	✓
processing_id	bigint	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓		Renamed from `execution_date` in V1

Themis

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
diary_id	bigint	✗	✓
emis_diary_guid	varchar	✓	✓	diary_guid
exa_diary_guid	varchar	✓	✓	diary_uuid
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
diary_organisation_id	bigint	✗	✓
diary_organisation_guid	varchar	✗	✓
diary_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
location_type_id	bigint	✗	✓
location_type_description	varchar	✓	✓
is_active_flag	boolean	✓	✓	is_active
is_complete_flag	boolean	✓	✓	is_complete
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
associated_text	varchar	✓	✓
entered_by_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
recorded_date	timestamp(6) with time zone	✓	✓	availability_datetime
duration_term	varchar	✓	✓
confidential_flag	boolean	✓	✓	is_confidential
sensitive_flag	boolean	✓	✓	is_sensitive
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_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	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
readv2_code	varchar	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
_record_version	varchar	✓	✗
_update_date	varchar	✓	✗
_update_hour	varchar	✓	✗

Zeus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
diary_id	bigint	✗	✓
emis_diary_guid	varchar	✓	✓	diary_guid
exa_diary_guid	varchar	✓	✓	diary_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
emis_patient_id	bigint	✓	✗	patient_id
pseudo_patient_uuid	varchar	✗	✓	patient_uuid
pseudo_registration_guid_ourea	varchar	✓	✓	patient_guid
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
duration_term	varchar	✓	✓
is_active_flag	boolean	✓	✓	is_active
is_complete_flag	boolean	✓	✓	is_complete
entered_by_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	date	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
recorded_date	timestamp(6) with time zone	✓	✓	availability_datetime
sensitive_flag	boolean	✓	✓	is_sensitive
location_type_id	bigint	✗	✓
location_type_description	varchar	✓	✓
confidential_flag	boolean	✓	✓	is_confidential
data_filter	integer	✓	✗
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_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	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
readv2_code	varchar	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓