CCMDB.mdb Change Log 2010

From CCMDB Wiki
Jump to navigation Jump to search

see the Development Documentation Category for other development logs

The CCMDB.mdb Change Log logs changes made to the CCMDB.mdb, including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general. When a change is tested and rolled out it is also documented here.


Bugs & Requested Changes

Bug reports and requested changes have been popping up in different places. Please post article-specific things under the article (e.g. a tmp study's consistency check is broken). Please put general concerns under Requested CCMDB changes for the next version. Thanks, Ttenbergen 12:58, 29 October 2009 (CDT)

Versions

V1.9934

Rolled out Ttenbergen 10:12, 23 April 2010 (CDT)

  • hiding the ABG Checker button for medicine since they don't collect ABG. Ttenbergen 16:43, 22 April 2010 (CDT)
  • fixed pH checking stuff Ttenbergen 10:11, 23 April 2010 (CDT)

V1.9933

Rolled out. ' --Ttenbergen 15:16, 22 April 2010 (CDT)

  • CCMDB.mdb allowed entering an item for a project it was not associated with. Working on fix Ttenbergen 16:12, 30 March 2010 (CDT)
  • fixed tab order in Registry tab Ttenbergen 11:40, 9 April 2010 (CDT)
  • fix to ApDO2 calculator, form wasn't updating properly Ttenbergen 15:03, 9 April 2010 (CDT)
  • added automated settings changes to Database_starter function for full menus, correct macro security settings, auto-compact, automatically find with "any part of field"; some of these changes would only work once Access is restarted, so these are largely to ensure things stay set the right way.Ttenbergen 15:53, 9 April 2010 (CDT)
  • added "find dx" button to the Dx chooser to facilitate searching for diagnoses. Ttenbergen 16:01, 9 April 2010 (CDT)
  • made "view" button in patient list into binoculars and moved buttons/labels to save screen space. Ttenbergen 16:06, 9 April 2010 (CDT)
  • made "type" label in DX lister into a button that will re-sort the list to standard sorting; when entering directly this will make it easier to read the listing and make sure all is in there. Ttenbergen 09:37, 12 April 2010 (CDT)
  • took pH out of ABG testingTtenbergen 10:11, 14 April 2010 (CDT)
  • added Apache scores and score-listers to Apache values. Ttenbergen 10:11, 14 April 2010 (CDT)
    • Should the apache scores be visible for medicine, for those values collected in both programs? Template:Discussion Ttenbergen 10:11, 14 April 2010 (CDT)
  • added "Add Patient" to patient list form, to be able to add patients from there rather than having to do so from the patient editor page. Ttenbergen 10:45, 14 April 2010 (CDT)
  • made function "add_record_status" to add record_status field to L_Log in preparation for new data repository. This has to be done locally for laptops since we don't have central access to the data, so automation was required. Ttenbergen 10:28, 15 April 2010 (CDT)
  • changed the notes field so that double-clicking the notes field will open it in a much larger window. Ttenbergen 15:50, 16 April 2010 (CDT)
  • changed Patient List and Viewer to open in maximized version. Ttenbergen 13:58, 20 April 2010 (CDT)
  • added "close" button to patient list. Ttenbergen 13:58, 20 April 2010 (CDT)

t1

test-fix 1: commented out add_record_status since it does not work on linked tables (i.e. on laptops). Change rolled to TestersTtenbergen 09:27, 21 April 2010 (CDT)

t2

test-fix 2:

  • fixed old error where non-overlapping duplicates were not allowed. didn't know this was still an issue.

Change rolled to Testers -Ttenbergen 14:06, 21 April 2010 (CDT)

t3

test-fix 3:

  • followed request to change sort order of pathogens to have the following first (codes 59 65 68 92 to top) :
    • negative culture
    • no culture sent
    • unknown pathogen
    • Aspiration ...

Change rolled to Testers-Ttenbergen 14:18, 21 April 2010 (CDT)

t4

test-fix 4:

  • fixed bug in ApDO2 chooser

Change rolled to Testers-Ttenbergen 15:06, 21 April 2010 (CDT)

t5

tweaks to duplicate checker; Change rolled to Testers-Ttenbergen 14:19, 22 April 2010 (CDT)

TESTING COMMENTS

  • Testers for version 1.9933 put you comments here. Thanks--TOstryzniuk 15:20, 19 April 2010 (CDT)

ph part still needs fixing...when I enter a seCo2, it still requires a ph to be entered, except there is no ph not to go with seCo2. ph needs to be put in the ABG section. BDeVlaming 16:00, 22 April 2010 (CDT)

V1.9932

Put file into master for Trish to fix up peer-audit and roll. Ttenbergen 09:44, 12 March 2010 (CST)

  • Edited dx name for severe sepsis, original included definition and was too long to list properly in any fields.
    • Currently investigating other long dxs with TrishTtenbergen 14:19, 9 March 2010 (CST)
      • Decided to leave other long DXs alone for now for expedience. Ttenbergen 09:44, 12 March 2010 (CST)
  • ECHMO and co fix. Ttenbergen 14:48, 10 March 2010 (CST)
    • fixed spelling of ECMO (was ECHMO) in s_alldiagnoses
    • added ECMO and Line insertion as non-mandatory reasons for admission from OR, see Check_ORDx
    • made ECHMO -> ECMO change in s_handbase as well.Ttenbergen 14:51, 10 March 2010 (CST)
      • if ECMO, is in admit DX slots then must be from the OR.TOstryzniuk 15:24, 11 March 2010 (CST)
        • I'd rather keep this "can be". The ECMO case Laura told me about actually had ECMO put on in the ER. Ttenbergen 09:34, 12 March 2010 (CST)
  • Removed STB_B5 from s_locations. Ttenbergen 09:44, 12 March 2010 (CST)

V1.9931

added the following to peer_audits_partners and rolled out:

  • VIC S4 VIC_S5 Shirley - added 2010-03-03 as per Shirley's request due to Tara's LOA
  • VIC S5 VIC_S3 Wendy - added 2010-03-03 as per Shirley's request due to Tara's LOA

Ttenbergen 14:26, 3 March 2010 (CST)

V1.993

V1.993 Status

Rolled out. Ttenbergen 11:47, 24 February 2010 (CST)

V1.993 Changes

  • changed end date for QA Septic Shock: QASeptic_Stop = #12/31/2010#
  • pathogen listing made wider
  • ensured dx sorting is same in dx form data source (changed query in properties) as in send_dxs (changed L_DiagnosesSort) to fix bug where two dxs of equal priority would give OR_DX error to the exclusion of the actual priority error. This didn't affect output because a duplicate priority error would have been launched if the other error had not happened first.
  • ABG Helper button and form added to facilitate AaDO2 calculation
  • BP Helper button added, not yet functional
  • Changed the way check functions access data from using using "Set this_db = CurrentDb" to accessing CurrentDB directly; had used this_db to address a different error earlier on which no longer seems to be a problem
  • changed Check Renal IncompatibleDxs to implement changes in Renal_Coding_Considerations#Competing_Diagnoses
  • changed Pending_Julie to list discharge dates even if a time is not entered

V1.992

Status

  • Copy back to Master and rolled out.--TOstryzniuk 18:18, 14 January 2010 (CST)
  • rolled out Ttenbergen 11:24, 7 January 2010 (CST)

Changes

  • changes to Peer Audit Partners table.--STB_B5 added. Gayles PDA is know as B5 not E6 because location_setting are hard coded into HanDBase. --TOstryzniuk 20:00, 20 January 2010 (CST)
  • changes to Peer Audit Partners table made.--TOstryzniuk 18:18, 14 January 2010 (CST)
  • duplicate checker changed to disregard audit patients (an audit patient might move to a collector's home ward). Tina

V 1.991

  • Peer audit table comment column added to include Original PDA location setting and other notes for IT and data processing. Rolled out.TOstryzniuk 17:26, 4 January 2010 (CST)

Batch File Changes

~Nov-dev 2009 Changed batch files to create a total of 20 previous versions for each location to retain data. Ttenbergen 12:21, 30 November 2009 (CST)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2010&oldid=18059"