CCMDB.mdb Change Log 2014: Difference between revisions

(34 intermediate revisions by 2 users not shown)

Line 6:

Enter '''[[requested CCMDB changes for the next version]]''' in that article.

~~[[File~~:~~Christmas icons 09~~.~~gif]]~~

== Versions ==

===2014-Dec-23===

re-rolled Ttenbergen 15:20, 2014 December 23 (CST)

* added CR4, A3, E3 and L&D to s_varoptions for STB

* changed patient viewer form layout

** added colour background for dates and from/to info

** re-arranged some fields for better grouping and background

* fixed integrity checks AdFrom_Var1_reconcile and Disto_Var2_reconcile for 7 Oaks, their abbreviation in from/to is non-std

* fixed query ''s_tmp_brr_dx_inconsistent'', was looking at dx 100.03 instead of 100.01

~~== Versions ==~~

===2014-Dec-17===

~~not~~ rolled ~~yet~~ Ttenbergen 17:37, 2014 December 17 (CST)

rolled Ttenbergen 19:32, 2014 December 17 (CST)

* [[BRR]]

** added cooling BRR/XBR to table ''s_tmp''

Line 19:

Line 26:

** in module tmp_checker, added BRR checking content to

** updated Function Validate_Var2() to not trigger old check Ttenbergen 18:09, 2014 December 17 (CST)

* fixed Function uncheck_tmp() which would not have unchecked tmp properly.

* ICU Var1/2

** changed table ''s_varOptions''

** updated function ''Legacy_hider'' so it shows Var 1 for ICU

** updated table ''s_VarNames'' to label properly

** changed dropdown sources in Form View to give ICU and Med both the Var 1 options for Var1 and Var2.

** changed functions ''AdFrom_Var1_reconcile'' and ''DisTo_Var2_reconcile'' to run for both ICU and Med Ttenbergen 18:57, 2014 December 17 (CST)

===2014-Dec-11===

Line 130:

Line 142:

* confirmed that sending while previously "sent" patients are still on the list should be possible; sent out email to find out what problems people appear to be having with this.

* collectors were getting error "You entered an expression that has no value" at end of sending; changed the naming of the log file to eliminate this, please let me know if this still shows up

* Critical Care - some locations were getting error about trach tasks and dxs being inconsistent. Changed query ''check_trach_dx_task'' to eliminate the error thatsome locations have been getting about inconsistent trach diagnoses and tasks because, of course, cc doesn't do tasks.

* Critical Care - some locations were getting error about trach tasks and dxs being inconsistent. Changed [[query check_trach_dx_task]] to eliminate the error thatsome locations have been getting about inconsistent trach diagnoses and tasks because, of course, cc doesn't do tasks.

* collectors were getting errors that transfer dates are required even for ward-to-ward transfers. I can't remember what the rules were for that and the wiki is down, so excluding patients discharged to ward from transfer date requirement for now; need to review what the story was when wiki is back up. (function Validate_TransDate())don't need to know

* changed buttons for tmp date "now" to only include date, not current time.

Line 141:

Line 153:

=== 2014-Oct-22 - 2 ===

rolled with old version number because it was a quick fix Ttenbergen 10:27, 2014 October 23 (CDT)

* fixed [[Check OR from but not Surgical Type]] Ttenbergen 10:27, 2014 October 23 (CDT)

* fixed query ''Check OR from but not Surgical Type'' Ttenbergen 10:27, 2014 October 23 (CDT)

=== 2014-Oct-22 ===

Line 152:

Line 164:

* changed province entry for Newfoundland in [[S Provinces]] from NF o NL; also changed sort order of dropdown to have MB at the top. Ttenbergen 11:48, 2014 October 22 (CDT)

* updated [[Minimal_Data_Set#CCDMB_Data_Integrity_Checks]]. Ttenbergen 12:46, 2014 October 22 (CDT)

* new consistency check [[Check OR from but not Surgical Type]] Ttenbergen 15:50, 2014 October 22 (CDT)

* new consistency check ''Check OR from but not Surgical Type'' Ttenbergen 15:50, 2014 October 22 (CDT)

Changes Collectors don't need to know about

Line 179:

Line 191:

** moved the close button on the view form to the left so it's visible on old laptops running Access 2010 Ttenbergen 16:29, 2014 September 4 (CDT)

** updated main dx name for dx codes 831** to "Other Head/Neck-OR Procedures" from just "Other procedures"

** updated main dx name for dx codes 199** to "[[cardiovascular ~~other~~ problems]]" from just "Other problems"

** updated main dx name for dx codes 199** to "[[Other cardiovascular problems]]" from just "Other problems"

** updated [[Debridement - Cardiovascular]] from old wording "Wound Debridement" Ttenbergen 16:29, 2014 September 11 (CDT)

* changes that should be invisible

Line 188:

Line 200:

rolled out Ttenbergen 11:42, 2014 September 3 (CDT)

* changed spelling of dx code [[Art/Ven Embolus/Thrombus]] 13209 to inNominate Ttenbergen 09:31, 2014 August 25 (CDT)

* changed wording for [[~~50507~~ - CVA-Cerebral Venous Thrombosis]] from Superior Sagital Sinus (should have been sagittal but that was the spelling...) Ttenbergen 09:51, 2014 August 25 (CDT)

* changed wording for [[CVA-Cerebral Vascular Accident | CVA-Cerebral Vascular Accident - '''CVA-Cerebral Venous Thrombosis''']] from Superior Sagital Sinus (should have been sagittal but that was the spelling...) Ttenbergen 09:51, 2014 August 25 (CDT)

* updated labs_flowsheet form so it will hopefully work when using font magnification... ('''Trish or Joyce to test''') Ttenbergen 12:47, 2014 August 26 (CDT)

* fixed spelling for "sending complete" Ttenbergen 12:59, 2014 August 26 (CDT)

* added code to the patient list open button to change focus away from the ~~Patient~~ ID to prevent accidental edits. Ttenbergen 13:04, 2014 August 26 (CDT)

* added code to the patient list open button to change focus away from the [[Pat ID]] to prevent accidental edits. Ttenbergen 13:04, 2014 August 26 (CDT)

* [[L_Log not updated for location, sex and type]]: updated query ''send_Centralized_1L_Log_update'' which was not updating the following fields:

** actually used and relevant in long-term data

*** ~~R_Location~~

*** [[R_location]]

*** ~~R_Sex~~

*** [[R_sex]]

*** ~~R_Type~~

*** [[R_type]]

**** emailed main office about these Ttenbergen 11:22, 2014 September 3 (CDT)

** protocol-only fields not relevant for long-term data

Line 292:

Line 304:

** 46300 [[Sedatives/Antidepressants]] Ttenbergen 14:19, 2014 July 7 (CDT)

** 25001 [[Lupus Pneumonitis]] Ttenbergen 14:19, 2014 July 7 (CDT)

** 8200 [[Necrotizing soft tissue infections]] to [[Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, ~~Gas OR~~ clostridial gangrene etc.)]]

** 8200 "Necrotizing soft tissue infections" to "Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, Gas OR clostridial gangrene etc.)" for [[Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, gas or clostridial gangrene etc.)]]

=== 2014-Jul-03 ===

Line 315:

Line 327:

* changed [[s_Locations]] to make STB_A5 and STB_B4 inactive - Ttenbergen 10:08, 2014 June 25 (CDT)

* deleted old dev query ''s_charlson_comorbid_wiki_list_generator'' Ttenbergen 10:30, 2014 June 25 (CDT)

* messed around with [[~~S charlson dxs~~]] and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT)

* messed around with [[s_charlson_dxs table]] and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT)

* '''to fix sending''' - re-enabled function overlap from last update, is used during sending after all... Ttenbergen 10:22, 2014 June 26 (CDT)

Line 323:

Line 335:

** reverted that change until Trish has had a change to stage the change over. Ttenbergen 17:31, 2014 June 12 (CDT)

* integrated change from v [[#2014-Jun-11]]. Ttenbergen 16:40, 2014 June 12 (CDT)

* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[~~s_alldiagnoses~~]] Ttenbergen 15:42, 2014 June 19 (CDT)

* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[s_AllDiagnoses table]] Ttenbergen 15:42, 2014 June 19 (CDT)

* changed Apache admit type to not allow anything other than dropdown values and blank, blank will not allow checking apache complete. Ttenbergen 12:41, 2014 June 23 (CDT)

* fixes to s_alldiagnoses legacy entries: disallow collection for 3097, 84602, 79497, 39997, 83197, 80697, 59997, 77797, 84897, 21997, should have been like that already but was missed during imports and updates somehow Ttenbergen 12:48, 2014 June 23 (CDT)

* imported newest version of module ''Apache_Scoring'' from [[Centralized data front end.~~mdb~~]] Ttenbergen 13:18, 2014 June 23 (CDT)

* imported newest version of module ''Apache_Scoring'' from [[Centralized data front end.accdb]] Ttenbergen 13:18, 2014 June 23 (CDT)

** made some tweaks to integrate it Ttenbergen 14:00, 2014 June 23 (CDT)

** renamed Apache scoring callers in module check_forms so they are never same as in ApacheScoring Ttenbergen 13:21, 2014 June 23 (CDT)

* commented out function ''overlap'', not being called from anywhere and makes no sense Ttenbergen 13:24, 2014 June 23 (CDT)

* eliminated Pentaspan and Voluven from Labs collection screen on laptops Ttenbergen 14:20, 2014 June 23 (CDT)

* eliminated [[Pentaspan]] and [[Voluven]] from Labs collection screen on laptops Ttenbergen 14:20, 2014 June 23 (CDT)

===2014-Jun-11===

Line 336:

Line 348:

*Laptop B3 to allow location HSC_H4H.

*I rolled it out.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:07, 2014 June 11 (CDT)

**Tina will have to integrate this minor change with the copy of ~~ccmdb~~.~~mdb~~ program she may have on her laptop.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)

**Tina will have to integrate this minor change with the copy of [[CCMDB.accdb]] program she may have on her laptop.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)

*** Done for version [[#2014-Jun-12]] Ttenbergen 16:40, 2014 June 12 (CDT)

Line 364:

Line 376:

====other changes====

* imported the apache_scoring module as used in centralized front end, was changed there and they are supposed to be the same. No need to roll for this, change has no effect on function of ~~ccmdb~~.~~mdb~~ - Ttenbergen 10:20, 2014 May 5 (CDT)

* imported the apache_scoring module as used in centralized front end, was changed there and they are supposed to be the same. No need to roll for this, change has no effect on function of [[CCMDB.accdb]] - Ttenbergen 10:20, 2014 May 5 (CDT)

* made s_admitDischarge same as elsewhere, ie incl. setting FP and FR to "surgical" and making sure that the Grace and HSC Nursing home entry is present. Ttenbergen 15:55, 2014 May 8 (CDT)

* implementing limitation for locations dropdown to only those collected by this laptop

Line 419:

Line 431:

=== 2014-03-06 ===

rolled out Ttenbergen 14:48, 2014 March 6 (CST)

* reinstates comorbid [[Viral Hepatitis]] into [[~~S_alldiagnoses~~]]; had been deleted in January because the 00 subcode should not be used for dxs any more, but still needs to be there for comos. Ttenbergen 14:48, 2014 March 6 (CST)

* reinstates comorbid [[Viral Hepatitis]] into [[s_AllDiagnoses table]]; had been deleted in January because the 00 subcode should not be used for dxs any more, but still needs to be there for comos. Ttenbergen 14:48, 2014 March 6 (CST)

=== 2014-03-05 ===

Line 438:

Line 450:

** s_tmp_ER_Wait_has_tmp_not_from_ER

** s_tmp_ER_Wait_from_ER_no_ER_Wait

* removed table [[s_tmp_moverequired]] since it is not used any more. Ttenbergen 10:12, 2014 March 3 (CST)

* removed table s_tmp_moverequired since it is not used any more. Ttenbergen 10:12, 2014 March 3 (CST)

* updated query ~~'''~~s_tmp_project_item_consistent~~'''~~ (run by ~~pre~~-send ~~checker~~) to accommodate tmp entries without item/values, needed to accommodate new "No Transfer Date" entry Ttenbergen 15:11, 2014 March 3 (CST)

* updated [[query s_tmp_project_item_consistent]] (run by [[Pre-send Checker]]) to accommodate tmp entries without item/values, needed to accommodate new "No Transfer Date" entry Ttenbergen 15:11, 2014 March 3 (CST)

=== 2014-01-29 ===

Line 471:

Line 483:

* refactored function CCMDB_age to be able to use it with parameters (birth, admit). Ttenbergen 15:40, 2014 January 2 (CST)

* commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from table ~~s_GCS~~. Ttenbergen 16:08, 2014 January 2 (CST)

* commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from [[s_GCS table]]. Ttenbergen 16:08, 2014 January 2 (CST)

** updated Transition Coordinator function to draw Apache scoring from new location Ttenbergen 18:39, 2014 January 15 (CST)

* changed function Ap_Chronic to be able to take CH and AT as parameters rather than draw from form Ttenbergen 16:08, 2014 January 2 (CST)

Line 487:

Line 499:

** Function ApScore_WBC

** moved in Function Ap_Chronic

* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses]] Ttenbergen 10:19, 2014 January 6 (CST)

* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses table]] Ttenbergen 10:19, 2014 January 6 (CST)

* added yes/no column "choosable" to table s_AP_Chronic; added record "0HasChronic" as unchoosable record, updated form_view.ap_Chronic to draw from revised table. Ttenbergen 10:19, 2014 January 10 (CST)

* added column "surgical" to table s_AdmitDischarge. Ttenbergen 10:28, 2014 January 10 (CST)

* cleaned defunct HanDBase columns out of table s_AP_AdmitType. Ttenbergen 10:43, 2014 January 10 (CST)

* added ''NH Nursing Home HSC'' to [[s_AdmitDischarge]]

* added ''W4'' to [[s_varOptions]] var1/2 entries for Grace

* added ''W4'' to s_varOptions var1/2 entries for Grace

* integrated changes to closeNavPane() and MinimizeRibbons() that were made for Access 2010 but were breaking 2003 and were reverted. Tested on Con's laptop and on mine, work now. Ttenbergen 16:10, 2014 January 15 (CST)

[[Category: ~~IT Instructions]]~~

[[Category:CCMDB.accdb]]

~~[[Category: Development Documentation~~]]

[[Category: Change Logs CCMDB]]

@@ Line 6: / Line 6: @@
 Enter '''[[requested CCMDB changes for the next version]]''' in that article.
-[[File:Christmas icons 09.gif]]
+== Versions ==
+===2014-Dec-23===
+re-rolled Ttenbergen 15:20, 2014 December 23 (CST)
+* added CR4, A3, E3 and L&D to s_varoptions for STB
+* changed patient viewer form layout
+** added colour background for dates and from/to info
+** re-arranged some fields for better grouping and background
+* fixed integrity checks AdFrom_Var1_reconcile and Disto_Var2_reconcile for 7 Oaks, their abbreviation in from/to is non-std
+* fixed query ''s_tmp_brr_dx_inconsistent'', was looking at dx 100.03 instead of 100.01
-== Versions ==
 ===2014-Dec-17===
-not rolled yet Ttenbergen 17:37, 2014 December 17 (CST)
+rolled Ttenbergen 19:32, 2014 December 17 (CST)
 * [[BRR]]
 ** added cooling BRR/XBR to table ''s_tmp''
@@ Line 19: / Line 26: @@
 ** in module tmp_checker, added BRR checking content to
 ** updated Function Validate_Var2() to not trigger old check Ttenbergen 18:09, 2014 December 17 (CST)
 * fixed Function uncheck_tmp() which would not have unchecked tmp properly.
+* ICU Var1/2
+** changed table ''s_varOptions''
+** updated function ''Legacy_hider'' so it shows Var 1 for ICU
+** updated table ''s_VarNames'' to label properly
+** changed dropdown sources in Form View to give ICU and Med both the Var 1 options for Var1 and Var2.
+** changed functions ''AdFrom_Var1_reconcile'' and ''DisTo_Var2_reconcile'' to run for both ICU and Med Ttenbergen 18:57, 2014 December 17 (CST)
 ===2014-Dec-11===
@@ Line 130: / Line 142: @@
 * confirmed that sending while previously "sent" patients are still on the list should be possible; sent out email to find out what problems people appear to be having with this.
 * collectors were getting error "You entered an expression that has no value" at end of sending; changed the naming of the log file to eliminate this, please let me know if this still shows up
-* Critical Care - some locations were getting error about trach tasks and dxs being inconsistent. Changed query ''check_trach_dx_task'' to eliminate the error thatsome locations have been getting about inconsistent trach diagnoses and tasks because, of course, cc doesn't do tasks.
+* Critical Care - some locations were getting error about trach tasks and dxs being inconsistent. Changed [[query check_trach_dx_task]] to eliminate the error thatsome locations have been getting about inconsistent trach diagnoses and tasks because, of course, cc doesn't do tasks.
 * collectors were getting errors that transfer dates are required even for ward-to-ward transfers. I can't remember what the rules were for that and the wiki is down, so excluding patients discharged to ward from transfer date requirement for now; need to review what the story was when wiki is back up. (function Validate_TransDate())don't need to know
 * changed buttons for tmp date "now" to only include date, not current time.
@@ Line 141: / Line 153: @@
 === 2014-Oct-22 - 2 ===
 rolled with old version number because it was a quick fix Ttenbergen 10:27, 2014 October 23 (CDT)
-* fixed [[Check OR from but not Surgical Type]] Ttenbergen 10:27, 2014 October 23 (CDT)
+* fixed query ''Check OR from but not Surgical Type'' Ttenbergen 10:27, 2014 October 23 (CDT)
 === 2014-Oct-22 ===
@@ Line 152: / Line 164: @@
 * changed province entry for Newfoundland in [[S Provinces]] from NF o NL; also changed sort order of dropdown to have MB at the top. Ttenbergen 11:48, 2014 October 22 (CDT)
 * updated [[Minimal_Data_Set#CCDMB_Data_Integrity_Checks]]. Ttenbergen 12:46, 2014 October 22 (CDT)
-* new consistency check [[Check OR from but not Surgical Type]] Ttenbergen 15:50, 2014 October 22 (CDT)
+* new consistency check ''Check OR from but not Surgical Type'' Ttenbergen 15:50, 2014 October 22 (CDT)
 Changes Collectors don't need to know about
@@ Line 179: / Line 191: @@
 ** moved the close button on the view form to the left so it's visible on old laptops running Access 2010 Ttenbergen 16:29, 2014 September 4 (CDT)
 ** updated main dx name for dx codes 831** to "Other Head/Neck-OR Procedures" from just "Other procedures"
-** updated main dx name for dx codes 199** to "[[cardiovascular other problems]]" from just "Other problems"
+** updated main dx name for dx codes 199** to "[[Other cardiovascular problems]]" from just "Other problems"
 ** updated [[Debridement - Cardiovascular]] from old wording "Wound Debridement" Ttenbergen 16:29, 2014 September 11 (CDT)
 * changes that should be invisible
@@ Line 188: / Line 200: @@
 rolled out Ttenbergen 11:42, 2014 September 3 (CDT)
 * changed spelling of dx code [[Art/Ven Embolus/Thrombus]] 13209 to inNominate Ttenbergen 09:31, 2014 August 25 (CDT)
-* changed wording for [[50507 - CVA-Cerebral Venous Thrombosis]] from Superior Sagital Sinus (should have been sagittal but that was the spelling...) Ttenbergen 09:51, 2014 August 25 (CDT)
+* changed wording for [[CVA-Cerebral Vascular Accident | CVA-Cerebral Vascular Accident - '''CVA-Cerebral Venous Thrombosis''']] from Superior Sagital Sinus (should have been sagittal but that was the spelling...) Ttenbergen 09:51, 2014 August 25 (CDT)
 * updated labs_flowsheet form so it will hopefully work when using font magnification... ('''Trish or Joyce to test''') Ttenbergen 12:47, 2014 August 26 (CDT)
 * fixed spelling for "sending complete" Ttenbergen 12:59, 2014 August 26 (CDT)
-* added code to the patient list open button to change focus away from the Patient ID to prevent accidental edits. Ttenbergen 13:04, 2014 August 26 (CDT)
+* added code to the patient list open button to change focus away from the [[Pat ID]] to prevent accidental edits. Ttenbergen 13:04, 2014 August 26 (CDT)
 * [[L_Log not updated for location, sex and type]]: updated query ''send_Centralized_1L_Log_update'' which was not updating the following fields:
 ** actually used and relevant in long-term data
-*** R_Location
+*** [[R_location]]
-*** R_Sex
+*** [[R_sex]]
-*** R_Type
+*** [[R_type]]
 **** emailed main office about these Ttenbergen 11:22, 2014 September 3 (CDT)
 ** protocol-only fields not relevant for long-term data
@@ Line 292: / Line 304: @@
 ** 46300 [[Sedatives/Antidepressants]] Ttenbergen 14:19, 2014 July 7 (CDT)
 ** 25001 [[Lupus Pneumonitis]] Ttenbergen 14:19, 2014 July 7 (CDT)
-** 8200 [[Necrotizing soft tissue infections]] to [[Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, Gas OR clostridial gangrene etc.)]]
+** 8200 "Necrotizing soft tissue infections" to "Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, Gas OR clostridial gangrene etc.)" for [[Necrotizing soft tissue infections (necrotizing fasciitis, myonecrosis, gas or clostridial gangrene etc.)]]
 === 2014-Jul-03 ===
@@ Line 315: / Line 327: @@
 * changed [[s_Locations]] to make STB_A5 and STB_B4 inactive - Ttenbergen 10:08, 2014 June 25 (CDT)
 * deleted old dev query ''s_charlson_comorbid_wiki_list_generator'' Ttenbergen 10:30, 2014 June 25 (CDT)
-* messed around with [[S charlson dxs]] and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT)
+* messed around with [[s_charlson_dxs table]] and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT)
 * '''to fix sending''' - re-enabled function overlap from last update, is used during sending after all... Ttenbergen 10:22, 2014 June 26 (CDT)
@@ Line 323: / Line 335: @@
 ** reverted that change until Trish has had a change to stage the change over. Ttenbergen 17:31, 2014 June 12 (CDT)
 * integrated change from v [[#2014-Jun-11]]. Ttenbergen 16:40, 2014 June 12 (CDT)
-* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[s_alldiagnoses]] Ttenbergen 15:42, 2014 June 19 (CDT)
+* updated [[Wegener's Granulomatosis / Granulomatosis with polyangiitis]] in [[s_AllDiagnoses table]] Ttenbergen 15:42, 2014 June 19 (CDT)
 * changed Apache admit type to not allow anything other than dropdown values and blank, blank will not allow checking apache complete. Ttenbergen 12:41, 2014 June 23 (CDT)
 * fixes to s_alldiagnoses legacy entries: disallow collection for 3097, 84602, 79497, 39997, 83197, 80697, 59997, 77797, 84897, 21997, should have been like that already but was missed during imports and updates somehow Ttenbergen 12:48, 2014 June 23 (CDT)
-* imported newest version of module ''Apache_Scoring'' from [[Centralized data front end.mdb]] Ttenbergen 13:18, 2014 June 23 (CDT)
+* imported newest version of module ''Apache_Scoring'' from [[Centralized data front end.accdb]] Ttenbergen 13:18, 2014 June 23 (CDT)
 ** made some tweaks to integrate it Ttenbergen 14:00, 2014 June 23 (CDT)
 ** renamed Apache scoring callers in module check_forms so they are never same as in ApacheScoring Ttenbergen 13:21, 2014 June 23 (CDT)
 * commented out function ''overlap'', not being called from anywhere and makes no sense Ttenbergen 13:24, 2014 June 23 (CDT)
-* eliminated Pentaspan and Voluven from Labs collection screen on laptops Ttenbergen 14:20, 2014 June 23 (CDT)
+* eliminated [[Pentaspan]] and [[Voluven]] from Labs collection screen on laptops Ttenbergen 14:20, 2014 June 23 (CDT)
 ===2014-Jun-11===
@@ Line 336: / Line 348: @@
 *Laptop B3 to allow location HSC_H4H.
 *I rolled it out.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:07, 2014 June 11 (CDT)
-**Tina will have to integrate this minor change with the copy of ccmdb.mdb program she may have on her laptop.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)
+**Tina will have to integrate this minor change with the copy of [[CCMDB.accdb]] program she may have on her laptop.[[User:TOstryzniuk|Trish Ostryzniuk]] 12:08, 2014 June 11 (CDT)
 *** Done for version [[#2014-Jun-12]] Ttenbergen 16:40, 2014 June 12 (CDT)
@@ Line 364: / Line 376: @@
 ====other changes====
-* imported the apache_scoring module as used in centralized front end, was changed there and they are supposed to be the same. No need to roll for this, change has no effect on function of ccmdb.mdb - Ttenbergen 10:20, 2014 May 5 (CDT)
+* imported the apache_scoring module as used in centralized front end, was changed there and they are supposed to be the same. No need to roll for this, change has no effect on function of [[CCMDB.accdb]] - Ttenbergen 10:20, 2014 May 5 (CDT)
 * made s_admitDischarge same as elsewhere, ie incl. setting FP and FR to "surgical" and making sure that the Grace and HSC Nursing home entry is present. Ttenbergen 15:55, 2014 May 8 (CDT)
 * implementing limitation for locations dropdown to only those collected by this laptop
@@ Line 419: / Line 431: @@
 === 2014-03-06 ===
 rolled out Ttenbergen 14:48, 2014 March 6 (CST)
-* reinstates comorbid [[Viral Hepatitis]] into [[S_alldiagnoses]]; had been deleted in January because the 00 subcode should not be used for dxs any more, but still needs to be there for comos. Ttenbergen 14:48, 2014 March 6 (CST)
+* reinstates comorbid [[Viral Hepatitis]] into [[s_AllDiagnoses table]]; had been deleted in January because the 00 subcode should not be used for dxs any more, but still needs to be there for comos. Ttenbergen 14:48, 2014 March 6 (CST)
 === 2014-03-05 ===
@@ Line 438: / Line 450: @@
 ** s_tmp_ER_Wait_has_tmp_not_from_ER
 ** s_tmp_ER_Wait_from_ER_no_ER_Wait
-* removed table [[s_tmp_moverequired]] since it is not used any more. Ttenbergen 10:12, 2014 March 3 (CST)
+* removed table s_tmp_moverequired since it is not used any more. Ttenbergen 10:12, 2014 March 3 (CST)
-* updated query '''s_tmp_project_item_consistent''' (run by pre-send checker) to accommodate tmp entries without item/values, needed to accommodate new "No Transfer Date" entry Ttenbergen 15:11, 2014 March 3 (CST)
+* updated [[query s_tmp_project_item_consistent]] (run by [[Pre-send Checker]]) to accommodate tmp entries without item/values, needed to accommodate new "No Transfer Date" entry Ttenbergen 15:11, 2014 March 3 (CST)
 === 2014-01-29 ===
@@ Line 471: / Line 483: @@
 * refactored function CCMDB_age to be able to use it with parameters (birth, admit). Ttenbergen 15:40, 2014 January 2 (CST)
-* commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from table s_GCS. Ttenbergen 16:08, 2014 January 2 (CST)
+* commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from [[s_GCS table]]. Ttenbergen 16:08, 2014 January 2 (CST)
 ** updated Transition Coordinator function to draw Apache scoring from new location Ttenbergen 18:39, 2014 January 15 (CST)
 * changed function Ap_Chronic to be able to take CH and AT as parameters rather than draw from form Ttenbergen 16:08, 2014 January 2 (CST)
@@ Line 487: / Line 499: @@
 ** Function ApScore_WBC
 ** moved in Function Ap_Chronic
-* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses]] Ttenbergen 10:19, 2014 January 6 (CST)
+* fixed spelling for [[Polycythemia Rubra Vera]] in [[s_AllDiagnoses table]] Ttenbergen 10:19, 2014 January 6 (CST)
 * added yes/no column "choosable" to table s_AP_Chronic; added record "0HasChronic" as unchoosable record, updated form_view.ap_Chronic to draw from revised table. Ttenbergen 10:19, 2014 January 10 (CST)
 * added column "surgical" to table s_AdmitDischarge. Ttenbergen 10:28, 2014 January 10 (CST)
 * cleaned defunct HanDBase columns out of table s_AP_AdmitType. Ttenbergen 10:43, 2014 January 10 (CST)
 * added ''NH Nursing Home HSC'' to [[s_AdmitDischarge]]
-* added ''W4'' to [[s_varOptions]] var1/2 entries for Grace
+* added ''W4'' to s_varOptions var1/2 entries for Grace
 * integrated changes to closeNavPane() and MinimizeRibbons() that were made for Access 2010 but were breaking 2003 and were reverted. Tested on Con's laptop and on mine, work now. Ttenbergen 16:10, 2014 January 15 (CST)
-[[Category: IT Instructions]]
+[[Category:CCMDB.accdb]]
-[[Category: Development Documentation]]
 [[Category: Change Logs CCMDB]]