_ingest_time | varchar | Timestamp of data ingestion | ’20240603101655’ |
emis_observation_guid | varchar | Problem observation identifier | ’123e4567-e89b-12d3-a456-426614174000’ |
exa_observation_guid | varchar | EXA problem observation identifier | ’987fcdeb-51a2-3c4d-e5f6-789012345678’ |
emis_drug_guid | varchar | Medication identifier | ’a7b8c9d0-e1f2-3456-7890-abcdef012345’ |
exa_drug_guid | varchar | EXA medication identifier | ’b8c9d0e1-f2a3-4567-8901-bcdef0123456’ |
entered_date | date | Date recorded | ’2026-01-02’ |
entered_time | varchar | Time recorded | ’12:34:56’ |
pseudo_registration_guid | varchar | Hashed registration identifier | ’a1b2c3d4-e5f6-7890-abcd-ef1234567890’ |
pseudo_patient_id | varchar | Hashed patient identifier | ’f47ac10b-58cc-4372-a567-0e02b2c3d479’ |
emis_registration_organisation_guid | varchar | Registration organisation GUID | ’b2c3d4e5-f6a7-8901-bcde-f12345678901’ |
intent | varchar | Intent of the link | ’causal’ |
confidential_flag | boolean | Confidentiality flag | false |
_execution_date | varchar(14) | Extract execution date | ’20260521042151’ |
organisation | varchar | Organisation identifier | ’CDB-0001’ |
study_id | varchar | Study identifier from included patients view | ’study-12345’ |