CCMDB.accdb Change Log 2019

See Log (disambiguation) for other uses of the term "Log". See the Development Documentation Category for other development logs. See Rolling out changes for the process of rolling out changes. See also requested CCMDB changes for the next version and CCMDB.mdb Data Integrity Checks.

Versions

2019-05-08

not rolled yet

To do

• DOB - input mask; joanna's has /, mine has - but both look explicit!
• the other date fields also act inconsistently on _edits_. Might need to set these in VBA since the settings are not sticking.
• sort dx drop by frequency

Changes collectors will want to know about: Thanks for a good conversation with Joanna and other HSC collectors who brought forward a few good suggestions. Keep them coming, this is how your program gets better.

• removed the misclicker colour problem in ICD10s (if you clicked outside of a box accidentally the row would be hidden by a coloured box)
• fixed problem on the CCI Chooser and CCI Chooser picklist forms ("?" button on CCI tabs)
  • changed order of items in drop down for filter in CCI Chooser to list Diagnostic, Therapeutic and imaging first, some oddballs last, and the rest alphabetic. Let me know if it needs tweaking.
  • fixed the filter listing duplicates etc
• Disabled QAInf / QA Infection CLI / QA Infection VAP in S tmp table since this is now stored in CCI/ICD10

2019-05-07

rolled out Ttenbergen 13:43, 2019 May 7 (CDT)

• changed ICD10 chooser form so the focus/cursor is in the filter field when you open the form.
• Changed CCI Picklist and Component list chooser (comes up when you click ?) so focus is on filer field to start.
• Pharmacy now lists in entry date order, was random order before

2019-05-02

rolled out Ttenbergen 17:42, 2019 May 2 (CDT)

• Project Borrow arrive - added GRA - ER as an option
• added "Infection requiring pathogen" and "Infectious disease" to Tracheostomy complication, infection of site

2019-04-28

rolled out Ttenbergen 21:26, 2019 April 28 (CDT)

• updated categories for Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii to include "Infection with implied pathogen".

2019-04-22

rolled out Ttenbergen 18:31, 2019 April 25 (CDT)

• updated cross checks to fix Bad values can get through if changed after setting RecordStatus to Complete - if I did this right collectors will not notice the change, but if I did it wrong there will be problems checking patients complete.

2019-04-22

rolled out Ttenbergen 17:40, 2019 April 24 (CDT) Changes collectors will want to know about:

• changed Pneumonia, NOS from a "Potential infection" to an "Infection requiring pathogen"

Behind the scenes change:

• tweaked Chart component of query check_minimal_data_set_incomplete to not give overflow error for very long chart numbers.
• updated Function Validate_Chart to check for leading zeros since minimal doesn't do that any more after the above change.

2019-04-15

rolled out Ttenbergen 13:23, 2019 April 17 (CDT)

• fixed typo in s_ICD10 table: "Disoder of mediastinum, NOS" --> Disorder of mediastinum, NOS Ttenbergen 21:06, 2019 April 15 (CDT)
• in s_dispo table, changed all the "Other Continents..." codes to "Not Canada or USA..."; the former did not include Mexico, now it does. Ttenbergen 21:11, 2019 April 15 (CDT)
• fixed false positives in Query check_ICD10_trach_dxs_consistent Ttenbergen 13:21, 2019 April 17 (CDT)

2019-04-10

rolled out Ttenbergen 16:07, 2019 April 15 (CDT)

• changed names, appended ", severe or symptomatic" (see pages for Allan's update to definitions):
  • Hypermagnesemia, severe or symptomatic
  • Hypomagnesemia, severe or symptomatic
  • Hypercalcemia, severe or symptomatic
  • Hypocalcemia, severe or symptomatic
  • Hypernatremia / hyperosmolarity, severe or symptomatic
  • Hyponatremia / hypoosmolarity, severe or symptomatic
  • Hyperkalemia, severe or symptomatic
  • Hypokalemia, severe or symptomatic
  • Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic

2019-04-08

rolled out Ttenbergen 23:34, 2019 April 8 (CDT)

• retired Tracheostomy care
  • removed it from Query check ICD10 trach dxs consistent
• updated Query check_ICD10_trach_dxs_consistent with tweaked rules

2019-03-27-3

rolled out Ttenbergen 16:36, 2019 March 27 (CDT)

• cleaned out query Check eliminated dx and calls to it.

2019-03-27-2

rolled out Ttenbergen 15:57, 2019 March 27 (CDT)

• suspended use of Query check ICD10 duplicates since it was giving false positives.

2019-03-27

rolled Ttenbergen 12:33, 2019 March 27 (CDT)

• tweak to the diagnosis cross checks, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)

2019-03-25

rolled out last night. Ttenbergen 10:38, 2019 March 27 (CDT)

Changes collectors will want to know about:

• renamed ICD10 diagnoses that had ", poisoning by non-pharmaceutical" to just ", poisoning" since there were too many exceptions otherwise
• updated the Patient Viewer form to not tab to the DOB field when leaving the Notes field. (Thanks Debbie!)
• changed Bronchitis, acute or chronic not specified, infectious or noninfectious to be a potential infection (Thanks Michelle!)
• All 2018 patients have been sent, so:
  • disabled the old "Diagnoses" and "Labs" tabs; they will be fully removed at a later time; fixed up checkbox locations. Ttenbergen 18:43, 2019 March 25 (CDT)

Changes behind the scenes:

• removed L_Dxs, L_Comos, L_Labs from
  • reconnector
  • db converter
  • sending
• commented out all code in the Labs, Como, Dxs forms
• removed query Check_ApARF_CRF
• excluded some dxs from Query check ICD10 duplicates

2019-03-20

rolled out Ttenbergen 17:58, 2019 March 20 (CDT)

• changed sending function so that Oaks can send via wifi again, since wifi is all they have.
• disabled GRA_OVER in s_dispo table
• updated s_dispo table.meanLOS3STD so Function long LOS() will be based on current LOSs.
• added s_ICD10_Chapter_block_pattern table

2019-03-13

rolled out Ttenbergen 13:42, 2019 March 20 (CDT)

• updated STB_ICMU in s_dispo table to not be selectable as a service location (ICMA, B, D should be used)
• updated Query check ICD10 trach dxs consistent to no longer require additional tracheostomy Dxs if Tracheostomy, has one is present. Ttenbergen 12:46, 2019 March 20 (CDT)

2019-03-11-2

rolled out Ttenbergen 13:23, 2019 March 13 (CDT)

Changes collectors will want to know about:

• Sending will now disconnect from wifi at start of sending, and re-connect once sending is done. This was necessary because being on wifi significantly slows down and occasionally breaks some of the queries.

Changes collectors likely don't care about:

• updated query send_check_centralized_is_owner to make it smaller; it was giving an error
• completed another cycle of Re-importing CCI and IDC10 categories from wiki to CCMDB.mdb

2019-03-11

rolled out Ttenbergen 10:38, 2019 March 11 (CDT)

• further tweaks to code that runs when tabbing out of Notes field.

2019-03-09

rolled out

Changes collectors will want to know about:

• inactivated only the consult accepted / consult rejected part IICU consult in s_tmp table
• changed name for following CCI systems to include the word "peritoneal" in s_CCI_1 table:
  • (T) Abdominal, Pelvic or Peritoneal Cavity, NOS
  • (D) Abdominal, Pelvic or Peritoneal Cavity, NOS

2019-03-07

rolled out Ttenbergen 10:33, 2019 March 7 (CST) Changes collectors will want to know about:

• updated Query_check_ICD10_trach_dxs_consistent error to say "Patient has some tracheostomy CCI and/or ICD10 codes but they are either inconsistent or incomplete."
• fixed Run-time error when closing the Notes field (added a .requery at the start of Sub notes_checker)
• fixed Query check AIDS vs HIV so it will only flag if the AIDS and HIV records are in the same dx_type; before this would complain across dx_types, but it makes sense that someone would have HIV chronically and now has full blown AIDS as an Admit Diagnosis.

2019-03-06

rolled out Ttenbergen 10:22, 2019 March 6 (CST) changes collectors will want to know about:

• added Heart assist device, has one to s_ICD10 table

behind the scenes changes:

• updated Function Reject_a_query to return true/rejected when the query fails to ensure fail safe; this way if a query fails the test will return an error. This will mean that if there are errors during cross checks or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".

2019-02-13

rolled out Ttenbergen 10:06, 2019 February 14 (CST)

Changes collectors will want to know about:

• added to s_ICD10 table:
  • Stimulants incl. methamphetamine, poisoning
  • Past history, transplanted pancreas or islet cells
• changed Transfusion of albumin to CCI Collection Mode CCI collect first

Behind the scenes changes:

• re-ran Re-importing CCI and IDC10 categories from wiki to CCMDB.mdb

2019-02-06-1

rolled out Ttenbergen 09:37, 2019 February 6 (CST)

• updated s_ICD10 table to allow Pathogen for Testis, orchitis (edited S ICD10 Categories table)

2019-02-05

rolled out Ttenbergen 09:23, 2019 February 6 (CST)

Changes collectors will want to know about:

• changed "Gastrointestinal infection (gastroenteritis), bacterial, NOS" to Gastrointestinal infection (gastroenteritis, colitis), bacterial, NOS in s_tmp table

Changes behind the scenes:

• updated overstay function to use function CCMDB_Age

2019-01-30

rolled out Ttenbergen 22:54, 2019 February 5 (CST)

Changes collectors will want to know about

• Updated for consistency in s_ICD10 table:
  • "Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS" to Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS
  • "Gastrointestinal infection (gastroenteritis, colitis), viral" to Gastrointestinal infection (gastroenteritis, colitis), viral
• allowed Conjunctivitis, any type or cause and Testis, orchitis as potential infection
• changed "Bone or bone marrow, metatstatic malignancy to it (also code primary site)" to Bone or bone marrow, metastatic malignancy to it (also code primary site)

Behind the scenes changes

• Updated query s_tmp_overstay_Dementia_adm_como
• Updated Sub LabCheck() to still run on pt with Dispo DtTm < 2019-01-01

2019-01-24

rolled about half an hour ago Ttenbergen 16:17, 2019 January 24 (CST) Changes collectors will want to know about:

• added Abnormal blood chemistry NOS to s_ICD10 table
• fixed false positive in query s_tmp_IICU_consult_DtTm
• disabled Query s tmp Borrow sensible DtTm vs no borrow for now, wrong premise since these are autoentries, need to review.

2019-01-23

rolled out Ttenbergen 08:26, 2019 January 24 (CST)

• updated Query check ICD10 ESRD vs ARF to exclude patients with kidney transplant on this admission.
• implemented:
  • query s_tmp_Borrow_sensible_DtTm_vs_no_borrow
  • query s_tmp_Borrow_duplicates

2019-01-22-1

rolled outTtenbergen 13:56, 2019 January 23 (CST)

• tweaked bug in
  • Query check ICD10 awaiting has Transfer Ready DtTm
  • Query check ICD10 mechanism vs trauma

2019-01-22

rolled out Ttenbergen 15:14, 2019 January 22 (CST)

• updated Px Count field in L CCI Picklist subform and L CCI Component subform to be able to show numbers >99 Ttenbergen 15:55, 2019 January 21 (CST)
• updated pre-send checker to give a message whether it passes or fails, it was running quietly
• updated sending so it fails more strongly when there is an error during sending; specifically, it should now no longer set patient records to "sent" in CCMDB, or to "complete" in centralized.
• implemented Query check ICD10 mechanism vs trauma
• updated Query check_ICD10_awaiting_has_Transfer_Ready_DtTm to require that Transfer Ready DtTm must be on different date than Dispo_DtTm if there is an awaiting code.
• implemented query s_tmp_IICU_consult_dispo_to_IICU_but_no_tmp to require an IICU consult entry for every patient discharged to HSC_IICU
• implemented Query check_ICD10_trach_dxs_consistent to require that any pt who has a code implying a tracheostomy also has Tracheostomy, has one coded

2019-01-21

rolled out Ttenbergen 15:42, 2019 January 21 (CST) Changes Collectors will want to know about:

• updated Sending so it works again...

Behind the scenes changes:

• retired Query check VAP admit must be from ICU

2019-01-17

rolled out Ttenbergen 09:37, 2019 January 21 (CST)

Just fixes this time.

• fixed color generation for Overstay - updated query check_pt_from_pch
• fixed IICU consult - updated query s_tmp_IICU_consult_DtTm
• fixed "param" errors and missing queries- added code to resolve param if there is more than one.
• tweaked pre-send Checker so it gives no-error msg again
• resolved error in checking for duplicate patients.

2019-01-16

rolled out Ttenbergen 09:45, 2019 January 17 (CST)

• tweaked the new error coding further.
• specifically, it was breaking overstay coding and giving some "param" errors - hopefully I caught all of those now.

2019-01-15

rolled out Ttenbergen 23:21, 2019 January 16 (CST) 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
• 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)
• fixed links in error messages that didn't use to open wiki pages - updated field in form data_integrity_check and function Err_hURLer
• updated Pre-send Checker and Send button to make sure both run the same checks - moved Check duplicate patient from sending only to the code that runs from pre-send checker.
• tweaked height of tab content again to hopefully eliminate scrolling.

Behind the scenes stuff:

• cleaned defunct and commented code out of Function TmpChecker and deleted queries:
  • query s_tmp_QAInf_basic
  • query s_tmp_QAInf_dx_no_tmp
  • query s_tmp_QAInf_tmp_no_dx
  • query s_tmp_QAInf_LT_48_hrs_after_admit
  • Check BRR/XBR vs cardiac arrest dx
  • query s_tmp_ACP
  • 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"
• cleared out Function has_multiples()
• cleared out old code from Sub Dx_Checker()

2019-01-14-1

rolled out Ttenbergen 10:35, 2019 January 15 (CST)

• fixed the chart number sort in Patient List - this will help when you try to troubleshoot duplicate patients.
• fixed false positive when there legitimately are no CCIs - update query check_CCI_if_no_then_none
• tweaked the width of first and last name fields on Patient List further after additional request.
• fixed sort order for magic wand in L ICD10 subform

2019-01-14

rolled out Ttenbergen 10:58, 2019 January 14 (CST) Changes collectors will want to know about

• fixed the links to the CCI Collection Mode in the L CCI Picklist subform
• made the name fields wider in the Patient List

2019-01-10-1

rolled out Ttenbergen 10:17, 2019 January 14 (CST) Changes collectors probably want to know about:

• fixed problem that required entry of comorbid dx for patients discharged before Jan 1 - deleted "query check_ICD10_has_comorbid" which was an evil twin of query check_ICD10_Comorbids_Dx_present
• upped the font size of ICD10s and CCIs back up, and instead made those tabs and subforms much taller so they can show better on the external screens at least. This may mean scrolling in your CCMDB.mdb. Let me know how it works and we can tweak it further. ' - changed frame sizes in Patient viewer.
• updated sort order for ICD10 tab to be Adm, acq, como on default, and when using magic wand button - updated L ICD10 subform

Changes collectors probably don't care about:

• added Query s_ICD10_Chapter_block_dxs
• added S_ICD10_Chapter_block_pattern table
• removed "S_ICD10_Block_Dxs" table

2019-01-10

rolled outTtenbergen 13:33, 2019 January 10 (CST) Things collectors will want to know:

• reimported the CCI / ICD10 categories to reflect our reduction of CCI collection, see CCI Collection Modes in CCI Picklist.
• changed fonts on CCI and ICD10 screen to keep fields small but make fonts bigger
• added lines back into ICD10 tab that had gone missing.
• tweaked Query check CCI must have entry to eliminate false-positive

2019-01-09

not rolled out yet Ttenbergen 10:06, 2019 January 9 (CST) Things collectors will want to know about:

• made fonts smaller in ICD10 screen to make more lines fit on the screen
• split the CCI screen into a picklist screen and a component screen and made the font smaller to fit more on one screen
• made following "collect first":
  • ICP monitor (Placement of implanted, invasive intracranial pressure monitoring device)
  • PD (Peritoneal dialysis)
  • HD (Hemodialysis)
  • CRRT (incl volume removal via PRISMA device)

Things collectors would only care about if things were not working right:

• fixed false positives in query check_AIDS_vs_HIV
• fixed false negative in query check CCI must have entry
• changed VBA so Query check CCI no admin entries actually gets called
• re-imported CCI Categories for CCMDB.mdb and ICD10 Categories for CCMDB.mdb

2019-01-03-1

rolled out Ttenbergen 10:06, 2019 January 9 (CST)

• retired Implanted device NOS, adjustment/management from S ICD10 table
• fixed spelling for BiPAP, CPAP, NIV, own ventilator (Mechanical ventilation, noninvasive) in s_CCI_Picklist table
• added "Query check_ICD10_has_comorbid"
• updated so they will work with the workload sharing locations:
  • Check function preAdmit NE Location
  • Check function previous NE Location
  • Check function location NE dispo
• in function TmpChecker
  • commented out QA_Inf checks since we are no longer doing that in ICD10/CCI
  • commented out old ACCU borrow checks that have not been needed since 2018-07-19 and were replaced by different method

2019-01-03

rolled out Ttenbergen 14:22, 2019 January 3 (CST)

• fixed uncheckable dx box (updated Sub Dx_Checker() so the colours for boxes that it relies on are initialized correctly as before)

2019-01-02-2

rolled out Ttenbergen 16:05, 2019 January 2 (CST)

• updated Dx_Checker to write changes before checking; this is to fix the problem where checking dx checkbox does't necessarily stick. Ttenbergen 15:42, 2019 January 2 (CST)
• updated query L_ICD10_Charlson_Agepts which had negative scores in it
• added Dx_Type to Query L_ICD10_Charlson_dxs Ttenbergen 15:54, 2019 January 2 (CST)
• filtered Query L_ICD10_Charlson_component_points to only include Comorbid Diagnosis and Admit Diagnosis Ttenbergen 15:54, 2019 January 2 (CST)

2019-01-02-1

was rolled

• updated to not give Pat_ID error
  • Query check_ICD10_ESRD_vs_AP_ARF
  • Query check_ICD10_ESRD_vs_ARF

2019-01-02

rolled out Ttenbergen 08:15, 2019 January 2 (CST)

• changed query s_CCI_Categories_Collection_Mode back to a table, having it as a query prevents entries of new CCI codes.
• updated to not give Pat_ID error
  • Query s_tmp_QASeptic_Dx_no_tmp_ICD10
  • Query s_tmp_QASeptic_tmp_no_dx
  • Query check CCI must have entry

2018-...

• see CCMDB.mdb Change Log 2018