CCMDB.accdb Change Log 2019: Difference between revisions

(51 intermediate revisions by the same user not shown)

Line 3:

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

* updated how most [[cross check]]s 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 ====

Line 19:

Line 87:

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.

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

Line 28:

Line 96:

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

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

* 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

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

Line 41:

Line 109:

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

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

Line 50:

Line 118:

rolled out Ttenbergen 16:52, 2019 November 13 (CST)

Things collectors probably do care about:

* [[EPR Reports Integrator]] tweaks

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

Line 58:

Line 126:

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

* updated Convert_DB() to include ''SL_EPR_Logs table''

==== 2019-11-06-1 ====

Line 67:

Line 135:

==== 2019-11-06 ====

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

* tweaked [["~~Set~~ MRSA Colonized" button]]

* 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

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

* changed [["set MRSA Colonized" button]] to populate [[Isolation, infectious]] as [[Acquired Procedure]] Ttenbergen 13:37, 2019 November 3 (CST)

* [[EPR Reports Integrator]]

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

Line 91:

Line 159:

==== 2019-10-31 ====

rolled out (Tina)

* tweak to [[EPR Reports Integrator]]

* tweak to ''EPR Reports Integrator''

==== 2019-10-30 ====

Line 109:

Line 177:

Collectors will want to know about this:

* made the [["~~Set~~ MRSA Colonized" button]] Ttenbergen 15:00, 2019 October 25 (CDT)

* 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

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

Line 122:

Line 190:

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

* updated [[cross check]]s 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]]

Line 140:

Line 208:

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

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

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

Line 161:

Line 229:

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.

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

Line 201:

Line 269:

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

* updated [[cross check]]s [[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 ====

Line 210:

Line 278:

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)

* updated sending functions to accommodate [[Conversion of [[Centralized_data.accdb]] to Centralized_data.accdb]] Ttenbergen 16:48, 2019 September 18 (CDT)

==== 2019-09-18 ====

Line 475:

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 500:

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 522:

Line 590:

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

* updated [[cross check]]s 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 ====

Line 541:

Line 609:

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

** "Hypermagnesemia, severe or symptomatic"

** [[Hypomagnesemia, severe or symptomatic]]

** "Hypomagnesemia, severe or symptomatic"

** [[Hypercalcemia, severe or symptomatic]]

** "Hypercalcemia, severe or symptomatic"

** [[Hypocalcemia, severe or symptomatic]]

** "Hypocalcemia, severe or symptomatic"

** [[Hypernatremia / hyperosmolarity, severe or symptomatic]]

** "Hypernatremia / hyperosmolarity, severe or symptomatic"

** [[Hyponatremia / hypoosmolarity, severe or symptomatic]]

** "Hyponatremia / hypoosmolarity, severe or symptomatic"

** [[Hyperkalemia, severe or symptomatic]]

** "Hyperkalemia, severe or symptomatic"

** [[Hypokalemia, severe or symptomatic]]

** "Hypokalemia, severe or symptomatic"

** [[Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic]]

** "Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic"

* These were named back to remove the "severe and symptomatic" 2025-04-09 and the links removed from here.

==== 2019-04-08 ====

Line 567:

Line 636:

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

* tweak to the diagnosis [[cross check]]s, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)

==== 2019-03-25 ====

Line 608:

Line 677:

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 636:

Line 705:

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

* 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 check]]s or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".

==== 2019-02-13 ====

Line 647:

Line 716:

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

Line 742:

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 736:

Line 805:

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

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

Line 782:

Line 851:

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 802:

Line 871:

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

Line 915:

[[Category:CCMDB.accdb]]

[[Category: Change Logs CCMDB]]

[[Category:Change Logs CCMDB]]

@@ Line 3: / Line 3: @@
 == 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)
+* updated how most [[cross check]]s 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 ====
@@ Line 19: / Line 87: @@
 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.
+** 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
@@ Line 28: / Line 96: @@
 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
+* '''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
+* 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
+* 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 ====
@@ Line 41: / Line 109: @@
 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]]
+* ''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
@@ Line 50: / Line 118: @@
 rolled out Ttenbergen 16:52, 2019 November 13 (CST)
 Things collectors probably do care about:
-* [[EPR Reports Integrator]] tweaks
+* ''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
@@ Line 58: / Line 126: @@
 ** 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]]
+* updated Convert_DB() to include ''SL_EPR_Logs table''
 ==== 2019-11-06-1 ====
@@ Line 67: / Line 135: @@
 ==== 2019-11-06 ====
 rolled out Ttenbergen 10:25, 2019 November 6 (CST)
-* tweaked [["Set MRSA Colonized" button]]
+* 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
+* 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)
+* changed [["set MRSA Colonized" button]] to populate [[Isolation, infectious]] as [[Acquired Procedure]] Ttenbergen 13:37, 2019 November 3 (CST)
-* [[EPR Reports Integrator]]
+* ''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.
@@ Line 91: / Line 159: @@
 ==== 2019-10-31 ====
 rolled out (Tina)
-* tweak to [[EPR Reports Integrator]]
+* tweak to ''EPR Reports Integrator''
 ==== 2019-10-30 ====
@@ Line 109: / Line 177: @@
 Collectors will want to know about this:
-* made the [["Set MRSA Colonized" button]] Ttenbergen 15:00, 2019 October 25 (CDT)
+* 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
+* 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:
@@ Line 122: / Line 190: @@
 ** 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:
+* updated [[cross check]]s 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]]
@@ Line 140: / Line 208: @@
 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]]
+* 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]]
+* 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.
@@ Line 161: / Line 229: @@
 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.
+* 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:
@@ Line 201: / Line 269: @@
 *** 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)
+* updated [[cross check]]s [[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 ====
@@ Line 210: / Line 278: @@
 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)
+* updated sending functions to accommodate [[Conversion of [[Centralized_data.accdb]] to Centralized_data.accdb]] Ttenbergen 16:48, 2019 September 18 (CDT)
 ==== 2019-09-18 ====
@@ Line 475: / 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 500: / 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 522: / Line 590: @@
 ==== 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.
+* updated [[cross check]]s 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 ====
@@ Line 541: / Line 609: @@
 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]]
+** "Hypermagnesemia, severe or symptomatic"
-** [[Hypomagnesemia, severe or symptomatic]]
+** "Hypomagnesemia, severe or symptomatic"
-** [[Hypercalcemia, severe or symptomatic]]
+** "Hypercalcemia, severe or symptomatic"
-** [[Hypocalcemia, severe or symptomatic]]
+** "Hypocalcemia, severe or symptomatic"
-** [[Hypernatremia / hyperosmolarity, severe or symptomatic]]
+** "Hypernatremia / hyperosmolarity, severe or symptomatic"
-** [[Hyponatremia / hypoosmolarity, severe or symptomatic]]
+** "Hyponatremia / hypoosmolarity, severe or symptomatic"
-** [[Hyperkalemia, severe or symptomatic]]
+** "Hyperkalemia, severe or symptomatic"
-** [[Hypokalemia, severe or symptomatic]]
+** "Hypokalemia, severe or symptomatic"
-** [[Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic]]
+** "Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic"
+* These were named back to remove the "severe and symptomatic" 2025-04-09 and the links removed from here.
 ==== 2019-04-08 ====
@@ Line 567: / Line 636: @@
 ==== 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)
+* tweak to the diagnosis [[cross check]]s, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)
 ==== 2019-03-25 ====
@@ Line 608: / Line 677: @@
 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 636: / Line 705: @@
 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".
+* 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 check]]s or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".
 ==== 2019-02-13 ====
@@ Line 647: / Line 716: @@
 * 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 673: / Line 742: @@
 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 736: / Line 805: @@
 * '''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)
+* '''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.
@@ Line 782: / Line 851: @@
 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 802: / Line 871: @@
 * 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 846: / Line 915: @@
 [[Category:CCMDB.accdb]]
-[[Category: Change Logs CCMDB]]
+[[Category:Change Logs CCMDB]]