This website places cookies on your device to help us improve our service to you. To find out more about the cookies, see our Privacy and Cookies notice
ISD Scotland better information, better decisions, better health

ISD(S)1 Data Collection

Hospital Records Data Monitoring

NHS National Services Scotland ISD Scotland & NHS National Services Scotland

ISD(S)1 Data Collection

ISD(s)1 is a standard set of aggregated summary statistics on activity in hospitals and other health care settings in Scotland. Data collected includes: Available and occupied beds numbers, Inpatients and day cases treated, Outpatients and ward attenders seen, Day patient places and day patients seen, Haemodialysis patients, Patients seen by allied health professionals and other technical departments, Hospital cancellations and additions to waiting list and Nurse led outpatient activity.

Submission Dates for 2013

Monthly returns - CC1, CC2, CC8 & CC9

  • 18th January (December data)
  • 22nd February (January data)
  • 22nd March (February data)
  • 19th April (March data)
  • 24th May (April data)
  • 21st June (May data)
  • 19th July (June data)
  • 23rd August (July data)
  • 20th September (August data)
  • 18th October (September data)
  • 22nd November (October data)
  • 20th December (November data)

Quarterly returns - CC3, CC4, CC5, CC6 & CC7

  • 25th January (October - December data)
  • 26th April (January - March data)
  • 26th July (April - June data)
  • 25th October (July - September data)

Submission Guidance

All ISD(S)1 submissions are to be sent via SWIFT - DVL Processing using the link below. The steps are:

  • create your data file - either csv or text
  • send to ISD via SWIFT -DVL Processing (secure file transfer)
  • data file is loaded and validated at ISD
  • outcome of the data load is presented to you at time of loading

https://oas.nss.scot.nhs.uk/swift/

This is the latest version of SWIFT.

  • Save to your Favourites as ISD(S)1 SWIFT Login
  • Login (username and password will be provided for new users)
  • Click on DVL Processing
  • Browse to find your file
  • Submit

Data Templates

If your data is in a spreadsheet format use the MS Excel templates.

  • Enter the data into the template
  • Update the header record
  • Save as a CSV (comma separated values)

Card Class 1 Download Excel file [23kb] - Inpatients

Card Class 2 Download Excel file [17kb] - Day Bed Units

Card Class 3 Download Excel file [17kb] - Day Patients

Card Class 4 Download Excel file [16kb] - Consultant Outpatients

Card Class 5 Download Excel file [16kb] - Ward Attenders & Bedside Consultations

Card Class 6 Download Excel file [16kb] - Intermittent Haemodialysis

Card Class 7 Download Excel file [17kb] - AHPs & Other Technical Departments

Card Class 8 Download Excel file [16kb] - Hospital Cancellations & Additions to Waiting List

Card Class 9 Download Excel file [16kb] - Nurse led Activity

Please note: you must populate any blank data fields with a zero value.

Sending Location

This field in the header record identifies the dataset to ISD. Please use the Sending location code provided by the ISD(S)1 team.

Validation

Your data file will be validated at ISD during import to our database. Data import and validation is part of the SWIFT - DVL Processing submission. You will be presented with an online load report once the file has been processed.

Data validation at ISD is in 3 parts:

  1. header record - all fields must be valid including edition
  2. data type - as well as an alpha/numeric check, each data record is validated against the national reference files for location, specialty and facility codes
  3. validation rules - data logic that is specific to each card class.

Validation Rules Download Excel file [41kb]

Contact Us

If you have any queries please contact the ISD(S)1 team.

© ISD Scotland 2010
Information Services Division,
NHS National Services Scotland,
Gyle Square,
1 South Gyle Crescent,
Edinburgh EH12 9EB,
Tel: 0131 275 7777
nss.csd@nhs.net

About Information Services Division | Contact Us | Accessibility | Complaints
Copyright | Terms and Conditions | Privacy | Site Map | Freedom of Information | Data Protection

ISD is a division of NHS NSS
Working at the very heart of the health service, NSS delivers services critical to frontline patient care and in support of the efficient and effective operation of NHS Scotland. Visit the NSS Website for more information