CCMDB Wiki

CCMDB data.mdb Change Log: Difference between revisions

← Older edit
mNo edit summary
 
(51 intermediate revisions by the same user not shown)
Line 1: Line 1:
__NOTOC__
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''


Line 8: Line 9:
== Versions ==
== Versions ==
See [[Rolling out changes]] for info on rolling out changes to ccmdb_data.mdb. Ttenbergen 13:51, 2016 March 14 (CDT)
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 ===
=== 2017-Dec-11 ===
Not rolled out yet Ttenbergen 12:36, 2017 December 11 (CST)
must have been rolled out, forgot to update here
* Moved over from testing in [[CCMDB.mdb]]
* Moved over from testing in [[CCMDB.accdb]]
** [[L_ICD10 table]]
** [[L_ICD10 table]]
** [[L_CCI 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 ===
=== 2017-Jan-30 ===
Line 20: Line 84:


=== 2016-Sept-15 ===
=== 2016-Sept-15 ===
not rolled out yet Ttenbergen 10:00, 2016 September 15 (CDT)
(clearly was rolled out even though not updated here at the time)  
* added
* added
** [[GCS sedated field]]
** [[GCS sedated field]]
** [[Accept DtTm missing field]]
** ''Accept DtTm missing field''


=== 2016-Jun-22 ===
=== 2016-Jun-22 ===
Line 32: Line 96:
*rolled out 2016-May-9 late about 1534 hrs. - Tina
*rolled out 2016-May-9 late about 1534 hrs. - Tina
*eliminated dual entry (old way with new way) for ACP status
*eliminated dual entry (old way with new way) for ACP status
{{Discussion}} there is no such version number for ccmdb_DATA, nor should that change have affected the structure. Did you mean to put this into [[log]]? Ttenbergen 12:38, 2016 May 19 (CDT)
'''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 ===
=== 2016-04-28 ===
Line 58: Line 122:
** [[Service/Location field]]
** [[Service/Location field]]
** [[Dispo field]]
** [[Dispo field]]
** [[Accept_DtTm field]]
** ''Accept_DtTm field''
** [[Arrive_DtTm field]]
** ''Arrive_DtTm field''
** [[Dispo_DtTm field]]
** [[Dispo_DtTm field]]
** [[Transfer_Ready_DtTm field]]
** [[Transfer_Ready_DtTm field]]
Line 90: Line 154:
** 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 102: Line 166:
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 112: Line 176:
** 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
Line 135: Line 199:




[[Category:CCMDB.mdb]]
[[Category:CCMDB.accdb]]
[[Category:Change Logs CCMDB]]
[[Category:Change Logs CCMDB]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB_data.mdb_Change_Log"