Date of Request: May 2007
Dataset(s) AffectedI.T. Systems Affected
ISD(S)1 / PAS, HISSRaised By: / Reference (office use only):
Name / Allison Gilchrist
Job Title / Data Development Manager
Organisation / ISD/DIG
Address / Area 54B
Gyle Square
Tel. No. / Ext 6309 / Fax. No.
Change Requested (be explicit about which data items involved and how):
Change Requested
To change the method of submitting ISD(S)1 data. Note that there is no change to the data or dataset.
CURRENT METHOD
Data submission - Data is currently submitted to ISD by NHSScotland in fixed width format. Data is received by email.
Data validation - data is validated locally prior to submission using the SHARP system (although ISD is aware that not all sites do this).
Data amendments - amended data is currently sent as a full re-submission or in part
UPDATED METHOD
Data submission - data will be submitted direct to the Oracle database using Swift- DVL processing. (This method is used successfully for submission of other ISD datasets). File format can be either fixed width or csv. A separate submission is required for each Card Class. Each file requires a header record. ISD will provide data templates/layout.
Data validation - data will be validated at ISD during import to the database. If the file fails to load, an error report will be returned to sender.
Data amendments - when SWIFT is implemented for ISD(S)1 and users/sites want to amend data already submitted via SWIFT this must be done by sending an updated version of the full submission for the card class as the amended file overwrites the entire previous submission.
CHANGES REQUIRED
SHARP will no longer be supported by ISD.
Data will be submitted using SWIFT – DVL Processing
Level of Urgency (information on how soon the request needs to be implemented and why):
We plan to implement this method of submission on 1st October 2007 so consultation/communication has to be soon. We are also approaching holiday periods so the optimum time for consultation is within the next 3 to 4 weeks.
Background (i.e. reason for request):
SHARP uses a version of Access which is no longer supported and is not flexible enough to accommodate a revised dataset ie the inclusion of card class 9 in 2003.
To standardise data submission as it currently arrives in ISD by different methods.
To use more modern methods of submitting and receiving data.
Event Log (office use only)
Date / Event
19/07/07 / I have shared the responses with the team and there are no show stoppers to implementation. I see no need for a meeting. Someone from the review team will be in touch with those who have responded. Alison Gilchrist
-----Original Message-----
From: Wilson, Gordon
Sent:20 December 2007 12:10
To:Gilchrist, Allison
Subject:RE: ISDS1 change request
Alison
Can you possibly advise me where we are with this change request?
< File: 070766 ISDS1.doc >
Thanks
Gordon
-----Original Message-----
From: Gilchrist, Allison
Sent:11 October 2007 10:34
To:Young, Stephen; Wilson, Gordon
Cc:Reid, Brian
Subject:RE: ISDS1 change request
Stephen
I will speak to Brian, Jay etc and get back to you. I think Brian & co are out all day so tomorrow will be the first opportunity for me to speak to them. I'm sorry you have had no follow up on this and will get back to you tomorrow.
Regards
Allison
-----Original Message-----
From: Young, Stephen
Sent:11 October 2007 07:35
To:Wilson, Gordon; Gilchrist, Allison
Subject:RE: ISDS1 change request
Alison / Gordon - my comments on 19th June:
"Gordon - does this mean that ISD(S)1 data will be held in Oracle as it's "home" and therefore can be analysed directly with SQL like, eg, SMRs? Currently source ISD(S)1 data is in the form of SPSS system files which is a major pain when integrating with other Oracle based data sets. If this data's "home" is to be moved from SPSS to Oracle then you have my fulsome support but the consequences of this will have to be thought through."
... and I've still not had a reply!
Will New Ways in the pipeline and the redevelopment of the web site it will be necessary to integrate New Ways & SMR data (in Oracle) with ISD(S)1, so this issue is becoming more pertinent.
S
-----Original Message-----
From: Wilson, Gordon
Sent:01 August 2007 15:20
To:Young, Stephen
Cc:Gilchrist, Allison
Subject:FW: ISDS1 change request
Stephen
Your feedback is in this spreadsheet
< File: ISDS1 Feedback.xls >
Alison says that someone from the review team will be in touch
Regards
Gordon
-----Original Message-----
From: Gilchrist, Allison
Sent:19 July 2007 16:44
To:Wilson, Gordon
Cc:Johnston, Philip (ISD); Mohammed, Themina; Reid, Brian; Bostock, Jay
Subject:RE: ISDS1 change request
Gordon
I have shared the responses with the team and there are no show stoppers to implementation. I see no need for a meeting. Someone from the review team will be in touch with those who have responded.
Regards
Allison
-----Original Message-----
From: Wilson, Gordon
Sent:19 June 2007 11:28
To:Gilchrist, Allison
Cc:Johnston, Philip (ISD); Mohammed, Themina
Subject:FW: ISDS1 change request
Allison
Can you advise me who to invite to the meeting should we have one?
Philip suggested we may not need a meeting, but I wonder if I should set one up provisonally so this can happen quickly if we need it (given diffculties of availability)
Thanks
Gordon
-----Original Message-----
From: Wilson, Gordon
Sent:19 June 2007 11:20
To:/o=CSA/ou=ISD/cn=Recipients/cn=Barabra.Iwinska; Anderson, Ron (Tayside); Anderson, Valerie; Arbuckle, Paul; Beattie, Ernest; Boyle, Ted; Boyle2,Ted; Brian MacGowan (E-mail); Bryden Robert (E-mail); Cully, Stewart; Davies, Lee; Deirdre Coyle (E-mail); Diane Fleming; Dominic Dick; Donnelly, Dorothy; Downie, Norma; Ewen, Ken; Ferguson, Dougie; Flora MacInnes (E-mail); Galloway, Joyce; Gilchrist, Allison; Gillen, June; Gordon jack; Grant, Pat; Gray, Jamie; Greenlees, Val; Harper, Clare; Helen Nettleship; Hood, Dave; Horne, Marilyn; Hugh Scouller (E-mail); Jane Knox (E-mail); John Duncan; Johnston, Philip (ISD); Jonathan Todd; Jones, Chris; Kathleen Houston; Kerr Donaldson (E-mail); Lynne Buttercase (E-mail); Marshall, Ann; Mason, Margaret; McAdie, Joyce; McConnell, May; McInneny, Kevin; McIntosh, Janice; McVeigh, Pam; Mohammed, Themina; Padfield, Matthew; Pat Pirie (E-mail); Philip. Wield (E-mail); Ramsay, Lorna; Rankin, John; Reekie, Alan; Reid, Margaret; Robertson, Jim; Ross, Veronica; Smith, Marjorie; Stefano Pilloni; Waldron, Jim; Ward, Ann; Wilson, Gordon; Young, Stephen
Subject:ISDS1 change request
Could I please have your comments feedback on this change request by the 10th July?
< File: ISDS1.doc >
If you are completely satisfied with this request, could you please also email me to say this.
A meeting is not planned to discuss this, but can be arranged depending on feedback and if you would like to attend
Thank you
Gordon Wilson
Data Development Officer
National Clinical Dataset Development Programme (NCDDP)
NHS National Services Scotland
Gyle Square
1 South Gyle Crescent
Edinburgh
EH12 9EB
0131 275 6914
20/12/07 / Gordon
Change was made for all submissions from 1st October 2008. All settled in and working fine.
Allison
Agreed by DLG
Agreed by Change Group
Please return to: Gordon Wilson, Data Intelligence Group, ISD, Information Services (ISD), NHS National Services Scotland, Gyle Square, 1 South Gyle Crescent, Edinburgh, EH12 9EB