CCMDB.accdb Change Log 2019: Difference between revisions

(297 intermediate revisions by 3 users not shown)

Line 1:

__NOTOC__

See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | 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]]'''.

See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | 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 ==

Change for next version:

* remove the uppercaser in Main form Form_Load()

==== 2019-12-17 ====

not rolled yet Ttenbergen 11:58, 2019 December 17 (CST)

* Added checkbox option to [[Project ABO TEE]] project function.

==== 2019-12-11 ====

rolled out Ttenbergen 17:44, 2019 December 12 (CST)

* tweak to update function so it doesn't give error message to OK it.

* in ''EPR Reports Integrator''

** made date formats explicit for Accept and Arrive DtTm; had been set to default but that appears to be different on collector laptops than on Tina's

*** chose format mm/dd/yyyy to make comparison easier, since that's what comes in the EPR Report

** replaced Dispo DtTm field with Record field, apparently that is more useful in collecting; talk to me if it needs tweaking; also moved it closer to the left to be able to see it together with "binoc" button

** fixed sorting

** fixed logic that prevented entering a new record with key button just because a record corresponding to some dates on that line already exists. There are EPR log entries that need to result in two records, eg. transfer from and to a unit where we collect. Now this scenario launches a dialogue box that guides the collector through.

==== 2019-12-11 ====

rolled out Ttenbergen 17:09, 2019 December 11 (CST)

Changes collectors will want to know about:

* added a way to get MR list into an email to facilitate [[STB Medical Records requests]].

** broke out query ''MR_List'', essentially a copy of what was driving [[MR List]]

** changed [[MR_List]] report to use the new MR_List query instead for future consistency of changes

** added button "MR copy-paste" to [[Main Form (CCMDB.accdb)]] which just opens query ''MR_List'' directly

* in ''EPR Reports Integrator'', fixed sending based on admit or discharge "key" buttons

Behind the scenes changes collectors don't really need to know about:

* changed on Close event for [[Patient viewer]] to update ''EPR Reports Integrator'' if it's open when viewer closes

* made background blue lighter on ''EPR Reports Integrator'' Discharge Date

* updated [[Patient copier button]] to close without doing anything when "cancel" is pressed at [[Pat ID]] interaction.

* added code to Form_Load() to change the entries to RecordStatus from "incomplete" to "Incomplete"; had been entered as incomplete when generated by copier or EPR reports entry

* ran [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]

==== 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 [[Transfer_Ready_DtTm_field#Hierarchy_of_levels_of_care | 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 [[:Category:Double duty pathogen|Double duty pathogen]]s: updated [[Query check ICD10 Inf Infection req Pathogen must have one]] to allow [[:Category:Double duty pathogen|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 [[Task Team Meeting - Rolling Agenda and Minutes 2019#ICU Database Task Group Meeting – August 28, 2019 |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 [[Category:Infection requiring pathogen|Infection requiring pathogen]] 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 ====

~~{{DT | look at change request log for few things...thanks [[User:TOstryzniuk|Trish Ostryzniuk]]~~ 17:10, 2019 May 9 (CDT) }}

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

Line 37:

Line 543:

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 [[query check_ICD10_mechanism_vs_trauma]] to make it easier to read (it listed [[Pat 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]]

Line 62:

Line 568:

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

* changed [[Patient List]] so the cursor/focus is on the patient picker binocular button when the form is opened, instead of the [[Pat ID field]] as before (there were reports of accidental deleting of the [[Pat ID]] with the old way)

* updated [["generate email" button]] to include ~~Patient~~ ID

* updated [["generate email" button]] to include [[Pat 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)

Line 170:

Line 676:

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

* completed another cycle of [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]

==== 2019-03-11 ====

Line 209:

Line 715:

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

* re-ran [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]

==== 2019-02-06-1 ====

Line 235:

Line 741:

Behind the scenes changes

* Updated [[query s_tmp_overstay_Dementia_adm_como]]

* Updated ''query s_tmp_overstay_Dementia_adm_como''

* Updated Sub LabCheck() to still run on pt with [[Dispo DtTm]] < 2019-01-01

Line 344:

Line 850:

rolled outTtenbergen 13:33, 2019 January 10 (CST)

Things collectors will want to know:

* '''[[Re-importing CCI and IDC10 categories from wiki to CCMDB.~~mdb~~|reimported]] the CCI / ICD10 categories to reflect our reduction of CCI collection, see [[CCI Collection Mode]]s in [[CCI Picklist]].

* '''[[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb|reimported]] the CCI / ICD10 categories to reflect our reduction of CCI collection, see [[CCI Collection Mode]]s 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.

Line 364:

Line 870:

* fixed false negative in [[query check CCI must have entry]]

* changed VBA so [[Query check CCI no admin entries]] actually gets called

* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.~~mdb~~ | re-imported]] [[CCI Categories for CCMDB.~~mdb~~]] and [[ICD10 Categories for CCMDB.~~mdb~~]]

* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb | re-imported]] [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]

==== 2019-01-03-1 ====

Line 407:

Line 913:

* see [[CCMDB.mdb Change Log 2018]]

[[Category: CCMDB.~~mdb~~]]

[[Category:CCMDB.accdb]]

[[Category: Change Logs CCMDB]]

@@ Line 1: / Line 1: @@
 __NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
-See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | 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]]'''.
+See [[Log (disambiguation)]] for other uses of the term "Log". See the [[:Category: Development Documentation | 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 ==
+Change for next version:
+* remove the uppercaser in Main form Form_Load()
+==== 2019-12-17 ====
+not rolled yet Ttenbergen 11:58, 2019 December 17 (CST)
+* Added checkbox option to [[Project ABO TEE]] project function.
+==== 2019-12-11 ====
+rolled out Ttenbergen 17:44, 2019 December 12 (CST)
+* tweak to update function so it doesn't give error message to OK it.
+* in ''EPR Reports Integrator''
+** made date formats explicit for Accept and Arrive DtTm; had been set to default but that appears to be different on collector laptops than on Tina's
+*** chose format mm/dd/yyyy to make comparison easier, since that's what comes in the EPR Report
+** replaced Dispo DtTm field with Record field, apparently that is more useful in collecting; talk to me if it needs tweaking; also moved it closer to the left to be able to see it together with "binoc" button
+** fixed sorting
+** fixed logic that prevented entering a new record with key button just because a record corresponding to some dates on that line already exists. There are EPR log entries that need to result in two records, eg. transfer from and to a unit where we collect. Now this scenario launches a dialogue box that guides the collector through.
+==== 2019-12-11 ====
+rolled out Ttenbergen 17:09, 2019 December 11 (CST)
+Changes collectors will want to know about:
+* added a way to get MR list into an email to facilitate [[STB Medical Records requests]].
+** broke out query ''MR_List'', essentially a copy of what was driving [[MR List]]
+** changed [[MR_List]] report to use the new MR_List query instead for future consistency of changes
+** added button "MR copy-paste" to [[Main Form (CCMDB.accdb)]] which just opens query ''MR_List'' directly
+* in ''EPR Reports Integrator'', fixed sending based on admit or discharge "key" buttons
+Behind the scenes changes collectors don't really need to know about:
+* changed on Close event for [[Patient viewer]] to update ''EPR Reports Integrator'' if it's open when viewer closes
+* made background blue lighter on ''EPR Reports Integrator'' Discharge Date
+* updated [[Patient copier button]] to close without doing anything when "cancel" is pressed at [[Pat ID]] interaction.
+* added code to Form_Load() to change the entries to RecordStatus from "incomplete" to "Incomplete"; had been entered as incomplete when generated by copier or EPR reports entry
+* ran [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]
+==== 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 [[Transfer_Ready_DtTm_field#Hierarchy_of_levels_of_care | 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 [[:Category:Double duty pathogen|Double duty pathogen]]s: updated [[Query check ICD10 Inf Infection req Pathogen must have one]] to allow [[:Category:Double duty pathogen|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 [[Task Team Meeting - Rolling Agenda and Minutes 2019#ICU Database Task Group Meeting – August 28, 2019 |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 [[Category:Infection requiring pathogen|Infection requiring pathogen]] 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
+: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 ====
-{{DT |  look at change request log for few things...thanks [[User:TOstryzniuk|Trish Ostryzniuk]] 17:10, 2019 May 9 (CDT) }}
+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]]
@@ Line 37: / Line 543: @@
 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 [[query check_ICD10_mechanism_vs_trauma]] to make it easier to read (it listed [[Pat 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]]
@@ Line 62: / Line 568: @@
 ** 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)
+* changed [[Patient List]] so the cursor/focus is on the patient picker binocular button when the form is opened, instead of the [[Pat ID field]] as before (there were reports of accidental deleting of the [[Pat ID]] with the old way)
-* updated [["generate email" button]] to include Patient ID
+* updated [["generate email" button]] to include [[Pat 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)
@@ Line 170: / Line 676: @@
 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]]
+* completed another cycle of [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]
 ==== 2019-03-11 ====
@@ Line 209: / Line 715: @@
 * 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]]
+* re-ran [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb]]
 ==== 2019-02-06-1 ====
@@ Line 235: / Line 741: @@
 Behind the scenes changes
-* Updated [[query s_tmp_overstay_Dementia_adm_como]]
+* Updated ''query s_tmp_overstay_Dementia_adm_como''
 * Updated Sub LabCheck() to still run on pt with [[Dispo DtTm]] < 2019-01-01
@@ Line 344: / Line 850: @@
 rolled outTtenbergen 13:33, 2019 January 10 (CST)
 Things collectors will want to know:
-* '''[[Re-importing CCI and IDC10 categories from wiki to CCMDB.mdb|reimported]] the CCI / ICD10 categories to reflect our reduction of CCI collection, see [[CCI Collection Mode]]s in [[CCI Picklist]].
+* '''[[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb|reimported]] the CCI / ICD10 categories to reflect our reduction of CCI collection, see [[CCI Collection Mode]]s 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.
@@ Line 364: / Line 870: @@
 * fixed false negative in [[query check CCI must have entry]]
 * changed VBA so [[Query check CCI no admin entries]] actually gets called
-* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.mdb | re-imported]] [[CCI Categories for CCMDB.mdb]] and [[ICD10 Categories for CCMDB.mdb]]
+* [[Re-importing CCI and IDC10 categories from wiki to CCMDB.accdb | re-imported]] [[CCI Categories for CCMDB.accdb]] and [[ICD10 Categories for CCMDB.accdb]]
 ==== 2019-01-03-1 ====
@@ Line 407: / Line 913: @@
 * see [[CCMDB.mdb Change Log 2018]]
-[[Category: CCMDB.mdb]]
+[[Category:CCMDB.accdb]]
 [[Category: Change Logs CCMDB]]