CCMDB.accdb Change Log 2019: Difference between revisions

(48 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)

==== 2019-11-27 ====

~~not~~ rolled ~~yet~~ Ttenbergen 10:16, 2019 November 28 (CST)

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)

Line 14:

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

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

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

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

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

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

Line 159:

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

rolled out (Tina)

* tweak to [[EPR Reports Integrator]]

* tweak to ''EPR Reports Integrator''

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

Line 104:

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

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

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

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

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

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

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

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

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

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 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)
 ==== 2019-11-27 ====
-not rolled yet Ttenbergen 10:16, 2019 November 28 (CST)
+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)
@@ Line 14: / 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 23: / 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 36: / 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 45: / 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 53: / 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 62: / 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 86: / Line 159: @@
 ==== 2019-10-31 ====
 rolled out (Tina)
-* tweak to [[EPR Reports Integrator]]
+* tweak to ''EPR Reports Integrator''
 ==== 2019-10-30 ====
@@ Line 104: / 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 135: / 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 156: / 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 470: / 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 495: / 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 603: / 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 642: / 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 668: / 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 777: / 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 797: / 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 ====