CCMDB data.mdb Change Log: Difference between revisions

m Text replacement - "ccmdb.mdb" to "ccmdb.accdb"
Line 28: Line 28:
rolled out Ttenbergen 21:51, 2018 April 4 (CDT)
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)
* 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.mdb where it had been stored for testing. Ttenbergen 16:40, 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)
* 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)
* fixed relationships to include [[L_ICD10 table]], [[L_CCI_Component table]] and [[L_CCI_Picklist table]] Ttenbergen 21:31, 2018 April 3 (CDT)
Line 136: Line 136:
** add table [[L Pharm Flowsheet]][[User:Ttenbergen|Ttenbergen]] 11:09, 11 December 2011 (CST)
** 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)
* removed remnants removed from ccmdb.mdb in [[CCMDB.mdb_Change_Log_2010#v1.9938]] since no longer used:  
* removed remnants removed from ccmdb.accdb in [[CCMDB.mdb_Change_Log_2010#v1.9938]] since no longer used:  
** CPAP, SerUrea, DBili, UrineOutput, ActiveTx
** CPAP, SerUrea, DBili, UrineOutput, ActiveTx


Line 148: Line 148:
was rolled out, not sure when. [[User:Ttenbergen|Ttenbergen]] 15:54, 13 May 2011 (CDT)
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)
* 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)
* 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 158: Line 158:
** 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_AaDO2 to sL_AaDO2
** L_BPs to sL_BPs
** L_BPs to sL_BPs