CCMDB.mdb Change Log 2018: Difference between revisions

== Versions ==

* in [[s_ICD10 table]]

* in [[S_CCI_2 table]]

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

** "Cardiac drug, adverse effect"  to [[Cardiac/cardiovascular drug NOS, adverse effect]]

** "Cocaine intoxication, acute"  to [[Cocaine, acute intoxication]]

** "Hallucinogen or psychodysleptic, adverse effect"  to [[Hallucinogen, adverse effect]]

** "Hallucinogen or psychodysleptic, overdose/toxicity"  to [[Hallucinogen, overdose/toxicity]]

** "Hemorrhage, due to anticoagulant drugs"  to [[Hemorrhage, due to anticoagulant or thrombolytic drug]]

** "Hormone or hormone agonist drug, adverse effect"  to [[Hormone or hormone agonist drug, adverse effect]]

** "Opioid chronic abuse/dependence/addiction"  to [[Opioid/narcotic, chronic abuse/dependence/addiction]]

** "Opioid intoxication, acute"  to [[Opioid/narcotic, acute intoxication]]

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

** "Stimulants incl methamphetamine withdrawal"  to [[Stimulants incl methamphetamine, withdrawal]]

** "Tricyclic antidepressant drug, adverse effect"  to [[Tricyclic antidepressant, adverse effect]]

** "Tricyclic antidepressant drug, overdose/toxicity"  to [[Tricyclic antidepressant, overdose/toxicity]]

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

** '''[[Hallucinogen, adverse effect]]

** '''[[Beta-blocker, adverse effect]]

** '''[[Hypergammaglobulinemia]]

** '''[[Bronchitis, chronic, infectious or noninfectious]]

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

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

* removed [[No procedure performed]] from [[S_CCI_1 table]] because [[CCI Collection]] says to enter this from [[CCI Picklist]] - this will facilitate cross checks

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

** changed "Obesity, NOS (BMI 30.0 to 30.9)" to [[Obesity, NOS (BMI 30.0 to 39.9)]]

** changed "Parthyroid gland, primary malignancy" to [[Parathyroid gland, primary malignancy]]

* in [[L_ICD10 subform]], added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row. Ttenbergen 10:31, 2018 May 30 (CDT)

* in [[L_CCI_Picklist subform]], added code to prevent error and give meaningful error msg when someone tries to simply delete a dx entry rather than the whole row.

** [[Physical rehabilitation care]] code changed from Z50 to Z50.1, definition etc updated on the wiki. Ttenbergen 14:28, 2018 April 25 (CDT)

** added [[Other type of infectious organism, NOS‎‎]] splitting up "Infectious disease NOS OR for buglist organism NOS" into this new one and [[Infectious disease NOS]] Ttenbergen 16:06, 2018 April 25 (CDT)

* in [[s_dispo table]]

** allowed  GRA_CAU, HSC_CAU, STB_CAU as [[Dispo]]

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

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

* [[ACCU borrow]] - fix to cross check query ''s_tmp_ACCU_Borrow_chronicity_hard''; was using obsdate and obstime, when it should have used date_var and time_var. Ttenbergen 13:13, 2018 January 4 (CST)

[[Category: Change Logs CCMDB]]