CCMDB Wiki

CCMDB data.mdb Change Log: Difference between revisions

← Older edit
m →2016-03-16: rolled
mNo edit summary
 
(74 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 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 ===
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 ===
=== 2016-03-16 ===
rolled Ttenbergen 17:45, 2016 March 16 (CDT)
rolled Ttenbergen 17:45, 2016 March 16 (CDT)
* Added fields to [[L_Log]] in prep for starting [[Dispo]]
* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]
** PostalCode
** PostalCode
** LastOpened_DtTm
** LastOpened_DtTm
Line 17: Line 115:
=== 2016-03-07 ===
=== 2016-03-07 ===
was rolled MondayTtenbergen 17:21, 2016 March 16 (CDT)
was rolled MondayTtenbergen 17:21, 2016 March 16 (CDT)
* Added fields to [[L_Log]] in prep for starting [[Dispo]]
* Added fields to [[L_Log]] in prep for starting [[2016 Time and Place changes]]
**[[Pre_Acute_Living_Situation]]
** [[Pre acute living situation field]]
**[[Pre_Admit_Inpatient_Institution]]
** [[Pre-admit Inpatient Institution field]]
**[[Previous_Location]]
** [[Previous Location field]]
**[[Previous_Service]]
** [[Previous Service field]]
**[[Service_Location]]
** [[Service/Location field]]
**[[Dispo]]
** [[Dispo field]]
**[[Accept_DtTm]]
** ''Accept_DtTm field''
**[[Arrive_DtTm]]
** ''Arrive_DtTm field''
**[[Dispo_DtTm]]
** [[Dispo_DtTm field]]
**[[Transfer_Ready_DtTm]]
** [[Transfer_Ready_DtTm field]]


=== 2013-08-12 ===
=== 2013-08-12 ===
Line 56: 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 68: 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 78: 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 101: 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"