Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp the row was ingested into the Explorer Platform	20240917084800
is_deleted	boolean	If this record should be considered soft deleted	FALSE
organisation_id	bigint	The emis web organisation identifier, can be used to join to other models	12345
location_id	bigint	The location identifier	67890
organisation	varchar	Owning organisation of EMIS Web instance	CDB-50002
load_datetime	timestamp(6) with time zone	The datetime that the record was last upserted in to the EXA data lake with a relevant change	2024-10-11T16:39:24+00:00
organisation_guid	varchar	The GUID for this organisation	82E6FF36-87E2-11EF-B3A3-48DF37DF55D0
location_guid	varchar	The GUID for this location	A3E962E4-CB3B-40B2-8D86-D850CB9BF1A4
is_main_location	boolean	Flag to indicate if this is the main location for the organisation	TRUE
transform_datetime	timestamp(6) with time zone	The datetime that the data was made available in the model with a relevant change	2024-12-17T13:44:00+00:00
_execution_date	varchar	Execution date of the data pipeline	20241217

Vanilla

Not used in this schema

Apollo

Not used in this schema

Artemis

Not used in this schema

Hestia

Not used in this schema

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	✓	✓
emis_main_location_guid	varchar	✓	✗	No longer required for this model in v2
processing_id	integer	✓	✗	Removed as it is deprecated in iPCV v1
is_deleted	boolean	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
organisation_id	bigint	✗	✓
emis_organisation_guid	varchar	✓	✓
location_id	bigint	✗	✓
location_guid	varchar	✗	✓
is_main_location_flag	boolean	✓	✓
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 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	✗	✓
organisation_id	bigint	✗	✓
emis_organisation_guid	varchar	✓	✓
location_id	bigint	✗	✓
emis_main_location_guid	varchar	✓	✗	No longer required for this model in v2
is_main_location_flag	boolean	✓	✓
processing_id	bigint	✓	✗	Removed as it is deprecated in iPCV v1
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 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	✗	✓
organisation_id	bigint	✗	✓
organisation_guid	varchar	✓	✓
location_id	bigint	✗	✓
location_guid	varchar	✓	✓
is_main_location	boolean	✓	✓
processing_id	bigint	✓	✗	Removed as it is deprecated in iPCV v1
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	execution_date	✓	Exists in v1 with a different name

Themis

Not used in this schema

Zeus

Not used in this schema