CCMDB.mdb Change Log 2018: Difference between revisions

m link fixes due to page name changes
m link fixes
Line 37: Line 37:
* updated [[Overstay Predictor Project Algorithm]]
* updated [[Overstay Predictor Project Algorithm]]
* updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 cross checks
* updated Function include_pt() that had previously only included D_IDs ending in 8 in CCI/ICD10 cross checks
* re-imported [[CCI Categories for CCMDB.mdb]] and [[ICD10 Categories for CCMDB.mdb]]
* re-imported [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]


==== 2018-12-20-2 ====
==== 2018-12-20-2 ====
Line 45: Line 45:
*''' updated [[L_CCI_Picklist_subform]] to show the respective [[CCI Collection Mode]].
*''' updated [[L_CCI_Picklist_subform]] to show the respective [[CCI Collection Mode]].
behind the scenes...
behind the scenes...
* re-imported [[CCI_Categories_for_CCMDB.mdb]] and [[ICD10 Categories for CCMDB.mdb]]
* re-imported [[CCI_Categories_for_CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]


==== 2018-12-20 ====
==== 2018-12-20 ====
Line 258: Line 258:
behind the scenes changes
behind the scenes changes
* changed how errors are displayed to provide a clickable URL to the wiki page for the error function Reject_a_query and function Reject_a_query_PatID  
* changed how errors are displayed to provide a clickable URL to the wiki page for the error function Reject_a_query and function Reject_a_query_PatID  
* updated [[ICD10 Categories for CCMDB.mdb]]
* updated [[ICD10 Categories for CCMDB.accdb]]
* updated [[CCI Categories for CCMDB.mdb]]
* updated [[CCI Categories for CCMDB.accdb]]
* updated [[Check Inf Pathogens must have Infection requiring pathogen or Potential Infection]] to not trigger for [[:Category:Double duty pathogen]]
* updated [[Check Inf Pathogens must have Infection requiring pathogen or Potential Infection]] to not trigger for [[:Category:Double duty pathogen]]
* updated [[Check Inf Infection with implied pathogen must not have a pathogen combined code]] to not compare a dx with itself
* updated [[Check Inf Infection with implied pathogen must not have a pathogen combined code]] to not compare a dx with itself
Line 520: Line 520:
** query s_tmp_Service_Sending_to_ICU_duplicate
** query s_tmp_Service_Sending_to_ICU_duplicate
* updated [[Check duplicate patient]] to properly accommodate [[PHIN_field#Location_Manitoba_and_no_PHIN]]
* updated [[Check duplicate patient]] to properly accommodate [[PHIN_field#Location_Manitoba_and_no_PHIN]]
* [[CCMDB.accdb links to CCMDB wiki]] - edited the label for [[DOB]] to no longer be link, added little link icon to left of label. Please see and provide feedback at [[CCMDB.mdb links to CCMDB wiki]].
* [[CCMDB.accdb links to CCMDB wiki]] - edited the label for [[DOB]] to no longer be link, added little link icon to left of label. Please see and provide feedback at [[CCMDB.accdb links to CCMDB wiki]].
* updated Function runQuery to generate an email with the relevant error rather than ask collectors to screen shoot and email.
* updated Function runQuery to generate an email with the relevant error rather than ask collectors to screen shoot and email.
* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate cross checks
* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate cross checks