CCMDB.accdb Change Log 2019: Difference between revisions
Ttenbergen (talk | contribs) m link fixes |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 51: | Line 51: | ||
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 | ** 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 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 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 ''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. | ||
| 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 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 914: | Line 915: | ||
[[Category:CCMDB.accdb]] | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||