Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’2026-04-10’
emis_userinrole_guid	varchar	Unique identifier for the user	’123e4567-e89b-12d3-a456-426614174000’
emis_employer_organisation_guid	varchar	Unique identifier for the organisation	’123e4567-e89b-12d3-a456-426614174001’
emis_job_category_code	varchar	Job category code	’R5007’
emis_job_category_name	varchar	Job category name	’General Practitioner’
_execution_date	varchar(14)	Date of execution	’20260521042151’
organisation	varchar	Organisation identifier	’CDB-0001’