CCMDB data.mdb Change Log: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (22 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) | ||
=== | === 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 === | === 2018-10-27 === | ||
Rolled out Ttenbergen 20:18, 2019 October 27 (CDT) | Rolled out Ttenbergen 20:18, 2019 October 27 (CDT) | ||
* added | * added ''sL_EPR_Exclusions table'' | ||
* added | * added ''EPR_Admit_DtTm'' to [[L_Log table]] | ||
=== 2018-05-03 === | === 2018-05-03 === | ||
| Line 24: | Line 46: | ||
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 | * 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 65: | Line 87: | ||
* added | * added | ||
** [[GCS sedated field]] | ** [[GCS sedated field]] | ||
** | ** ''Accept DtTm missing field'' | ||
=== 2016-Jun-22 === | === 2016-Jun-22 === | ||
| Line 100: | Line 122: | ||
** [[Service/Location field]] | ** [[Service/Location field]] | ||
** [[Dispo field]] | ** [[Dispo field]] | ||
** | ** ''Accept_DtTm field'' | ||
** | ** ''Arrive_DtTm field'' | ||
** [[Dispo_DtTm field]] | ** [[Dispo_DtTm field]] | ||
** [[Transfer_Ready_DtTm field]] | ** [[Transfer_Ready_DtTm field]] | ||
| Line 132: | 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 | * 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 144: | 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 | 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 154: | 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 | * 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 | ||