SHARE datasets for use solely for SHARE approved projects

RDS  > SHARE @ 132

SHARE is an NHS Research Scotland initiative. It has been created to establish a register of people, aged 11 and over, interested in participating in health research. https://www.registerforshare.org/

HDR UK

NHS Scotland

PROCHI

SHARE_Registrations

SHARE_Demography

This is the alpha and/or numeric Health Board code in which the patient CHI information was extracted from. The Health Board codes are:    D = State Hospital  X = Common Services Agency  H = 01 = Highland  N = 02 = Grampian  T = 03 = Tayside  F = 04 = Fife  S = 05 = Lothian  B = 06 = Borders  V = 07 = Forth Valley  C = 08 = Argyle and Clyde  G = 09 = Greater Glasgow  L = 10 = Lanarkshire  A = 11 - Ayrshire and Arran  Y = 12 = Dumfries and Galloway  R = 13 = Orkney  Z = 14 = Shetland  W = 15 = Western Isles.

Region

current_postcode

current_gp

This field represents the patients date of birth and should be anonymised on release.

date_of_birth

hic_dataLoadRunID

hic_validFrom

SHARE v_registration_share_current_for_contact

This is the patient's full postcode (e.g., DD2 3XX) .  .

POSTCODE

The Scottish Cancer Registry (SMR06) at ISD is responsible for the collection of information on Scottish residents when they are diagnosed with malignant (and some benign) tumours. The registry began in 1958 collecting personal, demographic and diagnosis information (such as site, histology, behaviour, histological confirmation and hospital of diagnosis) from cancer patients. In 1997, a new electronic cancer recording system was launched and at this point the registry was extended to include extra information on tumour stage (for breast, cervical and colorectal cancer), tumour grade and treatment information. A wide variety of geographical data is also included in the dataset including Scottish Index of Multiple Deprivation and Carstairs measures, census output area, NHS Board, Electoral Ward and Parliamentary constituency.

SHARE NAT_SMR06

This field represents the date when death occurred.  Patients date of death as recorded on  SOCRATES system  Date in the format CCYYMMDD.

DATE_OF_DEATH

This field represents the primary cause of death in ICD-9/10..

CAUSE_1

This field represents the secondary cause of death 1 in ICD-9/10.  .

CAUSE_2

This field represents the secondary cause of death 2 in ICD-9/10.  .

CAUSE_3

This field represents the secondary cause of death 3 in ICD-9/10.  .

CAUSE_4

This field represents the date when the cancer in question becomes formally known to the NHSiS.  .

INCIDENCE_DATE

This field indicates the side or laterality (i.e. left or right). In paired organs of the body in which the tumour is located. It is important that this be recorded for paired organs (e.g. breast, kidney, limb, lung, ovary, testis).    0 = Not Applicable  1 = Right  2 = Left  3 = Bilateral  9 = Not Known.

SIDE

This field represents the anatomical site of origin of the primary tumour and comprises a code from ICD-9 (Mandatory for YTC pre-1997 & post 1997 DCOs only)..

SITE_ICD9

This field denotes the anatomical site of origin of the primary tumour and comprises a code from ICD-10 (Mandatory for YTC 1997 onwards)..

ICD10S_CANCER_SITE

Tumour site denotes the anatomical site of origin of the primary tumour and comprises a code from ICD-10 (Mandatory for YTC 1997 onwards)..

ICDO2_ICDO2

ICDO - International Classification of Diseases for Oncology. Tumour type indicates the morphology  (histology) of the tumour and comprises the first four digits of the ICD-O morphology code and a fifth  digit which denotes behaviour of the tumour.  All registrations with an incidence date up to and including 31.12.1996 should be classified according to  the ICDO classification.  5th digit options:   Code Description  0 Benign  1 Uncertain whether benign or malignant  2 Carcinoma in situ  3 Malignant- primary site  6 Malignant- metastatic site or secondary site  9 Malignant- uncertain whether primary or metastatic site .

TYPE_ICDO

MORPH_MORPHOLOGY

A ICDO(3) - International Classification of Diseases for Oncology (3rd revision). Tumour type indicates the  morphology (histology) of the tumour and comprises the first four digits of the ICDO(3) morphology code  and a fifth digit which denotes behavior. This is recorded for haematological transformations which have  occurred since 01.01.2013.

TYPE_ICDO3

This field indicates the classification system used for grading tumour.    1 = Nottingham grading system for breast only  2 = ICDO/UICC grading system  3 = Gleason Score (Prostate)  4 = Bloom and Richardson for Breast only  5 = Fuhrman Nuclear Grade  8 = Other  9 = Not determined/not stated/not applicable  .

GRADE_CLASSIFICATION

Grade or cell type indicates the degree of differentiation of malignant tumours or the T-cell & B-cell designation for lymphoma's and leukaemia's.  There are various different grades used per type of tumour. References for this can be found in supplemental data  file: Grade Cell Type.doc and may require clinical guidance.

GRADE_CELL_TYPE

Histological Verification is microscopic confirmation of the histological or cytological diagnosis (including  examination of peripheral blood film). For post-97 registrations, HV-verified should correspond with  Most Valid Basis Of Diagnosis options 5-8.  NOTE - CIN 3 should only be registered if the diagnosis is based on histology, not cytology alone  Code Description  1 Verified  2 Not verified .

HIST_VER

Method of first detection indicates how the tumour was first detected.    1 = Screening examination  2 = Incidental finding  3 = Clinical presentation  4 = Incidental finding at autopsy  5 = Interval Cancer  8 = Other  9 = Not known.

METHOD_1ST_DETECTION

This field represents the clinical stage (breast and lung) indicates the extent of spread of the tumour at diagnosis in terms of clinical findings.     T-size/ Extent of Primary tumour based on clinical examination and/or imagining (e.g., Mammography).  .

STAGE_CLINICAL_T

Clinical N indicates a condition of regional lymph nodes/glands based on clinical examination and/or imaging..

STAGE_CLINICAL_N

Clinical stage M indicates distant metastases. .

STAGE_CLINICAL_M

Pathological Stage (breast and lung) indicates the extent of the spread of the tumour at diagnosis in terms of the pathological findings.    T-size/ Extent of Primary tumour based on clinical examination and/or imagining (e.g., Mammography).  .

STAGE_PATHOLOGIC_T

Pathological stage N indicates a condition of regional lymph nodes/glands based on clinical examination and/or imaging..

STAGE_PATHOLOGIC_N

Pathological Stage M indicates distant metastases.   .

STAGE_PATHOLOGIC_M

This field is collected for invasive lung tumours of 01/01/2005 incidence data. It indicates the extent of spread of invasive lung tumour.     The available options are as follows:    1 = Localised  2 = Regional Spread  3 = Distant Metastases  4 = Not Known.

CLINICAL_EXTENT_OF_DISEASE

FIGO Stage  indicates the extent of spread of the invasive primary tumour for cervix and ovary at diagnosis in terms of the pathological and/or clinical findings for Socrates. This field represents the FIGO stage after surgery.     .

STAGE_FIGO_AFTER_SURGERY

FIGO Stage indicates the extent of spread of the invasive primary tumour for cervix and ovary at diagnosis in terms of the pathological and/or clinical findings for Socrates. This field represents the FIGO stage before surgery. .

STAGE_FIGO_BEFORE_SURGERY

This field represents the tumour size of the cancer..

TUMOUR_SIZE

This field, which is a pathological nodal status, indicates if the regional lymph nodes were examined. It is associated with invasive breast cancer only.    0 = No    1 = Yes, a sample    2 = Yes, axillary node clearance    9 = Not Known  .

NODES_EXAMINED

This field, which is a pathological nodal status, indicates how many of the regional lymph nodes were examined.    .

NO_OF_NODES_EXAMINED

This field, which is a pathological nodal status, indicates if any of the regional lymph nodes were positive    0 = No    1 = Yes    9 = Not Known  .

POSITIVE_NODES

This field, which is a pathological nodal status, indicates how many of the regional lymph nodes were positive    Option range: 0-99 or NK - not known.

NO_POSITIVE_NODES

This field represents the date of first surgical treatment..

DATE_1ST_SURGERY

This field indicates if the patient was referred to a Radiotherapy department or not.    0 = No  1 = Yes   7 = Planned to refer   9 = Not known.

REF_TO_RAD

This field indicates if the patient has been treated with Radiotherapy.     The options available are:    0 = No   1 = Yes   7 = Planned   9 = Not known  .

TREATED_WITH_RAD

This field represents the Radiotherapy treatment to primary site.    N = No  Y = Yes   U = Not known  .

RAD_TO_PRIMARY

This field represents the Radiotherapy treatment to Metastases. .    N = No  Y = Yes   U = Not known  .

RAD_TO_METS

This field represents the Radiotherapy treatment to Other such as organ ablation or prophylaxis.     N = No  Y = Yes   U = Not known  .

RAD_OTHER

This field represents the date of first Radiotherapy treatment..

DATE_1ST_RAD

This field indicates if a patient has had systemic chemotherapy treatment.  The options available are as follows:     0 = No   1 = Yes  7 = Planned   9 = Not known.

CHEMO

This field represents the date of first Chemotherapy..

DATE_1ST_CHEMO

This field indicates if a patient has had Hormone  treatment. It is most likely to apply to Breast, Prostate, Endometrial (uterus) and to a lesser extent, hypernephroma.     0 = No   1 = Yes   7 = Planned   9 = Not known  .

HORM_THERAPY

This field represents the date of first Hormone Therapy treatment..

DATE_1ST_HORM

This field represents the date of first Other Therapy..

DATE_1ST_OTHER_THERAPY

This is the alpha and/or numeric Health Board code in which the patient CHI information was extracted from. .

HB_of_Residence

VITAL_STATUS

This is collected for registrations of cutaneous malignant melanoma. It is a measure of the depth of invasion of the melanoma into the skin in mm.    Option Range: 00 – 99 or ## – not known.

MELANOMA_SKIN_BRESLOW_SIZE

This is a measure of depth of invasion of the melanoma into the skin. The available levels are as follows:    I = Level I  II = Level II  III = Level III  IV = Level IV  NK = Not Known  V = Level V  .

MELANOMA_SKIN_CLARKS_LEVEL

The term ‘microinvasive’ is used to describe a degree of invasion which is not associated with any risk of nodal metastasis and is sufficiently small to treat by local or conservative means.    0 = No  1 = Yes  9 = Not known  .

MICROINVASIVE

There are two tests available to measure over-expression of HER2 receptors in a tumour cell.  a) Immunochemistry HER2 receptor test (IHC) shows how much of the HER2 protein is present in  a tumour cell.  b) Fluorescence in-situ hybridisation (FISH).If the HER2 test results are borderline this additional  more accurate test, will be carried out to confirm a positive or negative result.   Code Description  0 Negative  1 Positive  9 Not Known.

HER2

Unique number generated for CDP (Cancer Data Processing) for all notifications.

ACCESSION_NO

Indexed ICD and OPCs codes for searching and filtering, but not for extraction..

Search

Lookup value for ADMISSION_TRANSFER_FROM_LOC.

ADMISSION_TRANSFER_FROM_LOC_Desc

The Mental Health Inpatient and Day Case dataset (SMR04) collects episode level data on patients who are receiving care at psychiatric hospitals at the point of both admission and discharge. The dataset contains a wide variety of information such as patient characteristics, mental health diagnosis, length of stay, destination on discharge, whether they are admitted under Mental Health Legislation and any previous psychiatric care. Patient identifiers such as name, date of birth, Community Health Index number, NHS number, and postcode are included together with a wide variety of geographical measures. This includes the Scottish Index of Multiple Deprivation and Carstairs measures, census output area, NHS Board, Electoral Ward and Parliamentary constituency.

SHARE NAT_SMR04

Lookup value for DISCHARGE_TRANSFER_TO_LOCATION.

DISCHARGE_TRANSFER_TO_LOCATION_Desc

This field represents the description relating to the sending location code.

SENDING_LOCATION_Desc

LOCATION_Desc

DISCHARGE_TRANSFER_TO_Desc

ADMISSION_REASON_Desc

SPECIALTY_Desc

SIGNIFICANT_FACILITY_Desc

ADMISSION_TYPE_Desc

DISCHARGE_TYPE_Desc

Sending Location is a five character alpha-numeric code used in data processing to identify the NHS organisation where an SMR submission has been sent from..

SENDING_LOCATION

This field denotes a sequential number known as the Episode Record Key.

EPISODE_RECORD_KEY

This field represents the location code at which health activity takes place. In other words, the location code represents the point of delivery of health care.  . The statistical considerations for this entry are study specific. It is determined by the researchers in relation to their particular study. In some cases the Statistical Considerations field will remain blank because there is no information to provide for a specific entry. The location entry will only have a purpose if the researcher is studying multiple locations.

LOCATION

This field represents a specialty which is defined as a division of medicine or dentistry covering a specific area of clinical activity and identified within one of the Royal Colleges or Faculties..

SPECIALTY

This field represents a clinical facility code, which is of interest for clinical and/or contracting purposes.   .

SIGNIFICANT_FACILITY

This field represents the date on which an inpatient or day case admission occurs.   .

ADMISSION_DATE

This field is a numeric code which describes the inpatient admission type. An inpatient admission is categorised as an emergency, urgent or routine inpatient admission except for Maternity and Neonatal admissions. The appropriate admission category depends on the clinical condition of the patient as assessed by the receiving consultant..

ADMISSION_TYPE

Admission reason indicates the primary reason why a patient is admitted.    .

ADMISSION_REASON

This field represents the source of admission, or type of location from which a patient has been admitted..

ADMISSION_TRANSFER_FROM

This field represents the location code, where appropriate, of the location from where a patient is admitted. .

ADMISSION_TRANSFER_FROM_LOC

This field represents the date on which a patient is discharged from an episode of care..

DISCHARGE_DATE

This field indicates whether a discharge from an inpatient or day case episode is regular, irregular (e.g., self-discharge) or as a result of the patient's death.    .

DISCHARGE_TYPE

This field represents the type of location to which a patient is discharged following an episode of care.  .

DISCHARGE_TRANSFER_TO

This field represents the location code, where appropriate, of a patient's destination following discharge from an episode of care.  .

DISCHARGE_TRANSFER_TO_LOCATION

This field describes the main medical or social condition managed/investigated during the patient's stay.     The International Statistical Classification of Diseases and Related Health Problems (ICD) is a detailed index of diseases and injuries that is developed and released by the World Health Organisation (WHO). Details of a diagnosis are recorded by a clinician in the patient's medical notes. These are translated into ICD-10 codes by a clinical coder. This allows consistency when selecting and comparing conditions. It is possible to select and compare conditions consistently, not only in Scotland but also across the world wherever ICD-10 is used. The information can be used for epidemiological purposes, health service planning and clinical audit at both a national and local level.    ICD is revised periodically and is currently in its tenth edition. ICD-10 was developed in 1992 to track morbidity statistics and Scotland adopted its use in 1996. Since its launch there have been 2 major updates and minor annual updates which are published by WHO. ICD-10 Version 5 (5th edition 2016) is the current standard used in NHS Scotland and was implemented for the recording of patient morbidities detailed in hospital discharges on and after April 1st 2016.    https://www.isdscotland.org/products-and-services/terminology-services/coding-and-terminology-systems/.

MAIN_CONDITION

This field represents other medical conditions which contributed to the decision to admit the patient or which were identified on admission as requiring management. This field is also referred to as Diagnosis 2..

OTHER_CONDITION_1

This field represents other medical conditions which contributed to the decision to admit the patient or which were identified on admission as requiring management. This field is also referred to as Diagnosis 3..

OTHER_CONDITION_2

This field represents other medical conditions which contributed to the decision to admit the patient or which were identified on admission as requiring management. This field is also referred to as Diagnosis 4..

OTHER_CONDITION_3

This field represents other medical conditions which contributed to the decision to admit the patient or which were identified on admission as requiring management. This field is also referred to as Diagnosis 5..

OTHER_CONDITION_4

This field represents other medical conditions which contributed to the decision to admit the patient or which were identified on admission as requiring management. This field is also referred to as Diagnosis 6..

OTHER_CONDITION_5

The main operation is that selected by the clinician responsible for the care of the patient. Part A is used for single codes or for the primary part of a recognised code-pair.     The Office of Population Censuses and Surveys' Classification of Surgical Operations version-4 (OPCS-4) was first issued in September 1987 to record operations and procedures carried out in the acute sector although coding of surgical procedures had been ongoing since 1944. It is now in its sixth revision with the latest release, OPCS-4.7, implemented in April 2014 and was expanded to include interventions. In Scotland OPCS codes are used in SMR returns to record operations, procedures and interventions. The NHS Digital Clinical Classifications Services maintain and develop OPCS on behalf of the UK. OPCS-4.8 is the current standard used in NHS Scotland and was implemented for the recording of patient interventions detailed in hospital discharges on and after April 1st 2017.      https://www.isdscotland.org/products-and-services/terminology-services/coding-and-terminology-systems/.

MAIN_OPERATION

This field represents the date when the main operation was performed. The date is in the format CCYYMMDD..

DATE_OF_MAIN_OPERATION

This field represents other operation entered in the order specified by the clinician. This part is used for single codes or for the primary part of a recognised code-pair..

OTHER_OPERATION_1

This field represents the date when other operation was performed. The date is in the format CCYYMMDD..

DATE_OF_OTHER_OPERATION_1

OTHER_OPERATION_2

DATE_OF_OTHER_OPERATION_2

OTHER_OPERATION_3

SHARE

The Prescribing Information System (PIS) is the definitive data source for all prescribing relating to all medicines and their costs that are prescribed and dispensed in the community in Scotland. The information is supplied by Practitioner & Counter Fraud Services Division (P&CFS) who is responsible for the processing and pricing of all prescriptions dispensed in Scotland. These data are augmented with information on prescriptions written in Scotland that were dispensed elsewhere in the United Kingdom. GP’s write the vast majority of these prescriptions, with the remainder written by other authorised prescribers such as nurses and dentists. Also included in the dataset are prescriptions written in hospitals that are dispensed in the community. Note that prescriptions dispensed within hospitals are not included. Data includes CHI number, prescriber and dispenser details for community prescribing, costs and drug information. Data on practices (e.g. list size), organisational structures (e.g. practices within Community Health Partnerships (CHPs) and NHS Boards), prescribable items (e.g. manufacturer, formulation code, strength) are also included.

SHARE NAT_PIS

SMR00 relates to all outpatients (new and follow-up) in specialties other than Accident & Emergency (A&E), and Genito-Urinary Medicine.  SMR00 includes follow-up as well as new attendances and Did Not Attends (DNAs) where computer recording is in place. Furthermore, in addition to the basic administrative data set, it allows the recording of procedural information, for which a "Short list of Procedures performed on Outpatients" has been drawn up (Refer to SMR Data Manual for codes and values).  There are a number of fields that are predominantly blank and reserved for the inclusion of diagnostic information which is a possible future development (for ISD).

SHARE NAT_SMR00

SHARE NAT_SMR02

This dataset collects episode level data on hospital inpatient and day case charges from acute specialities from hospitals in Fife and Tayside, Scotland. If you are interested in full hospital admissions, you should be aware that a hospital admission, or hospitalisation consists of one or more episodes - which essentially represent transfer between wards, clinicians etc.   In order to link these records together into full admissions, please use the CIS_Marker or GLS_CIS_Marker - further detail is in the metadata for these individual fields.

SHARE

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin