CCMDB.mdb Change Log 2018: Difference between revisions

== Versions ==

Changes collectors will want to know about:  

* in [[s_ICD10 table]]

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

* in [[s_dispo table]], '''added "Institution NOS" as option for [[Previous Location]] / [[dispo]] option

* in [[S_CCI_2 table]]

** '''retired [[Installation of External Appliance]]

** '''added [[Debridement]] to allow for first-only coding

Changes behind the scenes:  

'''Collectors will only care about these if they went wrong...'''

** [[Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm]] - needed a tweak for the right codes, and VBA code to actually call it

** [[Query s tmp QASeptic tmp no dx]]

* retired as part of moving to ICD10/CCI

** [[Check BRR/XBR vs cardiac arrest dx]] - retired and replaced

** [[Query check ApARF CRF]] - retired and replaced

** [[Query Check Renal IncompatibleDxs]]

==== 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 ====

'''Changes collectors will want to know about'''

* sorry guys, this is a big and hard to read one

* '''fixed [[query s_tmp_IICU_consult_DtTm]] which was giving false positives

* '''renamed [[CCI Picklist]] item "Whole body cooling" to [[Targeted Temperature Management (TTM)]]

* '''renamed  

** '''"Intracranial or intraspinous veins or venous sinuses, septic thromboembolism -- incl septic embolism" to [[Intracranial or intraspinous veins or venous sinuses, septic thromboembolism]]

{{Collapsable  

| always= '''a bunch of spelling tweaks in the substance category

* minor

** "Alcohol (ethanol) intoxication, acute (drunkenness)"  to [[Alcohol (ethanol) acute intoxication (drunkenness)]]

** "Antibiotic or other anti-infective, overdose/toxicity" to [[Antibiotic/antimicrobial, overdose/toxicity]]

** "Antibiotic/anti-infective drug, adverse effect"  to [[Antibiotic/antimicrobial, adverse effect]]

** [[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

* '''renamed for consistency in [[s_ICD10 table]]

** '''"Neuromuscular blocking drug, adverse effect" to [[Neuromuscular blocker/paralytic, adverse effect]]

** '''"Alcohol (ethanol) acute intoxication (drunkenness)" to [[Alcohol (ethanol) acute intoxication (drunkenness)]]

* '''changed all ICD10 dxs named "*, overdose/poisoning" to "*, overdose/toxicity"

* '''changed all ICD10 dxs named "*,  used appropriately, adverse effect \(reaction, allergy, hypersensitivity\)" to "*, adverse effect", and added [[Template:ICD10 Guideline adverse effect]] to contain the instruction that was implied in the name before.

* '''re-imported CCI and ICD10 categories

* '''added [[Chest tube, left in place]] to [[s_CCI_Picklist table]]

* '''added [[query check ICD10 ESRD vs kidney transplant]]

* '''added [[query check VAP admit must be from ICU]]

* '''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]]

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

* re-imported CCI and ICD10 categories once more.

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]]

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

* '''added "consult unknown" option to [[IICU consult]]

* '''updated [[CCI Chooser form]] to include a category filter for CCI 1 items

* '''added [[CCI_Pick_Chooser form]] to include a category filter for CCI Picklist items

** 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

* other changes (minor, might be visible but should not require change in collection)

** updated description for renal codes in [[s_ICD10 table]] so they sort in order 1-5, thanks for the thought on how to do this Trish

==== 2018-11-02 ====

** "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)

*** [[Stimulants incl methamphetamine, acute intoxication]]

*** [[Stimulants incl methamphetamine, chronic abuse/dependence/addiction]]

* in [[s_CCI_1 table]]:  

** changed procedure names to replace "lower limb" with leg, "upper limb" with arm, to make consistent among procedures; new codes are:

** added [[Pharmacotherapy, thrombolytic agent]] to be able to code such things as "MI aborted with TPN" (I have cleaned up the page that had been made just for that purpose.) Ttenbergen 12:50, 2018 April 11 (CDT)

* in [[S_CCI_1 table]]:  

* in [[s_dispo table]]:

** updated "HSC - Interventional Radiology" and "STB - Interventional Radiology" to fill "site" field with hospital, and to allow as [[Dispo]]

**[[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)