SCI-Diabetes provides a fully integrated shared electronic patient record to support treatment of NHSScotland patients with Diabetes

ADR  > SCI Diabetes @ 133

SCI Diabetes brings together the functionality of SCI-DC Network and SCI-DC Clinical and also includes specialty modules for Paediatrics, Podiatry, Diabetes Specialist Nursing and Dietetics
SCI-Diabetes is developed, maintained and supported by the SCI-DC Development Team based in the Clinical Technology Centre, Ninewells Hospital, Tayside.

Scottish Health Data

NHS Scotland

PROCHI

Data for around 48 patients in Tayside who have be part of a randomised control trial over the last 18 months. Project 3301 LINK-1882

SCI-Diabetes - Analysis of a RCT - SCI-Diabetes

StudyID

This field represents the recruitment date.

recruitmentDate

This field represents the patient status.

randomised

Diabetes treatment - management and treatment type

Diabetes - Treatment Type

This field represents the date of the record .

Date

This field represents where the patient is managed (Primary care, GP...etc).

DiabetesCareType

This field represents the type of treatement received.

DiabetesTreatmentType

This field representss the values (Yes,NO) to indicated wether the patient attend an outpatient clinic or not.

HospitalDiabetesClinicAttendance

This field represents whether the patient using Insulin Pump or not.

InsulinPumpTherapyDevice

This field represents the Data Source ID provided by SCI_Diabetes lookup table.

DataSourceId

PopulationID_User acts with DataSourceID to give the DataSource_Description.

PopulationId_User

This field represents the Additional Source ID data to fully Identify the Data Source in addition to DataSourceId field.    This field may have the GP number when the GP is the source of data- this data is suppressed and special approval is need to access this field  .

PopulationId

This field represents the data source description - combination of DatasourceID and PopulationID.

DataSource_Description

As SCI-DC will not use a structured format for most of these data, data items mapped must be linked using ‘TransactionId’.

TransactionId

hic_dataLoadRunID

hic_validFrom

A simplified view of the raw smoking data.  A list of patients and a flag indicating any evidence of smoking in their records.  Refer to Raw Smoking dataset for complete SCIDiabetes data.  This dataset gives a view of whether someone has ever smoked.

Diabetes - Smoking Cleaned

Flag indicating any evidence of smoking in the raw smoking data.   Populated with 1 where patient has any record, past or present indicating:   Current Status as 'Current smoker' or 'Ex-smoker’  OR Year Patient Stopped Smoking = 'Yes’  OR Cigarettes Smoked Per Day > 0  .

Evidence of Ever Smoking

Date of the first record indicating a positive smoking status.  Blank if the patient does not have evidence of smoking..

First Evidence of Smoking

Date of the most recent record of a patient with no evidence of smoking.  Blank if the patient has at least one evidence of smoking..

Last Record of Never Smoking

Cleaned measurement data consisting of weight in KGs, standardised height in metres, calculated and supplied BMI.  Height is only standardised for those aged >= 16, due to difficulties validating these measurements in adolescence.

Diabetes - Merged Height Weight BMI - Cleaned

When Special data Cleaning Flag = 0:  Standardised median Height based on all valid heights of a patient, that were taken over a specific age threshold, rounded to 2 decimal places.  Height is the median of all non-extreme heights over a specific age limit. Height is treated as static measurement.  Extreme values are determined by checking against both low and high boundaries.  Valid Height excludes extreme values outwith 1 - 2.5m.    When Special data Cleaning Flag = 1:  Height is the mean of non-extreme measurements on the same day if the maximum difference is not more than the threshold (0.035m).  Only includes measurements under the specified age threshold  Height is considered as changing variable.  Extreme values are determined by checking only against the high boundary, allowing values smaller than the low boundary.  Valid Height excludes extreme values above 2.5m.  .

Height

New description:  Only includes records if validation status is ‘Single Weight’ or ‘Averaged’.  Weight is treated as a changing variable. In reality there are limits to the changes depending on the timeframe, but it is difficult to distinguish between real changes to a person’s weight and measurement errors. These have not been filtered.    For multiple weights on the same day, the mean of the distinct valid weights is taken, if the maximum difference is with a 1Kg threshold.  If the maximum difference is greater than the threshold, the measurements have been excluded as indeterminate (these can be seen in the raw dataset where validation status: indeterminate).    Extreme values are determined by checking against both low and high boundaries when Special data Cleaning Flag is 0.  Valid weight excludes extreme values outwith 5 - 300Kg.    When Special data Cleaning Flag is 1, extreme values are determined by checking only against the high boundary, allowing values smaller than the low boundary.  Valid Weight excludes extreme values above 300Kg.    If complete data is required, please refer to the Raw Weight table.  A small number of patients are excluded from the cleaned table, due to not having any ‘valid’ weights.      Original description:  Weight is the corrected weight from the raw table  Only includes records if validation status is ‘Single Weight’ or ‘Averaged’.  Adult weight is treated as a changing variable. In reality there are limits to the changes depending on the timeframe, but it is difficult to distinguish between real changes to a person’s weight and measurement errors. These have not been filtered.  Multiple weights on the same-day with high variance are excluded (these can be seen in the raw dataset where validation status: indeterminate).  If complete data or non-adult measurements are required, please refer to the Raw Weight table.  A small number of patients are excluded from the cleaned table, due to not having any ‘valid’ adult weights.    .

Weight

Only includes records if validation status is ‘Single’ or ‘Take Average’.  If the validation status is ‘Take Average’, the mean of the BMIs on the same day is used, if single, it is just the BMI.  BMI is treated as a changing variable.  If complete data is required, please refer to the Raw BMI table.  A small number of patients maybe excluded from the cleaned table, due to not having any ‘valid’ BMIs.  This is supplied for comparison, due to the nature of how the data was collected, large variation in height makes this column unreliable, however difficulties in standardising height and weight mean that occasionally this maybe closer to reality when calculated BMI produces an unusual value.  .

Original_BMI

Calculated from standardised median Height, Weight with standard BMI calculation.  In most cases this is better quality than the original BMI. We supply the original BMI for transparency..

Calculated BMI

This field represents whether the patient is under 16.

under16

temp rename acronym from Diabetes - Summary to Diabetes_Diagnosis  This data set provides an overview of the type of diabetes, the date it was diagnosed, the treatment type and healthboard the patient belongs to.

Diabetes - Main Diagnosis Type Summary

This field represents the type of diabetes the patient was last diagnosed as suffering from e.g. 'Type 2 Diabetes Mellitus',  'Impaired Fasting Glucose' etc.

DiabetesMellitusType

This field represents the type of treatment received for Diabetes..

DiabetesMellitusType_Mapped

This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from .

DiabetesMellitusType_DataSourceName

This field represents the date the patient was diagnosed with diabetes.  SCI Diabetes represents NULL, or no date available as 1899. These should be ignored. .

DateOfDiagnosisDiabetes_Date

DateOfDiagnosisDiabetes_DataSourceName

DiabetesTreatmentType_Mapped

Lower Limb Raw dataset cleaned.  There is only one record per CHI and Date. Where the raw data has more than one values for the same attribute, the value becomes ambiguous, and has been replaced by 'HICconflictingValues'.  Raw data is also provided for the purpose of investigating these ambiguous, conflicting values.  Refer to documentation for details on data cleaning.

Diabetes - LowerLimbsCleaned

date/time associated with the clinical data held in the record.

DataItemDate

This field represents vibration felt in patients left foot.

FootVibrationLeft

This field represents vibration felt in patients right foot.

FootVibrationRight

This field represents peripheral pulses on the right hand side of the patient.

PeripheralPulsesRight

This field represents peripheral pulses on the left hand side of the patient.

PeripheralPulsesLeft

This field represents the use of monofilament on right sites.

MonofilamentRightSites

This field represents the use of monofilament on left sites.

MonofilamentLeftSites

This field represents sensation in patients left foot .

FootSensationStatusLeft

This field represents sensation in patients right foot.

FootSensationStatusRight

This field represents structural abnormaility on the right.

StructuralAbnormalityRight

This field represents structural abnormaility on the left.

StructuralAbnormalityLeft

This field represents the patients Left foot risk status.

DiabeticFootRiskStatusLeft

This field represents the patients Right foot risk status.

DiabeticFootRiskStatusRight

This field represents calluses present on the patients right foot.

FootCallusRight

This field represents calluses present on the patients left foot.

FootCallusLeft

The Neurothesiometer is used for the determination of vibration sensitivity threshold at any desired site on the body surface.

NeurothesiometerAssessmentLeft

NeurothesiometerAssessmentRight

This field represents whether painful neuropathy was detected.  The data is defined by:      Absent   HIC_ConflictingValues   Not Known   Present   .

PainfulNeuropathy

Diabetes - Foot Ulcers

This field represents the date of the record.  This date is associated with the Active Ulcer record and if there is a 'Yes' in the Active Ulcer Left/Right Stop then the date is when the active ulcer expired.

This field represents whether the patient has an active ulcer on the left foot.   The data is either a Yes or No and may state whether a side is specified or unspecified..

ActiveUlcerLeft

This field represents whether the patient has an active ulcer on the left foot.   The data is either a Yes or No and may state whether a side is specified or unspecified.  If yes , date associated with the record is the date when the active ulcer expired.

ActiveUlcerLeft_End

This field represents whether the patient has an active ulcer on the Right foot.   The data is either a Yes or No and may state whether a side is specified or unspecified..

ActiveUlcerRight

This field represents whether the patient has an active ulcer on the Right  foot.   The data is either a Yes or No and may state whether a side is specified or unspecified.  If yes , date associated with the record is the date when the active ulcer expired.

ActiveUlcerRight_End

This field represents previous ulceration.

PrevUlceration

This field indicates whether there was a previous active ulcer in left foot  The data is either a Yes or No and may state whether a side is specified or unspecified..

PreviousUlcerLeft

Indicates whether there was a previous active ulcer in right foot  The data is either a Yes or No and may state whether a side is specified or unspecified..

PreviousUlcerRight

Can have idenifiable data and need special approval to release.

Gives the data source as represented by DatasourceID and PopulationID.

An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations.

Diabetes - Eyes

This field represents the date at which the eye examination occured.

Indicate whether the patient is registered blind or not.

BlindRegistrationStatus

Indicates if the patient is blind and whether this blindness is diabetic related or not..

BlindnessStatus

This field represents Cateract extraction (left eye)..

CataractExtractionLeft

This field represents Cateract extraction (right eye)..

CataractExtractionRight

This field represents Cataract status (left).

CataractStatusLeft

This field represents Cataract status (right).

CataractStatusRight

This field represents Diabetic Retinopathy Screening (DRS) Quality Assurance Result Indicator  Results defined with:   EC-QARI-00  EC-QARI-01  N  Q.

DRSQAResultIndicator

EyeExaminationMethod

This field represents whether the patient has Glaucoma.    .

Glaucoma

This field represents Laser eye therapy (left).

LaserEyeTherapyLeft

This field represents Laser eye therapy (right).

LaserEyeTherapyRight

This field represents Laser photocoagulation scars left eye.

LaserPhotocoagulationScarsLeft

This file represents Laser photocoagulation scars right  eye.

LaserPhotocoagulationScarsRight

This field represents a maculopathy Left.

MaculopathyLeft

This field represents a maculopathy right.

MaculopathyRight

This field represents Non diabetic retinal lesions left.

NonDiabeticRetinalLesionsLeft

This field represents Non diabetic retinal lesions right.

NonDiabeticRetinalLesionsRight

This field represents a Retinopathy left .

RetinopathyLeft

This field represents a Retinopathy right .

RetinopathyRight

This field represents the Retinopathy screening status.

RetinopathyScreeningStatus

This field represents Visual acuity left.

VisualAcuityLeft

This field represents visual accuity correction status (left eye).

VisualAcuityCorrectionStatus_Left

This field represents Visual acuity right.

VisualAcuityRight

This field represents visual accuity correction status (right eye).

VisualAcuityCorrectionStatus_Right

SCI Diabetes

Copy of Diabetes - Main Diagnosis Type Summary, to substitute deprecated catalogue Diabetes - CD Diabetes Summary.  The Cat PK is CHI(PROCHI) - Date of Diagnosis to match target table in DB3 GoShareGS.  The PK of the underlying table is masterCHI, CHI

Diabetes - Diagnosis

Diabetes - CD Diabetes Longitudinal

Ethnicity summary from SCIDiabetes. One record per person

Diabetes - Ethnicity

This table gives a list of conditions that the patient might have.

Diabetes - Clinical Outcomes

Longitudinal amputation records of diabetic patients

Diabetes - Amputations

Lower Limb Raw dataset cleaned.  There is only one record per CHI and Date. Where the raw data has more than one values for the same attribute, the value becomes ambiguous, and has been replaced by "HICconflictingValues".  Raw data is also provided for the purpose of investigating these ambiguous, conflicting values.  Refer to documentation for details on data cleaning.

Longitudinal data of Average weekly alcohol intake in units and Alcohol Status.  Alcohol status is very sparse compared to average weekly intake.

Diabetes - Alcohol

Diabetes - Extended Summary

Blood Pressure measurements from SCIDiabetes

SCI Diabetes

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin