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.accdb Data Integrity Checks.

Versions

2019-12-08

rolled out Ttenbergen 12:05, 2019 December 9 (CST)

• fixed that I had left a variable set to debug mode...

2019-12-07

rolled out Ttenbergen 11:20, 2019 December 9 (CST)

Changes collectors will want to know about:

• removed HSC_A3S stepdown from dropdowns
• changed how sending checks for existing records, hoping this will fix System resource exceeded error...

Changes collectors will probably want to know about if they are testing EPR Reports Integrator

• updated the query that drives EPR Reports Integrator (sL_EPR_Logs_FormQuery) to
  • compare based Arrive_DtTm and Dispo_DtTm in addition to Accept_DtTm and EPR_Admit_DtTm
  • fix the chart number matcher, it wasn't finding some matches.
• changed how the buttons work
  • button at the beginning of the line will now only work if both chart and date are green, and will open that record.
  • there are two new buttons, to right of AdmDtTm and to right of DisDtTm; they will start a new record with the corresponding date as Arrive_DtTm; this was necessary since the transfer report can work in at least two different ways.
• changed name on form to "EPR Reports Integrator" (was "...Aggregator")

2019-12-04

rolled out Ttenbergen 18:27, 2019 December 4 (CST)

Things collectors will want to know about:

• Changed Boarding Loc dropdowns to only allow options from the local site
• CCI consolidating:
  • changed code "Excision, Resection" to Excision, Resection to include the other excision/resection codes
  • retired Excision, Resection, radical
  • retired Excision, Resection, total

Things collectors probably don't care about:

• checked code for things that set RecordStatus to lowercase incomplete, as had been flagged by Pagasa
  • updated Patient copier button code to use uppercase incomplete

2019-11-27

rolled out Ttenbergen 17:53, 2019 December 3 (CST)

• tweaked query s_tmp_ABO_TEE_checks so it triggers properly when the tmp box is checked, not when pre-send checker runs.
• updated how most cross checks are called; errors could have slipped by if a record had been correct, set to complete, and then got changed Ttenbergen 17:53, 2019 December 3 (CST)

2019-11-27

rolled out Ttenbergen 11:01, 2019 November 28 (CST)

• updated several queries that turned weird during the re-import last version; they turned named fields into "expr1" etc:
  • query check_CCI_Component_unfilled (was breaking when clicking diagnosis checkbox)
  • query L_ICD10_Charlson_Agepts (was breaking when clicking overstay)

2019-11-20

was rolled out sometime on Nov 26 evening

Changes collectors probably don't care about:

• changed owner check to hopefully reduce System resource exceeded error
  • added query L_Log_ownerCheck_maker' and code that runs it to create temporary table L_Log_ownerCheck which will be compared instead of full L_Log table.
• re-imported CCMDB.accdb into a new clean file; compact-repair was causing a password request at closing.
• cleaned up some old remnant code that was causing problems, presumably because some other errors were no longer hiding it
• tweaked query s_tmp_IICU_consult_DtTm to make it easier to see what, specifically, is wrong

2019-11-18

rolled out Ttenbergen 17:30, 2019 November 18 (CST)

Changes collectors probably care about:

• time overlap - updated function overlap to accept Dispo_DtTm at one unit to be <=, not only <, than Arrive_DtTm at the next
• Changes to quit overstay for patients with Accept_DtTm >= 2019-10-01
  • Update query query check_overstay_no_colour
  • Update query query check_overstay_not_entered

Changes collectors probably don't care about:

• updated query s_tmp_IICU_consult_dispo_to_IICU_but_no_tmp to stop checking at end of project, ie Accept_DtTm >= 2020-01-01

2019-11-13-1

rolled out Ttenbergen 22:40, 2019 November 17 (CST)

Things collectors probably want to know about:

• added "other - known but not listed" to s_dispo table as per Previous Location field Ttenbergen 17:55, 2019 November 13 (CST)
• EPR Reports Integrator
  • tweak to query to fix circumstance where date is found but chart is not
  • changed how the program deals with sent/deleted records
  • changed the key button so it no longer adds the dispo dttm from EPR to the dispo Dttm in CCMDB - apparently that field is used differently in the EPR reports as it comes in, and the Dispo DtTm should be possible to add to existing records via dispo button when it shows up in discharge report.
• changed the program so windows don't automatically get maximized all the time; this was specifically to be better able to work with Integrator, but of course will affect other windows as well

2019-11-13

rolled out Ttenbergen 16:52, 2019 November 13 (CST) Things collectors probably do care about:

• EPR Reports Integrator tweaks
  • fix to import for Sex field, it was setting to M when empty (ie in transfer report)
  • added sorting by PtName
  • added some code to kind of return to the same spot after excluding a record; not super happy with it, though; will probably need to tweak that further; still better than it was, I think.
  • fixed date sorts, they were sorting as text and now sort properly as dates
  • changed the "key" button so it populates Accept_DtTm rather than Arrive_DtTm
  • changed the query that drives the form to compare with Accept rather than Arrive DtTm.

Things collectors probably don't care about:

• updated Convert_DB() to include SL_EPR_Logs table

2019-11-06-1

rolled out Ttenbergen 17:39, 2019 November 7 (CST)

• added No codable procedure done in OR to s_CCI_Picklist table. Ttenbergen 14:44, 2019 November 7 (CST)
• confirmed that query check_CCI_from_OR_no_CCI will accept new code Ttenbergen 14:57, 2019 November 7 (CST)

2019-11-06

rolled out Ttenbergen 10:25, 2019 November 6 (CST)

• tweaked "Set MRSA Colonized" button
  • so it works right on a brand new empty record (was opening new form instead). Ttenbergen 09:56, 2019 November 6 (CST)
  • px count will now show as 1 instead of 0 for isolation
• updated EPR Reports Integrator so key button will work right for pt who has chart but not yet record for this admit dttm

2019-11-03

rolled out Ttenbergen 17:31, 2019 November 5 (CST)

• changed "Set MRSA Colonized" button to populate Isolation, infectious as Acquired Procedure Ttenbergen 13:37, 2019 November 3 (CST)
• EPR Reports Integrator
  • changed DisDtTm field so that clicking when a corresponding record exists on the laptop will fill the DisDtTm into Dispo DtTm
  • Fixed text field for location filter to allow entering filter text.
• in S_dispo table, disabled the following:
  • CON - ER
  • CON - ER (parked)
  • OAK - ER
  • OAK - ER (parked)

2019-11-01

rolled out Ttenbergen 12:28, 2019 November 1 (CDT) Changes collectors won't care about:

• updated query send_phi so it only includes completes and incompletes

2019-10-31

rolled out (Tina)

• tweak to EPR Reports Integrator

2019-10-30

rolled out Ttenbergen 12:02, 2019 October 30 (CDT)

• Changes collectors will want to know about:
  • ICUotherService - added options 'MICU under CICU service' and 'CICU under MICU service'
  • Boarding Loc
    • inactivated OAK - recovery
    • confirmed that e.g. HSC - Home medicine ward exists for this project
  • tweaked error msg for Query check ICD10 chronic vent acute resp failure to provide better instruction what to code instead.
  • in s_ICD10 table, renamed the following to clarify:
    • Liver failure w/wo hepatic encephalopathy, due to toxin/drug NOS to Liver failure due to toxin/drug NOS, w/wo hepatic encephalopathy
    • Liver failure w/wo hepatic encephalopathy, alcoholic to Liver failure, alcoholic, w/wo hepatic encephalopathy

2019-10-25

rolled out Ttenbergen 20:17, 2019 October 27 (CDT)

Collectors will want to know about this:

• made the "Set MRSA Colonized" button Ttenbergen 15:00, 2019 October 25 (CDT)
• added to s_ICD10 table
  • Rib fracture(s) due to CPR
  • Genetic susceptibility to malignant neoplasm
• changed Query check ICD10 chronic vent acute resp failure into a soft check: there will now be a warning but the entry will be allowed.
• added EPR Admit DtTm to dispo tab; this will be needed for EPR Reports Integrator and doesn't need to be entered until that is used; see instructions at pages above if you are interested

Changes collectors probably don't care about:

• changed Sub cb_Delete_Sent_Patients_Click() to
  • only logically delete patients at original delete time by setting recordstatus to deleted
  • delete their child l_* entries
  • delete log entries with discharge date < now - 3months
• updated sub DB_Converter and sub DB_Connect() to deal with CCMDB data.mdb Change Log#2018-10-27
• updated cross checks so they can cope with incompletes and take program from data rather than from setting:
  • query check_CCI_from_OR_no_CCI
  • Query check CCI must have entry
  • query check_ICD10_Comorbids_Dx_present
  • Query check overstay not entered
  • query check_overstay_pt_from_our_med
  • Query send_check_centralized_is_owner
• deleted legacy query Check Trauma codes without subcodes
• changed query PatientList to not include recordstatus deleted
• updated Sub GenerUpdate_tmp_entry, query check_tmp_generate_allowed to base on that record's program, not that laptop's

2019-10-24

rolled out Ttenbergen 09:48, 2019 October 24 (CDT)

• Tweak to the EPR Import button

2019-10-22

rolled out Ttenbergen 17:44, 2019 October 23 (CDT)

• working on some stuff for PatientFollow Project
• changed function overlap to allow same arrive dttm and dispo dttm on pt who has moved: please no longer use a delay as it used to be per Transfer time rule
• for EPR Reports Integrator
  • updated send query Send_Centralized_1L_Log_append it will only send incomplete or complete records now; before there were fewer options for RecordStatus, but now there will be more, so this needed to be filtered.
  • added two new buttons to the Main Form (CCMDB.accdb) to import and view EPR Reports data; updated the image while I was at it.

2019-10-09

rolled out Ttenbergen 15:45, 2019 October 21 (CDT)

• working on some stuff for PatientFollow Project
• in S dispo table:
  • changed acuity of "AMA (left against medical advice)" to really hi so no transfer ready date will be required.
  • set "HSC - Transitional care" to inactive as per Transitional Care
  • added "Not Known" and "Known but not listed"
  • added" HSC_A7S stepdown"; "HSC_A3S stepdown" will be removed once last pt in that location have been collected; can someone tell me when that is?
• added to S ICD10 table:
  • Retroperitoneal abscess
  • Psoas abscess

2019-10-08

rolled out Ttenbergen 16:53, 2019 October 8 (CDT)

• Changed the "set accept_DtTm to arrive_DtTm" button to move the focus to the Accept DtTm field when done to fix some flaky tabbing behaviour.
• Cross-check query check_dispo_lower_acuity_than_location was misfiring for discharges to generic ward locations (e.g. HSC ward) because they were listed at acuity level of non-teaching units, when we really have no clue about the level, so I changed it to acuity level of teaching units. Changed generic ward acuity levels to be same as teaching units. This is part of the bigger picture of Eliminating distinction between different ward types; flagging again for confirmation with Julie and Trish.
  • In S dispo table acuity_level:
    • set all blanks to 0
    • set all wards in our hospitals to level 6

2019-10-08

rolled out Ttenbergen 20:14, 2019 October 3 (CDT)

• inactivated "Died - NOT organ donor" and "Died - organ donor" in S dispo table
• added Septic Thrombosis or Embolism, NOS Ttenbergen 19:50, 2019 October 3 (CDT)

2019-10-02

rolled out Ttenbergen 22:54, 2019 October 2 (CDT)

• Boarding Loc: made Con - Recovery inactive
• using Double duty pathogens: updated Query check ICD10 Inf Infection req Pathogen must have one to allow Double duty pathogen as pathogens (e.g. Clostridium difficile infection (C. diff))

2019-09-27

rolled out Ttenbergen 16:22, 2019 September 27 (CDT)

• tweaked the sending sub and made sure it works
  • moved the wifi disconnect higher in the function

2019-09-25-1

rolled out Ttenbergen 17:24, 2019 September 25 (CDT)

• made Boarding Loc "no borrow" a default entry for new patients.

2019-09-25

rolled out Ttenbergen 12:12, 2019 September 25 (CDT) Collectors will likely not care about these:

• updated send function and globals to limit where the output location is set to only one place for better testing.
• updated query Send_Centralized_L_CCI_Component_append" to include Px Count which had been missing
  • confirmed that query Send_Centralized_L_CCI_Component_update includes Px Count

2019-09-24

rolled out Ttenbergen 14:13, 2019 September 24 (CDT)

• for Boarding Loc
  • added S tmp table dropdown:
    • GRA - Home medicine ward
    • HSC - Home medicine ward
    • STB - Home medicine ward
  • retired query s_tmp_Borrow_sensible_DtTm_vs_no_borrow
• updated cross checks query check_CCI_Picklist_unfilled and query check_CCI_Component_unfilled to trap types that are not "admit" or "acquired". Ttenbergen 13:10, 2019 September 24 (CDT)

2019-09-22

rolled out Ttenbergen 16:38, 2019 September 22 (CDT)

• added "home ward" to Boarding Loc S tmp table dropdown

2019-09-18-2

not rolled yet Ttenbergen 15:50, 2019 September 18 (CDT)

• updated Sub Reg_Yellower to make sure it sets to incomplete successfully; this was because some records were making it through for Check Function Validate_PostalCode. Ttenbergen 15:50, 2019 September 18 (CDT)
• updated sending functions to accommodate Conversion of Centralized data.mdb to Centralized data.accdb Ttenbergen 16:48, 2019 September 18 (CDT)

2019-09-18

rolled out Ttenbergen 07:55, 2019 September 18 (CDT)

• pw fix

2019-09-16-2

rolled out Ttenbergen 15:12, 2019 September 16 (CDT)

• retired Homelessness ICD10 code in S ICD10 table as per August 28, 2019 Task meeting
• retired / removed from dropdown several old tmp codes:
  • QA Infection CLI
  • Cooling
  • QA Septic Shock
  • Septic Shock Order Set

2019-09-16

rolled Ttenbergen 10:31, 2019 September 16 (CDT)

• removed the automatic adding of lines to the Notes field for new patients since the majority of collectors found them not helpful. Ttenbergen 10:11, 2019 September 16 (CDT)
• removed the attempt to fix Run-time error when closing the Notes field since it was causing more problems than it solved. Ttenbergen 10:11, 2019 September 16 (CDT)

2019-09-12

rolled Ttenbergen 10:57, 2019 September 12 (CDT)

• updated patient copy button to set RecordStatus field to incomplete on new record (was blank) and to add the automatic tmp entries as for a new patient. Ttenbergen 09:55, 2019 September 12 (CDT)
• fixed Run-time error when closing the Notes field error.

2019-09-11

rolled out Ttenbergen 13:37, 2019 September 11 (CDT)

• implemented Category:Potential trauma so Query check ICD10 mechanism vs trauma can work right for things like Anoxic brain injury, NOS that need to be able to be coded with Mechanism of injury: hanging or strangulation (accidental or intentional), but it could also be due to non-traumatic causes or mechanisms.

2019-09-04

rolled Ttenbergen 13:25, 2019 September 4 (CDT)

• further streamlined Query send_check_centralized_is_owner to fix System resource exceeded error; please let me know if still an issue. Ttenbergen 13:25, 2019 September 4 (CDT)

2019-09-03

rolled last night or this morning, can't remember. Ttenbergen 13:22, 2019 September 4 (CDT)

• added Anoxic brain injury, NOS to Category:Trauma to allow it with Mechanism of injury: hanging or strangulation (accidental or intentional)

2019-08-28

rolled out Ttenbergen 16:57, 2019 August 28 (CDT)

Behind the scenes changes:

• updated query Send_Centralized_L_CCI_Picklist_append - it was not updating the Px Count; Julie will fix old data
• fixed code for TIPS (transjugular intrahepatic portosystemic shunt) - it would not have been possible to enter this one because the code had some bad characters in it.

2019-08-26

rolled out Ttenbergen Ttenbergen 20:58, 2019 August 26 (CDT) Changes collectors will want to know about:

• added tmp entries for Boarding Loc Ttenbergen 19:41, 2019 August 26 (CDT)
• retired Depressive episode without major depressive disorder
• Added to S CCI 1 table:
  • (T) Toe
  • (T) Finger
• Retired tmp entry Comfort Care
• Added to S_ICD10 table:
  • Pulseless Electrical Activity (PEA)
  • Asystole

Behind the scenes changes:

• CPR, cardiac resuscitation - added the "r" that was added in July to CCI categories as well, forgot that when I changed it #2019-07-24.

2019-08-21

Rolled out Ttenbergen 17:36, 2019 August 21 (CDT) Changes Collectors will want to know about:

• Eardrum (tympanic membrane), rupture, injury/trauma - changed spelling from "Ear drum (tympanic membrane), rupture, injury/trauma" to Eardrum to make it consistent with other mentions on this wiki in S ICD10 table
• Perforation of tympanic membrane (eardrum) - removed from trauma category in S ICD10 Categories table since these are explicitly not the trauma codes
• activated Oaks Urgent Care in S dispo table as OAK - UC (it had already been added earlier); have not yet removed OAK - ER pending discharge of last pt who was admitted from there
• re-imported ICD10 dxs as per S_ICD10_table#Query_to_populate_from_wiki - at some point at least one change didn't make it from wiki to CCMDB (eg some of the meth codes), so was time to reset; also did Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb

2019-08-08

rolled out Ttenbergen 17:04, 2019 August 8 (CDT)

• updated error message for Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm to make it clearer to review instructions when this error comes up. Ttenbergen 17:04, 2019 August 8 (CDT)

2019-08-07

rolled out Ttenbergen 16:44, 2019 August 7 (CDT)

Behind the scenes changes:

• changed order of the Service/Location dropdown for more convenient order for Val's pilot of PatientFollow Project

2019-08-01

rolled out Ttenbergen 16:51, 2019 August 1 (CDT) Changes relevant to collectors:

• implemented the Patient copier button

Changes behind the scenes:

• updated S locations allowed collection table so Val can pilot PatientFollow Project

2019-07-31

rolled out Ttenbergen 13:39, 2019 July 31 (CDT) Changes relevant to collectors:

• removed GRA Transitional Care unit from S dispo table (made inactive)
• added Prostate, abscess to so it will be able to (and have to) be entered with a pathogen.

2019-07-25

rolled out Ttenbergen 11:20, 2019 July 25 (CDT) Changes collectors might want to know about:

• fixed category and collection mode entries for CPR, cardiac resuscitation
• updated Function is_valid_postalcode to only allow postal codes starting with [A-C,E,G,H,J-N,P,R-T,V,X,Y]
• retired the following codes in s_ICD10 table
  • Gastrostomy care
  • Ileostomy care
  • Colostomy care
  • Cystostomy care
  • Artificial openings NOS care

2019-07-24

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

• changed Drowning or near-drowning to not be a trauma code so no mechanism will now be required for this
• retired the old code "1.HZ.30" for CPR, cardiac resuscitation and created a new one "1.HZ.30r" in S CCI Picklist table; see CPR, cardiac resuscitation#Non-standard CCI code for further info

2019-07-04

rolled out Ttenbergen 14:15, 2019 July 4 (CDT)

• in S ICD10 table:
  • added Schizoaffective disorders
  • renamed "Brain compression, including herniation" to Brain compression, including herniation
  • renamed "Small intestine, ulcer" to Intestinal ulcer
• changed typo in STB - Transitional Care in S dispo table

2019-07-03

rolled out Ttenbergen 17:09, 2019 July 3 (CDT)

• made inactive Grace Nursing Home Ward; waiting for end date. Ttenbergen

13:43, 2019 July 3 (CDT)

• changed following to not be traumas any more so Query check ICD10 mechanism vs trauma won't trigger:
  • Frostbite
  • Trench foot (immersion foot)
  • Acute abdomen
• added Helicobacter pylori (H. pylori) to following categories to stop Query check ICD10 Inf Infection req Pathogen must have one from triggering when it's coded alone:
  • Bacteria
  • Infection with implied pathogen
  • Double duty pathogen
• Added Transitional Care units to S dispo table:
  • VIC - Transitional care
  • HSC - Transitional care
  • GRA - Transitional care
  • STB - Transitional care
  • Misericordia - Transitional care

2019-06-26

rolled out Ttenbergen 16:19, 2019 June 26 (CDT)

• added (I) Spinal Cord and/or Vertebrae (any segments) to S CCI 1 table, where it should have been added in January but seems it was not.

2019-06-25

rolled out Ttenbergen 17:27, 2019 June 25 (CDT)

• made "HSC_B3S" inactive in S dispo table.
• tweaked Query check ICD10 awaiting has Transfer Ready DtTm to not crash when there is no Dispo DtTm.

2019-06-20

rolled out Ttenbergen 17:22, 2019 June 20 (CDT)

• Bladder, cystitis, chronic changed to "Potential infection" from "Infection Requiring pathogen"
• Physical rehabilitation care retired

2019-06-19-2

rolled out Ttenbergen 16:41, 2019 June 19 (CDT)

• updated query Query check_ICD10_only_1_stage_of_renal_failure some more...

2019-06-19

rolled out Ttenbergen 09:53, 2019 June 19 (CDT)

• tweaked Query check_ICD10_only_1_stage_of_renal_failure
• fixed spelling for the following that was breaking link to wiki:
  • Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2, GFR 60-89
  • Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3, GFR 30-59
  • Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4, GFR 15-29

2019-06-18

rolled out Ttenbergen 17:03, 2019 June 18 (CDT) Changes collectors will want to know about:

• took Gallbladder or bile duct perforation or rupture out of Trauma and Neoplastic categories
• took Brain compression, including herniation out of trauma categories
• removed Rotator cuff, tear or rupture from mechanism category, should have never been in there...
• changed query check_ICD10_mechanism_vs_trauma to not include iatrogenic mechanisms
• removed Respiratory tract, foreign body in from Trauma category
• renamed the chronic renal diagnoses to include the GFR range in name:
  • Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1, GFR GT 90
  • Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2, GFR 60-89
  • Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3, GFR 30-59
  • Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4, GFR 15-29
  • Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15
• renamed codes to have "renal" in the name so keyword searches can find them
  • Chronic kidney/renal disease, NOS (stage unspecified)
  • Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15
• updated error box at the bottom to also list D_ID at all times for easier use of screen shots.
• implemented Query check_ICD10_only_1_stage_of_renal_failure

2019-06-12

rolled outTtenbergen 13:26, 2019 June 13 (CDT)

• Viral infection, NOS
• changed label for DC Treatment in demographic tab to "DC artificial life support treatment" (there seemed to be some confusion)
• added
  • CAR-T (Chimeric Antigen Receptor T-cell Immunotherapy)
  • Past history of Chimeric Antigen Receptor T-cell Immunotherapy (CAR-T)
• added Mechanism of injury: assault with bodily force
• retired code Sneezing
• added Upper airway obstruction, NOS

2019-06-10

rolled out Ttenbergen 10:35, 2019 June 11 (CDT)

• fixed spelling for Retinal tear, detachment, or break
• changed Clostridium difficile infection (C. diff) so it can be used as a pathogen when needed

2019-06-07

rolled out Ttenbergen 13:20, 2019 June 7 (CDT) Changes collectors will want to know about:

• took the following out of trauma category so it can now be used for situation caused by disease processes; see those pages for how to code in the context of trauma:
  • Spinal cord compression
  • Hemopericardium
  • Hemoperitoneum

• retired Intra-abdominal organ NOS, traumatic laceration/rupture - it was extremely similar to Intra-abdominal organ NOS, wound/injury/trauma NOS, so use that one.

• changed Radiation Therapy to collection mode collect first as decided Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2019#ICU_Database_Task_Group_Meeting_.E2.80.93_May_7.2C_2019.

2019-06-04-2

was rolled 06-04 12:40ish

• retired Query check CCI CRRT vs Tmp

2019-06-04

rolled out Ttenbergen 09:31, 2019 June 4 (CDT) Changes collectors will want to know about:

• in S_dispo table
  • added entries for new Guideline for coding organ donation after death
  • added entry for CON - UC, OAK - UC
• deactivatd CRRT in S tmp table

2019-05-23

rolled out Ttenbergen 10:33, 2019 May 24 (CDT)

• added Mycobacterium avium-intracellulare (MAC) to pathogen category to fix infection cross check.

2019-05-16

rolled out Ttenbergen 17:47, 2019 May 23 (CDT)

• added TIPS (transjugular intrahepatic portosystemic shunt) to S CCI Picklist table.
• included Category:Iatrogenic mechanism as mechanisms in Query check ICD10 mechanism vs trauma
• changed query check ICD10 mechanism vs trauma to list dx descriptions rather than codes.
• added a trigger for dx consistency every time someone leaves the dx tab

2019-05-15-2

rolled out Ttenbergen 16:01, 2019 May 15 (CDT) Changes collectors will want to know about:

• tweaked L ICD10 subform so the Dx Date is highlighted for Acquired Diagnoses
• changed tab order of text fields in Pharmacy tab to order of fields
• removed Epistaxis from Trauma since it was causing false positives in Query check ICD10 mechanism vs trauma.
• updated Query check_ICD10_Inf_Infection_req_Pathogen_must_have_one to list the dx description, not just the code.

Changes I tried and took back out:

• tweaked the input mask for times "Dispo" tab in Patient Viewer so you can enter single digits for hours or minutes
  • except I can't edit the minutes now for times with single digit hours so took this change back out.
• sort dx drop by frequency
  • realized that to make this work the dropdown sorting would have become something totally chaotic; discussed with HSC collectors and we decided not worth it

2019-05-15

rolled out Ttenbergen 09:26, 2019 May 15 (CDT)

• updated Pharm_flow tab in Patient Viewer to accept manual edit of date, and so that the "*" button only puts a date, no time. Ttenbergen 09:26, 2019 May 15 (CDT)

2019-05-14

rolled out Ttenbergen 17:14, 2019 May 14 (CDT) Changes collectors probably want to know about:

• changed ICD10 Chooser form: on opening the focus is now in filter box so you can just start typing for the filter, but the form no longer refreshes (and requires a second click on the item) when you click out of the filter box unless you actually entered something in the filter

2019-05-13

rolled out Ttenbergen 10:57, 2019 May 14 (CDT) Changes collectors should know about:

• changed the DOB field so the input mask works (ie no need to type dashes), at expense of losing the calendar tool (in Access you can only have one). Emailed collectors about the reasoning behind this.
• added "GRA_MICU" to Project Borrow arrive; needed to use the "GRA_ER" entry that was added some time ago.
• tweaked ICD10 Chooser form so the first click into it no longer reverts to the top of the list.

Changes collectors probably don't need to read about:

• updated query check_ICD10_mechanism_vs_trauma to make it easier to read (it listed Patient ID rather than the ID of the offending dx before)
• updated Toxicology, blood, alcohol, positive so it is no longer in trauma category, where it accidentally got added, which gave errors with query check_ICD10_mechanism_vs_trauma

2019-05-10

rolled out Ttenbergen 11:37, 2019 May 13 (CDT) Changes collectors will likely want to know about:

• Fixed the date fields so calendar entry works again; most recent change had accidentally disabled it. Ttenbergen 14:50, 2019 May 10 (CDT)
• tweaked filtering on CCI Chooser form and CCI Pick Chooser form

2019-05-09-2

Rolled out Ttenbergen 10:51, 2019 May 10 (CDT) Changes collectors will want to know about:

• fixed the input masks for the date fields

Changes collectors probably don't need to know about:

• deleted some old components that had been used for the old dx, como, lab schema

2019-05-09

rolled out Ttenbergen 22:51, 2019 May 9 (CDT) 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.

• fixed problems 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 after repeated fiddling with filter settings
• disabled QAInf / QA Infection CLI / QA Infection VAP in S tmp table since this is now stored in CCI/ICD10
• changed Patient List so the cursor/focus is on the patient picker binocular button when the form is opened, instead of the Patient ID field as before (there were reports of accidental deleting of the Patient ID with the old way)
• updated "generate email" button to include Patient ID
• fixed Query check ICD10 mechanism vs trauma that was not finding some errors (thanks for flagging that Michelle!)
• fixed the misclicker colour problem in ICD10s (if you clicked outside of a box accidentally the row would be hidden by a coloured box)

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