CCMDB.mdb Change Log 2013: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (22 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
== Versions == | == Versions == | ||
==Changes == | ==Changes == | ||
=== 2013-12-13 === | |||
not rolled out yet Ttenbergen 15:22, 2013 December 13 (CST) | |||
no need to know: | |||
* 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) | |||
* [[s_ADLOptions table]] - added columns for scoring Ttenbergen 14:12, 2013 December 23 (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 === | ||
rolled out earlier today. Ttenbergen 13:54, 2013 December 13 (CST) | |||
==== changes collectors need to know ==== | ==== changes collectors need to know ==== | ||
* one more fix to have input mask same as format, still was not that before Ttenbergen 14:55, 2013 November 28 (CST) | * one more fix to have input mask same as format, still was not that before Ttenbergen 14:55, 2013 November 28 (CST) | ||
| Line 15: | Line 25: | ||
** updated pharm and labs to use same font and size as rest Ttenbergen 14:44, 2013 November 28 (CST) | ** updated pharm and labs to use same font and size as rest Ttenbergen 14:44, 2013 November 28 (CST) | ||
* updated DOB field to call the upater for Apache age when changed Ttenbergen 14:50, 2013 November 28 (CST) | * updated DOB field to call the upater for Apache age when changed Ttenbergen 14:50, 2013 November 28 (CST) | ||
* removed input mask for the date in L_Tmp Ttenbergen 12:42, 2013 December 13 (CST) | |||
==== changes collectors don't need to know ==== | ==== changes collectors don't need to know ==== | ||
| Line 30: | 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 37: | 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) | ||
=== ver 2013-11-04 === | === ver 2013-11-04 === | ||
| Line 66: | Line 77: | ||
* fixed tab order (how the tab key moves between fields) in Apache screen. Before it would not tab from creatinine to ARF, now it does. Ttenbergen 20:00, 2013 October 17 (CDT) | * fixed tab order (how the tab key moves between fields) in Apache screen. Before it would not tab from creatinine to ARF, now it does. Ttenbergen 20:00, 2013 October 17 (CDT) | ||
* Decreased page margins for send report. HSC requested I do it in the Master as they had had to re-set it after each update to save paper. | * Decreased page margins for send report. HSC requested I do it in the Master as they had had to re-set it after each update to save paper. | ||
** let me know if there are problems with the new setup. Ttenbergen 11:39, 2013 October 18 (CDT) | ** let me know if there are problems with the new setup. Ttenbergen 11:39, 2013 October 18 (CDT) | ||
* name checking function realchars() was set to allow numbers; disallowed numbers, so will no longer be able to complete records with numbers in names. Ttenbergen 11:47, 2013 October 18 (CDT) | * name checking function realchars() was set to allow numbers; disallowed numbers, so will no longer be able to complete records with numbers in names. Ttenbergen 11:47, 2013 October 18 (CDT) | ||
| Line 75: | 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 111: | 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 188: | Line 199: | ||
rolled out Ttenbergen 10:38, 2013 July 31 (CDT) | rolled out Ttenbergen 10:38, 2013 July 31 (CDT) | ||
* fixed bug that stopped sending | * fixed bug that stopped sending | ||
** changed query send_check_centralized_is_owner, it was only checking Patient_ID rather than Patient_ID & Location Ttenbergen 10:15, 2013 July 31 (CDT) | ** changed query send_check_centralized_is_owner, it was only checking [[Patient_ID]] rather than Patient_ID & Location Ttenbergen 10:15, 2013 July 31 (CDT) | ||
* changed sub CloseOutputDBs and added sub CloseTable to close new tables opened in last version. Ttenbergen 10:34, 2013 July 31 (CDT) | * changed sub CloseOutputDBs and added sub CloseTable to close new tables opened in last version. Ttenbergen 10:34, 2013 July 31 (CDT) | ||
| Line 238: | 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 428: | Line 439: | ||
* implemented [[Project ABO TEE]] - Ttenbergen 17:33, 2013 January 25 (EST) | * implemented [[Project ABO TEE]] - Ttenbergen 17:33, 2013 January 25 (EST) | ||
* changed uncontrolled HTN to [[Uncontrolled Hypertension]] - Ttenbergen 17:33, 2013 January 25 (EST) | * changed uncontrolled HTN to [[Uncontrolled Hypertension]] - Ttenbergen 17:33, 2013 January 25 (EST) | ||
* changed [[Tracheostomy | * changed [[Tracheostomy]] - site infection to list as an ''infection'' - Ttenbergen 17:51, 2013 January 25 (EST) | ||
* added [[Overstay]] entry capability for the Vic Ttenbergen 10:40, 2013 January 28 (EST) | * added [[Overstay]] entry capability for the Vic Ttenbergen 10:40, 2013 January 28 (EST) | ||
[[Category: | [[Category:CCMDB.accdb]] | ||
[[Category:Change Logs CCMDB]] | |||
[[Category: Change Logs CCMDB]] | |||