CCMDB data.mdb Change Log

see the Development Documentation Category for other development logs

The CCMDB_data.mdb Change Log logs changes made to the CCMDB_data.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; make sure you mark any discussion with {{discussion}} so it doesn't get lost in the fray. 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

2011-02-23

not rolled yet Ttenbergen 14:56, 23 February 2011 (CST)

Must be rolled out before ccmdb.mdb ver 2011-02-16 Ttenbergen 16:00, 24 February 2011 (CST)

• default lab date to today Ttenbergen 13:40, 23 February 2011 (CST)
• changed table level validation rules for L_BPs DBP and SBP to allow 0, as in not entered. Ttenbergen 16:00, 24 February 2011 (CST)
• removed priority and rank fields from L_Como Ttenbergen 13:13, 25 February 2011 (CST)
• removed TISSComplete and LaborPharmMissing from L_Log Ttenbergen 13:13, 25 February 2011 (CST)
• renamed L_Log.chart# to L_Log.chart since it keeps causing grief Ttenbergen 16:10, 25 February 2011 (CST)

V2

rolled out yesterday but not tied in yet. tie-in will happen with a change in Log. Ttenbergen 14:36, 26 October 2010 (CDT)

• changed title to "CCMDB Data V2" Ttenbergen 10:16, 25 October 2010 (CDT)
• deleted L_Green table Ttenbergen 10:16, 25 October 2010 (CDT)
• un-defaulted DOB so it no longer enters Date() Ttenbergen 16:17, 25 October 2010 (CDT)
• add a field for room number to L_Log Ttenbergen 16:17, 25 October 2010 (CDT)
• added RecordStatus to L_Log; field to track whether the record is ready to send or rejected or similar; will replace FinalCheck; to be used with future functionality if we go to a new repository where a simple yes/no would not cover all possibilities Ttenbergen 16:17, 25 October 2010 (CDT)
• sL_AaDO2 imported empty as L_AaDO2 Ttenbergen 16:17, 25 October 2010 (CDT)
• sL_Record imported empty as L_Record Ttenbergen 16:17, 25 October 2010 (CDT)
• added L_Errors table with
  • Date/time of error
  • patient ID (Hosp Loc Serial)
  • Field Identifier
  • error descriptor (text)
  • erroneous value
• made a L_BPs to help with the BP chooser functionality