RAPID (Hospital Stay Level Data)

Preview of JSON file

{
  "linkage": {
    "associatedMedia": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/overview/what-is-edris/"
  },
  "summary": {
    "title": "RAPID (Hospital Stay Level Data)",
    "abstract": "The Rapid Preliminary Inpatient Data (RAPID) dataset contains the underlying admissions data which is used by System Watch. It enables access to the hospital admissions data  submitted in its unprocessed state e.g. it does not contain predictions.",
    "keywords": "Inpatient;,;Hospital Admissions",
    "publisher": {
      "name": "Public Health Scotland",
      "gatewayId": "c40be7ce-f0ca-4fd8-b63c-0632593d2507"
    },
    "inPipeline": "Not available",
    "shortTitle": "RAPID (Hospital Stay Level Data)",
    "datasetType": "Health and disease",
    "description": "The data collection known as 'System Watch' was developed in 2001 to meet the requirements of the System Watch product, which monitors and predicts emergency admissions and bed occupancy in mainland NHS Boards. The data collection is now known as 'RAPID'. The data collected are management information and have very limited validation.",
    "contactPoint": "phs.edris@phs.scot",
    "datasetSubType": "Not applicable",
    "populationSize": -1
  },
  "coverage": {
    "pathway": "All of secondary care in relation to hospital stays",
    "spatial": "United Kingdom,Scotland",
    "followUp": "Other",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:16.485494Z",
    "version": "6.0.0",
    "modified": "2024-10-08T11:28:16.485505Z",
    "gatewayId": "58",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/58?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "a1e6b740-5849-4425-a392-5b8919b1ab8b"
  },
  "provenance": {
    "origin": {
      "source": "EPR",
      "imageContrast": "Not stated",
      "collectionSituation": "Secondary care - In-patients"
    },
    "temporal": {
      "timeLag": "1-2 weeks",
      "startDate": "2015-05-01",
      "accrualPeriodicity": "Weekly",
      "distributionReleaseDate": "2020-11-17"
    }
  },
  "observations": [
    {
      "observedNode": "Events",
      "measuredValue": 6067069,
      "observationDate": "2021-02-05",
      "measuredProperty": "Count",
      "disambiguatingDescription": "Stays"
    },
    {
      "observedNode": "Events",
      "measuredValue": 8140208,
      "observationDate": "2021-02-05",
      "measuredProperty": "Count",
      "disambiguatingDescription": "Episodes"
    }
  ],
  "accessibility": {
    "usage": {
      "resourceCreator": {
        "name": "None"
      },
      "dataUseLimitation": "General research use",
      "dataUseRequirement": "Institution-specific restrictions;,;Not for profit use"
    },
    "access": {
      "accessRights": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/services-we-offer/",
      "jurisdiction": "GB-GBN",
      "accessService": "Scottish National Safe Haven / Trusted Research Environment: https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/national-safe-haven-nsh/",
      "dataProcessor": "National Services Scotland",
      "dataController": "Public Health Scotland",
      "deliveryLeadTime": "Other",
      "accessRequestCost": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/cost-of-services/",
      "accessServiceCategory": "TRE/SDE"
    },
    "formatAndStandards": {
      "formats": "text/csv",
      "languages": "en",
      "vocabularyEncodingSchemes": "ICD10"
    }
  },
  "structuralMetadata": [
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_1A_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DISCHARGE_DATE",
          "dataType": "date",
          "sensitive": false,
          "description": "The date on which a  discharge occurs."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "GP_PRACTICE_LOCATION_TYPE",
          "dataType": "character",
          "sensitive": false,
          "description": "SHORT FORM DESCRIPTION OF THE TYPE OF LOCATION, EG. GPPRA -> GP PRACTICE, HOSP -> HOSPITAL. PART OF THE NATURAL KEY ALONG WITH LOCATION CODE."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HOSPITAL_OF_TREATMENT_LOCATION_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "THE LOCATION CODE. UNIQUE TO A LOCATION FOR CERTAIN LOCATION TYPES BUT NOT FOR OTHERS (EG. GP PRACTICES AND DENTAL PRACTICES CAN HAVE THE SAME CODE). PART OF THE NATURAL KEY IN CONJUNCTION WITH LOCATION TYPE."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "WARD_SIGNIFICANT_FACILITY_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "The description, i.e. name of the Significant Facility, which is a type of clinical facility, identified for clinical and/or costing purposes."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "CIS_LENGTH_OF_STAY",
          "dataType": "numeric",
          "sensitive": false,
          "description": "The length of the CIS."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "ADMISSION_DATE",
          "dataType": "date",
          "sensitive": false,
          "description": "The date on which an admission occurs."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HEALTH_BOARD_OF_RESIDENCE_CODE_CURRENT",
          "dataType": "character",
          "sensitive": false,
          "description": "Current configuration health board code aka cypher. This is a candidate natural key for each territorial health board, however only some special boards have codes and some have none."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_3B_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_1_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis description associated with code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DISCHARGE_TIME",
          "dataType": "character",
          "sensitive": false,
          "description": "The time at which a discharge occurs."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SENDING_LOCATION_NAME",
          "dataType": "character",
          "sensitive": false,
          "description": "THE NAME/DESCRIPTION OF THE LOCATION (TYPE 1 - CURRENT)"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_2A_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SPECIALTY_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Name describing the specialty.  A specialty is a division of medicine covering a specific area of clinical activity and identified within one of the Royal Colleges or Faculties.  For a complete list of specialties, please see: http://www.datadictionaryadmin.scot.nhs.uk/isddd/9751.html.<br><br>\\n\\nThis classification only became applicable to SMR1/SMR01 records from 1 April 1997 onwards.  For discharges prior to this date this field is NULL.  For records admitted prior to this date and where the patient is still considered to be a resident (i.e. no discharge date available), a mapping has been applied to assign a specialty based on the consultant responsible for the care of the patient."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_6_CODE_4CHAR",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DISCHARGE_TRANSFER_TO_TYPE",
          "dataType": "character",
          "sensitive": false,
          "description": "A two-character code representing Discharge Transfer To which categorises the destination following discharge, or type of location, to which a patient has been discharged. This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_4A_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "GP_PRACTICE_NHS_BOARD_NAME_CURRENT",
          "dataType": "character",
          "sensitive": false,
          "description": "CURRENT CONFIGURATION HEALTH BOARD NAME"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_5_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis description associated with code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_2A_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code description for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "MANAGEMENT_OF_PATIENT_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "The description i.e. name, of the Management of Patient i.e. the patient type and the pattern of bed use of a patient.  In summary, it distinguishes inpatient from day case care.   This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "ADMITTED_TRANSFER_FROM_TYPE",
          "dataType": "character",
          "sensitive": false,
          "description": "A two-character code representing Admitted Transfer From which categorises the source of admission, or type of location, from which a patient has been admitted. This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_3A_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code description for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_4B_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_1B_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "PATIENT_GENDER_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Gender code for the patient\nM = Male\nF = Female"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "WARD_SIGNIFICANT_FACILITY",
          "dataType": "character",
          "sensitive": false,
          "description": "A two-character code representing the Significant Facility which is a type of clinical facility, identified for clinical and/or costing purposes."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_1A_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "ADMITTED_TRANSFER_FROM_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "The description, i.e., name of the Admitted Transfer From Code, which categorises the source of admission, or type of location, from which a patient has been admitted.  This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_4_CODE_4CHAR",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "POSTCODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Natural Key. The postcode formatted to 7 digits using standard format postcode function."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "ADMISSION_TIME",
          "dataType": "character",
          "sensitive": false,
          "description": "The time at which an admission occurs."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HOSPITAL_OF_TREATMENT_LOCATION_TYPE",
          "dataType": "character",
          "sensitive": false,
          "description": "SHORT FORM DESCRIPTION OF THE TYPE OF LOCATION, EG. GPPRA -> GP PRACTICE, HOSP -> HOSPITAL. PART OF THE NATURAL KEY ALONG WITH LOCATION CODE."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "PSEUDO-ANONYMISED ID NUMBER",
          "dataType": "varchar",
          "sensitive": false
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_2_CODE_4_CHAR",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SPECIALTY",
          "dataType": "character",
          "sensitive": false,
          "description": "Maximum three character code representing the specialty.  A specialty is a division of medicine covering a specific area of clinical activity and identified within one of the Royal Colleges or Faculties.  For a complete list of specialties, please see: http://www.datadictionaryadmin.scot.nhs.uk/isddd/9751.html<br><br>\\n\\nThis classification only became applicable to SMR1/SMR01 records from 1 April 1997 onwards.  For discharges prior to this date this field is NULL.  For records admitted prior to this date and where the patient is still considered to be a resident (i.e. no discharge date available), a mapping has been applied to assign a specialty based on the consultant responsible for the care of the patient."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_1_CODE_4_CHAR",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "INPATIENT_DAYCASE_IDENTIFIER_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "A two-character code representing the Inpatient Day Case Identifier, which indicates whether the patient was treated as an inpatient or a day case.\\nSystem Watch currently only deals with Inpatient records, however it is possible that this will be extended in the future to cover day cases."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "EMERGENCY_ADMISSION_FLAG",
          "dataType": "character",
          "sensitive": false,
          "description": "Y or N flag indicating if the episode related to an emergency admission."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SENDING_LOCATION_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "THE LOCATION CODE. UNIQUE TO A LOCATION FOR CERTAIN LOCATION TYPES BUT NOT FOR OTHERS (EG. GP PRACTICES AND DENTAL PRACTICES CAN HAVE THE SAME CODE). PART OF THE NATURAL KEY IN CONJUNCTION WITH LOCATION TYPE."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_4A_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code description for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "GP_PRACTICE_LOCATION_NAME",
          "dataType": "character",
          "sensitive": false,
          "description": "THE NAME/DESCRIPTION OF THE LOCATION (TYPE 1 - CURRENT)"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "INPATIENT_DAYCASE_IDENTIFIER_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "The description, i.e. name, of the Inpatient Day Case Identifier, which indicates whether the patient was treated as an inpatient or a day case.\\nSystem Watch currently only deals with Inpatient records, however it is possible that this will be extended in the future to cover day cases."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DISCHARGE_TYPE_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "The description, i.e., name of the Discharge Type, which categorises, generally, whether the patient was discharged regularly, irregularly or because of death.  This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SIMD_SCOTLAND_DECILE",
          "dataType": "numeric",
          "sensitive": false,
          "description": "LEGACY - retained to support existing applications. Source data is no longer updated."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "PATIENT_DOB_DATE",
          "dataType": "date",
          "sensitive": false,
          "description": "Date of Birth is the patient's full date of birth (derived from their CHI record)."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "NUMBER_OF_STAYS",
          "dataType": "integer",
          "sensitive": false,
          "description": "Number of stays"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_2B_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HSCP_OF_RESIDENCE_NAME_CURRENT",
          "dataType": "character",
          "sensitive": false,
          "description": "Current configuration Health and Social Care Partnership (HSCP) name"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_3B_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code description for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_3A_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "GP_PRACTICE_NHS_BOARD_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "CURRENT CONFIGURATION HEALTH BOARD 9-DIGIT CODE."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_5_CODE_4CHAR",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HSCP_OF_RESIDENCE_CODE_CURRENT",
          "dataType": "character",
          "sensitive": false,
          "description": "Current configuration Health and Social Care Partnership (HSCP) 9 digit code"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "PATIENT_GENDER_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Gender of the patient"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_4_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis description associated with code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "EXTRACT_DATE",
          "dataType": "date",
          "sensitive": false,
          "description": "The date on which a file extract occurs in an NHS Board. For stay-level records, the extract date will be the extract date for the latest episode in the stay."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SPECIALTY_GROUP",
          "dataType": "integer",
          "sensitive": false,
          "description": "A grouping of Specialty Code into\n1 (SURGICAL)\n2 (MEDICAL)\n3 (PAEDIATRICS)\nAlso includes a group 0 (OTHER) for non System-Watch specialties"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_3_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis description associated with code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_4B_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code description for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HOSPITAL_OF_TREATMENT_NHS_BOARD_NAME_CURRENT",
          "dataType": "character",
          "sensitive": false,
          "description": "CURRENT CONFIGURATION SUB HEALTH BOARD NAME"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_1B_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code description for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "MANAGEMENT_OF_PATIENT",
          "dataType": "character",
          "sensitive": false,
          "description": "A one-character code representing the Management of Patient i.e. the patient type and the pattern of bed use of a patient.  In summary, it distinguishes inpatient from day case care.   This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DISCHARGE_TYPE",
          "dataType": "character",
          "sensitive": false,
          "description": "A two character code representing the Discharge Type which categorises, generally, whether the patient was discharged regularly, irregularly or because of death.  This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HOSPITAL_OF_TREATMENT_NHS_BOARD_CODE_CURRENT",
          "dataType": "character",
          "sensitive": false,
          "description": "CURRENT CONFIGURATION SUB HEALTH BOARD CODE. SUB HEALTH BOARD IS DEPRECATED PAST 1ST APRIL 2014 AND IS THEREAFTER SYNONYMOUS WITH THE HEALTH BOARD CODE"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "ADMISSION_TYPE",
          "dataType": "character",
          "sensitive": false,
          "description": "A two-character code representing the Admission Type, which categorises, generally, whether the patient was admitted routinely, urgently or as an emergency."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_2_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis description associated with code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DISCHARGE_TRANSFER_TO_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "The description, i.e., name of the  Discharge Transfer To which categorises the destination following discharge, or type of location, to which a patient has been discharged. This item is only applicable to discharges from 1 April 1997."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_6_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis description associated with code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "DIAGNOSIS_3_CODE_4_CHAR",
          "dataType": "character",
          "sensitive": false,
          "description": "Diagnosis code specified at aggregated 4-character level representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HOSPITAL_OF_TREATMENT_LARGE_HOSPITAL",
          "dataType": "character",
          "sensitive": false,
          "description": "Indicates whether the hospital where the episode of treatment took place is considered 'large' i.e. treats a substantial number of patients"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "OPERATION_2B_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "Main OPCS3/OPCS4 code for the operation/procedure carried out on the individual representing the code responsible for the greatest use of resource"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SIMD_SCOTLAND_QUINTILE",
          "dataType": "numeric",
          "sensitive": false,
          "description": "LEGACY - retained to support existing applications. Source data is no longer updated."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "HOSPITAL_OF_TREATMENT_LOCATION_NAME",
          "dataType": "character",
          "sensitive": false,
          "description": "THE NAME/DESCRIPTION OF THE LOCATION (TYPE 1 - CURRENT)"
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "GP_PRACTICE_LOCATION_CODE",
          "dataType": "character",
          "sensitive": false,
          "description": "THE LOCATION CODE. UNIQUE TO A LOCATION FOR CERTAIN LOCATION TYPES BUT NOT FOR OTHERS (EG. GP PRACTICES AND DENTAL PRACTICES CAN HAVE THE SAME CODE). PART OF THE NATURAL KEY IN CONJUNCTION WITH LOCATION TYPE."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "CIS_MARKER",
          "dataType": "numeric",
          "sensitive": false,
          "description": "A numerical marker which is unique per patient per stay.\n\nFor example, all the individual episodes within a single stay will have the same CIS Marker."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "ADMISSION_TYPE_DESCRIPTION",
          "dataType": "character",
          "sensitive": false,
          "description": "The description, ie. name of the Admission Type which categorises, generally, whether the  patient was admitted routinely, urgently or as an emergency."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "AGE_ON_ADMISSION",
          "dataType": "integer",
          "sensitive": false,
          "description": "Age on Admission (years) records the difference in full years from the patient's date of birth to their date of admission.  This field is more usually just referred to as \"age\"."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "SIMD_SCORE",
          "dataType": "numeric",
          "sensitive": false,
          "description": "LEGACY - retained to support existing applications. Source data is no longer updated."
        }
      ]
    },
    {
      "name": "RAPID",
      "columns": [
        {
          "name": "STAY_LENGTH",
          "dataType": "numeric",
          "sensitive": false,
          "description": "This dimension object allows users to report on stay based measures (e.g. the number of stays) by the length of stay. In this context is behaves slightly differently to the Length of Stay measure, which will be the same for a single stay, however the measure will give the aggregate sum length when dealing with more than one stay."
        }
      ]
    }
  ]
}