CCMDB.mdb Change Log 2018: Difference between revisions

Changes collectors will want to know about:  

* in [[s_ICD10 table]]

** '''added [[Inflammatory/immune arthritis, NOS]]

** '''retired [[Renal dialysis care, including dialysis itself]]

** added "precedence" field to [[s_ICD10_Charlson_Como_conditions table]]

* updated [[Overstay Predictor Project Algorithm]]

==== 2018-12-20-2 ====

*''' updated [[L_CCI_Picklist_subform]] to show the respective [[CCI Collection Mode]].

behind the scenes...

==== 2018-12-20 ====

** [[Angioplasty, coronary (without stenting)]]

* [[ICUotherService]] project: added option "CICU under ACCU service"

** to [[S dispo table]]

** to [[s_locations_allowed_collection table]]

rolled out Ttenbergen 10:23, 2018 December 4 (CST)

* '''reduce the number of times that the ER Delay error shows up '''

==== 2018-12-02 ====

** [[Thrombolytic drug, overdose/toxicity]] from T44.5 to T45.6

** [[Cardiac/cardiovascular drug NOS, adverse effect]] from Y52 to Y52.9

* [[S ICD10 table]] - removed columns important_wiki_info, Bug_req, min_nr_grouped_with because this is not how we are doing things now

* re-updated the ICD10 and CCI categories from wiki

* '''changed [[Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days]]

behind the scenes or minor changes

* tweaked the size of the patient viewer form so it fits on a laptop screen without scrolling

* '''added "query check ICD10 ESRD vs AP CRF"

* '''added [[query check_ICD10_needs_awaiting_if_TR_Dt_and_Dispo_Dt_on_diff_days]]

* '''inactivated the remaining specific Vic wards in [[s_dispo table]]

* '''tweaked [[L_CCI_Picklist subform]] so that "no procedure performed" sorts to the top of the dropdown  

* tweaked to only compare same dx types:  

**[[Check Inf Infection with implied pathogen must not have a pathogen combined code]]

**[[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]]

**[[Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen]]

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  

* updated [[Check Inf Infection with implied pathogen must not have a pathogen combined code]] to not compare a dx with itself

* '''added infection cross-checks:  

** '''[[Check Inf Infection with implied pathogen must not have a pathogen combined code]]

** '''[[query check_ICD10_Inf_Infection_req_Pathogen_must_have_one]]

** '''[[Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen]]

** added [[IICU consult]] to [[s_tmp table]]  

** added [[Query check_CCI_CRRT_vs_Tmp]] - '''you will need to start entering CCI entries for all CRRT patients'''

** added [[Query check_cooling_vs_arrest]] - you can only use [[Targeted Temperature Management (TTM)]] if you have a [[Cardiac arrest]] dx in ICD10

** added [[Query check_AIDS_vs_HIV]] - can't code [[HIV infection, asymptomatic]] and [[AIDS (disease due to HIV)]] for same record

** "Coronary angiogram (diagnostic cardiac catherization)" --> [[Angiogram, coronary (diagnostic cardiac catheterization)]]

* updated Sub Legacy_Hider() to properly hide the wiki links for ADLs for Critical Care patients. Ttenbergen 23:34, 2018 October 24 (CDT)

* fixed [[Query check dx primary lowest priority]], it was checking for lowest priority over all dxs, not just admit dxs Ttenbergen 09:33, 2018 October 25 (CDT)

rolled out Ttenbergen 18:24, 2018 October 14 (CDT)

* '''relevant to collectors: '''

*** [[Query check CCI if no then none]]

*** [[Query check CCI component 1 and 2 compatible]]

** query s_tmp_Service_Sending_to_ICU_duplicate

* updated [[Check duplicate patient]] to properly accommodate [[PHIN_field#Location_Manitoba_and_no_PHIN]]

* updated Function runQuery to generate an email with the relevant error rather than ask collectors to screen shoot and email.

* implemented checks and added to Sub Dx_Checker():  

* [[Query check_dx_primary_lowest_priority]]

* in [[S_CCI_1 table]], changed "(T) Ventricle" to [[(T) Cardiac ventricle]]

* in [[S_CCI_Picklist table]], added [[Tracheostomy creation]]

* actually deleted query ''deleted query check_OR_from_but_not_Surgical_Type''; had logged this as done in [[#2018-05-09]] but evidently never did then. Ttenbergen 10:50, 2018 September 20 (CDT)

* fixed [[Patient List]] sorting by [[Chart number]]; ages ago that field was called "chart#" and it seems the buttons have been broken ever since that was changed. Ttenbergen 15:35, 2018 September 21 (CDT)

**[[L CCI Picklist subform]]

**[[L CCI Component subform]]

** query ''check_ER_Delay_not_too_big''

** error msg in ''Function Dispo_Chronological()''

==== 2018-02-02 (mis-dated) ====

had been rolled out... Ttenbergen 13:54, 2018 January 30 (CST)

** query ''s_tmp_Accept_Log_Park_prev_no_tmp''

** query ''s_tmp_Accept_Log_Park_tmp_no_prev''

* added for [[Accept Loc Park]]:

** nursing stations Ttenbergen 13:51, 2018 January 21 (CST)

*** query ''s_tmp_Accept_Log_Park_prev_no_tmp''

*** query ''s_tmp_Accept_Log_Park_tmp_no_prev''

rolled out Ttenbergen 18:01, 2018 January 10 (CST)

* added "negative" for [[Influenza tracking]]

=== 2018-01-09 ===

rolled out Ttenbergen 09:18, 2018 January 9 (CST)

** [[Awaiting/delayed transfer to home]]

=== 2018-01-04 ===

* removed [[Angio coronary field]] and [[Angio others field]] from labs tab in patient viewer Ttenbergen 17:01, 2017 December 28 (CST)

* updated the pick button in [[ICD10 Chooser form]] to no longer requery the [[L ICD10 subform]] as this was resorting the dxs and collectors then had to find the one they had just entered to finish the entry. Ttenbergen 18:44, 2017 December 28 (CST)

[[Category:CCMDB.accdb]]