Difference between revisions of "AquilaCRS Whats New"

Revision as of 12:14, 25 July 2014

See the change log for detailed information.

Version 1.2.1

Estimated Release: 28th July 2014

This is primarily a maintenance release to address some issues that were discovered in v1.2.0. The following have been fixed/implemented:

• Some proxy server settings were incorrectly detected, preventing national database submissions.
• Some settings were not being successfully saved to the registry: the IBID Summary Fit-To-Width option and the Large IBID View option in patient folder.
• In some situations, saving a Patient Folder with an empty Description would generate an error.
• Increased the tolerance for reporting failure to replicate with the national database to allow for one-off network faults.
• Better handle the response to attempted use of context sensitive help.
• Some users experienced an Access Violation when tabbing out of a Date field.
• Start up interrupted by error message " is not a valid integer" due to incomplete proxy server settings in IE.
• Error "A delta called VALIDATION_ERRORS is already present" could be received in some circumstances when saving a Dependency record.
• Validation messages for Dependency > Physio & Psych scoring pages not showing.

Version 1.2.0

This release, although looking very similar to previous versions, is almost 70% new under the hood. We have addressed numerous bugs, added numerous features & fields and concentrated on improving performance.

• Added user permissions:
  • On release of software, users will need permissions to be granted see Managing_Users#User_Permissions for more information.
  • Permissions are: Edit, Delete/Move, Query, Export/Print, Manage Historic data.

• Added function to move iBID record between patients (moves linked Dependency records as well)
• Added function to delete iBID record
• Added function to delete Dependency record
• Added function to delete Patient Folder
• Added function to delete Patient Demographics
• Show Historic BIBID ICU data on IBID Resusc tab for older iBID records.
• Add fields:
  • Demographics: GP Practice Code
  • Demographics: Country of Birth
  • IBID Demography: Spoken English standard
  • IBID Demography: Written English standard
  • IBID Demography: Preferred Language
  • IBID Demography: Interpreter Required
  • Inhalation: Vapour Inhalation
  • Causation: Clothing Fabric
  • Causation: Fire Resistant
• Implement theatre related analysis calculations, e.g. Total GA's, Total Grafting Ops
• Change name sounds like algorithm to SoundEx (implemented during server upgrade)
• Allow user to specify type of name search on patient search screen (exact, partial or sounds like)
• Merge iBID Demography screen with iBID Record screen
• Hide Age calculation on iBID Demographics data entry screen
• Improved Dependency to iBID linking algorithm - in rare cases where multiple IBID records match the date, now uses most severe IBID.
• Link all orphaned Dependency records with an iBID record during upgrade
• Update analysis formula for numerous fields
• IBID Summary completely re-designed
  • Uses new column layout
  • Includes numerous additional fields
  • Includes most recent Dependency data
  • Adds export functionality (requires export privileges)
  • Adds filtering functionality (for when viewing in-patients & out-patients lists)
• Add "IBID Summary for In-Patients" view
• Add "IBID Summary for Out-Patients" view
• Query tool completely re-designed
  • Queries now have their own top-level screen for maximal screen usage
  • Query is continually editable after initial execution
  • Excel export of results no longer requires Excel to be installed (requires export privileges)
  • The drop down list of field names now has the section name in brackets afterwards to better enable type-to-find
  • "Search for field" feature in field list
  • "Add field to filter" feature in field list (rt click on field name)
  • Allows use of '%' wildcard character in conditions using the "Like" operator
  • Can copy range of cells from search results to clipboard & paste into Excel or other spreadsheets (requires export privileges)
• Add Financial Year and Financial Quarter fields to the IBID Query
• Add an "IBID & Dependency" query to link both datasets
• Add a "Validation Message" query to get custom validation reports
• Validation Message engine completely re-designed
  • Improves speed
  • Validation message shows field display label not field name
  • Fix display bugs
• Remove all "spin-button" editors for number fields & replace with standard text editors
• Add Trauma Network ID to the Dependency data table on the Patient Folder to better identify which IBID record is which in cases where multiple IBID records exist
• Add Trauma Network ID to the drop-down list of IBID records in the Dependency screen to better identify which iBID is which
• Add "Large" view of IBID records to show 'card' style instead of data-table style
• Add right-click menu to all data table headers to allow access to advanced features
• Open dashboard reports (e.g. All Validation Messages & IBID Summaries) as top-level items, not embedded in dashboard to give more room
• Show expanded view of patient demographics on folder screen, with "edit" & "dismiss" options
• Re-design of the patient summary panels to enable re-use on every screen
• Patient search results default to opening the Demographics record not the folder
• Improve Age calculation & synchronise formula with other date point related analysis calculations
• Redesign layout algorithm of all data-entry screens to allow showing/hiding of individual fields (not just screens) based on record-type
• Add navigation buttons to all screens to allow opening of Patient Folder and Patient Demographics
• Adjust highlighting of key/KPI fields. Required fields have grey star, key fields have two-stars in red
• Added support for SQLite database engines for single user & demos.
• Fix all Help links
• Add additional themes with more "contrast"
  • Add "touch mode" to make rows, buttons and options larger for use with Windows tablets & touch screens
• Add confirmation of exiting when there are editor windows still open
• Set spelling auto-correct to OFF by default
• Fix spellings like Oximetry & Parenteral.
• Allow version 1.2 desktop client to be used against version 1.1 server
  • Features that rely on server to be gracefully handled
  • Show warning message to user about required upgrade
• Fixed over 300 other bugs & issues

Version 1.1.9

This release focusses on quality by fixing as many bugs as we can in the timescales. There are also some under-the-hood improvements.

• Fixed Access Violation bug when editing some date fields.
• Fixed "focus stealing" when app is running in background.
• Fixed: Validation message of date range checks now shows the correct date in the message.
• Fixed: Exporting data to excel not formatting date columns as date/time values.
• Fixed: New users' password not being shown correctly on user dialog
• Fixed: Entering search data that is too long for target fields caused SQL Truncation Error if user continued to create a patient with such values.
• New: Validation checks stop on first instance of a problem for each field, reduces number of validation messages, improves performance.
• New: Dependency date/time field no longer sets a default value
• New: Removed need for the `seconds` element in time values
• New: Right-click menu available for all data-table headers for accessing to sorting, filtering & grouping
• New: Added Validation Message to check for missing Linked IBID record in Dependency
• New: Dependency - Improved algorithm to find linked IBID Record to ensure most severe IBID case is linked in case of multiple IBID records covering same date point
• Fixed: InfoServer connection still made by WinInet - needs to use own TCP/IP stack
• Fixed: Filtering in the data tables (clicking on column heading) is case-sensitive, filtering needs to be case-insensitive.
• Fixed: Date & Time fields are being formatted as Date&Time in Excel export - now has individual date or time formatting where appropriate.
• Fixed: Changing own password and having session time out then did not silently log back in & caused "Session Not Found" error.
• Fixed: Entering data in fields in patient search fields that are too long for the database fields subsequently causes SQL Error if continue to create a patient
• Fixed: Change Parental Feeding to Parenteral Feeding on Dependency > Intensive Care form

Version 1.1.8

This version is now available & is primarily focussed on improving quality with many bugs found & fixed along with other improvements. We have also added a few new features that we have been asked for by users.

Highlights:

• The 'OK' button on each screen is now labelled 'Save & Close' to avoid any confusion as when the data is saved and/or the functionality of the button.
• iBID records are now revalidated automatically when the record type is changed.
• Added ability to manually re-validate at any time.
• Validation Messages added to dependency record & created validation rules for KPI fields.
• Improved display of validation messages on each screen: correct height, smoother updating & fixed "Record Index Out of Range" bug.
• Improved display of patient demographics history.
• Added Validation Report to Patient Demographics screen.
• Added Validation Report to Dependency screen.
• Export to Excel is no longer reliant on Excel being installed. This seemed to be causing problems for quite a lot of users, so we have completely re-written the Excel export to avoid needing Excel at all.
• Query Results screen show a summary of what was searched for.

For details of all bug-fixes please see the change log.

Known Issues:

• The IBID Query does not export the TotalLOS field correctly, i.e. it produces blanks only. A bulletin was added to the [1] website on 18 July 2013. Please read for more information.

Version 1.1.5

Released: Feb 2013

This release consists of lots of bug fixes and some major improvements in the application. For detailed information on the changes please see the change log which will be updated on final release.

Spell checking

This version introduces a spell checking component with auto replace. Every text field in the application is now spell checked, with errors being underlined in the way most users expect from a spell checker. Right clicking on the incorrect spelling displays a list of words. Additionally, commonly misspelled words are autocorrected, with full support for a user-defined auto-correct file.

Querying Improvements

When using the query tool (via IBID or Dependency queries for instance) the criteria you define and the fields you select for output can now be saved to files to be reloaded later. The criteria and field list are saved separately that allows a mix-and-match approach. Further, you can share these saved files with other users.

Pivot table/Charts

The 'Query Results' screen has been expanded to include full pivot table and chart support. Drag and drop fields from the list to create multi-level pivot tables and show a variety of charts based on the pivot table. Optionally you can show "drill-down" data by highlighting a cell in the pivot table to show the underlying data. The pivot table definition can also be saved to a file for later reuse.

New Record Types

Two new record types added:

• Non-burn, non-wound admission for care of Burn Team
• Non-burn, non-wound admission of another speciality to the Burn Service.

Application "Look and Feel"

The original application did not utilise native Windows look and feel. This new version has replaced all toolbar, menus, sidebars and status bar components in order to comply with windows look and feel more accurately. In doing so the mouse handling of the menu and toolbar items has improved greatly. We have endeavoured to keep the layout and the controls in the same place as before, so although these are major changes, they should be fairly transparent to the end user.

Selected Other Fixes

• Added Scar Potential and Prevention datasets to the IBID Query tool.
• Added Psych Assessor field to Co-Existing Disorders.
• Added Rehab Screening Performed to Dependency Psych Scoring.
• Added Improved bug reporting tool - semi-automatic and less invasive.
• Fixed "List Index Out Of Bounds" at random intervals in iBID records by altering Validation Error table view.
• Fixed importing "Acute Injury Assessment" when Admission Date is not blank now imported as "Acute Minor Admission", previously as "Acute Minor Outpatient".
• Implemented fix for previously imported records Acute Injury Assessment records that have Admission Date and were flagged as "Acute Minor Outpatient".
• Postcode analysis fields (area, district, sector) not being calculated correctly if original postcode is not complete.
• Fixed: Dependency Theatre/Intervention screen - checkboxes were 3-state but should be 2-state.
• Fixed: Time fields cannot be cleared.
• Fixed: Out of range dates caused bug report to be loaded. Now informs user via popup dialog of invalid date. MS SQL Server acceptable date range is 01-01-1753 to 31/12/9999.
• Added: New set of modern icons.
• Added: All tabs can be re-arranged via drag and drop.
• Added: Ability to skin the application to a look and feel of your choice.

Version 1.0.1 (August 2012)

As expected this version focuses even more on stability and bug fixing, with any new features restricted to very minor changes and "essential" work only.

The changelog for this release will be updated as soon as possible.

Version 0.9.15 [Gamma] (July 2012)

This release focuses on stability and minor improvements to existing features. New & fixed features this release:

• New: IBID records are now linked to the patient demographics that were active at the time of the IBID records (date point is either admission, assessment, referral or causation dates)
• New: Replication batch size limitation is removed when exiting the app.
• New: IBIDA_Demography calculations are now run when patient demographics records are updated.
• New: Patient Search results form now has a "max-records" type summary caption to provide feedback on the number of records returned.
• New: Ability to filter most recent number of days from dependency list.
• New: Improved icons for Validation Errors to be less urgent to emphasise their ""guidance"" element.
• New: Add IBID Field List help button to IBID Form to direct to help website.
• New: Dependency - allow selection of linked iBID record via drop down lookup list.
• Fixed: Postcode Analysis Calculations are producing DNK for all values (causation and demographics)
• Fixed: Patient demographics records were showing non-contiguous record start and end times for name & address records.
• Fixed: BIBID Data Transfer incorrectly setting record start times for patient name/address records, which is erroneous.
• Fixed: Showing existing form does not switch to correct tab
• Fixed: Safecall error on demographics query run with a single Description keyword.
• Fixed: Bulk Replication: remove Private_Delta_Details from export
• Fixed: Memory Leak of UserInfo complex type from server module.
• Fixed: Ensure dashboard side panel re-sizes correctly after closing search panels.
• Fixed: Dependency Query: need to sub-categorise ICU Scoring fields.
• Fixed: Dependency - remove the patient status glyph as it confuses users.
• Fixed: Dashboard Sidebar occasionally disappears when opening a query
• Fixed: Query Results - needs to show how many records are showing and the max records setting
• Fixed: Dependency Form not able to edit any data > 7 days old even when hitting Edit button

Version 0.9.14 [Gamma] (July 2012)

iBID Database version 38.4

This version fixes a number of bugs identified during the recent user training session, including the missing Afghanistan from the country code list. It also introduces two new query tools:

• Dependency Query
• Dependency Theatre/Intervention Query

The product is now a Gamma release.

Version 0.9.13 [Beta] (July 2012)

The versions up to 0.9.14 have fixed lots of bugs and improved the stability of the product. Major improvements have been made to the data replication module in response to the large amounts of data expected from the BIBID Transfer.

Version 0.9.9 [Beta] (June 2012)

This version introduces the BIBID Import and Transfer Utility. For more information see [http:

Version 0.9.8 [Beta] (May 2012)

This release fixed a major bug that was preventing data entry for a new ibid record.

Version 0.9.7 [Beta] (May 2012)

This update predominantly concentrates on interfacing the various online help systems with the software. Each page or tab will have it's own user help focussed web page. Each form in the application has a Help menu, under which one or several help items will appear depending on the number of tabs & embedded forms that are showing. There is also a quick access toolbar button containing a drop down menu of help items.

At the moment the help system is not 100% complete, so some pages may just direct you to a generic help page. The help links will be updated as and when the pages are created.

The help pages are, where appropriate, shown in a tab within the software, using an embedded web browser. Future versions may allow a choice of internal or external browser.

We've also added an internal database upgrade mechanism in the server app. This is triggered on start up of the software and now allows the software to automatically upgrade the database as well as being able to automatically upgrade the software.

We've also fixed a number of bugs reported by users, and found by internal QA. See the change log for more information on fixes.

Next release will focus on bug fixes and quality issues only. We will be developing an import process for BIBID v1 databases in parallel.

Version 0.9.6 [Beta] (Apr 2012)

This release concentrates on bug fixing following a detailed testing period, and fixes approximately 15 bugs reported in our ticketing system.

The major new feature in this release is the addition of a Validation Error report on each of the Patient Folder, and iBID forms. This complements the dashboard validation error report & provides a more focussed view of validation errors within specific patients & ibid records.

Version 0.9.5 [Beta] (Apr 2012)

IBID Database Version 37

The installation program has been changed: if you install over the top of an existing standalone installation, it now will not overwrite the database. The database file is still deleted if you uninstall the program. If you want to overwrite your database file, then you must uninstall before installing the new version.

The patient search function treats the NHS Number as a more important search criteria. It now searches for the NHS Number OR (all of the other criteria). Previously, search criteria that included the NHS NUmber with other criteria may not locate any records if the other criteria didn't match even though the NHS Number was present in the database. This fixes that and reduces the possibility of introducing duplicate NHS Numbers in the database.

Fixed some bugs with patient search function.

Version 0.9.4 [Beta] (Apr 2012)

IBID Database Version 37

Interim release to allow input of NHS Number in the following formats:

• NNN NNN NNNN
• NNNNNNNNN
• NNN-NNN-NNNN

Version 0.9.3 bld 321 (Apr 2012)

IBID Database Version 37

This software version is primarily a bug fix release.

NHS Number & email address validation have been added to the patient search form. We've also added "inline" NHS Number validation to the patient editor form. Invalid NHS Numbers also added to validation errors data.

Date editor input kind & immediate drop down on typing options have been added to the User Options form so that users can switch to their preferred method.

Version 0.9.2 bld 317 (Mar 2012)

incorporating IBID Database Version 37

Checkbox controls are now three-state (previously two-state). The new "grey" state indicates uncertainty. This affects 99% of patient and iBID boolean-type fields. (Dependency boolean fields are unchanged). The checkboxes cycle through the values in the following order: No -> Unknown -> Yes. The stored values in the database are No=0, Yes=1 and Unknown=NULL.

An iBID Registration mechanism has been introduced in this version.

This ensures that systems have to enter their official IBID Unit ID to become an iBID data provider. The registration form is visible on the dashboard and doesn't prevent access to other functions like creating a patient, querying the database and viewing reports.

The behaviour of iBID None Apply type field has been changed. In previous versions these fields hid their related option fields and then cleared them on saving. In this version ticking a None Apply type field leaves the related option fields visible and immediately clears them. This means that users can use the None Apply field to set all unknown values to No and can then selectively enter the Yes data.

The First Seen By Burns Consultant section has been moved from iBID Resusc to iBID Admission.

There have been a significant number of bugs fixed in this version.

Version 0.9.1 bld 302 (Mar 2012)

• Fixed bug in calculating IBID analysis data

Version 0.9.1 bld 273 (Feb 2012)

Firstly, we've fixed a major showstopping bug that prevented the dependency record from opening. This bug was introduced in v0.9.0.

We've also fixed a major bug in the local "DLL" server version. This did not surface itself to the user, but it caused the standalone/offline version of AquilaCRS to remain in memory when the program should have exited.

The big news in this release is the introduction of IBID Analysis. This feature means that approximately 45 new fields are available in the IBID Query feature. The new fields range from detailed analysis of postcode data, age categorisation thru to critical care minimum dataset compliant organ support "days" information. AquilaCRS calculates these values as you enter data, but in a separate thread to avoid blocking the user interface.

Years in dates are now represented as four digits everywhere. Date input of two digit years have a century window that extends back 98 years as most date entry will be retrospective.

The demographics search function defaults to showing the individual search fields now instead of the more advanced "Google" like single text entry. This single text entry field is still available at the top of the dashboard screen. It's a great productivity feature and detailed context help will be provided for this feature.

A number of IBID screens have had their layout adjusted in response to user comments.

Staff related fields in IBID admission, referral and discharge screens have had their drop down button removed to ensure user is aware that the field is a free-text field, even though a drop down list of values is still available.

The patient search function used to show a single text field (a la Google) but users requested a simpler search solution by exposing individual search fields by default.

We have fixed a large number of bugs in this release too.

ChangeLog

Live RSS feed of bug fixes/features.