CCMDB Wiki

CCMDB data.mdb Change Log: Difference between revisions

← Older edit
mNo edit summary
 
(83 intermediate revisions by 3 users 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 6: Line 7:
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)
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)


On the next round, get rid of a_info regional server entry. Ttenbergen 15:21, 2013 September 12 (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. '''


== Versions ==
=== 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 ===
=== 2013-08-12 ===
Line 31: Line 148:
This also applies to [CCMDB.mdb_Change_Log_2012#ver_2012-06-07] [[User:Ttenbergen|Ttenbergen]] 17:32, 2012 June 7 (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)
* 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)
* 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 ===
=== 2011-12-11 ===
Line 37: 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 49: 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 57: Line 174:
** L_Log.chart# to L_Log.chart [[User:Ttenbergen|Ttenbergen]] 16:10, 25 February 2011 (CST)
** 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)
** 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_AaDO2 to sL_AaDO2
** L_BPs to sL_BPs
** L_BPs to sL_BPs
Line 82: Line 199:




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