CCMDB.accdb Change Log 2019: Difference between revisions

Line 6: Line 6:
not rolled yet. Ttenbergen 17:48, 2019 January 15 (CST)
not rolled yet. Ttenbergen 17:48, 2019 January 15 (CST)
Stuff collectors should care about:  
Stuff collectors should care about:  
* '''hoping to make errors easier to find - errors launched by checkboxes will now also show the query that raised them, hopefully providing additional help in finding out what is wrong. ''' - updated Function Reject_a_query_PatID to use parameters, and all queries to use parameters.
* '''set [[Lung abscess]] so it can accept a pathogen''' - updated wiki page and [[s_ICD10_Categories table]]
* '''set [[Lung abscess]] so it can accept a pathogen''' - updated wiki page and [[s_ICD10_Categories table]]
* '''updated cross check for [[IICU consult]] to have the checkbox work according to collection instructions (cross check was giving false positives)''' - updated [[Query s tmp IICU consult DtTm]] Ttenbergen 10:14, 2019 January 16 (CST)
* '''updated cross check for [[IICU consult]] to have the checkbox work according to collection instructions (cross check was giving false positives)''' - updated [[Query s tmp IICU consult DtTm]] Ttenbergen 10:14, 2019 January 16 (CST)
Line 20: Line 21:
** [[Check BRR/XBR vs cardiac arrest dx]]
** [[Check BRR/XBR vs cardiac arrest dx]]
** [[query s_tmp_ACP]]
** [[query s_tmp_ACP]]
** "L_CCI_Resolver" - never ended up being used
** [[query check_trach_dx_task]]
** "111_dxCodeTRanslate" - never ended up being used
** [[ACCU borrow]] queries "query s_tmp_ACCU_Borrow_chronicity_hard, "query s_tmp_ACCU_Borrow_2_hr_soft", "query s_tmp_ACCU_off_ward", "query s_tmp_ACCU_twin"
** [[ACCU borrow]] queries "query s_tmp_ACCU_Borrow_chronicity_hard, "query s_tmp_ACCU_Borrow_2_hr_soft", "query s_tmp_ACCU_off_ward", "query s_tmp_ACCU_twin"
* cleared out Function has_multiples()
* cleared out Function has_multiples()