New Ways Home Latest Resources FAQs Data Warehouse Data Task Force Patient Information Guidance Links Contacts
New Ways
Data Warehouse
The management of waiting times nationally and locally under New Ways of Defining and Measuring Waiting Times will be achieved through local waiting times information stored in a national data warehouse. Data will be extracted on a frequent basis into a data warehouse developed by ISD.
New Ways Data Warehouse - Introduction
Business Objects Universe
Data Errors and Warnings
Data Validation Comparison
XML Schema
Data Warehouse Meetings
New Ways Data Warehouse Working Group
Business Objects: Training
New Ways Data Required and Extraction Specification
New Ways Data Warehouse - Introduction
Customer Support Desk
If you are experiencing problems accessing New Ways data through Business Objects (in particular looging on and accessing the BO environment) and you are confident that this is not a local issue then please contact the ISD Customer Support Desk on 0131 275 7777 in the first instance. This will allow any issues to be logged quickly and raised at the correct priority.
Data Errors and Warnings
During the last few weeks of 2007, the main focus of New Ways development has shifted from PAS implementations to the extraction and validation of data. It may be of value to you and your New Ways team to consider what type of errors are being commonly encountered. The document 'examples of data problems' is by no means comprehensive but it highlights those data items where you too may experience issues.
Each been classified as errors or warnings, although, as with everything in the New Ways programme, the arrival of real live data is identifying new issues every day which have to be addressed. Therefore these categories of errors or warnings may change with this experience, but we think sight of them now will be of value to you.
Data Validation Comparison
-
A comparison of the validation outlined in Appendix 5 of the Specification (Version 1.1a - 28 February 2007) and the current validation being used.
-
Data Validation Comparisons V0.4a
(14 March 2008)
-
-
A list of changes made to validation since 18 December 2007
-
Changes to validation since 18 December 2007 (14 March 2008)*
-
*Please note that reference to VE59A in this document is incorrect. Validation Check VE59a - Reason for removal from list must be entered when a date of removal from list has been entered has not been removed and will remain as an error. The document will be updated to reflect this.
XML schema
-
Version 0-6 November 2007
-
XML schema and data submission requirements - letter issued 4 October 2007
Initial work with sites has highlighted some issues with one part of the XML schema, that was circulated on 28 February 2007. As a result of this it has been necessary to make some slight changes to that schema. These changes are needed to take account of differences between Oracle and Microsoft in implementation of the schema. Any sites that have provided sample extracts in the previous format, where there have been no issues, the previous XML schema may be retained. A letter was issued by e-mail on 4 October 2007 to New Ways leads, NHS Board IT contacts and system suppliers to update on XML schema and to provide clarification on data submission requirements.
The XML schema at 4 October 2007 are below:
Data Warehouse Meetings
ISD will be hosting the next Data Warehouse Meeting at ISD offices at Gyle Square on Wednesday 30 July 2008. The meeting will start at 12.00 pm and finish at 4.00 pm. A working lunch will be served. If you wish to attend this meeting or join by videoconference please contact Jane Thomson - e-mail jane.thomson@isd.csa.scot.nhs.uk tel - 0131 275 8925 at your earliest convenience. [Updated 25 June 2008]
-
Notes from Data Warehouse Meeting - 9 June 2008 [Updated 18 June 2008]
-
On 1 June a group of staff from the NHSScotland and ISD met to discuss the New Ways Data Warehouse and Business Objects. A report from event and presentation:
New Ways Data Warehouse Working Group (NWDWWG)
Following on from the Business Objects Development Day on 1 June, a working group was established to help agree the final stages of development for the New Ways data warehouse.
Business Objects: Training
There are national arrangements in place for training in Business Objects at reduced cost for NHSScotland through the training company Eclectic. Training should be booked through Nadia Mackinder at Eclectic who can be contacted on 0141 243 4812.
New Ways Data Required and Extraction Specification
-
Specification of data required and its extraction 28 February 2007 Version 1.1a This specification supercedes Version 1.1 dated 13 February 2007. Version 1.1a corrects a typographical error and adds further clarification to WT19 and WT25(1).
In future, should an issue result in a substantive change to the specification it will be managed through a formal change control procedure but as it stands, this specification (Version 1.1a) is final and is the statement of what is required to deliver New Ways functionality.
Jane Goodall
Printer friendly version
