Referral to Treatment Times - Details of Return

Referral to Treatment Times – Details of Return

Field Order	Format
Data Reference	2 alpha characters
Return Date	ccyymmdd
Organisation Code (LHB Area of Residence)	3 alpha numeric characters
Organisation Code (Code of Provider)	3 alpha numeric characters
Main Specialty (Consultant)	3 digit numeric
Weeks Wait	Alpha Numeric
Count	Numeric

All returns are to be sent in the form of a comma separated text file (csv format), i.e. in which the values in each field are separated by commas. There will be no header record.

The return should be named as:

xxxmmmyy.csv

where: xxx = the Local Health Board/ Trust code

mmm = first three letters of the month to which the data relates, e.g. Apr for the first submission of data relating to waiting times at end April.

yy = last 2 digits of the year

The return should be sent via the secure upload mechanism located on http://nwdss.hsw.wales.nhs.uk/ (NHS Wales Users Only)

Each time a return is submitted, Local Health Boards /Trusts should complete a HSW submission form and send it via e-mail to Waitingtimes@wales.nhs.uk with a subject heading of 'Referral to Treatment Times'.

Returns should be sent to reach HSW on the 25th day of the month or the next working day. From 1^st April 2008, the inclusion of the Local Health Board is mandated.

Only include RTT waits for elective specialty services available in your Local Health Board/ Trust. If your Local Health Board/ Trust provides a service but there are no patient’s with neither open or stop clocks, a zero should be placed in the zero week wait time band and the LHB field should be left blank.