CCMDB.mdb Change Log 2015: Difference between revisions

m 2015-Jun-30: updated Function ''AdFrom_same_ICU'' to no longer exempt STB_MICU
Line 8: Line 8:
== Versions ==
== Versions ==
=== 2015-Jun-30 ===
=== 2015-Jun-30 ===
* need to do:  
not rolled yet, will roll Wed morning Ttenbergen 17:02, 2015 July 6 (CDT)
** possibly update the codes that have leading 00s to not have them
UPDATE L_Log INNER JOIN s_HospitalCodes_updt ON L_Log.R_HospitalPrevious = s_HospitalCodes_updt.Code 
SET L_Log.[R_HospitalPrevious] = [CodeNr]
WHERE (((s_HospitalCodes_updt.Code)<>CStr([CodeNr])));
** possibly update the "0"s to ""s
UPDATE L_Log SET L_Log.R_HospitalPrevious = "" WHERE (((L_Log.R_HospitalPrevious)="0"));
 
Changes done:
* updated Function ''AdFrom_same_ICU'' to no longer exempt STB_MICU
* updated Function ''AdFrom_same_ICU'' to no longer exempt STB_MICU
* changed query ''s_tmp_ER_Wait_from_ER_no_ER_Wait'' to only trigger on complete records
* changed query ''s_tmp_ER_Wait_from_ER_no_ER_Wait'' to only trigger on complete records