CCMDB.accdb Change Log 2019 - Revision history

Ttenbergen: Text replacement - "[[Category: " to "[[Category:"

2025-07-30T16:32:54Z

Text replacement - "[[Category: " to "[[Category:"

← Older revision		Revision as of 11:32, 30 July 2025
Line 915:		Line 915:

	[[Category:CCMDB.accdb]]		[[Category:CCMDB.accdb]]
	[[Category: Change Logs CCMDB]]		[[Category:Change Logs CCMDB]]

Ttenbergen: Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"

2025-07-23T19:52:03Z

Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"

← Older revision		Revision as of 14:52, 23 July 2025
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 [[~~Centralized data~~.accdb]] to ~~Centralized data~~.accdb]] Ttenbergen 16:48, 2019 September 18 (CDT)		* updated sending functions to accommodate [[Conversion of [[Centralized_data.accdb]] to Centralized_data.accdb]] Ttenbergen 16:48, 2019 September 18 (CDT)

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

Ttenbergen: Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

2025-07-23T19:44:37Z

Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

← Older revision		Revision as of 14:44, 23 July 2025
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 Centralized data.~~mdb~~ to Centralized data.accdb]] Ttenbergen 16:48, 2019 September 18 (CDT)		* updated sending functions to accommodate [[Conversion of [[Centralized data.accdb]] to Centralized data.accdb]] Ttenbergen 16:48, 2019 September 18 (CDT)

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

Ttenbergen: Text replacement - "cross checks" to "cross checks"

2025-06-20T19:26:59Z

Text replacement - "cross checks" to "cross checks"

← Older revision		Revision as of 14:26, 20 June 2025
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 ~~checks~~ are called; errors could have slipped by if a record had been correct, set to complete, and then got changed Ttenbergen 17:53, 2019 December 3 (CST)		* updated how most [[cross check]]s are called; errors could have slipped by if a record had been correct, set to complete, and then got changed Ttenbergen 17:53, 2019 December 3 (CST)

	==== 2019-11-27 ====		==== 2019-11-27 ====
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 ~~checks~~ so they can cope with incompletes and take program from data rather than from setting:		* updated [[cross check]]s so they can cope with incompletes and take program from data rather than from setting:
	** [[query check_CCI_from_OR_no_CCI]]		** [[query check_CCI_from_OR_no_CCI]]
	** [[Query check CCI must have entry]]		** [[Query check CCI must have entry]]
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 ~~checks~~ [[query check_CCI_Picklist_unfilled]] and [[query check_CCI_Component_unfilled]] to trap types that are not "admit" or "acquired". Ttenbergen 13:10, 2019 September 24 (CDT)		* updated [[cross check]]s [[query check_CCI_Picklist_unfilled]] and [[query check_CCI_Component_unfilled]] to trap types that are not "admit" or "acquired". Ttenbergen 13:10, 2019 September 24 (CDT)

	==== 2019-09-22 ====		==== 2019-09-22 ====
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 ~~checks~~ to fix [[Bad values can get through if changed after setting RecordStatus to Complete]] - if I did this right collectors will not notice the change, but if I did it wrong there will be problems checking patients complete.		* updated [[cross check]]s to fix [[Bad values can get through if changed after setting RecordStatus to Complete]] - if I did this right collectors will not notice the change, but if I did it wrong there will be problems checking patients complete.

	==== 2019-04-22 ====		==== 2019-04-22 ====
Line 636:		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 ~~checks~~, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)		* tweak to the diagnosis [[cross check]]s, they were still trying to do things with the old form. Ttenbergen 12:33, 2019 March 27 (CDT)

	==== 2019-03-25 ====		==== 2019-03-25 ====
Line 705:		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 ~~checks~~ or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".		* updated Function Reject_a_query to return true/rejected when the query fails to ensure fail safe; this way if a query fails the test will return an error. This will mean that if there are errors during [[cross check]]s or sending collectors will no longer think "but it allowed me to send" or "but it allowed me to check complete".

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

Ttenbergen: Text replacement - "cross check " to "cross check "

2025-06-20T19:26:37Z

Text replacement - "cross check " to "cross check "

← Older revision		Revision as of 14:26, 20 June 2025
Line 805:		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.

Ttenbergen: /* 2019-04-10 */

2025-04-09T21:52:56Z

2019-04-10

← Older revision		Revision as of 16:52, 9 April 2025
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]]		** "Hypermagnesemia, severe or symptomatic"
	** [[Hypomagnesemia, severe or symptomatic]]		** "Hypomagnesemia, severe or symptomatic"
	** [[Hypercalcemia, severe or symptomatic]]		** "Hypercalcemia, severe or symptomatic"
	** [[Hypocalcemia, severe or symptomatic]]		** "Hypocalcemia, severe or symptomatic"
	** [[Hypernatremia / hyperosmolarity, severe or symptomatic]]		** "Hypernatremia / hyperosmolarity, severe or symptomatic"
	** [[Hyponatremia / hypoosmolarity, severe or symptomatic]]		** "Hyponatremia / hypoosmolarity, severe or symptomatic"
	** [[Hyperkalemia, severe or symptomatic]]		** "Hyperkalemia, severe or symptomatic"
	** [[Hypokalemia, severe or symptomatic]]		** "Hypokalemia, severe or symptomatic"
	** [[Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic]]		** "Hyperphosphatemia, hypophosphotemia or other disorder of phosphate metabolism, severe or symptomatic"
			* These were named back to remove the "severe and symptomatic" 2025-04-09 and the links removed from here.

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

Ttenbergen at 14:44, 18 May 2023

2023-05-18T14:44:11Z

← Older revision		Revision as of 09:44, 18 May 2023
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 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

Ttenbergen: Text replacement - "EPR Admit DtTm" to "''EPR_Admit_DtTm''"

2023-05-04T16:50:01Z

Text replacement - "EPR Admit DtTm" to "''EPR_Admit_DtTm''"

← Older revision		Revision as of 11:50, 4 May 2023
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 ~~[[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:

Ttenbergen: removed links to accept and arrive dttm

2022-04-21T22:31:34Z

removed links to accept and arrive dttm

← Older revision		Revision as of 17:31, 21 April 2022
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 [[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:

Ttenbergen at 20:41, 19 April 2022

2022-04-19T20:41:17Z

← Older revision		Revision as of 15:41, 19 April 2022
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 [[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 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 [[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 ====