CCMDB data.mdb Change Log

From CCMDB Wiki
Jump to navigation Jump to search

see the Development Documentation Category for other development logs

The CCMDB_data.mdb Change Log logs changes made to the Ccmdb_data\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#Next_Round_of_Data_Changes. Thanks, Ttenbergen 12:58, 29 October 2009 (CDT)


See Rolling out changes for info on rolling out changes to ccmdb_data.mdb. Ttenbergen 13:51, 2016 March 14 (CDT)


rolled out Ttenbergen 15:02, 2022 August 4 (CDT)


copied to server, will be rolled out with corresponding update to CCMDB.accdb Ttenbergen 14:17, 2021 June 17 (CDT)


rolled out Ttenbergen 14:52, 2020 November 5 (CST)

  • re-roll of #2020-11-05 because the wrong version got rolled.


rolled out w CCMDB.accdb Change Log#2020-11-04


rolled out Ttenbergen 16:03, 2019 November 13 (CST)

  • changed index (unique, primary) for chart to just plain index in sL_EPR_Exclusions table, should not have been set up that way.


Rolled out Ttenbergen 20:18, 2019 October 27 (CDT)

  • added sL_EPR_Exclusions table
  • added EPR_Admit_DtTm to L_Log table


rolled out Ttenbergen 09:36, 2018 May 3 (CDT)


rolled out Ttenbergen 21:51, 2018 April 4 (CDT)


must have been rolled out, forgot to update here


Rolled out Haubel 12:22, 2017 January 30 (CST)

  • Field size increased from 40 to 255 for 'Item' column in L TmpV2 table


(clearly was rolled out even though not updated here at the time)


(clearly was rolled out even though not updated here at the time)

  • added off_ward field to table L_Log Ttenbergen 16:55, 2016 June 22 (CDT)


  • rolled out 2016-May-9 late about 1534 hrs. - Tina
  • eliminated dual entry (old way with new way) for ACP status

There is no such version number for ccmdb_DATA, nor should that change have affected the structure. This is likely an erroneous log entry.


rolled Ttenbergen 19:02, 2016 April 28 (CDT)


rolled Ttenbergen 18:43, 2016 April 18 (CDT)


rolled Ttenbergen 17:45, 2016 March 16 (CDT)


was rolled MondayTtenbergen 17:21, 2016 March 16 (CDT)


copied to server, will become active with roll-out of CCMDB.mdb_Change_Log_2013#ver_2013-08-12 Ttenbergen 09:51, 2013 August 29 (CDT)

  • added Tmp_ID to L_TmpV2 and made primary key
    • a plain conversion should do the trick, the autonumbers seem to update even if you just add the column.


there is no roll out for this, updated the version field to allow checking that changes required for CCMDB.mdb_Change_Log_2013#ver_2013-05-24 are done so they only run once. Ttenbergen 17:24, 2013 May 30 (EDT)


not rolled out yet (actually, this was rolled, not sure when...)

  • upgrading the database file to 2002-3
  • change L_Log to
    • change options for GCS to options actually available in the form Ttenbergen 15:04, 2013 March 11 (EDT)
    • implement changes in Drugs Collected, i.e. add:
      • pharm_PPI, pharm_H2_blockers, pharm_furosemide, pharm_heparin_sq, pharm_LMWH, pharm_benzodiazepines, pharm_opioids, pharm_propofol, pharm_insulin


Rolled outTtenbergen 15:57, 2012 June 29 (CDT)

This also applies to [CCMDB.mdb_Change_Log_2012#ver_2012-06-07] Ttenbergen 17:32, 2012 June 7 (CDT)

  • removed the old import module, was from when we first moved to two separate .mdbs, no longer relevant Ttenbergen 16:11, 2012 June 7 (CDT)
  • added relationship between L_Log and L_Pharm_Flow; table had been added in last version but relationship not been added, leading to orphans from deletions, and to lost or mis-assigned records if a Patient_ID is reassigned Ttenbergen 16:11, 2012 June 7 (CDT)



Set CCMDB.mdb_Change_Log_2011#ver_2011-05-04 to download this upon first opening. Ttenbergen 17:04, 13 May 2011 (CDT) To fix some problems in the BP Calculator the following changes were also made to the data:

  • sL_BPs.MBP changed to data type single from long integer to accomodate a decimal digit from calculation/division
  • added sL_BPs.ApPts field


was rolled out, not sure when. Ttenbergen 15:54, 13 May 2011 (CDT)

Must be rolled out before CCMDB.accdb 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)
  • fixed field names in L_Log that had names that cause errors (e.g. reserved words, spaces in names, etc)
  • changed table names to be consistent between ccmdb_data.mdb and CCMDB.accdb
    • L_AaDO2 to sL_AaDO2
    • L_BPs to sL_BPs
    • A_Records to sL_Records


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