CCMDB.mdb Change Log 2015: Difference between revisions

(59 intermediate revisions by 2 users not shown)

Line 1:

__NOTOC__

'''''see [[Log (disambiguation)]] for other uses of the term "Log"

''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''

Line 7:

Line 8:

== Versions ==

=== 2015-Dec-16 ===

rolled Ttenbergen 16:38, 2015 December 16 (CST)

* cross-checks for [[ACP Status Collection in ICU]] Ttenbergen 16:21, 2015 December 16 (CST)

=== 2015-Nov-25 ===

rolled. - Ttenbergen 10:02, 2015 December 8 (CST)

* [[Service Sending to ICU]] - made checks run only for CC Ttenbergen 10:02, 2015 December 8 (CST)

=== 2015-Nov-25 ===

rolled out Ttenbergen 22:27, 2015 December 7 (CST)

* [[Service Sending to ICU]]

** [[cross check]]s: all ICU patients must have an entry and the "item" can not be "enter" or "". Ttenbergen 20:49, 2015 December 7 (CST)

** auto entry: every new ICU patient will have a record in tmp tab for this, but item will be "enter" and must be updated. Ttenbergen 20:49, 2015 December 7 (CST)

** added option "z_not an inpatient" Ttenbergen 22:27, 2015 December 7 (CST)

=== 2015-Nov-16 ===

rolled to all, ie the changes that were beta tested at HSC are now rolled to all as well. Ttenbergen 10:34, 2015 November 16 (CST)

* updated the dxChooser form to list only dxs where collection_allowed is true (Thanks Joyce for pointing out this problem) Ttenbergen 10:34, 2015 November 16 (CST)

=== 2015-Nov-10 ===

rolled to HSC for testing. Ttenbergen 11:51, 2015 November 10 (CST)

* updated the database checks to only run upon changed if the checkbox is already set. Without this would have brought up a bunch of gophers for incomplete patients.

=== 2015-Oct-19 ===

Beta rolled to HSC as discussed with Trish. Ttenbergen 18:02, 2015 November 9 (CST)

* removed boarding column from [[s_dispo table]] Ttenbergen 16:55, 2015 October 19 (CDT)

* deleted query ''1_sDispoOutputter'' Ttenbergen 16:55, 2015 October 19 (CDT)

* reviewed table ''s_preAcuteLivingSituation'' that was added previously but not documented Ttenbergen 17:04, 2015 October 19 (CDT)

* added table ''s_previousService'' Ttenbergen 17:04, 2015 October 19 (CDT)

* made inactive [[Respiratory Arrest]] Ttenbergen 13:45, 2015 October 22 (CDT)

* added checks to catch if changes are made to a record after the checkboxes are set to complete:

** added checks to '''DX''' form for deletes and inserts, updates were already checked Ttenbergen 16:42, 2015 November 9 (CST)

** added checks to '''Como''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 16:42, 2015 November 9 (CST)

** added checks for '''Labs''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:31, 2015 November 9 (CST)

** added checks for '''Pharm''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:31, 2015 November 9 (CST)

** added checks for '''Tmp''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:34, 2015 November 9 (CST)

=== 2015-Oct-02 ===

rolled Ttenbergen 17:08, 2015 October 2 (CDT)

* removed STB A5 from [[S Locations]]. Ttenbergen 13:27, 2015 October 2 (CDT)

* updated Var1/var2 to not be mandatory for ICU... this had changed at some point, can't remember details, and Gail pointed out the problem. Ttenbergen 13:39, 2015 October 2 (CDT)

=== 2015-Sep-21 ===

rolled Ttenbergen 13:07, 2015 September 21 (CDT)

* fixed wording for [[Neurodevelopmental disorder]], had made a mistake cut/pasting it. Ttenbergen 13:07, 2015 September 21 (CDT)

=== 2015-Sep-16 ===

rolled Ttenbergen 16:51, 2015 September 17 (CDT)

* confirmed that "Caesarian Section" is in table [[Check_ORDx]]

* added [[HIPEC - Hyperthermic IntraPeritoneal Chemotherapy]] Ttenbergen 16:44, 2015 September 17 (CDT)

* added [[Neurodevelopmental disorder]] Ttenbergen 16:44, 2015 September 17 (CDT)

=== 2015-Aug-17 ===

rolled out Ttenbergen 09:20, 2015 August 24 (CDT)

* [[Panelling_or_Discharge_Planning#CCDMB_Data_Integrity_Checks]]

** imported query ''Primary_admit'' from [[CFE]] and updated for use in [[CCMDB.accdb]]

** added query ''check_panelled_primary_but_adm_NE_tr''

** added check to module Tmp_Checker Ttenbergen 16:06, 2015 August 17 (CDT)

* fixed [[Transfer_Ready_date_and_time#CCDMB_Data_Integrity_Checks]] for ICU, it was letting through empties as long as there was anything in the Notes field, no more. Ttenbergen 10:31, 2015 August 19 (CDT)

=== 2015-Aug-13 ===

rolled out Ttenbergen 08:56, 2015 August 17 (CDT)

* added [[ECMO Veno-venous]] and [[ECMO Veno-arterial]] to table [[Check_ORDx]] to allow collection as [[Primary Admit Diagnosis]] for patients who come from the OR. Ttenbergen 11:57, 2015 August 13 (CDT)

* removed field "old_hospital_code" from [[S_dispo table]], it now lives in ''S dispo legacy codes table'' Ttenbergen 17:08, 2015 August 13 (CDT)

=== 2015-Jul-23 ===

rolled Ttenbergen 09:46, 2015 August 10 (CDT)

* updated data in s_dispo and related s_ tables. Ttenbergen 10:15, 2015 August 6 (CDT)

* as decided at task meeting:

** added [[Other Psychological Disturbance]] to [[s_AllDiagnoses table]] Ttenbergen 15:02, 2015 August 6 (CDT)

** added "z_other" to [[Service Sending to ICU]] Ttenbergen 15:04, 2015 August 6 (CDT)

** added [[s_tmp table]] entries for [[ACP Status Collection in ICU]] Ttenbergen 15:42, 2015 August 6 (CDT)

=== 2015-Jul-14 ===

~~not~~ rolled ~~yet~~ Ttenbergen 21:05, 2015 July 14 (CDT)

rolled out Ttenbergen 11:34, 2015 July 23 (CDT)

* removed exemption for STB_CICU from Function AdFrom_same_ICU() Ttenbergen 21:05, 2015 July 14 (CDT)

* changed [[ECMO]] entry in [[~~s_Alldiagnoses~~]]

* changed [[ECMO]] entry in [[s_AllDiagnoses table]] Ttenbergen 11:33, 2015 July 23 (CDT)

** changed "collection_allowed" for 76339 to false

** added [[ECMO Veno-venous]] 76342

Line 36:

Line 110:

===2015-Jun-22===

rolled out Ttenbergen 16:07, 2015 June 22 (CDT)

* added to [[~~s_alldiagnoses~~]]: [[Adult failure to thrive]] Ttenbergen 13:56, 2015 June 22 (CDT)

* added to [[s_AllDiagnoses table]]: [[Adult failure to thrive]] Ttenbergen 13:56, 2015 June 22 (CDT)

* removed query and check for s_tmp_CCU_Service_missing for [[CCU Service Tracking]] Ttenbergen 14:01, 2015 June 22 (CDT)

* added to [[s_tmp]]: options for [[Service Sending to ICU]] Ttenbergen 14:55, 2015 June 22 (CDT)

* added to [[s_tmp table]]: options for [[Service Sending to ICU]] Ttenbergen 14:55, 2015 June 22 (CDT)

* [[s_AdmitDischarge]]: added "inpatient" column to be able to run checks for [[Service Sending to ICU]] Ttenbergen 15:35, 2015 June 22 (CDT)

* added cross-check queries ''s_tmp_Service_Sending_to_ICU'' and ''s_tmp_Service_Sending_to_ICU_duplicate'' for [[Service Sending to ICU]] Ttenbergen 15:35, 2015 June 22 (CDT)

Line 62:

Line 136:

rolled out Ttenbergen 10:26, 2015 June 1 (CDT)

* adding [[CCU Service Tracking]]

** added options to table ''[[~~S Tmp~~]]'' Ttenbergen 15:47, 2015 May 28 (CDT)

** added options to table ''[[s_tmp table]]'' Ttenbergen 15:47, 2015 May 28 (CDT)

** added code to module Tmp_Checker to run the queries Ttenbergen 16:27, 2015 May 28 (CDT)

** adding code to check that consecutive locations are not same...

Line 101:

Line 175:

===2015-May-4-3===

rolled Ttenbergen 11:42, 2015 May 4 (CDT)

* updated table ''[[s_tmp_er_wait_r_locations]]'' to accommodate changes in [[#2015-May-4-2]] Ttenbergen 11:42, 2015 May 4 (CDT)

* updated table ''s_tmp_er_wait_r_locations'' to accommodate changes in [[#2015-May-4-2]] Ttenbergen 11:42, 2015 May 4 (CDT)

===2015-May-4-2===

rolled Ttenbergen 11:14, 2015 May 4 (CDT)

* found some error checks that apply to HSC_ICUs that didn't translate to new location designations, fixed. Ttenbergen 11:06, 2015 May 4 (CDT)

* corrected the new names for [[HSC ICU ~~locations and serial number sharing 2015-05-01~~]] Ttenbergen 11:06, 2015 May 4 (CDT)

* corrected the new names for [[HSC ICU workload splitting]] Ttenbergen 11:06, 2015 May 4 (CDT)

* updated functions ''AdFrom_same_ICU'' and ''DisTo_same_ICU'' to check new locations and also check HSC IICU Ttenbergen 11:06, 2015 May 4 (CDT)

Line 127:

Line 201:

** changed date formats in patient list to make them more similar to the format used in the patient viewer. Ttenbergen 15:54, 2015 April 29 (CDT)

** added check that there '''can't be more than one''' entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)

** Added new HSC MICU locations as per [[HSC ICU ~~locations and serial number sharing 2015-05-01~~]] and inactivated old ones. Ttenbergen 16:58, 2015 April 29 (CDT)

** Added new HSC MICU locations as per [[HSC ICU workload splitting]] and inactivated old ones. Ttenbergen 16:58, 2015 April 29 (CDT)

* likely invisible

** renamed query ''L_Labs_Flowsheet_sum'' to [[Query L Labs total]] for consistency. Ttenbergen 14:15, 2015 April 16 (CDT)

** added query ''s_tmp_comfort_care_gt_one'' for cross check for more than one entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)

** added query ''s_tmp_comfort_care_gt_one'' for [[cross check]] for more than one entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)

** as discussed with Julie, changed module sending function Send_Data to no longer send to [[Tasks 1.mdb]],[[Imaging.mdb]],[[Pharmacy.mdb]] and [[TmpV2 1.mdb]]

** as discussed with Trish, changed module sending function Send_Data to no longer send TMS output .csvs

Line 138:

Line 212:

* deleted old send queries that are no longer used: send_imaging, send_tasks, send_tasks_master, send_tmp, send_tmp_audit Ttenbergen 10:48, 2015 April 30 (CDT)

* deleted old query 20130311_pharm_converter that was used only once when we changed the system Ttenbergen 10:48, 2015 April 30 (CDT)

* imported ~~ccmdb~~.~~mdb~~ into a new clean file; TMSX stuff had been the hold-up. Ttenbergen 11:15, 2015 April 30 (CDT)

* imported [[CCMDB.accdb]] into a new clean file; TMSX stuff had been the hold-up. Ttenbergen 11:15, 2015 April 30 (CDT)

* changed MainForm open code to not eliminate 2003 excel reference code Ttenbergen 11:15, 2015 April 30 (CDT)

Line 165:

Line 239:

*** eliminated options no longer used from drop-down

*** made label into link to wiki

*** added the field to the ~~hider function~~ so it is shown only for CC as wiki says only used for CC

*** added the field to the [[Sub Check_Forms.Legacy_Hider()]] so it is shown only for CC as wiki says only used for CC

* removed some erratic code from module tmp_checker that was trying to set form components when it is not run from that form

* [[ARF]]

Line 176:

Line 250:

* implement [[Serial_number#STB_5B:_Serial_number_share_plan]]

** added location STB_5B_X to table ''[[S Locations]]'' and to table ''s_locations_allowed_collection''

* added code to cause error if the [[Notes field]] has too much content (~~http~~://answers.microsoft.com/en-us/~~office~~/forum/~~office_2007-access~~/memo-field-could-not-update-currently-locked-by/d5c8163a-7ce5-484f-80d4-98c1a8c92160)Ttenbergen 14:30, 2015 January 19 (CST)

* added code to cause error if the [[Notes field]] has too much content (

https://answers.microsoft.com/en-us/msoffice/forum/all/memo-field-could-not-update-currently-locked-by/d5c8163a-7ce5-484f-80d4-98c1a8c92160) Ttenbergen 14:30, 2015 January 19 (CST)

===2015-Jan-5===

Line 186:

Line 261:

* [[S_AdmitDischarge]]: added ZH-Hospice Care Center

[[Category: CCMDB.~~mdb~~]]

[[Category:CCMDB.accdb]]

[[Category: Change Logs CCMDB]]

[[Category:Change Logs CCMDB]]

@@ Line 1: / Line 1: @@
+__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
 '''''see [[Log (disambiguation)]] for other uses of the term "Log"
 ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
@@ Line 7: / Line 8: @@
 == Versions ==
+=== 2015-Dec-16 ===
+rolled Ttenbergen 16:38, 2015 December 16 (CST)
+* cross-checks for [[ACP Status Collection in ICU]] Ttenbergen 16:21, 2015 December 16 (CST)
+=== 2015-Nov-25 ===
+rolled. - Ttenbergen 10:02, 2015 December 8 (CST)
+* [[Service Sending to ICU]] - made checks run only for CC Ttenbergen 10:02, 2015 December 8 (CST)
+=== 2015-Nov-25 ===
+rolled out Ttenbergen 22:27, 2015 December 7 (CST)
+* [[Service Sending to ICU]]
+** [[cross check]]s: all ICU patients must have an entry and the "item" can not be "enter" or "". Ttenbergen 20:49, 2015 December 7 (CST)
+** auto entry: every new ICU patient will have a record in tmp tab for this, but item will be "enter" and must be updated. Ttenbergen 20:49, 2015 December 7 (CST)
+** added option "z_not an inpatient" Ttenbergen 22:27, 2015 December 7 (CST)
+=== 2015-Nov-16 ===
+rolled to all, ie the changes that were beta tested at HSC are now rolled to all as well. Ttenbergen 10:34, 2015 November 16 (CST)
+* updated the dxChooser form to list only dxs where collection_allowed is true (Thanks Joyce for pointing out this problem) Ttenbergen 10:34, 2015 November 16 (CST)
+=== 2015-Nov-10 ===
+rolled to HSC for testing. Ttenbergen 11:51, 2015 November 10 (CST)
+* updated the database checks to only run upon changed if the checkbox is already set. Without this would have brought up a bunch of gophers for incomplete patients.
+=== 2015-Oct-19 ===
+Beta rolled to HSC as discussed with Trish. Ttenbergen 18:02, 2015 November 9 (CST)
+* removed boarding column from [[s_dispo table]] Ttenbergen 16:55, 2015 October 19 (CDT)
+* deleted query ''1_sDispoOutputter'' Ttenbergen 16:55, 2015 October 19 (CDT)
+* reviewed table ''s_preAcuteLivingSituation'' that was added previously but not documented Ttenbergen 17:04, 2015 October 19 (CDT)
+* added table ''s_previousService'' Ttenbergen 17:04, 2015 October 19 (CDT)
+* made inactive [[Respiratory Arrest]] Ttenbergen 13:45, 2015 October 22 (CDT)
+* added checks to catch if changes are made to a record after the checkboxes are set to complete:
+** added checks to '''DX''' form for deletes and inserts, updates were already checked Ttenbergen 16:42, 2015 November 9 (CST)
+** added checks to '''Como''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox  Ttenbergen 16:42, 2015 November 9 (CST)
+** added checks for '''Labs''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:31, 2015 November 9 (CST)
+** added checks for '''Pharm''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:31, 2015 November 9 (CST)
+** added checks for '''Tmp''' form for deletes and inserts and updates, there were not any inside that form, just called from checkbox Ttenbergen 17:34, 2015 November 9 (CST)
+=== 2015-Oct-02 ===
+rolled Ttenbergen 17:08, 2015 October 2 (CDT)
+* removed STB A5 from [[S Locations]]. Ttenbergen 13:27, 2015 October 2 (CDT)
+* updated Var1/var2 to not be mandatory for ICU... this had changed at some point, can't remember details, and Gail pointed out the problem. Ttenbergen 13:39, 2015 October 2 (CDT)
+=== 2015-Sep-21 ===
+rolled Ttenbergen 13:07, 2015 September 21 (CDT)
+* fixed wording for [[Neurodevelopmental disorder]], had made a mistake cut/pasting it. Ttenbergen 13:07, 2015 September 21 (CDT)
+=== 2015-Sep-16 ===
+rolled Ttenbergen 16:51, 2015 September 17 (CDT)
+* confirmed that "Caesarian Section" is in table [[Check_ORDx]]
+* added [[HIPEC - Hyperthermic IntraPeritoneal Chemotherapy]] Ttenbergen 16:44, 2015 September 17 (CDT)
+* added [[Neurodevelopmental disorder]] Ttenbergen 16:44, 2015 September 17 (CDT)
+=== 2015-Aug-17 ===
+rolled out Ttenbergen 09:20, 2015 August 24 (CDT)
+* [[Panelling_or_Discharge_Planning#CCDMB_Data_Integrity_Checks]]
+** imported query ''Primary_admit'' from [[CFE]] and updated for use in [[CCMDB.accdb]]
+** added query ''check_panelled_primary_but_adm_NE_tr''
+** added check to module Tmp_Checker Ttenbergen 16:06, 2015 August 17 (CDT)
+* fixed [[Transfer_Ready_date_and_time#CCDMB_Data_Integrity_Checks]] for ICU, it was letting through empties as long as there was anything in the Notes field, no more. Ttenbergen 10:31, 2015 August 19 (CDT)
+=== 2015-Aug-13 ===
+rolled out Ttenbergen 08:56, 2015 August 17 (CDT)
+* added [[ECMO Veno-venous]] and [[ECMO Veno-arterial]] to table [[Check_ORDx]] to allow collection as [[Primary Admit Diagnosis]] for patients who come from the OR. Ttenbergen 11:57, 2015 August 13 (CDT)
+* removed field "old_hospital_code" from [[S_dispo table]], it now lives in ''S dispo legacy codes table'' Ttenbergen 17:08, 2015 August 13 (CDT)
+=== 2015-Jul-23 ===
+rolled Ttenbergen 09:46, 2015 August 10 (CDT)
+* updated data in s_dispo and related s_ tables. Ttenbergen 10:15, 2015 August 6 (CDT)
+* as decided at task meeting:
+** added [[Other Psychological Disturbance]] to [[s_AllDiagnoses table]] Ttenbergen 15:02, 2015 August 6 (CDT)
+** added "z_other" to [[Service Sending to ICU]] Ttenbergen 15:04, 2015 August 6 (CDT)
+** added [[s_tmp table]] entries for [[ACP Status Collection in ICU]] Ttenbergen 15:42, 2015 August 6 (CDT)
 === 2015-Jul-14 ===
-not rolled yet Ttenbergen 21:05, 2015 July 14 (CDT)
+rolled out Ttenbergen 11:34, 2015 July 23 (CDT)
 * removed exemption for STB_CICU from Function AdFrom_same_ICU() Ttenbergen 21:05, 2015 July 14 (CDT)
-* changed [[ECMO]] entry in [[s_Alldiagnoses]]
+* changed [[ECMO]] entry in [[s_AllDiagnoses table]] Ttenbergen 11:33, 2015 July 23 (CDT)
 ** changed "collection_allowed" for 76339 to false
 ** added [[ECMO Veno-venous]]	76342
@@ Line 36: / Line 110: @@
 ===2015-Jun-22===
 rolled out Ttenbergen 16:07, 2015 June 22 (CDT)
-* added to [[s_alldiagnoses]]: [[Adult failure to thrive]] Ttenbergen 13:56, 2015 June 22 (CDT)
+* added to [[s_AllDiagnoses table]]: [[Adult failure to thrive]] Ttenbergen 13:56, 2015 June 22 (CDT)
 * removed query and check for s_tmp_CCU_Service_missing for [[CCU Service Tracking]] Ttenbergen 14:01, 2015 June 22 (CDT)
-* added to [[s_tmp]]: options for [[Service Sending to ICU]] Ttenbergen 14:55, 2015 June 22 (CDT)
+* added to [[s_tmp table]]: options for [[Service Sending to ICU]] Ttenbergen 14:55, 2015 June 22 (CDT)
 * [[s_AdmitDischarge]]: added "inpatient" column to be able to run checks for [[Service Sending to ICU]] Ttenbergen 15:35, 2015 June 22 (CDT)
 * added cross-check queries ''s_tmp_Service_Sending_to_ICU'' and ''s_tmp_Service_Sending_to_ICU_duplicate'' for [[Service Sending to ICU]] Ttenbergen 15:35, 2015 June 22 (CDT)
@@ Line 62: / Line 136: @@
 rolled out Ttenbergen 10:26, 2015 June 1 (CDT)
 * adding [[CCU Service Tracking]]
-** added options to table ''[[S Tmp]]'' Ttenbergen 15:47, 2015 May 28 (CDT)
+** added options to table ''[[s_tmp table]]'' Ttenbergen 15:47, 2015 May 28 (CDT)
 ** added code to module Tmp_Checker to run the queries Ttenbergen 16:27, 2015 May 28 (CDT)
 ** adding code to check that consecutive locations are not same...
@@ Line 101: / Line 175: @@
 ===2015-May-4-3===
 rolled Ttenbergen 11:42, 2015 May 4 (CDT)
-* updated table ''[[s_tmp_er_wait_r_locations]]'' to accommodate changes in [[#2015-May-4-2]] Ttenbergen 11:42, 2015 May 4 (CDT)
+* updated table ''s_tmp_er_wait_r_locations'' to accommodate changes in [[#2015-May-4-2]] Ttenbergen 11:42, 2015 May 4 (CDT)
 ===2015-May-4-2===
 rolled Ttenbergen 11:14, 2015 May 4 (CDT)
 * found some error checks that apply to HSC_ICUs that didn't translate to new location designations, fixed. Ttenbergen 11:06, 2015 May 4 (CDT)
-* corrected the new names for [[HSC ICU locations and serial number sharing 2015-05-01]] Ttenbergen 11:06, 2015 May 4 (CDT)
+* corrected the new names for [[HSC ICU workload splitting]] Ttenbergen 11:06, 2015 May 4 (CDT)
 * updated functions ''AdFrom_same_ICU'' and ''DisTo_same_ICU'' to check new locations and also check HSC IICU Ttenbergen 11:06, 2015 May 4 (CDT)
@@ Line 127: / Line 201: @@
 ** changed date formats in patient list to make them more similar to the format used in the patient viewer. Ttenbergen 15:54, 2015 April 29 (CDT)
 ** added check that there '''can't be more than one''' entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)
-** Added new HSC MICU locations as per [[HSC ICU locations and serial number sharing 2015-05-01]] and inactivated old ones. Ttenbergen 16:58, 2015 April 29 (CDT)
+** Added new HSC MICU locations as per [[HSC ICU workload splitting]] and inactivated old ones. Ttenbergen 16:58, 2015 April 29 (CDT)
 * likely invisible
 ** renamed query ''L_Labs_Flowsheet_sum'' to [[Query L Labs total]] for consistency. Ttenbergen 14:15, 2015 April 16 (CDT)
-** added query ''s_tmp_comfort_care_gt_one'' for cross check for more than one entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)
+** added query ''s_tmp_comfort_care_gt_one'' for [[cross check]] for more than one entry for [[Comfort Care]] per pt. Ttenbergen 16:21, 2015 April 29 (CDT)
 ** as discussed with Julie, changed module sending function Send_Data to no longer send to [[Tasks 1.mdb]],[[Imaging.mdb]],[[Pharmacy.mdb]] and [[TmpV2 1.mdb]]
 ** as discussed with Trish, changed module sending function Send_Data to no longer send TMS output .csvs
@@ Line 138: / Line 212: @@
 * deleted old send queries that are no longer used:  send_imaging, send_tasks, send_tasks_master, send_tmp, send_tmp_audit Ttenbergen 10:48, 2015 April 30 (CDT)
 * deleted old query 20130311_pharm_converter that was used only once when we changed the system Ttenbergen 10:48, 2015 April 30 (CDT)
-* imported ccmdb.mdb into a new clean file; TMSX stuff had been the hold-up. Ttenbergen 11:15, 2015 April 30 (CDT)
+* imported [[CCMDB.accdb]] into a new clean file; TMSX stuff had been the hold-up. Ttenbergen 11:15, 2015 April 30 (CDT)
 * changed MainForm open code to not eliminate 2003 excel reference code Ttenbergen 11:15, 2015 April 30 (CDT)
@@ Line 165: / Line 239: @@
 *** eliminated options no longer used from drop-down
 *** made label into link to wiki
-*** added the field to the hider function so it is shown only for CC as wiki says only used for CC
+*** added the field to the  [[Sub Check_Forms.Legacy_Hider()]] so it is shown only for CC as wiki says only used for CC
 * removed some erratic code from module tmp_checker that was trying to set form components when it is not run from that form
 * [[ARF]]
@@ Line 176: / Line 250: @@
 * implement [[Serial_number#STB_5B:_Serial_number_share_plan]]
 ** added location STB_5B_X to table ''[[S Locations]]'' and to table ''s_locations_allowed_collection''
-* added code to cause error if the [[Notes field]] has too much content (http://answers.microsoft.com/en-us/office/forum/office_2007-access/memo-field-could-not-update-currently-locked-by/d5c8163a-7ce5-484f-80d4-98c1a8c92160)Ttenbergen 14:30, 2015 January 19 (CST)
+* added code to cause error if the [[Notes field]] has too much content (
+https://answers.microsoft.com/en-us/msoffice/forum/all/memo-field-could-not-update-currently-locked-by/d5c8163a-7ce5-484f-80d4-98c1a8c92160) Ttenbergen 14:30, 2015 January 19 (CST)
 ===2015-Jan-5===
@@ Line 186: / Line 261: @@
 * [[S_AdmitDischarge]]: added ZH-Hospice Care Center
-[[Category: CCMDB.mdb]]
+[[Category:CCMDB.accdb]]
-[[Category: Change Logs CCMDB]]
+[[Category:Change Logs CCMDB]]