Schema

Schema Overview

Column Name	Data Type	Description	Example
is_deleted	boolean	If this record should be considered soft deleted; all columns excluding primary keys will be NULL if TRUE	false
code_id	bigint	EMIS code ID - internal identifier	348898019
emis_code_category_description	varchar	EMIS Code ID category description	Referral
model_updated_datetime	timestamp(6) with time zone	Date and time the model last updated this record	2023-05-12 14:30:15.000000 UTC
national_code	varchar	National letter code from the NHS data dictionary code	G02
national_code_category	varchar	National Code category name	ACTIVITY LOCATION TYPE CODE
national_description	varchar	National code description	Nursing Home
parent_code_id	bigint	Populated if EMIS Code ID has a parent Code ID	361953013
read_term_id	varchar	EMIS old code	791D1
readv2_code	varchar	Old readv2 code	791D100
snomed_concept_id	bigint	SNOMED CT concept identifier	218361000
snomed_description_id	bigint	ID of the preferred SNOMED description	330690010
term	varchar	Description of EMIS Code ID	Pulmonary valvectomy
transform_datetime	timestamp(6) with time zone	Date and time the data was made available in the model with a relevant change	2023-05-12 14:30:15.000000 UTC

Example Query

Use this query to preview recent rows and validate expected columns:

SELECT *
FROM explorer_open_safely.clinical_code
LIMIT 100;