Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Ingest timestamp	’2026-04-10T12:00:00Z’
emis_userinrole_guid	varchar	User-in-role GUID	’auth-45678’
emis_employer_organisation_guid	varchar	Employer organisation GUID	’org-22222’
emis_job_category_code	varchar	Job category code	’GP’
emis_job_category_name	varchar	Job category name	’General Practitioner’
_execution_date	varchar	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’CDB-0001’