Reference number | Field name | Description | Parameter | Read term | Read code | Term code | Laterality code | Coding comment | Changes from CRAG 2000 | Definitions and note |
1 | PT_NHS | Community Health Index (CHI) number for Scotland | 10 digits | Patient CHI number | 915B. | 00 | | Read code + CHI number | n/a | Mandatory field. The Community Health Index (CHI) is a population register used for health care purposes. The CHI number uniquely identifies a person on the index. |
2 | PT_ID | Principal treating hospital patient number | 14 characters | Patient hospital number | 915D. | 00 | | Read code + hospital number | n/a | The hospital patient identifier is a code, which uniquely identifies a patient on the main index of a hospital (i.e. within the hospital health records system). |
3 | HOSP_ID | Principal treating hospital identifier | 6 characters | Hospital reference number | 9R6.. | 00 | | Read code + ISD location code | n/a | Each location in Scotland, at which events pertinent to the Scottish Health Service take place, is allocated a location code. Locations include hospitals, health centres, clinics, NHS board offices, private nursing homes, homes for the elderly, children's homes and schools. The code is a five- character code maintained jointly by ISD and GRO (Scotland). |
4 | PRACID | General practice identifier | 6-digit practice code | | | | | ISD reference file number (no Read code available) | n/a | Each GP practice (partnerships and single-handed) in Scotland is identified by a unique GP practice code. The practice code is a four-digit code plus a check digit with ranges of codes allocated to each NHS Board |
5 | GP_CODE | Registered GP identifier (GMC Code) | 7 digits (GMC No. format) | General Medical Practitioner | 03DC. | 00 | | Read code + GMC Number | n/a | The GMC (General Medical Council) number is the personal identification number issued to each doctor/dentist by the General Medical Council/General Dental Council. |
6 | GPC_CODE | GMC Code of GP to whom correspondence should be addressed | 7 digits (GMC No. format) | | | | | GMC Number (no Read Code available) | n/a | See above. |
7 | SURNAME | Present surname | 20 characters | Patient surname | 9152. | 00 | | Read code + text | n/a | Mandatory field. The surname of a person represents that part of the name of a person, which indicates the family group of which the person is part. It should be noted that in Western culture this is normally the latter part of the name of a person. However, this is not necessarily true of all cultures. This will, of course, give rise to some problems in the representation of the name. This is resolved by including with the name a preferred name format indicating amongst other things the order of various parts of the name. |
8 | FNAME1 | 1st forename | 20 characters | Patient forename | 9151. | 00 | | Read code + text | n/a | Mandatory field. The first forename of a person represents that part of the name of a person, which after the surname, is the principal identifier of a person. |
9 | FNAME2 | 2nd forename | 20 characters | | | | | No Read code available | n/a | A previous name is any name by which a person was previously known. |
10 | OLDNAME | Previous surname | 20 characters | | | | | No Read code available | n/a | This is any surname by which a person was previously known. |
11 | DOB | Date of birth | dd/mm/yyyy | Patient date of birth | 9155. | 00 | | Read code + date | n/a | Mandatory field |
12 | ADDR1 | Address 1 | 35 characters | Patient address | 9153. | 00 | | Read code + address | n/a | NHS standards for unstructured and structured addresses exist and are applicable in England and Scotland. (Refer to Defs Manual for details). |
13 | ADDR2 | Address 2 | 35 characters | | | | | No Read code available | n/a | |
14 | ADDR3 | Address 3 | 35 characters | | | | | No Read code available | n/a | |
15 | ADDR4 | Address 4 | 35 characters | | | | | No Read code available | n/a | |
16 | PCODE | Postcode | 8 characters | Patient postcode | 9158. | 00 | | Read code + postcode | n/a | The postcode is a basic unit for identifying geographic locations. A postcode has two component parts: part one is the outcode, and part two is the incode. Refer to Definitions Manual for more details. |
17 | SEX | Sex | Heading | Gender | 1K... | 00 | | Read code heading | n/a | Phenotype at birth. |
| | | 1 = Male | Male | 1K0.. | 00 | | Read code | n/a | |
| | | 2 = Female | Female | 1K1.. | 00 | | Read code | n/a | |
18 | ETHN_GP | Ethnic grouping | heading | Ethnic groups (2001 census) | 9S... | 00 | | Read code heading | Updated from 1991 census to 2001 | An ethnic group is a group of people having racial, religious, linguistic and/or other cultural traits in common. The ethnic group to which a patient belongs is judged by the patient. The standard 2001 OPCS classification of ethnicity is used here. |
| | | 0 = White | White Scottish | 9S13. | 00 | | Read code | n/a | |
| | | | White Irish | 9S11. | 00 | | Read code | n/a | |
| | | | Other white British ethnic group | 9S14. | 00 | | Read code | n/a | |
| | | | Other white ethnic group | 9S12. | 00 | | Read code | n/a | |
| | | 1 = Black Caribbean | Black Caribbean | 9S2.. | 00 | | Read code | n/a | |
| | | 2 = Black African | Black African | 9S3.. | 00 | | Read code | n/a | |
| | | | Other black ethnic group | 9SG.. | 00 | | Read code | n/a | |
| | | 3 = Indian | Indian | 9S6.. | 00 | | Read code | n/a | |
| | | 4 = Pakistani | Pakistani | 9S7.. | 00 | | Read code | n/a | |
| | | 5 = Bangladeshi | Bangladeshi | 9S8.. | 00 | | Read code | n/a | |
| | | 6 = Chinese | Chinese | 9S9.. | 00 | | Read code | n/a | |
| | | | Other Asian ethnic group | 9SH.. | 00 | | Read code | n/a | |
| | | 30 = Other | Other ethnic group | 9SJ.. | 00 | | Read code | n/a | |
| | | | Other ethnic, mixed origin | 9SB.. | 00 | | Read code | n/a | |
| | | | Ethnic group not recorded | 9SE.. | 00 | | Read code | n/a | |
19 | STATUS | Current practice registration status | heading | Patient registration status | 912.. | 00 | | Read code heading | n/a | Required to record accurate prevalence data. |
| | | 1 = On practice list | Patient registered by HB | 912C. | 00 | | Read code | n/a | |
| | | 2 = Not on practice list | Patient not registered | 9121. | 00 | | Read code | n/a | |
20 | DTDIAG | Date of diagnosis | dd/mm/yyyy | Diabetes mellitus | C10.. | 00 | | Read code + date | n/a | Day and month are not obligatory and where missing the format 01/01/2003 is recommended. Date of diagnosis does not apply to states of impaired glucose tolerance or impaired fasting glucose. |
21 | FASTING | Fasting venous plasma glucose at diagnosis | (nn.n) mmol/l | Plasma fasting glucose level | 44g1. | 00 | | Read code + value + date | n/a | To ensure that a patient entered on the database has the appropriate diagnosis of diabetes mellitus, some measurement of blood glucose at diagnosis is required. Venous plasma sample must be used for this purpose. It is not essential that all 3 items are included, but at least one must be recorded. This should be interpreted according to the prevailing agreed UK classification of diabetes. In some cases, a random or fasting blood glucose will be sufficient; in others, the OGTT will be required. |
22 | 2HRGLU | 2-hour venous plasma glucose OGTT at diagnosis | (nn.n) mmol/l | 120 minute plasma glucose level | 44g6. | 00 | | Read code + value + date | n/a | Venous plasma glucose value two hours post 75g oral glucose. |
23 | RANDGLU | Random venous plasma glucose at diagnosis | (nn.n) mmol/l | Plasma random glucose level | 44g0. | 00 | | Read code + value + date | n/a | |
24 | TYPE_DM | Type of diabetes | 1 = Type 1 Diabetes Mellitus | Type 1 Diabetes Mellitus | C108. | 12 | | Read code + Term code | n/a | 'Preferred term' codes for types 1 & 2 diabetes should be available in the future through the new terminology SNOMED-CT. Secondary, other and unknown categories have not been included in the core dataset. 'Secondary diabetes' cannot currently be coded. It was considered that few or no patients should have 'other' or 'unknown' type of diabetes. |
| | | 2 = Type 2 Diabetes Mellitus | Type 2 Diabetes Mellitus | C109. | 12 | | Read code + Term code | n/a | |
| | | 3 = Impaired glucose tolerance | Impaired glucose tolerance | R10E. | 00 | | Read code | n/a | Note this does not constitute a diagnosis of diabetes mellitus. |
| | | 4 = Impaired fasting glucose | Impaired fasting glycaemia | R10DO | 00 | | Read code | | |
| | | 5 = Gestational | Gestational Diabetes Mellitus | L1809 | 00 | | Read code | n/a | |
| | | 6=Maturity onset diabetes of youth (MODY) | Maturity onset diabetes of youth | C10C. | 11 | | Read code + Term code | n/a | |
25 | HOSPCARE | Attendance at hospital diabetes clinic | Attended hospital diabetes clinic | Seen in diabetic clinic | 9N1Q. | 00 | | Read code + date | Binary response in CRAG 'attends/does not attend' - see notes | Binary response in CRAG 'attends/does not attend' could not be Read coded - considered positive response with date is appropriate for core dataset. |
26 | CARETYPE | Arrangement for formal diabetes care | heading | Diabetic monitoring | 66A.. | 00 | | Read code heading | 4 = Unknown in CRAG dataset - considered parameter should be known. | These data items should be recorded prospectively as intentions. |
| | | 1 = Primary care (GP) only | Diabetes: practice programme | 66AP. | 00 | | Read code | n/a | |
| | | 2 = Hospital diabetic clinic only | Diabetes care by hospital only | 66AU. | 00 | | Read code | n/a | |
| | | 3 = Shared between hospital diabetic clinic and GP | Diabetes: shared care program | 66AQ. | 00 | | Read code | n/a | |
27 | CLINIC | Principal treating hospital diabetes clinic ID | 6 characters | Attending diabetes clinic | 9NM0. | 00 | | Read code + clinic ID | n/a | |
28 | DOD | Date of death | dd/mm/yyyy | Death | 22J.. | 12 | | Read code + Term code + date | n/a | |
29 | DEATHGRO | Cause of death | ICD 10 code | Cause of death | 94B.. | | 00 | Read code + ICD10 code | n/a | This field would be appropriately completed with ICD10 code by data linkage. From this, death due to coronary heart disease (a St Vincent target) could be ascertained. |