NHS Greater Glasgow and Clyde Intellectual Disability and Pain
Summary
Abstract
Cohort of patients registered to NHS Greater Glasgow and Clyde Health Board with probable intellectual disability based on ICD-10 coding, and linked to records to explore likely burden of pain.
-
Contact point
-
Digital object identifier (DOI)Not available
Keywords
Publisher
-
NameWest of Scotland Safe Haven
-
Logo
Not available
-
DescriptionNot available
-
Contact pointNot available
Documentation
Description
This project dataset investigated pain medication prescribing patterns in adults with intellectual disabilities compared to a general population cohort. It was used to examine the impact of multimorbidity, polypharmacy and clinical/demographic factors on prescribing. It was also used to assess whether pain medication prescribing is associated with health outcomes like hospitalization and mortality. The cohort consists of over 10,700 adults with intellectual disabilities. The aim of the dataset was to increase understanding of pain medication use and its implications considering multimorbidity and polypharmacy.
-
Associated media
-
Available resource files can be downloaded below.
-
-
Is part of
- Not available
-
Landing page
Coverage
Spatial
-
Spatial coverage
United Kingdom, United Kingdom, Scotland, United Kingdom, Scotland, Glasgow City
-
Geographic levelsNot available
Temporal
-
Start date01/01/2012
-
End date31/12/2022
-
FrequencyStatic
-
Distribution release date06/02/2023
Provenance
-
PurposeNot available
-
SourceOther
-
Collection situationSecondary care - Outpatients, Clinic, Secondary care - Accident and Emergency
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 useProject-specific restrictions
-
Resource creatorLocal NHS boards
-
Is referenced byNot available
Access
-
Access rights
-
Access serviceThe West of Scotland Safe Haven is part of the regional Safe Haven network in Scotland. We operate as a REC-approved research database (IRAS 321198) within NHS Greater Glasgow and Clyde, and offer a delegated ethics route for data-only studies, cohort builds and linkage to a variety of deep, multi-modal clinical NHS data types - including structured, free text, and imaging - with hosting of deidentified research-ready datasets in an ISO-accredited Secure Data Environment. For more information, please email safehaven@ggc.scot.nhs.uk to discuss requirements.
-
JurisdictionGB-SCT
-
Data controllerNHS Greater Glasgow and Clyde
-
Data processorNHS Greater Glasgow and Clyde
Format and standards
-
LanguageEnglish
-
FormatCsv
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
{
"linkage": {
"associatedMedia": "https://www.nhsggc.scot/downloads/west-of-scotland-safe-haven-user-guide/"
},
"summary": {
"title": "NHS Greater Glasgow and Clyde Intellectual Disability and Pain",
"abstract": "Cohort of patients registered to NHS Greater Glasgow and Clyde Health Board with probable intellectual disability based on ICD-10 coding, and linked to records to explore likely burden of pain.",
"keywords": "SCOTLAND;,;NHS Greater Glasgow & Clyde;,;Glasgow;,;Pain;,;Alleviate",
"publisher": {
"name": "West of Scotland Safe Haven",
"gatewayId": "d8199a09-59da-44a6-97ce-0b9f9431d769"
},
"inPipeline": "Not available",
"shortTitle": "NHS Greater Glasgow and Clyde Intellectual Disability and Pain",
"datasetType": "Health and disease",
"description": "This project dataset investigated pain medication prescribing patterns in adults with intellectual disabilities compared to a general population cohort. It was used to examine the impact of multimorbidity, polypharmacy and clinical/demographic factors on prescribing. It was also used to assess whether pain medication prescribing is associated with health outcomes like hospitalization and mortality. The cohort consists of over 10,700 adults with intellectual disabilities. The aim of the dataset was to increase understanding of pain medication use and its implications considering multimorbidity and polypharmacy.",
"contactPoint": "safehaven@ggc.scot.nhs.uk",
"datasetSubType": "Not applicable",
"populationSize": -1
},
"coverage": {
"pathway": "Data for patients with conditions related to intellectual disability, based on ICD-10 diagnostic coding.",
"spatial": "United Kingdom;,;United Kingdom,Scotland;,;United Kingdom,Scotland,Glasgow City",
"followUp": "Unknown",
"typicalAgeRange": "0-150"
},
"required": {
"issued": "2024-10-08T11:32:29.334213Z",
"version": "1.0.0",
"modified": "2024-10-08T11:32:29.334227Z",
"gatewayId": "843",
"revisions": [
{
"url": "https://web.prod.hdruk.cloud//dataset/843?version=1.0.0",
"version": "1.0.0"
}
],
"gatewayPid": "bff8c80d-59ed-49c6-aff2-f486fb6f72da"
},
"provenance": {
"origin": {
"source": "Other",
"imageContrast": "Not stated",
"collectionSituation": "Secondary care - Outpatients;,;Clinic;,;Secondary care - Accident and Emergency"
},
"temporal": {
"endDate": "2022-12-31",
"timeLag": "Not applicable",
"startDate": "2012-01-01",
"accrualPeriodicity": "Static",
"distributionReleaseDate": "2023-02-06"
}
},
"observations": [
{
"observedNode": "Events",
"measuredValue": 10700,
"observationDate": "2023-02-06",
"measuredProperty": "COUNT",
"disambiguatingDescription": "Intellectual disability"
}
],
"accessibility": {
"usage": {
"resourceCreator": {
"name": "Local NHS boards"
},
"dataUseLimitation": "General research use",
"dataUseRequirement": "Project-specific restrictions"
},
"access": {
"accessRights": "https://www.nhsggc.scot/hospitals-services/services-a-to-z/west-of-scotland-safe-haven/",
"jurisdiction": "GB-SCT",
"accessService": "The West of Scotland Safe Haven is part of the regional Safe Haven network in Scotland. We operate as a REC-approved research database (IRAS 321198) within NHS Greater Glasgow and Clyde, and offer a delegated ethics route for data-only studies, cohort builds and linkage to a variety of deep, multi-modal clinical NHS data types - including structured, free text, and imaging - with hosting of deidentified research-ready datasets in an ISO-accredited Secure Data Environment. For more information, please email safehaven@ggc.scot.nhs.uk to discuss requirements.",
"dataProcessor": "NHS Greater Glasgow and Clyde",
"dataController": "NHS Greater Glasgow and Clyde",
"deliveryLeadTime": "2-4 weeks",
"accessRequestCost": "Operate on a cost recovery basis, quotations available on request"
},
"formatAndStandards": {
"formats": "CSV",
"languages": "en",
"vocabularyEncodingSchemes": "NHS SCOTLAND NATIONAL CODES"
}
},
"structuralMetadata": [
{
"name": "Demographics",
"columns": [
{
"name": "DATAZONE_2001",
"dataType": "varchar",
"sensitive": false,
"description": "Geography"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "DATAZONE_2011",
"dataType": "varchar",
"sensitive": false,
"description": "Geography"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "DATE_OF_DEATH",
"dataType": "date",
"sensitive": false,
"description": "Date of death"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "DATE_TRANSFER_OR_REMOVAL",
"dataType": "datetime2",
"sensitive": false,
"description": "Date of patient movement to Health Board"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "GENDER_DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Gender, description"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "INTZONE_2001",
"dataType": "varchar",
"sensitive": false,
"description": "Geography"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "INTZONE_2011",
"dataType": "varchar",
"sensitive": false,
"description": "Geography"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "MARITAL_STATUS",
"dataType": "varchar",
"sensitive": false,
"description": "Marital status"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "MARITAL_STATUS_DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Marital status, description"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "OBF_DOB",
"dataType": "date",
"sensitive": false,
"description": "Obfuscated date of birth"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "PCSECTOR",
"dataType": "varchar",
"sensitive": false,
"description": "Postcode outer only"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "PRACTICE_CODE",
"dataType": "varchar",
"sensitive": false,
"description": "GP practice of registration"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "REASON_FOR_TRANSFER_OUT",
"dataType": "varchar",
"sensitive": false,
"description": "Reason for movement from Health Board"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SEX",
"dataType": "varchar",
"sensitive": false,
"description": "Gender"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2009_DECILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2009_QUINTILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2009_RANK",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2009_VIGINTILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2012_DECILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2012_QUINTILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2012_RANK",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2012_VIGINTILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2016_DECILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2016_QUINTILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2016_RANK",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Demographics",
"columns": [
{
"name": "SIMD_2016_VIGINTILE",
"dataType": "int",
"sensitive": false,
"description": "Scottish Multiple Index of Deprivation"
}
],
"description": "Demographics for each patient represented in a cohort"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD0",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD0DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD1",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD1DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD2",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD2DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD3",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD3DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD4",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD4DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD5",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD5DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD6",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD6DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD7",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD7DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD8",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD8DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD9",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "COD9DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "CODDESC",
"dataType": "varchar",
"sensitive": false,
"description": "Cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "DOD",
"dataType": "date",
"sensitive": false,
"description": "Date of death"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "LOCATION",
"dataType": "varchar",
"sensitive": false,
"description": "Location of death"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "LOCATION_CODE",
"dataType": "varchar",
"sensitive": false,
"description": "Location of daeth, coded"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD0",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD0DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD1",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD1DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD2",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD2DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD3",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD3DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD4",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death as ICD-10"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Deaths",
"columns": [
{
"name": "SCOD4DESC",
"dataType": "varchar",
"sensitive": false,
"description": "Secondary cause of death, description"
}
],
"description": "Registered deaths, dates and causes"
},
{
"name": "Inpatient",
"columns": [
{
"name": "safehavenid",
"dataType": "int",
"sensitive": false,
"description": "Unique de-idenitified value created by the Safe Haven on a project to project basis"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMDATE",
"dataType": "date",
"sensitive": false,
"description": "Admission Date - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMHOSP",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMHOSPDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMREAS",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMREASDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMTRANS",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMTRANSDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMTYPE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ADMTYPEDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "AGEMTH",
"dataType": "varchar",
"sensitive": false,
"description": "Patients age in months derived from DOB and admisison date. Returns null if either date is blank."
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "AGGZONE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ASC",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ASCDesc",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DATAZONE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG1",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG1_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG1Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG2",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG2_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG2Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG3",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG3_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG3Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG4",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG4_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG4Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG5",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG5_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG5Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG6",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG6_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DIAG6Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DISDATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DISHOSP",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DISHOSPDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DISTRANS",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DISTRANSDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DISTYPE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "DISTYPEDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ENDFAC",
"dataType": "varchar",
"sensitive": false,
"description": "Clinical facility from which the patient was discharged at the end of an SMR inpatient or daycase episode. Not required from 1st April 2017."
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ENDFACDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "ETHGRP",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "HBTREAT",
"dataType": "varchar",
"sensitive": false,
"description": "Health Board of Treatment Number - Derived from location code or provider code"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "HEALTH_BOARD",
"dataType": "int",
"sensitive": false,
"description": "One of 14 Health Boards across Scotland, where the patient was treated"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "HOSP",
"dataType": "varchar",
"sensitive": false,
"description": "Hospital Location Code"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "HRG",
"dataType": "varchar",
"sensitive": false,
"description": "Healthcare Resource Group (HRG) codes are standard groupings of clinically similar treatments which use comparable levels of healthcare resource. The field contains version 4 HRG codes."
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "INPATIENT_DAYCASE_IDENTIFIER",
"dataType": "varchar",
"sensitive": false,
"description": "I = Inpatient D = Daycase"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "LOCAL_DECILE_BY_SIMD_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "LOCAL_DECILE_BY_SIMDSCOT_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "LOCAL_QUINTILE_BY_SIMD_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "LOCAL_QUINTILE_BY_SIMDSCOT_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP1A",
"dataType": "varchar",
"sensitive": false,
"description": "Operation Code - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP1ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Operation Description - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP1B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP1BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP1DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP2A",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP2ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP2B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP2BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP2DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP3A",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP3ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP3B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP3BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP3DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP4A",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP4ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP4B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP4BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OP4DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "OUTPUT91",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "PATCAT",
"dataType": "varchar",
"sensitive": false,
"description": "Patient Category- Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "PATCATDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "PATMAN",
"dataType": "varchar",
"sensitive": false,
"description": "Management of Patient - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "PATMANDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "RDYDATE",
"dataType": "date",
"sensitive": false,
"description": "Ready for Discharge Date - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "SIGFAC",
"dataType": "varchar",
"sensitive": false,
"description": "Significant Facility - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "SIGFACDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "SIMD_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "SPEC",
"dataType": "varchar",
"sensitive": false,
"description": "Specialty - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "SPECDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "STARTFAC",
"dataType": "varchar",
"sensitive": false,
"description": "Clinical facility to which the patient was admitted at the start of an SMR inpatient or daycase episode. Not required from 1st April 2017."
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "STARTFACDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "STAY",
"dataType": "varchar",
"sensitive": false,
"description": "The patients lengh of stay derived from admission date and discharge date."
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "WAIT",
"dataType": "varchar",
"sensitive": false,
"description": "The number of days a patient has been waiting derived from waiting list date and admission date."
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "WLDATE",
"dataType": "date",
"sensitive": false,
"description": "Waiting List Date - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "WLTYPE",
"dataType": "varchar",
"sensitive": false,
"description": "Waiting List Type - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Inpatient",
"columns": [
{
"name": "WLTYPEDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Acute inpatient and day cases"
},
{
"name": "Outpatient",
"columns": [
{
"name": "safehavenid",
"dataType": "int",
"sensitive": false,
"description": "Unique de-idenitified value created by the Safe Haven on a project to project basis"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMDATE",
"dataType": "date",
"sensitive": false,
"description": "Admission Date - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMHOSP",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMHOSPDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMREAS",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMREASDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMTRANS",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMTRANSDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMTYPE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ADMTYPEDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "AGEMTH",
"dataType": "varchar",
"sensitive": false,
"description": "Patients age in months derived from DOB and admisison date. Returns null if either date is blank."
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "AGGZONE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ASC",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ASCDesc",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DATAZONE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG1",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG1_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG1Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG2",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG2_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG2Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG3",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG3_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG3Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG4",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG4_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG4Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG5",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG5_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG5Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG6",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG6_clean",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DIAG6Desc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DISDATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DISHOSP",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DISHOSPDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DISTRANS",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DISTRANSDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DISTYPE",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "DISTYPEDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ENDFAC",
"dataType": "varchar",
"sensitive": false,
"description": "Clinical facility from which the patient was discharged at the end of an SMR inpatient or daycase episode. Not required from 1st April 2017."
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ENDFACDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "ETHGRP",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "HBTREAT",
"dataType": "varchar",
"sensitive": false,
"description": "Health Board of Treatment Number - Derived from location code or provider code"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "HEALTH_BOARD",
"dataType": "int",
"sensitive": false,
"description": "One of 14 Health Boards across Scotland, where the patient was treated"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "HOSP",
"dataType": "varchar",
"sensitive": false,
"description": "Hospital Location Code"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "HRG",
"dataType": "varchar",
"sensitive": false,
"description": "Healthcare Resource Group (HRG) codes are standard groupings of clinically similar treatments which use comparable levels of healthcare resource. The field contains version 4 HRG codes."
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "INPATIENT_DAYCASE_IDENTIFIER",
"dataType": "varchar",
"sensitive": false,
"description": "I = Inpatient D = Daycase"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "LOCAL_DECILE_BY_SIMD_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "LOCAL_DECILE_BY_SIMDSCOT_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "LOCAL_QUINTILE_BY_SIMD_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "LOCAL_QUINTILE_BY_SIMDSCOT_RANK_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP1A",
"dataType": "varchar",
"sensitive": false,
"description": "Operation Code - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP1ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Operation Description - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP1B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP1BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP1DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP2A",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP2ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP2B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP2BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP2DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP3A",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP3ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP3B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP3BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP3DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP4A",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP4ADesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP4B",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP4BDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OP4DATE",
"dataType": "date",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "OUTPUT91",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "PATCAT",
"dataType": "varchar",
"sensitive": false,
"description": "Patient Category- Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "PATCATDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "PATMAN",
"dataType": "varchar",
"sensitive": false,
"description": "Management of Patient - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "PATMANDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "RDYDATE",
"dataType": "date",
"sensitive": false,
"description": "Ready for Discharge Date - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "SIGFAC",
"dataType": "varchar",
"sensitive": false,
"description": "Significant Facility - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "SIGFACDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "SIMD_2012",
"dataType": "int",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "SPEC",
"dataType": "varchar",
"sensitive": false,
"description": "Specialty - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "SPECDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "STARTFAC",
"dataType": "varchar",
"sensitive": false,
"description": "Clinical facility to which the patient was admitted at the start of an SMR inpatient or daycase episode. Not required from 1st April 2017."
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "STARTFACDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "STAY",
"dataType": "varchar",
"sensitive": false,
"description": "The patients lengh of stay derived from admission date and discharge date."
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "WAIT",
"dataType": "varchar",
"sensitive": false,
"description": "The number of days a patient has been waiting derived from waiting list date and admission date."
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "WLDATE",
"dataType": "date",
"sensitive": false,
"description": "Waiting List Date - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "WLTYPE",
"dataType": "varchar",
"sensitive": false,
"description": "Waiting List Type - Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "Outpatient",
"columns": [
{
"name": "WLTYPEDesc",
"dataType": "varchar",
"sensitive": false,
"description": "Refer to Documentation - https://www.ndc.scot.nhs.uk/Dictionary-A-Z/Definitions/index.asp?Search=A"
}
],
"description": "Outpatients (new and follow-up)"
},
{
"name": "GP LES",
"columns": [
{
"name": "safehavenid",
"dataType": "int",
"sensitive": false,
"description": "Unique de-idenitified value created by the Safe Haven on a project to project basis"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "EventDate",
"dataType": "date",
"sensitive": false,
"description": "Date for coded event"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "READCODE",
"dataType": "varchar",
"sensitive": false,
"description": "READ coded entry"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "Description",
"dataType": "varchar",
"sensitive": false,
"description": "Free text description of READ code"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "IsPrescription",
"dataType": "varchar",
"sensitive": false,
"description": "Whether a prescription"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "IsValue",
"dataType": "varchar",
"sensitive": false,
"description": "Whether a value"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "Value1",
"dataType": "int",
"sensitive": false,
"description": "Value number one"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "Value2",
"dataType": "int",
"sensitive": false,
"description": "Value number two"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "LESAreaID",
"dataType": "int",
"sensitive": false,
"description": "Local enhanced service category"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "ShortName",
"dataType": "varchar",
"sensitive": false,
"description": "Local enhanced service category description"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "GP LES",
"columns": [
{
"name": "CreatedByExtractID",
"dataType": "int",
"sensitive": false,
"description": "System generated from source"
}
],
"description": "GP Local Enhanced Service"
},
{
"name": "Prescribing",
"columns": [
{
"name": "CAREHOMERESIDENT",
"dataType": "int",
"sensitive": false,
"description": "Care home flag"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "DISP_DATE",
"dataType": "date",
"sensitive": false,
"description": "Dispense date"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "Dispensed_Quantity",
"dataType": "nvarchar",
"sensitive": false,
"description": "Dispense quantity"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "Form_Type_Code",
"dataType": "nvarchar",
"sensitive": false,
"description": "Formulation code"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "FormTypeDescription",
"dataType": "nvarchar",
"sensitive": false,
"description": "Formulation description"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "Number_of_Dispensed_Forms",
"dataType": "nvarchar",
"sensitive": false,
"description": "Number of forms"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "Number_of_Dispensed_Items",
"dataType": "nvarchar",
"sensitive": false,
"description": "Number of items"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "Paid_Calendar_Month_and_Year",
"dataType": "nvarchar",
"sensitive": false,
"description": "Paid period"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_Approved_Name",
"dataType": "nvarchar",
"sensitive": false,
"description": "Drug approved name"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Chapter_Code",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Chapter_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Item_Code",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Item_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Paragraph_Code",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Paragraph_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Root_Drug_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Section_Code",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Section_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Sub_Section_Code",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_BNF_Sub_Section_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "BNF detail"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_Drug_Formulation",
"dataType": "nvarchar",
"sensitive": false,
"description": "Drug formulation"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_Item_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "Drug item description"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_Item_Strength_UOM",
"dataType": "nvarchar",
"sensitive": false,
"description": "Pack strength"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_Pack_Size",
"dataType": "nvarchar",
"sensitive": false,
"description": "Pack size"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_Prescribable_Item_Name",
"dataType": "nvarchar",
"sensitive": false,
"description": "Item name"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PI_Product_Description",
"dataType": "nvarchar",
"sensitive": false,
"description": "Item description"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "PRESC_DATE",
"dataType": "date",
"sensitive": false,
"description": "Prescribe date"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "Presc_Health_Board_Name",
"dataType": "nvarchar",
"sensitive": false,
"description": "Prescribe health board"
}
],
"description": "Community dispensed prescription items for a patient"
},
{
"name": "Prescribing",
"columns": [
{
"name": "Presc_Location_Code",
"dataType": "nvarchar",
"sensitive": false,
"description": "Prescribe location"
}
],
"description": "Community dispensed prescription items for a patient"
}
]
}
Copied to clipboard