CCMDB.mdb Change Log 2013: Difference between revisions
Ttenbergen (talk | contribs) m removed discussion tag |
Ttenbergen (talk | contribs) m Text replacement - "S Tmp" to "s_tmp table" |
||
| (10 intermediate revisions by the same user not shown) | |||
| Line 14: | Line 14: | ||
* ensured all objects are set to nothing after use, had forgot the step recently. Ttenbergen 15:22, 2013 December 13 (CST) | * ensured all objects are set to nothing after use, had forgot the step recently. Ttenbergen 15:22, 2013 December 13 (CST) | ||
* changed some code intended only for Office 2010 to use conditional compilation so it does not break in 2003 Ttenbergen 15:22, 2013 December 13 (CST) | * changed some code intended only for Office 2010 to use conditional compilation so it does not break in 2003 Ttenbergen 15:22, 2013 December 13 (CST) | ||
* [[s_ADLOptions]] - added columns for scoring Ttenbergen 14:12, 2013 December 23 (CST) | * [[s_ADLOptions table]] - added columns for scoring Ttenbergen 14:12, 2013 December 23 (CST) | ||
* [[s_GCS]] - table added that contains the dropdown options used in L_Log.AP_(eye, motor,verbal) to be used to convert point scores for centralized. Changed dropdowns to use this directly rather than hard-coded values in L_Log. Ttenbergen 11:34, 2013 December 30 (CST) | * [[s_GCS table]] - table added that contains the dropdown options used in L_Log.AP_(eye, motor,verbal) to be used to convert point scores for centralized. Changed dropdowns to use this directly rather than hard-coded values in L_Log. Ttenbergen 11:34, 2013 December 30 (CST) | ||
=== 2013-11-25 === | === 2013-11-25 === | ||
| Line 41: | Line 41: | ||
* re-added dxs to table s_AllDiagnoses to be able to import legacy codes. Set "collection_allowed" to false for these: Ttenbergen 16:34, 2013 November 18 (CST) | * re-added dxs to table s_AllDiagnoses to be able to import legacy codes. Set "collection_allowed" to false for these: Ttenbergen 16:34, 2013 November 18 (CST) | ||
** 90600 paneling | ** 90600 paneling | ||
** | ** 16000 - Soft tissue infections (old code) | ||
* changed query send_pharmacy to fix sending of checkbox-pharmacy-entries Ttenbergen 13:26, 2013 November 21 (CST) | * changed query send_pharmacy to fix sending of checkbox-pharmacy-entries Ttenbergen 13:26, 2013 November 21 (CST) | ||
| Line 48: | Line 48: | ||
* changed s_admitDischarge table entry "Outside Province-Uknown unit" to "... Unknown ..." Ttenbergen 15:53, 2013 November 7 (CST) | * changed s_admitDischarge table entry "Outside Province-Uknown unit" to "... Unknown ..." Ttenbergen 15:53, 2013 November 7 (CST) | ||
* added [[ | * added [[s_tmp table]] entry for project '''[[Comfort_Care]]''' Ttenbergen 11:27, 2013 November 11 (CST) | ||
* changed dx dropdown in patient viewer to not have a trailing "-" if there is not subdx (eg tasks or similar) Ttenbergen 11:27, 2013 November 11 (CST) | * changed dx dropdown in patient viewer to not have a trailing "-" if there is not subdx (eg tasks or similar) Ttenbergen 11:27, 2013 November 11 (CST) | ||
* changed [[ | * changed [[s_AllDiagnoses table]] entry ''Palliative Care'' to [[Palliative Service]] Ttenbergen 11:30, 2013 November 11 (CST) | ||
* fixed Send_Centralized_1L_Log_append to make it send [[SendDtTm]] properly. Ttenbergen 12:05, 2013 November 11 (CST) | * fixed Send_Centralized_1L_Log_append to make it send [[SendDtTm]] properly. Ttenbergen 12:05, 2013 November 11 (CST) | ||
| Line 86: | Line 86: | ||
** populated both columns 16:24, 2013 October 17 (CDT) | ** populated both columns 16:24, 2013 October 17 (CDT) | ||
* updated query s_locations_local (which drives the location dropdown) to show only this program and active Ttenbergen 16:32, 2013 October 17 (CDT) | * updated query s_locations_local (which drives the location dropdown) to show only this program and active Ttenbergen 16:32, 2013 October 17 (CDT) | ||
* added code to delete two rows from | * added code to delete two rows from [[A_Info table]] that are no longer used: RegSrv and data_path Ttenbergen 18:52, 2013 October 17 (CDT) | ||
* updated startup code to work properly even if [[A_Info]] is not available Ttenbergen 19:12, 2013 October 17 (CDT) | * updated startup code to work properly even if [[A_Info table]] is not available Ttenbergen 19:12, 2013 October 17 (CDT) | ||
* previously, if no transfer time was entered on a long-stay patient, the checkbox would become unchecked, but no error would be given; re-instated output for Validate_TransTime() which was disabled Ttenbergen 19:43, 2013 October 17 (CDT) | * previously, if no transfer time was entered on a long-stay patient, the checkbox would become unchecked, but no error would be given; re-instated output for Validate_TransTime() which was disabled Ttenbergen 19:43, 2013 October 17 (CDT) | ||
| Line 122: | Line 122: | ||
'''Changes Collectors Need to Know''' | '''Changes Collectors Need to Know''' | ||
*Added HB to [[S AdmitDischarge]] table. This is for discharges TO [[Lennox Bell | *Added HB to [[S AdmitDischarge]] table. This is for discharges TO [[HSC Lennox Bell]] from HSC medicine wards. [[User:Bcloutier|Bcloutier]] 13:49, 2013 September 11 (CDT) | ||
'''Changes Collectors Do Not Need to Know''' | '''Changes Collectors Do Not Need to Know''' | ||
| Line 249: | Line 249: | ||
rolled out Ttenbergen 13:03, 2013 June 3 (EDT) | rolled out Ttenbergen 13:03, 2013 June 3 (EDT) | ||
* changes in previous versions combined to break query Pharm_Flowsheet_Sum and sub PharmCheck(); fixedTtenbergen 11:12, 2013 June 3 (EDT) | * changes in previous versions combined to break query Pharm_Flowsheet_Sum and sub PharmCheck(); fixedTtenbergen 11:12, 2013 June 3 (EDT) | ||
* replaced all mentions in VBA of | * replaced all mentions in VBA of ltc.umanitoba.ca/wikis with http://ccmdb.kuality.ca Ttenbergen 12:20, 2013 June 3 (EDT) | ||
* added | * added 9200 - Tracheobronchitis | ||
* eliminated | * eliminated 3005 - Bronchitis | ||
* implemented [[Eliminating a diagnosis from collection]] | * implemented [[Eliminating a diagnosis from collection]] | ||
** added "collection_allowed" column to s_alldiagnoses, set true for all except Bronchitis-3005Ttenbergen 11:39, 2013 June 3 (EDT) | ** added "collection_allowed" column to s_alldiagnoses, set true for all except Bronchitis-3005Ttenbergen 11:39, 2013 June 3 (EDT) | ||
** changed dropdown to not list if not "collection_allowed" Ttenbergen 11:39, 2013 June 3 (EDT) | ** changed dropdown to not list if not "collection_allowed" Ttenbergen 11:39, 2013 June 3 (EDT) | ||
** change checks to fail if not "collection_allowed" Ttenbergen 12:50, 2013 June 3 (EDT) | ** change checks to fail if not "collection_allowed" Ttenbergen 12:50, 2013 June 3 (EDT) | ||
** added | ** added [[Function TmpChecker]] to reject if not "collection_allowed" Ttenbergen 12:50, 2013 June 3 (EDT) | ||
=== ver 2013-05-24 === | === ver 2013-05-24 === | ||
| Line 443: | Line 443: | ||
[[Category: CCMDB. | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category: Change Logs CCMDB]] | ||