Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Ingest timestamp	’20240512082638’
emis_session_guid	varchar	Session GUID the user is assigned to	’123e4567-e89b-12d3-a456-426614174000’
emis_session_userinrole_guid	varchar	User-in-role GUID assigned to the session	’123e4567-e89b-12d3-a456-426614174001’
session_id	bigint	Auxiliary session identifier	67890
user_in_role_id	bigint	Auxiliary user-in-role identifier	88888
deleted	boolean	Soft-delete flag	false
_execution_date	varchar(14)	Extract execution date	’20260521042151’
organisation	varchar	Organisation identifier	’CDB-0001’