RIS_STAT_Update_Changes_1.6.12_v2.8.1_v1.0.doc
Stats Update Changes by Version – Contents
VERSION 2.0.0 DATE 27/07/2007 5
NEW METHODS 5
METHOD MODIFICATIONS 6
VERSION 2.0.1 DATE 30/07/2007 10
MODIFICATIONS 10
VERSION 2.0.2 DATE 31/07/2007 10
MODIFICATIONS 10
VERSION 2.0.3 DATE 31/07/2007 10
MODIFICATIONS 10
VERSION 2.0.4 DATE 03/08/2007 10
MODIFICATIONS 10
VERSION 2.1.0 DATE 06/08/2007 11
NEW METHODS 11
VERSION 2.2.0 DATE 17/08/2007 12
NEW METHODS 12
MODIFICATIONS 12
VERSION 2.2.1 DATE 17/08/2007 14
MODIFICATIONS 14
VERSION 2.2.2 DATE 21/08/2007 14
MODIFICATIONS 14
VERSION 2.2.3 DATE 11/09/2007 14
MODIFICATIONS 14
VERSION 2.3.0 DATE 17/09/2007 15
NEW STANDARD STATS 15
VERSION 2.3.1 DATE 24/09/2007 19
MODIFICATIONS 19
VERSION 2.3.2 DATE 26/09/2007 19
NEW METHODS 19
MODIFICATIONS 19
VERSION 2.3.3 DATE 05/10/2007 22
MODIFICATIONS 22
VERSION 2.3.4 DATE 25/10/2007 22
NEW METHODS 22
MODIFICATIONS 22
VERSION 2.3.5 DATE 26/10/2007 24
NEW METHODS 24
MODIFICATIONS 24
VERSION 2.4.0 DATE 22/11/2007 25
NEW METHODS 25
MODIFICATIONS 25
NEW STANDARD STATS 26
VERSION 2.5.0 DATE 05/12/2007 27
NEW METHODS 27
MODIFICATIONS 27
NEW STANDARD STATS 27
VERSION 2.5.1 DATE 25/01/2008 41
MODIFICATIONS 41
VERSION 2.5.2 DATE 19/02/2008 41
NEW METHODS 41
STAT MODIFICATIONS 42
NEW STANDARD STAT 44
VERSION 2.5.3 DATE 10/03/2008 45
NEW FIELDS 45
MODIFICATIONS 45
VERSION 2.5.4 DATE 11/03/2008 45
MODIFICATIONS 45
VERSION 2.5.5 DATE 17/03/2008 46
NEW FIELDS 46
MODIFICATIONS 46
VERSION 2.5.6 DATE 18/04/2008 47
NEW FIELDS 47
MODIFICATIONS 48
NEW STANDARD STAT 48
STAT MODIFICATIONS 52
VERSION 2.5.7 DATE 02/06/2008 55
NEW FIELDS 55
VERSION 2.5.8 DATE 18/06/2008 55
MODIFIED FIELDS 55
VERSION 2.6.0 DATE 30/06/2008 56
NEW STANDARD STAT 56
NEW FIELDS 59
MODIFIED FIELDS 59
VERSION 2.6.1 DATE 01/08/2008 59
NEW FIELDS 59
MODIFIED FIELDS 59
VERSION 2.6.2 DATE 15/09/2008 60
NEW FIELDS 60
VERSION 2.6.3 DATE 03/10/2008 60
NEW FIELDS 60
VERSION 2.6.4 DATE 24/10/2008 61
MODIFIED FIELDS 61
VERSION 2.6.5 DATE 10/11/2008 61
MODIFIED FIELDS 61
VERSION 2.6.6 DATE 17/11/2008 61
NEW FIELDS 61
MODIFIED FIELDS 63
STAT MODIFICATIONS 63
VERSION 2.6.7 DATE 05/12/2008 64
NEW FIELDS 64
MODIFIED FIELDS 64
VERSION 2.6.8 DATE 15/12/2008 64
NEW FIELDS 65
MODIFIED FIELDS 65
VERSION 2.6.9 DATE 27/01/2009 65
NEW FIELDS 65
MODIFIED FIELDS 66
NEW STANDARD STAT 66
VERSION 2.7.0 DATE 12/02/2009 68
NEW FIELDS 68
MODIFIED FIELDS 68
NEW STANDARD STAT 70
VERSION 2.7.1 DATE 23/03/2009 73
NEW FIELDS 73
VERSION 2.7.2 DATE 07/05/2009 73
MODIFIED FIELDS 73
VERSION 2.7.3 DATE 16/06/2009 74
MODIFIED FIELDS 74
VERSION 2.7.4 DATE 30/06/2009 74
NEW FIELDS 74
MODIFIED FIELDS 75
VERSION 2.7.5 DATE 13/07/2009 75
MODIFIED FIELDS 75
STAT MODIFICATIONS 75
VERSION 2.7.6 DATE 07/08/2009 75
NEW FIELDS 75
VERSION 2.7.7 DATE 25/11/2009 76
MODIFIED FIELDS 76
VERSION 2.7.8 DATE 14/12/2009 76
NEW STANDARD STAT 76
VERSION 2.7.9 DATE 11/01/2011 77
NEW FIELDS 77
VERSION 2.8.0 DATE 26/01/2011 78
NEW STANDARD STATS 78
VERSION 2.8.1 DATE 03/06/2011 79
MODIFIED FIELDS 79
APPENDIX 80
Stats Update Changes
VERSION 2.0.0 DATE 27/07/2007
NEW METHODS
FIELD / DETAILS / GUI VERSIONPATIENT.Site Volume Info / Returns the volume key and location information for all volumes at the same site as the event details being output. If there are multiple volumes, they are returned in a comma separated list. / 06.04 onwards
DERIVED.Create > App M / Returns the number of minutes between the request received date and time, to the date and time the appointment was made. If the event has not been given an appointment, 0 is returned. / 06.04 onwards
DERIVED.Clock Reset Date / Returns the date the waiting time clock was last reset before the end date of the stat. This field helps to identify why the waiting times are as they are. If the clock has not been reset the original request date is returned. / 06.04 onwards
DERIVED.Wait Breach Date / Returns the date the event will breach the waiting time target for the exam, taking into account any clock reset dates. By default an 18 week wait maximum wait is used in this version, however the 18 week default can be overridden with an entry in the exams per hospital table for the exam. / 06.04 onwards
PATIENT.NHS Number Dups / Returns the number of other patients who have been given the same NHS number as the current patient. / 06.04 onwards
REPORTS.Examination / Returns the name of the examination the report is for. “Clinical/Summary Report” is returned if the report is a summary report, “Foetus {Foetus number} : OBS Report” is returned if the report is a foetus report, and “Uterus Report” is returned if the report is an Obstetric, but with is not for a foetus. / 06.04 onwards
DEMOHIS.Full name / Returns the patients forenames and surname in one field. / 06.04 onwards
PATIENT.Full name / Returns the patients forenames and surname in one field. / 06.04 onwards
DEMOHIS.Postcode / Returns the first part and second parts of the patient’s postcode in one field. / 06.04 onwards
EVENTS.No. Of Procs / Returns the number of procedures the event has on it. This is the sum of the number of exams from the exam codes table, for each exam code on the event, not the sum of the number of exam codes on the event. / 06.04 onwards
EXAMS.Room Desc / Returns the name of the room the exam is to be / has been performed in. If the room of the exam is unknown, a blank value is returned. / 06.04 onwards
EXAMS.Sum & exam rep / Returns any summary report and exam report text that is present, concatenated. Any formatting such as bold etc. is removed from the text before returning. / 06.04 onwards
EXAMS.Att to Rep Mins / Returns the number of minutes between the exam attendance date and time, and the date and time the exam was reported. If the exam is not attended “NOT ATTENDED” is returned, and if it is attended but does not have a report “NOT REPORTED” is returned. / 06.04 onwards
EXAMS.Att to Rep Hours / Returns the number of hours between the exam attendance date and time, and the date and time the exam was reported. If the exam is not attended “NOT ATTENDED” is returned, and if it is attended but does not have a report “NOT REPORTED” is returned. / 06.04 onwards
EXAMS.Att to Rep Days / Returns the number of days between the exam attendance date and time, and the date and time the exam was reported. If the exam is not attended “NOT ATTENDED” is returned, and if it is attended but does not have a report “NOT REPORTED” is returned. / 06.04 onwards
EXAMS.Att to Rep Str / Returns the number days, hours and minutes between the exam attendance date and time, and the date and time the exam was reported. If the exam is not attended “NOT ATTENDED” is returned, and if it is attended but does not have a report “NOT REPORTED” is returned. / 06.04 onwards
EXAMS.Att to Ver Mins / Returns the number of minutes between the exam attendance date and time, and the date and time the exam was verified. If the exam is not verified a blank value is returned. / 06.04 onwards
EXAMS.Att to Ver Hours / Returns the number of hours between the exam attendance date and time, and the date and time the exam was verified. If the exam is not verified a blank value is returned. / 06.04 onwards
EXAMS.Att to Ver Days / Returns the number of days between the exam attendance date and time, and the date and time the exam was verified. If the exam is not verified a blank value is returned. / 06.04 onwards
EXAMS.Att to Ver Str / Returns the number of days, hours and minutes between the exam attendance date and time, and the date and time the exam was verified. If the exam is not verified a blank value is returned. / 06.04 onwards
METHOD MODIFICATIONS
FIELD / DETAILS / GUI VERSIONEXAMS.Was Scheduled / Changed so the on call flag is not used to define whether an exam was scheduled. It now just checks if the exam has had an appointment status. / 06.04 onwards
ROOMSLT.Length / Added additional checks to check if the whole day, morning or afternoon of the diary is closed, and if it is, take this into account when returning the length of time of a room slot. A slot in a closed room will now return 0. / 06.04 onwards
EVENTS.Is Processed / No longer uses the exam summary database function, as this is an inefficient way to find out whether an exam has been processed. This field now just does queries to see if the event has been processed, without performing additional irrelevant queries. / 06.04 onwards
EXAMS.Reported / No longer uses the exam summary database function, as this is an inefficient way to find out whether an exam has been reported. This field now just does queries to see if the exam has been reported, without performing additional irrelevant queries. The field only returns Y if there is a report for the exam, not if a dictation is present. / 06.04 onwards
EVENTS.Unreported / No longer uses the exam summary database function, as this is an inefficient way to find out whether an event has been reported. This field now just does queries to see if the event has been reported, without performing additional irrelevant queries. The field returns N if there is no report on the event. / 06.04 onwards
Screenshot showing new fields “PATIENT.NHS Number Dups”, “DERIVED.Clock Reset Date”, and “DERIVED.Wait Breach Date”
Screenshot showing new fields “EVENTS.No Of Procs”, “REPORTS.Examination”, “EXAMS.Room Desc”, “EXAMS.Att to Rep Days”, “EXAMS.Att to Rep Hrs”, “EXAMS.Att to Rep Mins”, “EXAMS.Att to Rep Str”, “EXAMS.Att to Ver Days”, “EXAMS.Att to Ver Hrs”, EXAMS.Att to Ver Mins”, and “EXAMS.Att to Ver Str”.
Screenshot showing new fields “PATIENT.Full Name” and “DEMOHIS.Postcode”
VERSION 2.0.1 DATE 30/07/2007
MODIFICATIONS
FIELD / DETAILS / GUI VERSIONEVENTS.Unreported / Issued where instances that should have returned Y returned N and vice versa has been fixed. / 06.04 onwards
VERSION 2.0.2 DATE 31/07/2007
MODIFICATIONS
FIELD / DETAILS / GUI VERSIONDERIVED.Req > Rep Ver S / Fixed bug where this field would error and cause stat to fail. This was due to the wrong number of parameters being passed. / 06.04 onwards
VERSION 2.0.3 DATE 31/07/2007
MODIFICATIONS
FIELD / DETAILS / GUI VERSIONN/A / Re implemented the getNHSTraceType method for returning the trace type of 10. This is not available from the GUI application, only for HSS staff with access to the back end database. / N/A
VERSION 2.0.4 DATE 03/08/2007
MODIFICATIONS
FIELD / DETAILS / GUI VERSIONDERIVED.Att to Rep Days / Fixed error being caused by attempting to close the same result set and SQL statements multiple times. / 06.04 onwards
DERIVED.Att to Rep Hours / Fixed error being caused by attempting to close the same result set and SQL statements multiple times. / 06.04 onwards
DERIVED.Att to Rep Mins / Fixed error being caused by attempting to close the same result set and SQL statements multiple times. / 06.04 onwards
DERIVED.Att to Rep Str / Fixed error being caused by attempting to close the same result set and SQL statements multiple times. / 06.04 onwards
VERSION 2.1.0 DATE 06/08/2007
NEW METHODS
FIELD / DETAILS / GUI VERSIONPATIENT.Main Volume Info / Returns the location code, location name, volume type, and move date of each of the main volumes of the patient, that are at the site of the particular event being output. / 06.04 onwards
Screenshot showing the new field “PATIENT.Main Volume Info”.
VERSION 2.2.0 DATE 17/08/2007
NEW METHODS
FIELD / DETAILS / GUI VERSIONDERIVED.Req > Rec Days / Returns the number of days between the request being made and the request being entered on the system. / 06.04 onwards
DERIVED.App Made > Att S / Returns the days, hours and minutes from the date the last appointment was made after any reset dates, up to the attendance date and time. If no appointment was ever given to the event "NO APPOINTMENT" is returned, if the event is not yet attended "CURRENT: {current status code}” is returned. / 06.04 onwards
DERIVED.Rec > App M Str / Returns the days, hours and minutes from the request received date and time, to the date and time the first appointment was given. If no appointment was ever given to the event "NO APPOINTMENT" is returned. / 06.04 onwards
DERIVED.Proc > Typed Str / Returns the days, hours and minutes from the process finish time to the time the report was typed. If the event is not attended, "NOT ATTENDED" is returned. If the event is not processed, "NOT PROCESSED" is returned. "NO PROCESS TIME" is returned if the end time of the exam is not filled in on the post processing page. / 06.04 onwards
DERIVED.Req > Rep Ver S / Returns the number of days from the request being made to the report being verified. If the report is not verified, "NOT VERIFIED" is returned. / 06.04 onwards
DERIVED.Type > L Ver S / Returns the amount of time (Days, Hours and Minutes) from the time the report was typed, to the time the exam was last verified. If the exam is not verified, "NOT VERIFIED" is returned. / 06.04 onwards
MODIFICATIONS
FIELD / DETAILS / GUI VERSIONEXAMS.Verified Date / Changed to use the date last verified as the verification date, rather than the date first verified. / 06.12 onwards
N/A / The fields that are formatted as time in the form of days, hours and minutes, now always returns the minutes and hours, even if they are 0. e.g. 2D 0H 0M. / 06.04 onwards
DERIVED.Att to Proc Str / Returns any values in uppercase rather than mixed case. The "Hrs" and "Mins" have been changed to "H" and "M" for quicker case searching when querying on this field. / 06.04 onwards
Many / Fields when the clock could be stopped and reset have been improved as sometimes a DNA would not reset the clock. / 06.04 onwards