| Column Name | Data Type | Description | Example |
|---|
| is_deleted | BOOLEAN | Flag indicating if the code is deleted (or deprecated) | false |
| code_id | BIGINT | Unique identifier for the ethnicity code (Primary Key) | 12345 |
| snomed_concept_id | BIGINT | SNOMED CT concept identifier (nullable) | 186034007 |
| snomed_description | VARCHAR | Human-readable description of the SNOMED concept | ’White British’ |
| snomed_description_id | BIGINT | ID of the preferred SNOMED description | 234567 |
| organisation | VARCHAR | Identifier for the data source, always ‘EMIS' | 'EMIS’ |
| transform_datetime | TIMESTAMP(6) WITH TIME ZONE | Timestamp when the record was last transformed | ’2023-05-12 14:30:15+00’ |
| _execution_date | VARCHAR | Formatted transform datetime for versioning | ’20230512143015’ |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| snomed_description | 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description | varchar | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description | varchar | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description | varchar | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description | varchar | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description | varchar | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| snomed_description | 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| snomed_description | 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 Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| data_filter | integer | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description | varchar | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
