Distribution of Ongoing Waits CBF

URL: https://www.opendata.nhs.scot/dataset/e9dbef36-a343-4b9a-ab7e-b6e6cbcbb38e/resource/b2dc7934-9597-412d-abad-b605439855da/download/sot_distribution_of_ongoing_waits_cbf_dec24.csv

Information on the distribution of ongoing wait lengths, for inpatient, day case and outpatient stage of treatment waiting times at health board level, broken down by specialty. The health board data are further categorised into the patient’s health board of residence (HBR) and the health board where they are due to attend an appointment or receive treatment (HBT).

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

Column Type Label Description
QuarterEnding numeric

Last day of quarter that the data reports on (YYYYMMDD)

HBR text

9-digit code for health board of residence based on boundaries as at 1st April 2019 and 6-digit codes for other residential categories

HBRQF text

Qualifier for HBR

HBT text

9-digit code for health board of treatment based on boundaries as at 1st April 2019 and 6-digit codes for special board

HBTQF text

Qualifier for HBT

PatientType text

Patient Type i.e. New Outpatient, inpatient, day case etc.

Specialty text

Specialty of the healthcare professional who is in charge of the patient episode. Specialties with a low volume of patients at Scotland level have been excluded from the specialty breakdown therefore the specialty breakdown will not match the total presented under 'All Specialties'. NHS Greater Glasgow & Clyde code patients under more than one specialty with code 'XSU', as this is not on the list of PHS Specialty codes this has resulted in these patients specialty codes being mapped to a blank code.

SpecialtyQF text

Qualifier for Specialty

LessThan4WeekWait numeric

The number of waits less than or equal to four weeks.

LessThan4WeekWaitQF text

Qualifier for LessThan4WeekWaitQF

4To8WeekWait numeric

The number of waits longer than 4 weeks but less than or equal to 8 weeks.

4To8WeekWaitQF text

Qualifier for 4To8WeekWaitQF

8To12WeekWait numeric

The number of waits longer than 8 weeks but less than or equal to 12 weeks.

8To12WeekWaitQF text

Qualifier for 8To12WeekWaitQF

12To16WeekWait numeric

The number of waits longer than 12 weeks but less than or equal to 16 weeks.

12To16WeekWaitQF text

Qualifier for 12To16WeekWaitQF

16To20WeekWait numeric

Retrieving data. Wait a few seconds and try to cut or copy again.

16To20WeekWaitQF text

Retrieving data. Wait a few seconds and try to cut or copy again.

20To24WeekWait numeric

Retrieving data. Wait a few seconds and try to cut or copy again.

20To24WeekWaitQF text

Qualifier for 20To24WeekWaitQF

24To28WeekWait numeric

The number of waits longer than 24 weeks but less than or equal to 28 weeks.

24To28WeekWaitQF text

Qualifier for 24To28WeekWaitQF

28To32WeekWait numeric

The number of waits longer than 28 weeks but less than or equal to 32 weeks.

28To32WeekWaitQF text

Qualifier for 28To32WeekWaitQF

32To36WeekWait numeric

The number of waits longer than 32 weeks but less than or equal to 36 weeks.

32To36WeekWaitQF text

Qualifier for 32To36WeekWaitQF

36To40WeekWait numeric

The number of waits longer than 36 weeks but less than or equal to 40 weeks.

36To40WeekWaitQF text

Retrieving data. Wait a few seconds and try to cut or copy again.

40To44WeekWait numeric

The number of waits longer than 40 weeks but less than or equal to 44 weeks.

40To44WeekWaitQF text

Retrieving data. Wait a few seconds and try to cut or copy again.

44To48WeekWait numeric

Retrieving data. Wait a few seconds and try to cut or copy again.

44To48WeekWaitQF text

Qualifier for 44To48WeekWaitQF

48To52WeekWait numeric

The number of waits longer than 48 weeks but less than or equal to 52 weeks.

48To52WeekWaitQF text

Qualifier for 48To52WeekWaitQF

52To65WeekWait numeric

The number of waits longer than 52 weeks but less than or equal to 65 weeks.

52To65WeekWaitQF text

Qualifier for 52To65WeekWaitQF

65To78WeekWait numeric

The number of waits longer than 65 weeks but less than or equal to 78 weeks.

65To78WeekWaitQF text

Qualifier for 65To78WeekWaitQF

78To91WeekWait numeric

The number of waits longer than 78 weeks but less than or equal to 91 weeks.

78To91WeekWaitQF text

Qualifier for 78To91WeekWaitQF

91To104WeekWait numeric

The number of waits longer than 91 weeks but less than or equal to 104 weeks.

91To104WeekWaitQF text

Qualifier for 91To104WeekWaitQF

104To117WeekWait numeric

The number of waits longer than 104 weeks but less than or equal to 117 weeks.

104To117WeekWaitQF text

Qualifier for 104To117WeekWaitQF

117To130WeekWait numeric

The number of waits longer than 117 weeks but less than or equal to 130 weeks.

117To130WeekWaitQF text

Qualifier for 117To130WeekWaitQF

130To143WeekWait numeric

The number of waits longer than 130 weeks but less than or equal to 143 weeks.

130To143WeekWaitQF text

Qualifier for 130To143WeekWaitQF

143To156WeekWait numeric

The number of waits longer than 143 weeks but less than or equal to 156 weeks.

143To156WeekWaitQF text

Qualifier for 143To156WeekWaitQF

Over156WeekWait numeric

The number of waits longer than 156 weeks.

Over156WeekWaitQF text

Qualifier for Over156WeekWaitQF

Additional Information

Field Value
Data last updated March 5, 2025
Metadata last updated November 26, 2024
Created November 26, 2024
Format text/csv
License UK Open Government Licence (OGL)
created5 months ago
datastore activeTrue
formatCSV
has viewsTrue
idb2dc7934-9597-412d-abad-b605439855da
last modified1 month ago
mimetypetext/csv
on same domainTrue
package ide9dbef36-a343-4b9a-ab7e-b6e6cbcbb38e
position11
revision ida3c00f27-d8de-427e-a62b-f8f509c6b029
size6.2 MiB
stateactive
url typeupload