SCI Diabetes
Summary
Abstract
SCI-Diabetes provides a fully integrated shared electronic patient record to support treatment of NHSScotland patients with Diabetes
-
Contact point
-
Digital object identifier (DOI)Not available
Keywords
Publisher
-
NameHealth Informatics Centre - University of Dundee
-
Logo
Not available
-
DescriptionNot available
-
Contact pointNot available
Documentation
Description
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.
-
Associated media
- Not available
-
Is part of
- Not available
-
Landing page
Coverage
Spatial
-
Spatial coverage
United Kingdom, Scotland
-
Geographic levelsNot available
Temporal
-
Start date01/01/1970
-
End dateNot available
-
FrequencyContinuous
-
Distribution release date19/05/2022
Provenance
-
PurposeDisease registry
-
SourceOther
-
Collection situationOther
Access and governance
-
Conditions of accessGeneral research use
Requesting access to this data
This is a secure dataset that can only be accessed by researchers from approved organisations.
Find out how to apply to access this dataset
Usage
-
Conditions of useDisclosure control, Ethics approval required
-
Resource creatorNHS Scotland
-
Is referenced byNot available
Access
-
Access rights
-
Access serviceHIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data. Data is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis. Full details are available via the following link: https://www.dundee.ac.uk/hic/safe-haven
-
JurisdictionGB-SCT
-
Data controllerLocal NHS boards
-
Data processorUniversity of Dundee, Health Informatics Centre
Format and standards
-
LanguageEnglish
-
FormatDatabase
Enrichment and linkage
-
Related datasets
- Not available
-
Linkage opportunityNot available
-
Tools
- Not available
Synthetic data
Synthetic data is not yet available for this dataset.
Technical information
A JSON file is available with further technical information. This can include details of variables and data classes contained in the dataset.
Preview of JSON file
{
"summary": {
"title": "SCI Diabetes",
"abstract": "SCI-Diabetes provides a fully integrated shared electronic patient record to support treatment of NHSScotland patients with Diabetes",
"keywords": "SCIDiabetes;,;Eye;,;Amputation;,;smoking;,;Weight;,;Tayside;,;Fife;,;HIC;,;SCOTLAND",
"publisher": {
"name": "Health Informatics Centre - University of Dundee",
"gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
},
"inPipeline": "Not available",
"shortTitle": "SCI Diabetes",
"datasetType": "Health and disease",
"description": "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\nSCI-Diabetes is developed, maintained and supported by the SCI-DC Development Team based in the Clinical Technology Centre, Ninewells Hospital, Tayside.",
"contactPoint": "hicsupport@dundee.ac.uk",
"datasetSubType": "Not applicable",
"populationSize": 112514
},
"coverage": {
"pathway": "Secondary care records for Tayside and Fife",
"spatial": "United Kingdom,Scotland",
"followUp": "Unknown",
"typicalAgeRange": "0-150"
},
"required": {
"issued": "2024-10-08T11:28:34.698271Z",
"version": "1.0.0",
"modified": "2024-10-08T11:28:34.698282Z",
"gatewayId": "133",
"revisions": [
{
"url": "https://web.prod.hdruk.cloud//dataset/133?version=1.0.0",
"version": "1.0.0"
}
],
"gatewayPid": "2d09ec7a-8a3a-473a-865f-722084983827"
},
"provenance": {
"origin": {
"source": "Other",
"purpose": "Disease registry",
"imageContrast": "Not stated",
"collectionSituation": "Other"
},
"temporal": {
"timeLag": "Not applicable",
"startDate": "1970-01-01",
"accrualPeriodicity": "Continuous",
"distributionReleaseDate": "2022-05-19"
}
},
"observations": [
{
"observedNode": "Persons",
"measuredValue": 112514,
"observationDate": "2022-05-18",
"measuredProperty": "COUNT",
"disambiguatingDescription": "112,514 persons in this dataset"
}
],
"accessibility": {
"usage": {
"resourceCreator": {
"name": "NHS Scotland"
},
"dataUseLimitation": "General research use",
"dataUseRequirement": "Disclosure control;,;Ethics approval required"
},
"access": {
"accessRights": "https://www.dundee.ac.uk/hic/governance-service",
"jurisdiction": "GB-SCT",
"accessService": "HIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data.\n\nData is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis.\n\nFull details are available via the following link:\nhttps://www.dundee.ac.uk/hic/safe-haven",
"dataProcessor": "University of Dundee, Health Informatics Centre",
"dataController": "Local NHS boards",
"deliveryLeadTime": "2-4 weeks",
"accessRequestCost": "Quotation available on request",
"accessServiceCategory": "TRE/SDE"
},
"formatAndStandards": {
"formats": "Database",
"languages": "en",
"vocabularyEncodingSchemes": "LOCAL"
}
},
"structuralMetadata": [
{
"name": "SCI-Diabetes - Analysis of a RCT - SCI-Diabetes",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "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"
},
{
"name": "SCI-Diabetes - Analysis of a RCT - SCI-Diabetes",
"columns": [
{
"name": "StudyID",
"dataType": "int",
"sensitive": false,
"description": "This field represents the study ID."
}
],
"description": "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"
},
{
"name": "SCI-Diabetes - Analysis of a RCT - SCI-Diabetes",
"columns": [
{
"name": "recruitmentDate",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the recruitment date."
}
],
"description": "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"
},
{
"name": "SCI-Diabetes - Analysis of a RCT - SCI-Diabetes",
"columns": [
{
"name": "randomised",
"dataType": "varchar(7)",
"sensitive": false,
"description": "This field represents the patient status."
}
],
"description": "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"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(11)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "This field represents the date of the record ."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "DiabetesCareType",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents where the patient is managed (Primary care, GP...etc)."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "DiabetesTreatmentType",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents the type of treatement received."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "HospitalDiabetesClinicAttendance",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field representss the values (Yes,NO) to indicated wether the patient attend an outpatient clinic or not."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "InsulinPumpTherapyDevice",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents whether the patient using Insulin Pump or not."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "PopulationId_User",
"dataType": "varchar(50)",
"sensitive": false,
"description": "PopulationID_User acts with DataSourceID to give the DataSource_Description."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "PopulationId",
"dataType": "int",
"sensitive": false,
"description": "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 ."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "DataSource_Description",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents the data source description - combination of DatasourceID and PopulationID."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "TransactionId",
"dataType": "varchar(100)",
"sensitive": false,
"description": "As SCI-DC will not use a structured format for most of these data, data items mapped must be linked using ‘TransactionId’."
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Treatment Type",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Diabetes treatment - management and treatment type"
},
{
"name": "Diabetes - Smoking Cleaned",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "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."
},
{
"name": "Diabetes - Smoking Cleaned",
"columns": [
{
"name": "Evidence of Ever Smoking",
"dataType": "int",
"sensitive": false,
"description": "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 ."
}
],
"description": "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."
},
{
"name": "Diabetes - Smoking Cleaned",
"columns": [
{
"name": "First Evidence of Smoking",
"dataType": "date",
"sensitive": false,
"description": "Date of the first record indicating a positive smoking status. Blank if the patient does not have evidence of smoking.."
}
],
"description": "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."
},
{
"name": "Diabetes - Smoking Cleaned",
"columns": [
{
"name": "Last Record of Never Smoking",
"dataType": "date",
"sensitive": false,
"description": "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.."
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "Date of measurement, without time.."
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "Height",
"dataType": "decimal(10,2)",
"sensitive": false,
"description": "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. ."
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "Weight",
"dataType": "decimal(10,1)",
"sensitive": false,
"description": "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. ."
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "Original_BMI",
"dataType": "decimal(10,1)",
"sensitive": false,
"description": "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. ."
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "Calculated BMI",
"dataType": "decimal(10,1)",
"sensitive": false,
"description": "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.."
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "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."
},
{
"name": "Diabetes - Merged Height Weight BMI - Cleaned",
"columns": [
{
"name": "under16",
"dataType": "int",
"sensitive": false,
"description": "This field represents whether the patient is under 16."
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(13)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "DiabetesMellitusType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "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."
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "DiabetesMellitusType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the type of treatment received for Diabetes.."
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "DiabetesMellitusType_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "DateOfDiagnosisDiabetes_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "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. ."
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "DateOfDiagnosisDiabetes_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "DiabetesTreatmentType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the type of treatment received for Diabetes.."
}
],
"description": "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."
},
{
"name": "Diabetes - Main Diagnosis Type Summary",
"columns": [
{
"name": "DiabetesTreatmentType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the type of treatment received for Diabetes.."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(11)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "DataItemDate",
"dataType": "date",
"sensitive": false,
"description": "date/time associated with the clinical data held in the record."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "FootVibrationLeft",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents vibration felt in patients left foot."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "FootVibrationRight",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents vibration felt in patients right foot."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "PeripheralPulsesRight",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents peripheral pulses on the right hand side of the patient."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "PeripheralPulsesLeft",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents peripheral pulses on the left hand side of the patient."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "MonofilamentRightSites",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents the use of monofilament on right sites."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "MonofilamentLeftSites",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents the use of monofilament on left sites."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "FootSensationStatusLeft",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents sensation in patients left foot ."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "FootSensationStatusRight",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents sensation in patients right foot."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "StructuralAbnormalityRight",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents structural abnormaility on the right."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "StructuralAbnormalityLeft",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents structural abnormaility on the left."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "DiabeticFootRiskStatusLeft",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents the patients Left foot risk status."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "DiabeticFootRiskStatusRight",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents the patients Right foot risk status."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "FootCallusRight",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents calluses present on the patients right foot."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "FootCallusLeft",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents calluses present on the patients left foot."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "NeurothesiometerAssessmentLeft",
"dataType": "varchar(500)",
"sensitive": false,
"description": "The Neurothesiometer is used for the determination of vibration sensitivity threshold at any desired site on the body surface."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "NeurothesiometerAssessmentRight",
"dataType": "varchar(500)",
"sensitive": false,
"description": "The Neurothesiometer is used for the determination of vibration sensitivity threshold at any desired site on the body surface."
}
],
"description": "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."
},
{
"name": "Diabetes - LowerLimbsCleaned",
"columns": [
{
"name": "PainfulNeuropathy",
"dataType": "varchar(500)",
"sensitive": false,
"description": "This field represents whether painful neuropathy was detected. The data is defined by: Absent HIC_ConflictingValues Not Known Present ."
}
],
"description": "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."
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(11)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "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."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "ActiveUlcerLeft",
"dataType": "varchar(800)",
"sensitive": false,
"description": "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.."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "ActiveUlcerLeft_End",
"dataType": "varchar(800)",
"sensitive": false,
"description": "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."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "ActiveUlcerRight",
"dataType": "varchar(800)",
"sensitive": false,
"description": "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.."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "ActiveUlcerRight_End",
"dataType": "varchar(800)",
"sensitive": false,
"description": "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."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "PrevUlceration",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents previous ulceration."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "PreviousUlcerLeft",
"dataType": "varchar(800)",
"sensitive": false,
"description": "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.."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "PreviousUlcerRight",
"dataType": "varchar(800)",
"sensitive": false,
"description": "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.."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "PopulationId_User",
"dataType": "varchar(50)",
"sensitive": false,
"description": "PopulationID_User acts with DataSourceID to give the DataSource_Description."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "PopulationId",
"dataType": "int",
"sensitive": false,
"description": "Can have idenifiable data and need special approval to release."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "DataSource_Description",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "Gives the data source as represented by DatasourceID and PopulationID."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "TransactionId",
"dataType": "varchar(100)",
"sensitive": false,
"description": "As SCI-DC will not use a structured format for most of these data, data items mapped must be linked using ‘TransactionId’."
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Foot Ulcers",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Foot ulcer data for SCI_Diabetes(new),"
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "This field represents the date at which the eye examination occured."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "BlindRegistrationStatus",
"dataType": "varchar(800)",
"sensitive": false,
"description": "Indicate whether the patient is registered blind or not."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "BlindnessStatus",
"dataType": "varchar(800)",
"sensitive": false,
"description": "Indicates if the patient is blind and whether this blindness is diabetic related or not.."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "CataractExtractionLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Cateract extraction (left eye).."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "CataractExtractionRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Cateract extraction (right eye).."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "CataractStatusLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Cataract status (left)."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "CataractStatusRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Cataract status (right)."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "DRSQAResultIndicator",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents Diabetic Retinopathy Screening (DRS) Quality Assurance Result Indicator Results defined with: EC-QARI-00 EC-QARI-01 N Q."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "EyeExaminationMethod",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "Eye Examination Method."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "Glaucoma",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents whether the patient has Glaucoma. ."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "LaserEyeTherapyLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Laser eye therapy (left)."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "LaserEyeTherapyRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Laser eye therapy (right)."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "LaserPhotocoagulationScarsLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Laser photocoagulation scars left eye."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "LaserPhotocoagulationScarsRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This file represents Laser photocoagulation scars right eye."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "MaculopathyLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents a maculopathy Left."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "MaculopathyRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents a maculopathy right."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "NonDiabeticRetinalLesionsLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Non diabetic retinal lesions left."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "NonDiabeticRetinalLesionsRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Non diabetic retinal lesions right."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "RetinopathyLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents a Retinopathy left ."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "RetinopathyRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents a Retinopathy right ."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "RetinopathyScreeningStatus",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents the Retinopathy screening status."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "VisualAcuityLeft",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Visual acuity left."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "VisualAcuityCorrectionStatus_Left",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents visual accuity correction status (left eye)."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "VisualAcuityRight",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents Visual acuity right."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "VisualAcuityCorrectionStatus_Right",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "This field represents visual accuity correction status (right eye)."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "PopulationId_User",
"dataType": "varchar(50)",
"sensitive": false,
"description": "PopulationID_User acts with DataSourceID to give the DataSource_Description."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "PopulationId",
"dataType": "int",
"sensitive": false,
"description": "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 ."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "DataSource_Description",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "Data Source description - combination of DatasourceID and PopulationID."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "TransactionId",
"dataType": "varchar(256)",
"sensitive": false,
"description": "As SCI-DC will not use a structured format for most of these data, data items mapped must be linked using ‘TransactionId’."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "id",
"dataType": "int",
"sensitive": false,
"description": "This field represents a numerical reference."
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Eyes",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "An amalgamation of data from SCIDC and SCIDiabetes clinical systems on eye healthiness: visual accuity, retinopathy, retinal imaging, laser therapy,cateracts and eye examinations."
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(13)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the type of diabetes as mapped with Phase 3 Data is defined by: Diabetes Resolved Diabetes Type not defined Diabetes in Remission Gestational Diabetes (Current) Impaired Glucose Metabolism and Other Other Type 1 Diabetes Mellitus Type 2 Diabetes Mellitus."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusType_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis and must be maintained as originally held.."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusType_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusType_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DateOfDiagnosisDiabetes",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DateOfDiagnosisDiabetes_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents whether the date has been mapped. Data is defined by: NULL Estimate Known Not Known Yes."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DateOfDiagnosisDiabetes_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DateOfDiagnosisDiabetes_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DateOfDiagnosisDiabetes_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesTreatmentType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesTreatmentType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the type of treatment received for Diabetes.."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesTreatmentType_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesTreatmentType_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesTreatmentType_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1c",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1c_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the HbA1c result."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1c_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1c_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1c_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalCholesterol",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalCholesterol_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the the total cholesterol results."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalCholesterol_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalCholesterol_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalCholesterol_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TriglycerideLevel",
"dataType": "varchar(20)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TriglycerideLevel_Mapped",
"dataType": "varchar(20)",
"sensitive": false,
"description": "This field represents the triglyceride levels."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TriglycerideLevel_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TriglycerideLevel_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TriglycerideLevel_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Creatinine",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Creatinine_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the result of a creatinine test."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Creatinine_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Creatinine_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Creatinine_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMI",
"dataType": "decimal(11,8)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMI_Mapped",
"dataType": "decimal(9,6)",
"sensitive": false,
"description": "This field represents the result of BMI test."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMI_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMI_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMI_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CurrentTobaccoNicotineConsumptionStatus",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CurrentTobaccoNicotineConsumptionStatus_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the current status for smoking/tobacco. The data is defined: NULL Current non-smoker Current smoker Ex-smoker Never smoked Not known Patient declined."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CurrentTobaccoNicotineConsumptionStatus_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CurrentTobaccoNicotineConsumptionStatus_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CurrentTobaccoNicotineConsumptionStatus_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "peripheral pulse refers to the palpation of the high-pressure wave of blood moving away from the heart through vessels in the extremities following systolic ejection. The data is defined by: NULL Both Absent Both Absent - Side Unspecified Either Palpable Either Palpable - Side Unspecified."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "peripheral pulse refers to the palpation of the high-pressure wave of blood moving away from the heart through vessels in the extremities following systolic ejection. The data is defined by: NULL Both Absent Both Absent - Side Unspecified Either Palpable Either Palpable - Side Unspecified."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the date the pulse was taken."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentLeftSites",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentLeftSites_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "simple instrument used in screening the diabetic foot for loss of protective sensation The data is defined by: NULL Absent Absent - Side Unspecified Not Known Present Present - Side Unspecified."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentLeftSites_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentLeftSites_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentLeftSites_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentRightSites",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentRightSites_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "data is defined with: Absent - Side Unspecified Present - Side Unspecified Present Absent Not Known ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentRightSites_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "this is a date field."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentRightSites_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MonofilamentRightSites_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "The person's current risk of developing a diabetic foot problem or needing an amputation using a risk stratification."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "The person's current risk of developing a diabetic foot problem or needing an amputation using a risk stratification."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusCombined",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusCombined_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "The person's current risk of developing a diabetic foot problem or needing an amputation using a risk stratification."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusCombined_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusCombined_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabeticFootRiskStatusCombined_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the area amputated."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the area amputated."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationSummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationSummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationSummary_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbAmputationSummary_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralVascularDisease",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralVascularDisease_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "The data is defined with Yes or NULL."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralVascularDisease_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralVascularDisease_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralVascularDisease_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreenedDate",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreenedDate_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the data mapped. The data is defined by: Done Yes ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreenedDate_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreenedDate_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreenedDate_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents mapped data. The data is defined by: BDR (Background Diabetic Retinopathy ) - Mild BDR - Observable BDR - Referable Enucleated No Retinopathy Not Adequately Visualised Other Proliferative Retinopathy Result not recorded Stable treated proliferative retinopathy ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents mapped data. The data is defined by: BDR (Background Diabetic Retinopathy ) - Mild BDR - Observable BDR - Referable Enucleated No Retinopathy Not Adequately Visualised Other Proliferative Retinopathy Result not recorded Stable treated proliferative retinopathy ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathyLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathySummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathySummary_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: BDR (Background Diabetic Retinopathy ) - Mild BDR - Observable BDR - Referable Enucleated No Retinopathy Not Adequately Visualised Proliferative Retinopathy Stable treated proliferative retinopathy ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathySummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathySummary_DataSourceId",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "RetinopathySummary_DataSourceName",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "simple instrument used in screening the diabetic foot for loss of protective sensation The data is defined by: NULL Absent Absent - Side Unspecified Not Known Present Present - Side Unspecified."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: None Observable Diabetic Maculopathy Referable Diabetic Maculopathy ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MaculopathyLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents mapped data.."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "VisualAcuityLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Angina",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Angina_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Angina_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Angina_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Angina_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MyocardialInfraction",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MyocardialInfraction_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by Yes or NULL."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MyocardialInfraction_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MyocardialInfraction_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "MyocardialInfraction_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Hypertension",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Hypertension_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Yes or Null."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Hypertension_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Hypertension_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Hypertension_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAUnspecified",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAUnspecified_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAUnspecified_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAUnspecified_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAUnspecified_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CoronaryArteryBypassSurgery",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CoronaryArteryBypassSurgery_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CoronaryArteryBypassSurgery_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the date of bypass."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CoronaryArteryBypassSurgery_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CoronaryArteryBypassSurgery_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "SystolicBloodPressure",
"dataType": "decimal(4,1)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "SystolicBloodPressure_Mapped",
"dataType": "decimal(4,1)",
"sensitive": false,
"description": "This field represents mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "SystolicBloodPressure_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "SystolicBloodPressure_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "SystolicBloodPressure_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiastolicBloodPressure",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiastolicBloodPressure_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiastolicBloodPressure_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiastolicBloodPressure_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiastolicBloodPressure_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BPSummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BPSummary_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BPSummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "The date the study started."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BPSummary_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BPSummary_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "EstimatedGlomerularFiltrationRate",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "EstimatedGlomerularFiltrationRate_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "EstimatedGlomerularFiltrationRate_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "EstimatedGlomerularFiltrationRate_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "EstimatedGlomerularFiltrationRate_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesSummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesSummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "date field."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesSummary_DataSourceId",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "PeripheralPulsesSummary_DataSourceName",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "eGFR_FromCreatinine",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BlindnessStatus",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BlindnessStatus_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BlindnessStatus_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BlindnessStatus_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BlindnessStatus_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminConcentration",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminConcentration_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminConcentration_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminConcentration_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminConcentration_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminCreatinineRatio",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminCreatinineRatio_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminCreatinineRatio_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminCreatinineRatio_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminCreatinineRatio_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TimedOvernightAlbuminExcretionRate",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TimedOvernightAlbuminExcretionRate_Mapped",
"dataType": "int",
"sensitive": false,
"description": "This field represents mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TimedOvernightAlbuminExcretionRate_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TimedOvernightAlbuminExcretionRate_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TimedOvernightAlbuminExcretionRate_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSLastScreenedDate",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSLastScreenedDate_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "Data defined with NULL or Yes."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSLastScreenedDate_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSLastScreenedDate_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSLastScreenedDate_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreeningStatus",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreeningStatus_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. Data is defined by: Appointment Booked Did Not Attend Episode Started Invited Invited With Pre-Booked Appointment Permanently Suspended Ready For Work Flow Temporarily Suspended Wait For Delivery Wait For Result Of Episode ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreeningStatus_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreeningStatus_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSScreeningStatus_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSSuspensionReason",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSSuspensionReason_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents mapped data. The data is defined by: CHI Record Inactive Deceased Informed Choice Not Diabetic Ophthalmology Care for DR Temporarily Unavailable Terminal Illness Total Loss of Vision Under Age Unfit for Treatment ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSSuspensionReason_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSSuspensionReason_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DRSSuspensionReason_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "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.."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "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.."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerSummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerSummary_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerSummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerSummary_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerSummary_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlcoholStatus",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlcoholStatus_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlcoholStatus_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlcoholStatus_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlcoholStatus_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAHaemorrhagic",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAHaemorrhagic_Date",
"dataType": "bit",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAHaemorrhagic_DataSourceId",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVAHaemorrhagic_DataSourceName",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVANonHaemorrhagic",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVANonHaemorrhagic_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVANonHaemorrhagic_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVANonHaemorrhagic_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVANonHaemorrhagic_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVASummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVASummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVASummary_DataSourceId",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CVASummary_DataSourceName",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Absent Present ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "date field."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Absent Present ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationSummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationSummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "date field."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationSummary_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProtectiveSensationSummary_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "InsulinPumpTherapyDevice",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "InsulinPumpTherapyDevice_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: No Yes ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "InsulinPumpTherapyDevice_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "InsulinPumpTherapyDevice_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "InsulinPumpTherapyDevice_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "The data is defined by: Diseases of exocrine pancreas Drug- or Chemical-induced Endocrinopathies Gestational diabetes-former diagnosis Idiopathic Immune-mediated (Classical) Immune-mediated (LADA) Impaired Fasting Glucose Impaired Glucose Tolerance Monogenic diabetes Not defined Stress-induced hyperglycaemia Type 2 diabetes-former diagnosis ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BloodGlucose",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BloodGlucose_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BloodGlucose_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BloodGlucose_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BloodGlucose_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1cAt1YearPostDiagnosis",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1cAt1YearPostDiagnosis_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1cAt1YearPostDiagnosis_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1cAt1YearPostDiagnosis_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "HbA1cAt1YearPostDiagnosis_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMILast30Plus",
"dataType": "decimal(12,6)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMILast30Plus_Mapped",
"dataType": "decimal(10,4)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMILast30Plus_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMILast30Plus_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "BMILast30Plus_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestUlcerStartDate",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestUlcerStartDate_Mapped",
"dataType": "datetime2",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined in date formatt dd/mm/yyyy."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestUlcerStartDate_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestUlcerStartDate_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestUlcerStartDate_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight1YearPreCurrWeight",
"dataType": "decimal(10,7)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight1YearPreCurrWeight_Mapped",
"dataType": "decimal(7,4)",
"sensitive": false,
"description": "This field represents mapped data.."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight1YearPreCurrWeight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight1YearPreCurrWeight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight1YearPreCurrWeight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight",
"dataType": "decimal(10,7)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight_Mapped",
"dataType": "decimal(7,4)",
"sensitive": false,
"description": "This field represents the mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "Weight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStartDate",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStartDate_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Yes OR NULL."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStartDate_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStartDate_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStartDate_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStopDate",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStopDate_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Yes OR NULL."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStopDate_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStopDate_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LatestPumpStopDate_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "IschaemicHeartDisease",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "IschaemicHeartDisease_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Yes or NULL ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "IschaemicHeartDisease_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "IschaemicHeartDisease_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "IschaemicHeartDisease_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "OtherCardiacRevascularisation",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "OtherCardiacRevascularisation_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Drug-eluting stent Stent ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "OtherCardiacRevascularisation_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "OtherCardiacRevascularisation_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "OtherCardiacRevascularisation_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TransientIschemicAttack",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TransientIschemicAttack_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents mapped data. The data ius defined bby: Yes ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TransientIschemicAttack_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TransientIschemicAttack_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TransientIschemicAttack_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CarotidEndarterectomy",
"dataType": "bit",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CarotidEndarterectomy_Mapped",
"dataType": "bit",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CarotidEndarterectomy_Date",
"dataType": "bit",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CarotidEndarterectomy_DataSourceId",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "CarotidEndarterectomy_DataSourceName",
"dataType": "bit",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationRight",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationRight_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Angioplasty Stent ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationRight_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationRight_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationRight_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationLeft",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationLeft_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Angioplasty ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationLeft_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationLeft_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationLeft_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationSummary",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationSummary_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Angioplasty Stent ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationSummary_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationSummary_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "LowerLimbRevascularisationSummary_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProteinCreatinineRatio",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProteinCreatinineRatio_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProteinCreatinineRatio_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProteinCreatinineRatio_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ProteinCreatinineRatio_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalUrinaryProtein",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalUrinaryProtein_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents mapped data."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalUrinaryProtein_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalUrinaryProtein_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "TotalUrinaryProtein_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLastChangeToYes",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLastChangeToYes_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "The data is defined with Null, No and Yes."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLastChangeToYes_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLastChangeToYes_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "ActiveUlcerLastChangeToYes_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "InsulinType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "InsulinType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the mapped data. The data is defined by: Not on insulin On analog insulin On insulin On long and intermediate insulin ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesTreatmentTypeExpiry",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType3",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType3_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents whether the data has been mapped. The data is defined by: ABCC8 Cushing's syndrome Cystic fibrosis GATA6 GCK Glucocorticoids HNF1A HNF1B HNF4A Mitochondrial DNA (Other) Neoplasia Other Pancreatitis Surgery m.3243A>G ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType3_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType3_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "DiabetesMellitusSubType3_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminExcretionRate24h",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminExcretionRate24h_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminExcretionRate24h_Date",
"dataType": "datetime2",
"sensitive": false,
"description": "This is simply the date of the result, test, measurement or clinical diagnosis."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminExcretionRate24h_DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Extended Summary",
"columns": [
{
"name": "AlbuminExcretionRate24h_DataSourceName",
"dataType": "varchar(256)",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - Ethnicity",
"columns": [
{
"name": "PROCHI",
"dataType": "char(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "Ethnicity summary from SCIDiabetes. One record per person"
},
{
"name": "Diabetes - Ethnicity",
"columns": [
{
"name": "Ethnicity",
"dataType": "varchar(max)",
"sensitive": false,
"description": "This field represents the patients ethnicity."
}
],
"description": "Ethnicity summary from SCIDiabetes. One record per person"
},
{
"name": "Diabetes - Ethnicity",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Ethnicity summary from SCIDiabetes. One record per person"
},
{
"name": "Diabetes - Ethnicity",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Ethnicity summary from SCIDiabetes. One record per person"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(13)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "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"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "DiabetesMellitusType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "DiabetesMellitusType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "DiabetesMellitusType_Source",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "Date_of_Diagnosis",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "DateOfDiagnosisDiabetes_Source",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "DiabetesTreatmentType",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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"
},
{
"name": "Diabetes - Diagnosis",
"columns": [
{
"name": "DiabetesTreatmentType_Mapped",
"dataType": "varchar(256)",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "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"
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(11)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "This field represents the date at which the measure was taken.."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "Angina",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has Angina or not. The data is defined by Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "AngioStentInsert",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether patient has Angiopasty and Stent Insertion The data is defined by a Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "Angioplasty",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represenst whether the patient has had an angioplasty The data is defined by Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "AtrialFibrillation",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has had atrial fibrillation. The data is defined by Yes or Null."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "CVANonHaemorrhagic",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has had a Cerebro Vascular Accident (CVA) non haemorrhagic stroke. The data is defined with a yes or Null."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "CVAUnspecified",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has had a Cerebro Vascular Accident (CVA) unspecified The data is defined with a yes or Null."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "CoronaryArteryBypassSurgery",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has had coronary artery bypass surgery. The data is defined by Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "CoronaryHeartDisease",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has coronary heart disease The data is defined by yes or Null."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "DateOfDiabeticKetoacidosisEpisode",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the date of a diabetic ketoacidosis episiode."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "EndStageRenalFailureDate",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the date of end stage renal failure."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "FamilyHistoryOfCHD",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the patient having a family history of coronary heart disease (CHD) The data is defined with Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "Gout",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has gout. The data is defined with a Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "HeartTransplant",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has had a heart transplant. The data is defined with Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "Hypertension",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient suffers from Hypertension. The data is defined with Yes Or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "HypertensionTreated",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patients hypertension has been treated The data is defined with Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "IntermittentClaudicationLeft",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field representswhether the patients suffers from intermittent claudication on the left The data is defined by: GEN-NYN-02 No Yes."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "IntermittentClaudicationRight",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field representswhether the patients suffers from intermittent claudication on the left The data is defined by: CD-IC-02 GEN-NYN-02 No Yes."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "LeftVentricularDysfunction",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has Left ventricular dysfunction. The data is defined with Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "LeftVentricularHypertrophy",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patients has left ventricular hypertrophy. The data is defined with Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "MyocardialInfraction",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has Myocardial Infraction The data is defined with Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "PeripheralVascularDisease",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the patient has peripheral vascular disease. The data is defined with Yes or NUll."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "RenalReplacementTherapy",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the renal replacement therapy. The data is defined by: Hemodialysis Peritoneal dialysis Renal Dialysis - Type Unknown Renal transplant."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "StentInsertion",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents stent insertion. The data is defined by Yes or NULL."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Hospital Clinics, GP Practices, Clinical Domains and all other clinical data sources where data record is extracted from ."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "PopulationId_User",
"dataType": "varchar(50)",
"sensitive": false,
"description": "PopulationID_User acts with DataSourceID to give the DataSource_Description."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "PopulationId",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the Population ID. This is to fully Identify the Data Source in addition to DataSourceId field."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "DataSource_Description",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "Gives the data source as represented by DatasourceID and PopulationID."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "TransactionId",
"dataType": "varchar(100)",
"sensitive": false,
"description": "As SCI-DC will not use a structured format for most of these data, data items mapped must be linked using ‘TransactionId’."
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - Clinical Outcomes",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "This table gives a list of conditions that the patient might have."
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(11)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "This field represents the date of testing."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DateOfDiagnosisDiabetes",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whether the date of testing was the diagnosis date. The data is defined by: NULL Estimate Known Not Known Yes."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DiabetesCareType",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the type of diabetes cares received. The data is defined by: NULL AAM-DCT-99 Hospital Primary Care Shared."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DiabetesMellitusSubType",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the type of Diabetes Mellitus. The data is defined by: NULL Cushings syndrome Cystic Fibrosis Related Diabetes Glucokinase deficiency HNF1a HNF1b HNF4a Induced by non-steroid drugs Induced by steroids. Other - Please Specify."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DiabetesMellitusType",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the type of diabetes the patient was last diagnosed as suffering from: NULL Current Gestational Diabetes Diabetes Resolved Diabetes in Remission History of Gestational Diabetes Impaired Fasting Glucose Impaired Glucose Tolerance Latent Autoimmune Diabetes of Adulthood Maternally Inherited Diabetes and Deafness Maturity Onset Diabetes of Youth Neonatal Diabetes Not Diabetic Not Known Other Type of Diabetes Secondary - Disease Secondary - Drug Induced Secondary - Pancreatic Pathology Stress Induced Hyperglycaemia (transitory) Type 1 Diabetes Mellitus Type 2 Diabetes Mellitus Unconfirmed."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DiabetesMellitusTypeFirstDegreeRelative",
"dataType": "varchar(200)",
"sensitive": false,
"description": "Record of whether or not the patient has a family history of diabetes mellitus in a first degree relative. The data is defined by: NULL Not Known Type 1 Diabetes Mellitus Type 2 Diabetes Mellitus."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DiabetesTreatmentType",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the type of trestment received.."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "FamilyHistory",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents whetehr the patient has family history. The data is defined by: NULL No Not Known Yes."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "FamilyHistory_DiabetesMellitusTypeFirstDegreeRelative",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the family history type of Diabetes. The data is defined with: NULL Not Known Type 2 Diabetes Mellitus."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "FamilyHistory_RelationshipFirstDegreeRelative",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the relationship of relative: The data is defined by: NULL Relationship Unspecified."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "HospitalDiabetesClinicAttendance",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the record of attendance at the hospital diabetes clinic. The data is defined by: Yes or NULL."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "PopulationId_User",
"dataType": "varchar(50)",
"sensitive": false,
"description": "PopulationID_User acts with DataSourceID to give the DataSource_Description."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "PopulationId",
"dataType": "varchar(50)",
"sensitive": false,
"description": "Can have idenifiable data and need special approval to release."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "DataSource_Description",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "Gives the data source as represented by DatasourceID and PopulationID."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "TransactionId",
"dataType": "varchar(100)",
"sensitive": false,
"description": "As SCI-DC will not use a structured format for most of these data, data items mapped must be linked using ‘TransactionId’."
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - CD Diabetes Longitudinal",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "No table description available"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "Date",
"dataType": "datetime",
"sensitive": false,
"description": "Date of the measurement. Less than half of the records has time.."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "Systolic",
"dataType": "int",
"sensitive": false,
"description": "Systolic measurement. Unit is Hgmm2. Valid range: 10 - 400 Hgmm2 according to SCIDiabetes documentation.."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "Diastolic",
"dataType": "int",
"sensitive": false,
"description": "Diastolic measurement. Unit is Hgmm2. Valid range: 10 - 300 Hgmm2 according to SCIDiabetes documentation.."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "BP",
"dataType": "varchar(7)",
"sensitive": false,
"description": "Systolic and Diastolic measurement joined with forward slash. Format: Systolic/Diastolic, reads as Systolic over Diastolic. Some of the results are incomplete, missing either Systolic or Diastolic. The missing value is represented by a dash. Part of the unique primary key: CHI-Date-bp."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "SystolicLocationOfContact",
"dataType": "varchar(200)",
"sensitive": false,
"description": "The data is defined by: Conflicting values GP Surgery Hospital Not Known Other Patients Home ."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "DiastolicLocationOfContact",
"dataType": "varchar(200)",
"sensitive": false,
"description": "The data is defined by: Conflicting values GP Surgery Hospital Not Known Other Patients Home ."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "SystolicConfidenceLevelPairedDataItems",
"dataType": "varchar(200)",
"sensitive": false,
"description": "Sparse column, containing High or left blank."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "joinedOn",
"dataType": "varchar(100)",
"sensitive": false,
"description": "The data is received in key-value format. Systolic and Diastolic measurements are placed in the same row using a TransactionID as recommended by SCIDiabetes. Not all measurements are matched by the TransactionID. Remaining partial readings are matched on the criteria: There is exactly one Systolic and Diastolic result for the given CHI-Date Systolic must be greater than Diastolic The joined result (bp) does not already exist for the CHI-Date. This column can be provided for transparency on the joining process. After the augmented matching some records still remain partial. This column also explain the reason why they could not be matched.."
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - BP",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Blood Pressure measurements from SCIDiabetes"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "This field represents the date theamputation was performed.."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "LowerLimbAmputationLeft",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represent left side lower limb amputation. The data is defined with: Digit/ Metatarsal of Foot Digit/ Metatarsal of Foot - Side Unknown Forefoot Forefoot - Side Unknown None Not Known Other Other - Side Unknown Trans-femoral Trans-femoral - Side Unknown Trans-tibial Trans-tibial - Side Unknown."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "LowerLimbAmputationLeft_DiabetesRelated",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents whether the amputation was related to diabetes. The data is defined by: No Not Known Yes."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "DiabetesRelateAmputationLeft",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field records whether or not the amputation is diabetes related. The data is defined by: No Yes."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "LowerLimbAmputationRight",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represent right side lower limb amputation. The data is defined with: Digit/ Metatarsal of Foot Digit/ Metatarsal of Foot - Side Unknown Forefoot Forefoot - Side Unknown None Not Known Other Other - Side Unknown Trans-femoral Trans-femoral - Side Unknown Trans-tibial Trans-tibial - Side Unknown."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "LowerLimbAmputationRight_DiabetesRelated",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field represents whether the amputation was related to diabetes. The data is defined by: No Not Known Yes."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "DiabetesRelateAmputationRight",
"dataType": "varchar(800)",
"sensitive": false,
"description": "This field records whether or not the amputation is diabetes related. The data is defined by: No Yes."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "DataSourceId",
"dataType": "int",
"sensitive": false,
"description": "This field represents the Data Source ID provided by SCI_Diabetes lookup table."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "PopulationId_User",
"dataType": "varchar(50)",
"sensitive": false,
"description": "PopulationID_User acts with DataSourceID to give the DataSource_Description."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "PopulationId",
"dataType": "int",
"sensitive": false,
"description": "Can have idenifiable data and need special approval to release."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "DataSource_Description",
"dataType": "varchar(4000)",
"sensitive": false,
"description": "Gives the data source as represented by DatasourceID and PopulationID."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "TransactionId",
"dataType": "varchar(100)",
"sensitive": false,
"description": "As SCI-DC will not use a structured format for most of these data, data items mapped must be linked using ‘TransactionId’."
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Amputations",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Longitudinal amputation records of diabetic patients"
},
{
"name": "Diabetes - Alcohol",
"columns": [
{
"name": "PROCHI",
"dataType": "varchar(10)",
"sensitive": false,
"description": "Anonymised patient identifier"
}
],
"description": "Longitudinal data of Average weekly alcohol intake in units and Alcohol Status. Alcohol status is very sparse compared to average weekly intake."
},
{
"name": "Diabetes - Alcohol",
"columns": [
{
"name": "Date",
"dataType": "date",
"sensitive": false,
"description": "This field represents the date the information was taken."
}
],
"description": "Longitudinal data of Average weekly alcohol intake in units and Alcohol Status. Alcohol status is very sparse compared to average weekly intake."
},
{
"name": "Diabetes - Alcohol",
"columns": [
{
"name": "AlcoholStatus",
"dataType": "varchar(200)",
"sensitive": false,
"description": "This field represents the status of the patient with regards to alcohol consumption. The data is defined with: Current Current non-drinker Currently exceeds both weekly and daily recommended limits Currently exceeds daily recommended limits Currently exceeds weekly recommended limits Currently within recommended daily and weekly limits Ex-drinker Never Non drinker Not disclosed Not known ."
}
],
"description": "Longitudinal data of Average weekly alcohol intake in units and Alcohol Status. Alcohol status is very sparse compared to average weekly intake."
},
{
"name": "Diabetes - Alcohol",
"columns": [
{
"name": "AlcoholIntakePerAverageWeek",
"dataType": "float",
"sensitive": false,
"description": "This field represents the number of units per week."
}
],
"description": "Longitudinal data of Average weekly alcohol intake in units and Alcohol Status. Alcohol status is very sparse compared to average weekly intake."
},
{
"name": "Diabetes - Alcohol",
"columns": [
{
"name": "hic_dataLoadRunID",
"dataType": "int",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Longitudinal data of Average weekly alcohol intake in units and Alcohol Status. Alcohol status is very sparse compared to average weekly intake."
},
{
"name": "Diabetes - Alcohol",
"columns": [
{
"name": "hic_validFrom",
"dataType": "datetime2",
"sensitive": false,
"description": "No Column Description Available"
}
],
"description": "Longitudinal data of Average weekly alcohol intake in units and Alcohol Status. Alcohol status is very sparse compared to average weekly intake."
}
]
}
Copied to clipboard