CCMDB data.mdb Change Log: Difference between revisions

(102 intermediate revisions by 4 users not shown)

Line 1:

__NOTOC__

''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''

The CCMDB_data.mdb '''Change Log''' logs changes made to the ~~[[Ccmdb data~~\~~ccmdb data~~.mdb ~~| 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 <nowiki> {{discussion}} </nowiki> so it doesn't get lost in the fray. When a change is tested and rolled out it is also documented here.

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 <nowiki> {{discussion}} </nowiki> 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, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)

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, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)

== Versions ==

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

=== 2022-08-04 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:02, 2022 August 4 (CDT)

* dropped columns ''Pharm_Flow_Complete'', ''FinalCheck field'', ''Room_nr'', ''R_Filter'', ''ApLab_Complete'', ''DC_Treatment'', ''Transfer_Ready_DtTm'', [[ DC_Treatment]], [[ off_ward]], ''EPR_Admit_DtTm'', [[ off_ward]]

* dropped tables [[L_Como table]], [[L_Dxs table]], ''SL_EPR_Exclusions table'',

* added [[ClientGUID field]]

=== 2021-06-17 ===

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

* added field [[ClientVisitGUID field]] to [[L_Log table]] [[User:Ttenbergen|Ttenbergen]] 13:49, 2021 June 17 (CDT)

=== 2020-11-05-2 ===

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

* re-roll of [[#2020-11-05]] because the wrong version got rolled.

=== 2020-11-05 ===

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

* Added

** [[SL Cognos2 Service exclusions table]]

** [[SL Cognos2 Unit exclusions table]]

=== 2019-11-13 ===

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.

=== 2018-10-27 ===

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

* added ''sL_EPR_Exclusions table''

* added ''EPR_Admit_DtTm'' to [[L_Log table]]

=== 2018-05-03 ===

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

* in [[L_CCI_Component table]], changed field '' '' to be size 10 characters so it can accommodate the code for [[Pharmacotherapy, thrombolytic agent]], 35.HA-1C - Ttenbergen 09:27, 2018 May 3 (CDT)

=== 2018-04-03 ===

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

* deleted ''L_CCI table'' table since we will use [[L_CCI_Component table]] and [[L_CCI_Picklist table]] instead. Ttenbergen 16:38, 2018 April 3 (CDT)

* imported [[L_CCI_Component table]] and [[L_CCI_Picklist table]] from [[CCMDB.accdb]] where it had been stored for testing. Ttenbergen 16:40, 2018 April 3 (CDT)

* replaced [[L_ICD10 table]] with the new version that will actually store by ICD10 code rather than by independent identifier Ttenbergen 17:03, 2018 April 3 (CDT)

* fixed relationships to include [[L_ICD10 table]], [[L_CCI_Component table]] and [[L_CCI_Picklist table]] Ttenbergen 21:31, 2018 April 3 (CDT)

=== 2017-Dec-11 ===

must have been rolled out, forgot to update here

* Moved over from testing in [[CCMDB.accdb]]

** [[L_ICD10 table]]

** L_CCI table

** declared relationships for new tables

* removed old fields from [[L_Log table]]

** [[R_AdmDate]]

** [[R_location]]

** [[R_AdmitFrom]]

** [[R_DischargedTo]]

** [[R_HospitalPrevious]]

** [[R_SurviveExpire]]

** [[R_AdmTime]]

** [[R_TRDate]]

** [[R_TRTime]]

** [[R_DisDate]]

** [[R_DisTime]]

** Var1

** Var2

** Var3

** Var4

** Var5

** Var6

** [[Ap SapsSysBP field]]

* removed old fields from [[L_Dxs table]]: rank

=== 2017-Jan-30 ===

Rolled out [[User:Haubel|Haubel]] 12:22, 2017 January 30 (CST)

* Field size increased from 40 to 255 for 'Item' column in [[L TmpV2 table]]

=== 2016-Sept-15 ===

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

* added

** [[GCS sedated field]]

** ''Accept DtTm missing field''

=== 2016-Jun-22 ===

(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)

=== 2016-04-09 ===

*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. '''

=== 2016-04-28 ===

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

* added [[TR_info_status field ]] to [[L_Log]] Ttenbergen 19:02, 2016 April 28 (CDT)

=== 2016-04-18 ===

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

* added [[Visit Admit DtTm field]] Ttenbergen 18:43, 2016 April 18 (CDT)

* added VBG column to [[L_Labs_Flowsheet]] - Ttenbergen 10:56, 2016 March 24 (CDT)

=== 2016-03-16 ===

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

* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]

** PostalCode

** LastOpened_DtTm

=== 2016-03-07 ===

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

* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]

** [[Pre acute living situation field]]

** [[Pre-admit Inpatient Institution field]]

** [[Previous Location field]]

** [[Previous Service field]]

** [[Service/Location field]]

** [[Dispo field]]

** ''Accept_DtTm field''

** ''Arrive_DtTm field''

** [[Dispo_DtTm field]]

** [[Transfer_Ready_DtTm field]]

=== 2013-08-12 ===

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.

=== 2013-05-24 ===

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)

=== 2013-03-11 ===

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

=== 2012-06-07 ===

Rolled out[[User:Ttenbergen|Ttenbergen]] 15:57, 2012 June 29 (CDT)

This also applies to [CCMDB.mdb_Change_Log_2012#ver_2012-06-07] [[User:Ttenbergen|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 [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 16:11, 2012 June 7 (CDT)

=== 2011-12-11 ===

* changes to implement new [[Pharmacy collection]]:

** add table [[L Pharm Flowsheet]][[User:Ttenbergen|Ttenbergen]] 11:09, 11 December 2011 (CST)

** changed ARF checkbox into dropdown that will default to "enter" and allows "yes", "no", and "enter" [[User:Ttenbergen|Ttenbergen]] 12:32, 11 December 2011 (CST)

* changed ARF checkbox into dropdown that will default to "enter" and allows "yes", "no", and "enter" [[User:Ttenbergen|Ttenbergen]] 12:32, 11 December 2011 (CST)

** data .mdbs are not compact/fixing; confirmed that they are set to compact on close, suspect this doesn't trigger on a connected DB, need to fix it in CCMDB.mdb instead, added to [[~~Requested~~ CCMDB ~~changes for the next version~~]] [[~~User:Ttenbergen|Ttenbergen~~]] 11:15, ~~11 December 2011 (CST)~~

* removed remnants removed from [[CCMDB.accdb]] in [[CCMDB.mdb_Change_Log_2010#v1.9938]] since no longer used:

** CPAP, SerUrea, DBili, UrineOutput, ActiveTx

=== 2011-05-13 ===

Line 22:

Line 166:

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

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

Must be rolled out before [[CCMDB.accdb]] ver 2011-02-16 [[User:Ttenbergen|Ttenbergen]] 16:00, 24 February 2011 (CST)

* default lab date to today [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:00, 24 February 2011 (CST)

Line 30:

Line 174:

** L_Log.chart# to L_Log.chart [[User:Ttenbergen|Ttenbergen]] 16:10, 25 February 2011 (CST)

** L_Log.R_dc_ treat (with space) to R_dc_treat[[User:Ttenbergen|Ttenbergen]] 16:35, 25 February 2011 (CST)

** time to start_time [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)

** time to [[start_time]] [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)

** date to start_date [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)

** date to [[start_date]] [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)

* changed table names to be consistent between ccmdb_data.mdb and ~~ccmdb~~.~~mdb~~

* changed table names to be consistent between ccmdb_data.mdb and [[CCMDB.accdb]]

** L_AaDO2 to sL_AaDO2

** L_BPs to sL_BPs

Line 55:

Line 199:

[[Category:~~Development Documentation~~]]

[[Category:CCMDB.accdb]]

[[Category:Change Logs CCMDB]]

@@ Line 1: / Line 1: @@
+__NOTOC__
 ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
-The CCMDB_data.mdb '''Change Log''' logs changes made to the [[Ccmdb data\ccmdb data.mdb | 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 <nowiki> {{discussion}} </nowiki> so it doesn't get lost in the fray. When a change is tested and rolled out it is also documented here.
+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 <nowiki> {{discussion}} </nowiki> 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, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)
+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, [[User:Ttenbergen|Ttenbergen]] 12:58, 29 October 2009 (CDT)
 == Versions ==
+See [[Rolling out changes]] for info on rolling out changes to ccmdb_data.mdb. Ttenbergen 13:51, 2016 March 14 (CDT)
+=== 2022-08-04 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:02, 2022 August 4 (CDT)
+* dropped columns ''Pharm_Flow_Complete'', ''FinalCheck field'', ''Room_nr'', ''R_Filter'', ''ApLab_Complete'', ''DC_Treatment'', ''Transfer_Ready_DtTm'', [[ DC_Treatment]], [[ off_ward]], ''EPR_Admit_DtTm'', [[ off_ward]]
+* dropped tables [[L_Como table]], [[L_Dxs table]], ''SL_EPR_Exclusions table'',
+* added [[ClientGUID field]]
+=== 2021-06-17 ===
+copied to server, will be rolled out with corresponding update to [[CCMDB.accdb]] [[User:Ttenbergen|Ttenbergen]] 14:17, 2021 June 17 (CDT)
+* added field [[ClientVisitGUID field]] to [[L_Log table]] [[User:Ttenbergen|Ttenbergen]] 13:49, 2021 June 17 (CDT)
+=== 2020-11-05-2 ===
+rolled out Ttenbergen 14:52, 2020 November 5 (CST)
+* re-roll of [[#2020-11-05]] because the wrong version got rolled.
+=== 2020-11-05 ===
+rolled out w [[CCMDB.accdb Change Log#2020-11-04]]
+* Added
+** [[SL Cognos2 Service exclusions table]]
+** [[SL Cognos2 Unit exclusions table]]
+=== 2019-11-13 ===
+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.
+=== 2018-10-27 ===
+Rolled out Ttenbergen 20:18, 2019 October 27 (CDT)
+* added ''sL_EPR_Exclusions table''
+* added ''EPR_Admit_DtTm'' to [[L_Log table]]
+=== 2018-05-03 ===
+rolled out Ttenbergen 09:36, 2018 May 3 (CDT)
+* in [[L_CCI_Component table]], changed field '' '' to be size 10 characters so it can accommodate the code for [[Pharmacotherapy, thrombolytic agent]], 35.HA-1C  - Ttenbergen 09:27, 2018 May 3 (CDT)
+=== 2018-04-03 ===
+rolled out Ttenbergen 21:51, 2018 April 4 (CDT)
+* deleted ''L_CCI table'' table since we will use [[L_CCI_Component table]] and [[L_CCI_Picklist table]] instead. Ttenbergen 16:38, 2018 April 3 (CDT)
+* imported [[L_CCI_Component table]] and [[L_CCI_Picklist table]] from [[CCMDB.accdb]] where it had been stored for testing. Ttenbergen 16:40, 2018 April 3 (CDT)
+* replaced [[L_ICD10 table]] with the new version that will actually store by ICD10 code rather than by independent identifier Ttenbergen 17:03, 2018 April 3 (CDT)
+* fixed relationships to include [[L_ICD10 table]], [[L_CCI_Component table]] and [[L_CCI_Picklist table]] Ttenbergen 21:31, 2018 April 3 (CDT)
+=== 2017-Dec-11 ===
+must have been rolled out, forgot to update here
+* Moved over from testing in [[CCMDB.accdb]]
+** [[L_ICD10 table]]
+** L_CCI table
+** declared relationships for new tables
+* removed old fields from [[L_Log table]]
+** [[R_AdmDate]]
+** [[R_location]]
+** [[R_AdmitFrom]]
+** [[R_DischargedTo]]
+** [[R_HospitalPrevious]]
+** [[R_SurviveExpire]]
+** [[R_AdmTime]]
+** [[R_TRDate]]
+** [[R_TRTime]]
+** [[R_DisDate]]
+** [[R_DisTime]]
+** Var1
+** Var2
+** Var3
+** Var4
+** Var5
+** Var6
+** [[Ap SapsSysBP field]]
+* removed old fields from [[L_Dxs table]]: rank
+=== 2017-Jan-30 ===
+Rolled out [[User:Haubel|Haubel]] 12:22, 2017 January 30 (CST)
+* Field size increased from 40 to 255 for 'Item' column in [[L TmpV2 table]]
+=== 2016-Sept-15 ===
+(clearly was rolled out even though not updated here at the time)
+* added
+** [[GCS sedated field]]
+** ''Accept DtTm missing field''
+=== 2016-Jun-22 ===
+(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)
+=== 2016-04-09 ===
+*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. '''
+=== 2016-04-28 ===
+rolled Ttenbergen 19:02, 2016 April 28 (CDT)
+* added [[TR_info_status field ]] to [[L_Log]] Ttenbergen 19:02, 2016 April 28 (CDT)
+=== 2016-04-18 ===
+rolled Ttenbergen 18:43, 2016 April 18 (CDT)
+* added [[Visit Admit DtTm field]] Ttenbergen 18:43, 2016 April 18 (CDT)
+* added VBG column to [[L_Labs_Flowsheet]] - Ttenbergen 10:56, 2016 March 24 (CDT)
+=== 2016-03-16 ===
+rolled Ttenbergen 17:45, 2016 March 16 (CDT)
+* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]
+** PostalCode
+** LastOpened_DtTm
+=== 2016-03-07 ===
+was rolled MondayTtenbergen 17:21, 2016 March 16 (CDT)
+* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]
+** [[Pre acute living situation field]]
+** [[Pre-admit Inpatient Institution field]]
+** [[Previous Location field]]
+** [[Previous Service field]]
+** [[Service/Location field]]
+** [[Dispo field]]
+** ''Accept_DtTm field''
+** ''Arrive_DtTm field''
+** [[Dispo_DtTm field]]
+** [[Transfer_Ready_DtTm field]]
+=== 2013-08-12 ===
+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.
+=== 2013-05-24 ===
+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)
+=== 2013-03-11 ===
+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
+=== 2012-06-07 ===
+Rolled out[[User:Ttenbergen|Ttenbergen]] 15:57, 2012 June 29 (CDT)
+This also applies to [CCMDB.mdb_Change_Log_2012#ver_2012-06-07] [[User:Ttenbergen|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 [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 16:11, 2012 June 7 (CDT)
 === 2011-12-11 ===
 * changes to implement new [[Pharmacy collection]]:
 ** add table [[L Pharm Flowsheet]][[User:Ttenbergen|Ttenbergen]] 11:09, 11 December 2011 (CST)
-** changed ARF checkbox into dropdown that will default to "enter" and allows "yes", "no", and "enter" [[User:Ttenbergen|Ttenbergen]] 12:32, 11 December 2011 (CST)
+* changed ARF checkbox into dropdown that will default to "enter" and allows "yes", "no", and "enter" [[User:Ttenbergen|Ttenbergen]] 12:32, 11 December 2011 (CST)
-** data .mdbs are not compact/fixing; confirmed that they are set to compact on close, suspect this doesn't trigger on a connected DB, need to fix it in CCMDB.mdb instead, added to [[Requested CCMDB changes for the next version]] [[User:Ttenbergen|Ttenbergen]] 11:15, 11 December 2011 (CST)
+* removed remnants removed from [[CCMDB.accdb]] in [[CCMDB.mdb_Change_Log_2010#v1.9938]] since no longer used:
+** CPAP, SerUrea, DBili, UrineOutput, ActiveTx
 === 2011-05-13 ===
@@ Line 22: / Line 166: @@
 was rolled out, not sure when. [[User:Ttenbergen|Ttenbergen]] 15:54, 13 May 2011 (CDT)
-Must be rolled out before ccmdb.mdb ver 2011-02-16 [[User:Ttenbergen|Ttenbergen]] 16:00, 24 February 2011 (CST)
+Must be rolled out before [[CCMDB.accdb]] ver 2011-02-16 [[User:Ttenbergen|Ttenbergen]] 16:00, 24 February 2011 (CST)
 * default lab date to today [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:00, 24 February 2011 (CST)
@@ Line 30: / Line 174: @@
 ** L_Log.chart# to L_Log.chart [[User:Ttenbergen|Ttenbergen]] 16:10, 25 February 2011 (CST)
 ** L_Log.R_dc_ treat (with space) to R_dc_treat[[User:Ttenbergen|Ttenbergen]] 16:35, 25 February 2011 (CST)
-** time to start_time [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)
+** time to [[start_time]] [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)
-** date to start_date [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)
+** date to [[start_date]] [[User:Ttenbergen|Ttenbergen]] 16:38, 25 February 2011 (CST)
-* changed table names to be consistent between ccmdb_data.mdb and ccmdb.mdb
+* changed table names to be consistent between ccmdb_data.mdb and [[CCMDB.accdb]]
 ** L_AaDO2 to sL_AaDO2
 ** L_BPs to sL_BPs
@@ Line 55: / Line 199: @@
-[[Category:Development Documentation]]
+[[Category:CCMDB.accdb]]
+[[Category:Change Logs CCMDB]]