| Column Name | Data Types | Example |
|---|
| is_deleted | boolean | false |
| code_id | bigint | 123456789 |
| snomed_concept_id | bigint | 987654321 |
| data_dictionary_national_code | varchar | ABC123 |
| attribute_type | varchar(15) | diagnosis |
| organisation | varchar(4) | EMIS |
| transform_datetime | timestamp | 2024-01-15 10:30:45 |
| _execution_date | varchar(14) | 20240115103045 |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Types | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in v2 |
| data_filter | integer | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| data_dictionary_national_code | varchar | ✓ | ✓ | |
| attribute_type | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |