CCMDB.accdb Change Log 2019: Difference between revisions

m Text replacement - "cross check " to "cross check "
m Text replacement - "cross checks" to "cross checks"
Line 74: Line 74:
rolled out Ttenbergen 17:53, 2019 December 3 (CST)
rolled out Ttenbergen 17:53, 2019 December 3 (CST)
* tweaked [[query s_tmp_ABO_TEE_checks]] so it triggers properly when the tmp box is checked, not when pre-send checker runs.
* tweaked [[query s_tmp_ABO_TEE_checks]] so it triggers properly when the tmp box is checked, not when pre-send checker runs.
* updated how most cross checks are called; errors could have slipped by if a record had been correct, set to complete, and then got changed Ttenbergen 17:53, 2019 December 3 (CST)
* updated how most [[cross check]]s are called; errors could have slipped by if a record had been correct, set to complete, and then got changed Ttenbergen 17:53, 2019 December 3 (CST)


==== 2019-11-27 ====
==== 2019-11-27 ====
Line 190: Line 190:
** delete log entries with discharge date < now - 3months
** delete log entries with discharge date < now - 3months
* updated sub DB_Converter and sub DB_Connect() to deal with [[CCMDB data.mdb Change Log#2018-10-27]]
* updated sub DB_Converter and sub DB_Connect() to deal with [[CCMDB data.mdb Change Log#2018-10-27]]
* updated cross checks so they can cope with incompletes and take program from data rather than from setting:  
* updated [[cross check]]s so they can cope with incompletes and take program from data rather than from setting:  
** [[query check_CCI_from_OR_no_CCI]]
** [[query check_CCI_from_OR_no_CCI]]
** [[Query check CCI must have entry]]
** [[Query check CCI must have entry]]
Line 269: Line 269:
*** STB - Home medicine ward
*** STB - Home medicine ward
** retired [[query s_tmp_Borrow_sensible_DtTm_vs_no_borrow]]
** retired [[query s_tmp_Borrow_sensible_DtTm_vs_no_borrow]]
* updated cross checks [[query check_CCI_Picklist_unfilled]] and [[query check_CCI_Component_unfilled]] to trap types that are not "admit" or "acquired". Ttenbergen 13:10, 2019 September 24 (CDT)
* updated [[cross check]]s [[query check_CCI_Picklist_unfilled]] and [[query check_CCI_Component_unfilled]] to trap types that are not "admit" or "acquired". Ttenbergen 13:10, 2019 September 24 (CDT)


==== 2019-09-22 ====
==== 2019-09-22 ====
Line 590: Line 590:
==== 2019-04-22 ====
==== 2019-04-22 ====
rolled out Ttenbergen 18:31, 2019 April 25 (CDT)
rolled out Ttenbergen 18:31, 2019 April 25 (CDT)
* updated cross checks to fix [[Bad values can get through if changed after setting RecordStatus to Complete]] - if I did this right collectors will not notice the change, but if I did it wrong there will be problems checking patients complete.
* updated [[cross check]]s to fix [[Bad values can get through if changed after setting RecordStatus to Complete]] - if I did this right collectors will not notice the change, but if I did it wrong there will be problems checking patients complete.


==== 2019-04-22 ====
==== 2019-04-22 ====
Line 636: Line 636:
==== 2019-03-27 ====
==== 2019-03-27 ====
rolled Ttenbergen 12:33, 2019 March 27 (CDT)
rolled Ttenbergen 12:33, 2019 March 27 (CDT)
* tweak to the diagnosis cross checks, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)
* tweak to the diagnosis [[cross check]]s, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)


==== 2019-03-25 ====
==== 2019-03-25 ====
Line 705: Line 705:


behind the scenes changes:  
behind the scenes changes:  
* updated Function Reject_a_query to return true/rejected when the query fails to ensure fail safe; this way if a query fails the test will return an error. This will mean that if there are errors during cross checks or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".
* updated Function Reject_a_query to return true/rejected when the query fails to ensure fail safe; this way if a query fails the test will return an error. This will mean that if there are errors during [[cross check]]s or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".


==== 2019-02-13 ====
==== 2019-02-13 ====