Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10 12:00:00’
emis_code_id	varchar	Unique identifier for the clinical code	’code-12345’
emis_code_term	varchar	Term associated with the clinical code	’Hypertension’
emis_code_type	varchar	Type of the clinical code	’diagnosis’
emis_code_category	varchar	Category of the clinical code	’chronic’
emis_code_status	varchar	Status of the clinical code	’active’
emis_code_effective_date	date	Effective date of the clinical code	’2026-01-01’
emis_code_entered_date	date	Date when the clinical code was entered	’2026-01-02’
emis_code_entered_time	time	Time when the clinical code was entered	’12:34:56’
emis_code_authorising_user	varchar	Authorizing user for the clinical code	’auth-67890’
emis_code_consultation_guid	varchar	Consultation identifier	’cons-54321’
emis_code_confidential_flag	boolean	Indicates if the data is confidential	true
execution_date	date	Date of execution	’2026-04-10’
study_id	varchar	Study identifier	’study-67890’