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
referral_observation_id	bigint	Internal EMIS observation identifier for this referral record	12345
referral_observation_guid	varchar	EMIS observation GUID for the referral	’a1b2c3d4-e5f6-7890-abcd-ef1234567890’
referral_observation_uuid	varchar	Deterministic UUID5 generated from referral_observation_id + 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_uuid	varchar	Deterministic UUID5 generated from patient_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
patient_organisation_id	bigint	EMIS internal identifier of the patient’s registered organisation	12345
patient_organisation_guid	varchar	EMIS GUID of the patient’s registered organisation	’c3d4e5f6-a7b8-9012-cdef-123456789012’
patient_organisation_uuid	varchar	Deterministic UUID5 generated from patient_organisation_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
unique_booking_reference_number	varchar	Unique Booking Reference Number (UBRN) for the referral; NULL when deleted	’REF123456’
effective_datetime	timestamp(6) with time zone	The clinical effective datetime of the referral; NULL when deleted	’2023-01-10 09:00:00.000000 UTC’
effective_datetime_precision	varchar	Precision of the effective datetime; hardcoded to ‘YMDT’; NULL when deleted	’YMDT’
availability_datetime	timestamp(6) with time zone	The datetime the referral record became available; NULL when deleted	’2023-01-10 09:00:00.000000 UTC’
referral_made_datetime	timestamp(6) with time zone	The datetime the referral was originally made; NULL when deleted	’2023-01-09 16:45:00.000000 UTC’
ended_datetime	timestamp(6) with time zone	The datetime the referral ended or was resolved; NULL when deleted or not ended	’2023-06-30 00:00:00.000000 UTC’
consultation_section_id	bigint	Internal identifier for the consultation section	12345
consultation_section_uuid	varchar	Deterministic UUID5 generated from consultation_section_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
consultation_id	bigint	Internal identifier for the consultation	12345
consultation_guid	varchar	EMIS GUID of the consultation linked to this referral	’d4e5f6a7-b8c9-0123-defa-234567890123’
consultation_uuid	varchar	Deterministic UUID5 generated from consultation_id + organisation	’e5f6a7b8-c9d0-1234-efab-345678901234’
authorising_user_in_role_id	bigint	EMIS identifier of the authorising user in role; NULL when deleted	11223
authorising_user_in_role_uuid	varchar	Deterministic UUID5 generated from authorising_user_in_role_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
entered_by_user_in_role_id	bigint	EMIS identifier of the user in role who entered the referral; NULL when deleted	33445
entered_by_user_in_role_uuid	varchar	Deterministic UUID5 generated from entered_by_user_in_role_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
code_id	bigint	EMIS internal clinical code identifier; NULL when deleted	98765
original_term	varchar	Original clinical term as recorded in EMIS Web; masked when deleted or code is null	’Referral to cardiology’
qualifiers	varchar	Qualifiers associated with the referral observation; NULL when deleted	’Urgent’
consultation_source_code_id	bigint	EMIS code ID for the consultation source; NULL when deleted	45678
consultation_source_original_term	varchar	Original term for the consultation source code; NULL when deleted	’GP Surgery’
urgency	integer	Numeric urgency code: 0=Routine, 1=Soon, 2=Urgent, 3=Dated, 4=2 Week Wait; NULL when deleted	2
urgency_description	varchar	Human-readable urgency label derived from urgency code; NULL when deleted	’Urgent’
direction	varchar	Direction of the referral: ‘out’ (outgoing) or ‘in’ (incoming); NULL when deleted	’out’
service_type_id	bigint	EMIS code ID for the requested service type; NULL when deleted	5678
service_type_requested	bigint	The ID of service type requested	8
service_type_display_text	varchar	Display text for the requested service type; NULL when deleted	’Cardiology’
referral_mode_id	bigint	Internal identifier for the referral mode	12345
referral_mode_description	varchar	Referral mode description (e.g., written, telephone); NULL when deleted	’Written’
observation_organisation_id	bigint	EMIS internal identifier of the organisation associated with the observation	12345
observation_organisation_guid	varchar	EMIS GUID of the organisation associated with the observation	’a7b8c9d0-e1f2-0a1b-5c6d-7e8f9a0b1c2d’
observation_organisation_uuid	varchar	Deterministic UUID5 generated from observation_organisation_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
target_organisation_id	bigint	EMIS internal identifier of the target organisation the patient is referred to	12345
target_organisation_guid	varchar	EMIS GUID of the target organisation the patient is referred to	’f1e2d3c4-b5a6-7890-abcd-ef0123456789’
target_organisation_uuid	varchar	Deterministic UUID5 generated from target_organisation_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
problem_observation_id	bigint	EMIS internal identifier of the related problem observation, if linked	12345
problem_observation_guid	varchar	EMIS GUID of the related problem observation, if linked	’b8c9d0e1-f2a3-1b2c-6d7e-8f9a0b1c2d3e’
problem_observation_uuid	varchar	Deterministic UUID5 generated from problem_observation_id + organisation	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
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
is_sensitive	boolean	Indicates if the referral is currently flagged as sensitive	FALSE
was_sensitive	boolean	Indicates if the referral was previously flagged as sensitive	FALSE
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	’20230512143015’

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	✗	✓
referral_observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
patient_organisation_uuid	varchar	✗	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
observation_organisation_uuid	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	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
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	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_emis_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	✓	✓
received_date	date	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
referral_made_datetime	timestamp(6) with time zone	✗	✓
recorded_date	timestamp(6) with time zone	✓	✓
referral_end_date	timestamp(6) with time zone	✓	✓
qualifiers	varchar	✓	✓
referral_mode_id	bigint	✗	✓
referral_mode_description	varchar	✓	✓
emis_direction_description	varchar	✓	✓
emis_urgency	bigint	✓	✓
nhs_priority_description	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_urgency_description	varchar	✓	✓
service_type_emis_code_id	bigint	✓	✓
service_type_requested_description	varchar	✓	✓
nhs_priority	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
nhs_source	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
target_organisation_id	bigint	✗	✓
emis_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
ubrn	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
action_date	timestamp(3)	✓	✗
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	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
service_type_snomed_concept_id	bigint	✓	✗
service_type_term	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
readv2_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_code	varchar	✓	✗
other_display	varchar	✓	✗
emis_referral_term	varchar	✓	✗
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	✗	✓
referral_observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
patient_organisation_uuid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
observation_organisation_uuid	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	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
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	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_emis_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	✓	✓
received_date	date	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
referral_made_datetime	timestamp(6) with time zone	✗	✓
recorded_date	timestamp(6) with time zone	✓	✓
referral_end_date	timestamp(6) with time zone	✓	✓
qualifiers	varchar	✓	✓
referral_mode_id	bigint	✗	✓
referral_mode_description	varchar	✓	✓
emis_direction_description	varchar	✓	✓
nhs_priority_description	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_urgency_description	varchar	✓	✓
service_type_emis_code_id	bigint	✓	✓
service_type_requested_description	varchar	✓	✓
nhs_priority	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
nhs_source	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
target_organisation_id	bigint	✗	✓
emis_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
ubrn	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
action_date	timestamp(3)	✓	✗
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_referral_term	varchar	✓	✗
emis_urgency	bigint	✓	✓
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	✓	✗
readv2_code	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
service_type_snomed_concept_id	bigint	✓	✗
service_type_term	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
sensitive_patient_flag	bigint	✓	✗
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	✗	✓
referral_observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
patient_organisation_uuid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
observation_organisation_uuid	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	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
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	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
consultation_source_emis_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	✓	✓
received_date	date	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
referral_made_datetime	timestamp(6) with time zone	✗	✓
recorded_date	timestamp(6) with time zone	✓	✓
referral_end_date	timestamp(6) with time zone	✓	✓
qualifiers	varchar	✓	✓
referral_mode_id	bigint	✗	✓
referral_mode_description	varchar	✓	✓
emis_direction_description	varchar	✓	✓
nhs_priority_description	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_urgency	bigint	✓	✓
emis_urgency_description	varchar	✓	✓
service_type_emis_code_id	bigint	✓	✓
service_type_requested_description	varchar	✓	✓
nhs_priority	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
nhs_source	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_original_term	varchar	✓	✓
target_organisation_id	bigint	✗	✓
emis_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
ubrn	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
other_code	varchar	✓	✗
emis_referral_term	varchar	✓	✗
service_type_term	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
readv2_code	varchar	✓	✗
snomed_description_id	bigint	✓	✗
service_type_snomed_concept_id	bigint	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
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	✗	✓
referral_observation_id	bigint	✗	✓
exa_observation_guid	varchar	✓	✓
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
emis_observation_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
observation_organisation_uuid	varchar	✗	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
patient_organisation_uuid	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	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
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	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
received_date	date	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
referral_made_datetime	timestamp(6) with time zone	✗	✓
recorded_date	timestamp(6) with time zone	✓	✓
referral_end_date	timestamp(6) with time zone	✓	✓
qualifiers	varchar	✓	✓
referral_mode_id	bigint	✗	✓
referral_mode_description	varchar	✓	✓
emis_direction_description	varchar	✓	✓
nhs_priority_description	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_urgency	bigint	✓	✓
emis_urgency_description	varchar	✓	✓
service_type_emis_code_id	bigint	✓	✓
service_type_requested_description	varchar	✓	✓
nhs_priority	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
nhs_source	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
consultation_source_emis_original_term	varchar	✓	✓
emis_original_term	varchar	✓	✓
target_organisation_id	bigint	✗	✓
emis_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
ubrn	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
action_date	timestamp(3)	✓	✗
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_referral_term	varchar	✓	✗
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	✓	✗
readv2_code	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
service_type_snomed_concept_id	bigint	✓	✗
service_type_term	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
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	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
referral_observation_id	bigint	✗	✓
observation_guid	varchar	✓	✓
id_type5	varchar	✓	✓
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	✗	✓
problem_observation_id	bigint	✗	✓
problem_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
organisation_guid	varchar	✓	✓
patient_organisation_uuid	varchar	✗	✓
entered_by_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_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
clinician_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	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
referral_mode	varchar	✓	✓
referral_urgency	bigint	✓	✓
referral_service_type	varchar	✓	✓
target_organisation_id	bigint	✗	✓
referral_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
observation_type	varchar(8)	✓	✓
is_confidential	boolean	✓	✓
parent_observation_guid	varchar	✓	✗
document_guid	varchar	✓	✗
code_id	bigint	✓	✓
referral_source_organisation_guid	varchar	✓	✗
value	varchar	✓	✗
numeric_range_low	double	✓	✗
numeric_range_high	double	✓	✗
numeric_unit	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	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
referral_observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓
exa_consultation_guid	varchar	✓	✓
pseudo_registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
patient_organisation_uuid	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	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
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	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
referral_mode_id	bigint	✗	✓
referral_mode_description	varchar	✓	✓
emis_urgency_description	varchar	✓	✓
urgency	bigint	✗	✓
service_type_requested_description	varchar	✓	✓
target_organisation_id	bigint	✗	✓
emis_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
ubrn_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
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	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
referral_observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_consultation_guid	varchar	✓	✓
exa_consultation_guid	varchar	✓	✓
pseudo_registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
patient_organisation_uuid	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	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
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	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
referral_mode_id	bigint	✗	✓
referral_mode_description	varchar	✓	✓
emis_urgency_description	varchar	✓	✓
urgency	bigint	✗	✓
service_type_requested_description	varchar	✓	✓
target_organisation_id	bigint	✗	✓
emis_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
ubrn_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
observation_type	varchar(8)	✓	✓
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	✗	✓
referral_observation_id	bigint	✗	✓
emis_observation_guid	varchar	✓	✓
exa_observation_guid	varchar	✓	✓
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓
exa_encounter_guid	varchar	✓	✓
pseudo_registration_guid_ourea	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓
patient_organisation_uuid	varchar	✗	✓
problem_observation_id	bigint	✗	✓
emis_problem_observation_guid	varchar	✓	✓
problem_observation_uuid	varchar	✗	✓
observation_organisation_id	bigint	✗	✓
emis_observation_organisation_guid	varchar	✓	✓
observation_organisation_uuid	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	✓	✓
effective_date	timestamp(6) with time zone	✓	✓
effective_date_precision	varchar	✓	✓
received_date	date	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
referral_made_datetime	timestamp(6) with time zone	✗	✓
recorded_date	timestamp(6) with time zone	✓	✓
referral_end_date	timestamp(6) with time zone	✓	✓
qualifiers	varchar	✓	✓
referral_mode_id	bigint	✗	✓
referral_mode_description	varchar	✓	✓
emis_direction_description	varchar	✓	✓
nhs_priority_description	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_urgency	bigint	✓	✓
emis_urgency_description	varchar	✓	✓
service_type_emis_code_id	bigint	✓	✓
service_type_requested_description	varchar	✓	✓
nhs_priority	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
nhs_source	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
consultation_source_emis_original_term	varchar	✓	✓
emis_original_term	varchar	✓	✓
target_organisation_id	bigint	✗	✓
emis_target_organisation_guid	varchar	✓	✓
target_organisation_uuid	varchar	✗	✓
ubrn	varchar	✓	✓
confidential_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
action_date	timestamp(3)	✓	✗
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_authorising_userinrole_guid	varchar	✓	✗
emis_enteredby_userinrole_guid	varchar	✓	✗
emis_referral_term	varchar	✓	✗
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	✓	✗
readv2_code	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
service_type_snomed_concept_id	bigint	✓	✗
service_type_term	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
data_filter	bigint	✓	✗