| code_id | bigint | EMIS code ID - internal identifier | 348898019 |
| emis_code_category_description | varchar | EMIS Code ID category description | Referral |
| is_deleted | boolean | If this record should be considered soft deleted; all columns excluding primary keys will be NULL if TRUE | false |
| 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 |
| organisation | varchar | The organisation that this data was replicated from. Will be ‘EMIS’ for all records in this table | EMIS |
| 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 |