Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Ingest timestamp	’2026-04-10T12:00:00Z’
emis_session_guid	varchar	Session GUID the user is assigned to	’session-12345’
emis_session_userinrole_guid	varchar	User-in-role GUID assigned to the session	’auth-45678’
session_id	varchar	Auxiliary session identifier	’sid-99999’
user_in_role_id	varchar	Auxiliary user-in-role identifier	’uid-88888’
deleted	boolean	Soft-delete flag	false
_execution_date	varchar	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’CDB-0001’