CCMDB.accdb Change Log 2019: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Patient ID" to "Pat ID" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (14 intermediate revisions by the same user not shown) | |||
| Line 14: | Line 14: | ||
* tweak to update function so it doesn't give error message to OK it. | * tweak to update function so it doesn't give error message to OK it. | ||
* in | * 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 | ** 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 | *** chose format mm/dd/yyyy to make comparison easier, since that's what comes in the EPR Report | ||
| Line 28: | 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'' | ** added button "MR copy-paste" to [[Main Form (CCMDB.accdb)]] which just opens query ''MR_List'' directly | ||
* in | * 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 | * changed on Close event for [[Patient viewer]] to update ''EPR Reports Integrator'' if it's open when viewer closes | ||
* made background blue lighter on | * 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. | * 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 | * 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 | ||
| Line 49: | 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 | Changes collectors will probably want to know about ''if they are testing ''EPR Reports Integrator'' | ||
* updated the query that drives | * updated the query that drives ''EPR Reports Integrator'' (sL_EPR_Logs_FormQuery) to | ||
** compare based | ** 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 74: | Line 74: | ||
rolled out Ttenbergen 17:53, 2019 December 3 (CST) | 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. | * 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 | * 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 ==== | ==== 2019-11-27 ==== | ||
| Line 96: | 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 | * '''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 | * 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 | * 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 109: | 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'' | ||
** 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 118: | 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 | ||
** 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 126: | 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 | * updated Convert_DB() to include ''SL_EPR_Logs table'' | ||
==== 2019-11-06-1 ==== | ==== 2019-11-06-1 ==== | ||
| Line 138: | Line 138: | ||
** 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 | * 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'' | ||
** 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 159: | Line 159: | ||
==== 2019-10-31 ==== | ==== 2019-10-31 ==== | ||
rolled out (Tina) | rolled out (Tina) | ||
* tweak to | * tweak to ''EPR Reports Integrator'' | ||
==== 2019-10-30 ==== | ==== 2019-10-30 ==== | ||
| Line 182: | Line 182: | ||
** [[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 | * 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 190: | Line 190: | ||
** delete log entries with discharge date < now - 3months | ** 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 sub DB_Converter and sub DB_Connect() to deal with [[CCMDB data.mdb Change Log#2018-10-27]] | ||
* updated cross | * 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_from_OR_no_CCI]] | ||
** [[Query check CCI must have entry]] | ** [[Query check CCI must have entry]] | ||
| Line 208: | 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 | * 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 | * 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 229: | 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 | * 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 269: | Line 269: | ||
*** STB - Home medicine ward | *** STB - Home medicine ward | ||
** retired [[query s_tmp_Borrow_sensible_DtTm_vs_no_borrow]] | ** retired [[query s_tmp_Borrow_sensible_DtTm_vs_no_borrow]] | ||
* updated cross | * 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 ==== | ==== 2019-09-22 ==== | ||
| Line 278: | Line 278: | ||
not rolled yet Ttenbergen 15:50, 2019 September 18 (CDT) | 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 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 | * updated sending functions to accommodate [[Conversion of [[Centralized_data.accdb]] to Centralized_data.accdb]] Ttenbergen 16:48, 2019 September 18 (CDT) | ||
==== 2019-09-18 ==== | ==== 2019-09-18 ==== | ||
| Line 590: | Line 590: | ||
==== 2019-04-22 ==== | ==== 2019-04-22 ==== | ||
rolled out Ttenbergen 18:31, 2019 April 25 (CDT) | rolled out Ttenbergen 18:31, 2019 April 25 (CDT) | ||
* updated cross | * 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 ==== | ==== 2019-04-22 ==== | ||
| Line 609: | Line 609: | ||
rolled out Ttenbergen 16:07, 2019 April 15 (CDT) | rolled out Ttenbergen 16:07, 2019 April 15 (CDT) | ||
* changed names, appended ", severe or symptomatic" ('''see pages for Allan's update to definitions'''): | * changed names, appended ", severe or symptomatic" ('''see pages for Allan's update to definitions'''): | ||
** | ** "Hypermagnesemia, severe or symptomatic" | ||
** | ** "Hypomagnesemia, severe or symptomatic" | ||
** | ** "Hypercalcemia, severe or symptomatic" | ||
** | ** "Hypocalcemia, severe or symptomatic" | ||
** | ** "Hypernatremia / hyperosmolarity, severe or symptomatic" | ||
** | ** "Hyponatremia / hypoosmolarity, severe or symptomatic" | ||
** | ** "Hyperkalemia, severe or symptomatic" | ||
** | ** "Hypokalemia, severe or symptomatic" | ||
** | ** "Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic" | ||
* These were named back to remove the "severe and symptomatic" 2025-04-09 and the links removed from here. | |||
==== 2019-04-08 ==== | ==== 2019-04-08 ==== | ||
| Line 635: | Line 636: | ||
==== 2019-03-27 ==== | ==== 2019-03-27 ==== | ||
rolled Ttenbergen 12:33, 2019 March 27 (CDT) | rolled Ttenbergen 12:33, 2019 March 27 (CDT) | ||
* tweak to the diagnosis cross | * 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 ==== | ==== 2019-03-25 ==== | ||
| Line 704: | Line 705: | ||
behind the scenes changes: | 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 | * 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 ==== | ==== 2019-02-13 ==== | ||
| Line 741: | Line 742: | ||
Behind the scenes changes | Behind the scenes changes | ||
* Updated | * 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 804: | 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. | * '''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]] | * '''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 | * '''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. | * '''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 870: | Line 871: | ||
* 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.accdb | re-imported]] [[CCI Categories for CCMDB. | * [[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 ==== | ||
| Line 914: | Line 915: | ||
[[Category:CCMDB.accdb]] | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||