_ingest_time | varchar | Timestamp of data ingestion | ’20240512082638’ |
emis_session_guid | varchar | Unique identifier for the session | ’123e4567-e89b-12d3-a456-426614174000’ |
emis_session_userinrole_guid | varchar | Unique identifier for the user | ’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’ |