| is_deleted | boolean | If this record should be considered soft deleted | false |
| organisation | varchar | The organisation that this data was replicated from | ’EMIS’ |
| codeid | bigint | PK EMIS code - internal identifier | 348898019 |
| parent_code_id | bigint | populated if EMIS Code ID has a parent Code ID | 361953013 |
| term | varchar | Description of EMIS Code ID | ’Pulmonary valvectomy’ |
| read_term_id | varchar | 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 |
| national_code_category | varchar | National Code category name | ACTIVITY LOCATION TYPE CODE |
| national_code | varchar | National letter code | G02 |
| national_description | varchar | National code description | Nursing Home |
| emis_code_category_description | varchar | EMIS Code ID category description | Referral |
| transform_datetime | timestamp(6) with time zone | datetime the data was made available in the model with a relevant change | 2023-05-12 14:30:15.000000 UTC |
| model_last_update | timestamp(6) with time zone | Timestamp indicating when the model last updated this record (data type to be confirmed). | 2024-01-15 10:30:45 |
