CCMDB.mdb Change Log 2010

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.9938

Not rolled out yet Ttenbergen 12:35, 7 June 2010 (CDT)

• patient list changes, please comment at Feedback Request - Patient List
  • added "Find Patient" button to patient list
  • disabled editing on the patient list to prevent bypassing checks
  • added sorting buttons both ways for all columns in Patient List
• added H7 as an option for tmp moves Ttenbergen 13:09, 7 June 2010 (CDT)
• fixed phin field so it's never scientific notation Ttenbergen 13:12, 7 June 2010 (CDT)
• made checkbox in tmp form into an actual checkbox on the tmp form Ttenbergen 13:15, 7 June 2010 (CDT)
• moved registry tab to be first (wonder why it wasn't, hope there wasn't a reason Ttenbergen 13:18, 7 June 2010 (CDT)
• deleted remnants of CPAP, SerUrea, DBili, UrineOutput, ActiveTx since no longer used Ttenbergen 10:54, 9 June 2010 (CDT)

v1.9937

Rolled out. Ttenbergen 12:27, 17 May 2010 (CDT)

• fixed ABG helper Ttenbergen 17:47, 13 May 2010 (CDT)
• changed serCO2 apscore to be blank if ABGs are used Ttenbergen 12:13, 14 May 2010 (CDT)
• fixed bug that left an admit or acquired dx blank without generating an error if the pathogen was blanked out. error only affected laptop locations.
  • Note: Ed's program would have caught a blank dx unless the blank one was the last one. So, this could not have led to pts without any data, but it could have led to a lowest priority dx missing. The pathogen data is defaulted to "No Value", so someone would have had to delete that for this bug to manifest itself . Ttenbergen 12:27, 17 May 2010 (CDT)

V1.9936

Rolled out Ttenbergen 12:07, 5 May 2010 (CDT)

• made 763-30 (Defibrillator implant) non-mandatory OR as per email from Trish/Laura

V1.9935

Re-rolled because the original was of a bad version. Ttenbergen 10:35, 29 April 2010 (CDT)

• removed following line which causes error in Access 2002 under certain circumstances
  • Application.automationsecurity = 2 ' means "msoAutomationSecurityLow" without reference necessary
• change double-click on notes so that current changes to notes field (and rest of record) are written to DB before opening notes form. Thanks to Shirley for catching and describing this! Ttenbergen 10:35, 29 April 2010 (CDT)

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)

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)

• Updt all.bat changes complete
• "News and backup" batch file changes complete