Activity by Location of Treatment and Specialty
Specialty breakdown for new outpatient appointments and 'Did Not Attends' by location of treatment.
Size: 2.59MB
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| FinancialYear | text | The reference period as financial year (YYYY/YY) | |
| FinancialYearQF | text | Qualifier for FinancialYear | |
| HB | text | 9-digit code for NHS board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories | |
| HBQF | text | Qualifier for HB | |
| AppointmentType | text | ||
| AppointmentTypeQF | text | ||
| Location | text | 5-digit code for location of treatment and country code for Scotland | |
| LocationQF | text | Qualifier for Location | |
| Specialty | text | Specialty | |
| SpecialtyQF | text | Qualifier for Specialty | |
| SpecialtyName | text | The name of the Specialty | |
| SpecialtyNameQF | text | Qualifier for SpecialtyName | |
| SpecialtyGrouping | text | Specialty Grouping. The "All Acute Specialties" grouping includes the medical and surgery groupings combined. | [Specialty Groupings] (https://www.publichealthscotland.scot/media/13029/specialty-groupings.xlsx) |
| SpecialtyGroupingQF | text | Qualifier for SpecialtyGrouping | |
| Attendances | numeric | ||
| AttendancesQF | text | ||
| NewReturn | numeric | Ratio of New Attendances to Return Attendances | |
| NewReturnQF | text | Qualifier for NewReturn | |
| DNA | numeric | Number of patients who did not attend appointments. | |
| DNAQF | text | Qualifier for DNA | |
| DNARate | numeric | ||
| DNARateQF | text | ||
| Patients | numeric | ||
| PatientsQF | text |
Additional Information
| Field | Value |
|---|---|
| Data last updated | September 30, 2025 |
| Metadata last updated | September 28, 2020 |
| Created | September 28, 2020 |
| Format | text/csv |
| License | UK Open Government Licence (OGL) |
| created | over 5 years ago |
| datastore active | True |
| format | CSV |
| has views | True |
| id | 4e72be27-bec3-41ca-a0df-24417909d143 |
| last modified | 1 month ago |
| mimetype | text/csv |
| on same domain | True |
| package id | d57ceb20-4449-4c3b-b07c-d2affe9b8dc0 |
| position | 5 |
| revision id | 61981f07-00d4-4838-8659-2574f2abe821 |
| size | 5.8 MiB |
| state | active |
| url type | upload |