CCMDB data.mdb Change Log: Difference between revisions

mNo edit summary
 
(11 intermediate revisions by the same user not shown)
Line 10: Line 10:
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)


=== Next Round ===
=== 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 ===
=== 2020-11-05-2 ===
rolled out Ttenbergen 14:52, 2020 November 5 (CST)
rolled out Ttenbergen 14:52, 2020 November 5 (CST)
* re-roll of [[#2020-11-05]] because the wrong version got rolled.  
* re-roll of [[#2020-11-05]] because the wrong version got rolled.


=== 2020-11-05 ===
=== 2020-11-05 ===
Line 24: Line 32:
=== 2019-11-13 ===
=== 2019-11-13 ===
rolled out Ttenbergen 16:03, 2019 November 13 (CST)
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.
* 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 ===
=== 2018-10-27 ===
Rolled out Ttenbergen 20:18, 2019 October 27 (CDT)
Rolled out Ttenbergen 20:18, 2019 October 27 (CDT)
* added [[sL_EPR_Exclusions table]]
* added ''sL_EPR_Exclusions table''
* added [[EPR Admit DtTm]] to [[L_Log table]]
* added ''EPR_Admit_DtTm'' to [[L_Log table]]


=== 2018-05-03 ===
=== 2018-05-03 ===
Line 79: Line 87:
* added
* added
** [[GCS sedated field]]
** [[GCS sedated field]]
** [[Accept DtTm missing field]]
** ''Accept DtTm missing field''


=== 2016-Jun-22 ===
=== 2016-Jun-22 ===
Line 114: 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]]