CCMDB.accdb Change Log 2019: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(23 intermediate revisions by the same user not shown)
Line 3: Line 3:


== Versions ==
== 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 ====
==== 2019-12-11 ====
not rolled out Ttenbergen
rolled out Ttenbergen 17:09, 2019 December 11 (CST)


Changes collectors will want to know about:  
Changes collectors will want to know about:  
Line 10: Line 28:
** broke out query ''MR_List'', essentially a copy of what was driving [[MR List]]
** 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
** 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'' diretly
** 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:  
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
* 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
* made background blue lighter on ''EPR Reports Integrator'' Discharge Date
* updated [[Patient copier button]] to close without doing anything when "cancel" is pressed at Patient ID interaction.
* 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 ====
==== 2019-12-08 ====
Line 28: Line 49:
* changed how sending checks for existing records, hoping this will fix [[System resource exceeded]] error...  
* 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]]
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  
* 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]]
** 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.
** fix the chart number matcher, it wasn't finding some matches.
* changed how the buttons work
* changed how the buttons work
Line 66: Line 87:
Changes collectors probably don't care about:
Changes collectors probably don't care about:
* changed owner check to hopefully reduce [[System resource exceeded]] error
* 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.
* 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
* cleaned up some old remnant code that was causing problems, presumably because some ''other'' errors were no longer hiding it
Line 75: Line 96:


Changes collectors probably care about:  
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_no_colour]]
** Update query [[query check_overstay_not_entered]]
** Update query [[query check_overstay_not_entered]]


Changes collectors probably don't care about:
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 ====
==== 2019-11-13-1 ====
Line 88: Line 109:
Things collectors probably want to know about:
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)
* 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
** tweak to query to fix circumstance where date is found but chart is not
** changed how the program deals with sent/deleted records
** changed how the program deals with sent/deleted records
Line 97: Line 118:
rolled out Ttenbergen 16:52, 2019 November 13 (CST)
rolled out Ttenbergen 16:52, 2019 November 13 (CST)
Things collectors probably do care about:  
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)
** fix to import for Sex field, it was setting to M when empty (ie in transfer report)
** added sorting by PtName
** added sorting by PtName
Line 105: Line 126:
** changed the query that drives the form to compare with Accept 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:  
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 ====
==== 2019-11-06-1 ====
Line 114: Line 135:
==== 2019-11-06 ====
==== 2019-11-06 ====
rolled out Ttenbergen 10:25, 2019 November 6 (CST)
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)
** 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
** 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 ====
==== 2019-11-03 ====
rolled out Ttenbergen 17:31, 2019 November 5 (CST)
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]]
** 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.
** Fixed text field for location filter to allow entering filter text.
Line 138: Line 159:
==== 2019-10-31 ====
==== 2019-10-31 ====
rolled out (Tina)
rolled out (Tina)
* tweak to [[EPR Reports Integrator]]
* tweak to ''EPR Reports Integrator''


==== 2019-10-30 ====
==== 2019-10-30 ====
Line 156: Line 177:


Collectors will want to know about this:
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]]
* added to [[s_ICD10 table]]
** [[Rib fracture(s) due to CPR]]  
** [[Rib fracture(s) due to CPR]]  
** [[Genetic susceptibility to malignant neoplasm]]
** [[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.  
* 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:
Changes collectors probably don't care about:
Line 187: Line 208:
rolled out Ttenbergen 17:44, 2019 October 23 (CDT)
rolled out Ttenbergen 17:44, 2019 October 23 (CDT)
* working on some stuff for [[PatientFollow Project]]
* 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.  
** 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.
** 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 208: Line 229:
rolled out Ttenbergen 16:53, 2019 October 8 (CDT)
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.
* 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:  
** In [[S dispo table]] acuity_level:  
Line 522: Line 543:


Changes collectors probably don't need to read about:  
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]]
* 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 547: Line 568:
** fixed the filter listing duplicates after repeated fiddling with filter settings
** 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]]
* 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 [[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)
* 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 655: Line 676:
Changes collectors likely don't care about:  
Changes collectors likely don't care about:  
* updated [[query send_check_centralized_is_owner]] to make it smaller; it was giving an error
* 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 ====
==== 2019-03-11 ====
Line 694: Line 715:
* changed '''[[Transfusion of albumin]]''' to [[CCI Collection Mode]] [[CCI collect first]]
* changed '''[[Transfusion of albumin]]''' to [[CCI Collection Mode]] [[CCI collect first]]
Behind the scenes changes:  
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 ====
==== 2019-02-06-1 ====
Line 720: Line 741:


Behind the scenes changes
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
* Updated Sub LabCheck() to still run on pt with [[Dispo DtTm]] < 2019-01-01


Line 829: Line 850:
rolled outTtenbergen 13:33, 2019 January 10 (CST)
rolled outTtenbergen 13:33, 2019 January 10 (CST)
Things collectors will want to know:  
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
* '''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.
* '''added lines back into ICD10 tab that had gone missing.
Line 849: Line 870:
* fixed false negative in [[query check CCI must have entry]]
* fixed false negative in [[query check CCI must have entry]]
* changed VBA so [[Query check CCI no admin entries]] actually gets called
* 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 ====
==== 2019-01-03-1 ====

Latest revision as of 09:44, 2023 May 18

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

Versions

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)

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:

Things collectors probably don't care about:

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:

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:

Changes collectors probably don't care about:

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)

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)

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)

2019-10-25

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

Collectors will want to know about this:

Changes collectors probably don't care about:

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)

2019-10-08

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

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

2019-10-08

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

2019-10-02

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

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)

2019-09-22

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

2019-09-18-2

not rolled yet Ttenbergen 15:50, 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)

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)

2019-09-11

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

2019-09-04

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

2019-08-28

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

Behind the scenes changes:

2019-08-26

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

Behind the scenes changes:

2019-08-21

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

2019-08-08

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

2019-08-07

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

Behind the scenes changes:

2019-08-01

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

Changes behind the scenes:

2019-07-31

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

2019-07-25

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

2019-07-24

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

2019-07-04

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

2019-07-03

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

13:43, 2019 July 3 (CDT)

2019-06-26

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

2019-06-25

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

2019-06-20

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

2019-06-19-2

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

2019-06-19

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

2019-06-18

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

2019-06-12

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

2019-06-10

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

2019-06-07

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

2019-06-04-2

was rolled 06-04 12:40ish

2019-06-04

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

2019-05-23

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

2019-05-16

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

2019-05-15-2

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

Changes I tried and took back out:

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

2019-05-15

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

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

2019-05-14

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

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

2019-05-13

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

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

Changes collectors probably don't need to read about:

2019-05-10

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

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

2019-05-09-2

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

  • fixed the input masks for the date fields

Changes collectors probably don't need to know about:

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

2019-05-09

rolled out Ttenbergen 22:51, 2019 May 9 (CDT) Changes collectors will want to know about: Thanks for a good conversation with Joanna and other HSC collectors who brought forward a few good suggestions. Keep them coming, this is how your program gets better.

  • fixed problems on the CCI Chooser and CCI Chooser picklist forms ("?" button on CCI tabs)
    • changed order of items in drop down for filter in CCI Chooser to list Diagnostic, Therapeutic and imaging first, some oddballs last, and the rest alphabetic. Let me know if it needs tweaking.
    • fixed the filter listing duplicates after repeated fiddling with filter settings
  • disabled QAInf / QA Infection CLI / QA Infection VAP in S tmp table since this is now stored in CCI/ICD10
  • changed Patient List so the cursor/focus is on the patient picker binocular button when the form is opened, instead of the 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 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)

2019-05-07

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

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

2019-05-02

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

2019-04-28

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

2019-04-22

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

2019-04-22

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

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

Behind the scenes change:

2019-04-15

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

2019-04-10

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

2019-04-08

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

2019-03-27-3

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

2019-03-27-2

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

2019-03-27

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

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

2019-03-25

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

Changes collectors will want to know about:

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

Changes behind the scenes:

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

2019-03-20

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

2019-03-13

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

2019-03-11-2

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

Changes collectors will want to know about:

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

Changes collectors likely don't care about:

2019-03-11

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

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

2019-03-09

rolled out

Changes collectors will want to know about:

2019-03-07

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

2019-03-06

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

behind the scenes changes:

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

2019-02-13

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

Changes collectors will want to know about:

Behind the scenes changes:

2019-02-06-1

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

2019-02-05

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

Changes collectors will want to know about:

Changes behind the scenes:

  • updated overstay function to use function CCMDB_Age

2019-01-30

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

Changes collectors will want to know about

Behind the scenes changes

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

2019-01-24

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

2019-01-23

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

2019-01-22-1

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

2019-01-22

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

2019-01-21

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

  • updated Sending so it works again...

Behind the scenes changes:

2019-01-17

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


Just fixes this time.


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

2019-01-16

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

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

2019-01-15

rolled out Ttenbergen 23:21, 2019 January 16 (CST) Stuff collectors should care about:

  • hoping to make errors easier to find - errors launched by checkboxes will now also show the query that raised them, hopefully providing additional help in finding out what is wrong. - updated Function Reject_a_query_PatID to use parameters, and all queries to use parameters.
  • set Lung abscess so it can accept a pathogen - updated wiki page and s_ICD10_Categories table
  • updated cross check for IICU consult to have the checkbox work according to collection instructions (cross check was giving false positives) - updated Query s tmp IICU consult DtTm Ttenbergen 10:14, 2019 January 16 (CST)
  • fixed links in error messages that didn't use to open wiki pages - updated field in form data_integrity_check and function Err_hURLer
  • updated Pre-send Checker and Send button to make sure both run the same checks - moved Check duplicate patient from sending only to the code that runs from pre-send checker.
  • tweaked height of tab content again to hopefully eliminate scrolling.

Behind the scenes stuff:

2019-01-14-1

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

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

2019-01-14

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

2019-01-10-1

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

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

Changes collectors probably don't care about:

2019-01-10

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

2019-01-09

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

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

2019-01-03-1

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

2019-01-03

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

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

2019-01-02-2

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

2019-01-02-1

was rolled

2019-01-02

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

2018-...