CCMDB.mdb Change Log 2013: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "S Tmp" to "s_tmp table" |
||
| (65 intermediate revisions by 4 users not shown) | |||
| Line 7: | Line 7: | ||
== Versions == | == Versions == | ||
==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 === | |||
rolled out earlier today. Ttenbergen 13:54, 2013 December 13 (CST) | |||
==== 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) | |||
* updated tmp, pharm, labs to use same date formatTtenbergen 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) | |||
* removed input mask for the date in L_Tmp Ttenbergen 12:42, 2013 December 13 (CST) | |||
==== changes collectors don't need to know ==== | |||
* made legacy code for paneling (and all legacy codes) invisible in the dropdown for dx_chooser. Ttenbergen 14:33, 2013 November 25 (CST) | |||
* added public subs closeNavPane() and MinimizeRibbons() to clean up interface for Access 2010. No collectors are using Access 2010 at this time so the change does not need to be known to them, but main office might want to know. Ttenbergen 18:03, 2013 December 12 (CST) | |||
===2013-11-18=== | |||
rolled out - Ttenbergen 14:15, 2013 November 21 (CST) | |||
* Removed "OVER" locations for Vic and Grace. Re-added Vic EMIP. Grace already had EMIP available. Ttenbergen 14:01, 2013 November 21 (CST) | |||
* dates in registry and DOB: made input mask consistent with format, and dates consistent with each other. Made it so that month needs to be letters. Ttenbergen 13:26, 2013 November 21 (CST) | |||
** input mask is 00/LLL/0000;;_ | |||
** format is yyyy/mmm/dd | |||
====Changes collectors don't need to know ==== | |||
* 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 | |||
** 16000 - Soft tissue infections (old code) | |||
* changed query send_pharmacy to fix sending of checkbox-pharmacy-entries Ttenbergen 13:26, 2013 November 21 (CST) | |||
=== ver 2013-11-07 === | |||
Rolled out. Ttenbergen 13:47, 2013 November 11 (CST) | |||
* changed s_admitDischarge table entry "Outside Province-Uknown unit" to "... Unknown ..." Ttenbergen 15:53, 2013 November 7 (CST) | |||
* 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 [[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) | |||
=== ver 2013-11-04 === | |||
rolled outTtenbergen 12:23, 2013 November 4 (CST) | |||
====changes collectors don't need to know ==== | |||
* changed references to regional_Server to a public constant rather than a function Ttenbergen 12:04, 2013 November 4 (CST) | |||
* changed query send_Centralized_1L_Log__intermediate to have a send_dttm for every record rather than only for complete ones Ttenbergen 12:07, 2013 November 4 (CST) | |||
=== ver 2013-10-28 === | |||
rolled out Ttenbergen 13:47, 2013 October 29 (CDT) | |||
* fixed tab order in apache tab; it got messed up accidentally when I fixed a different problem with it in the previous version Ttenbergen 13:47, 2013 October 29 (CDT) | |||
* fixed dx finder in diagnosis tab; I forgot to add a "no category" blank option in the last version Ttenbergen 13:47, 2013 October 29 (CDT) | |||
==== changes collectors don't need to know ==== | |||
* added legacy locations to s_locations, set to inactive, for use with centralized. Ttenbergen 17:11, 2013 October 28 (CDT) | |||
=== ver 2013-10-17 === | === ver 2013-10-17 === | ||
rolled out Ttenbergen 11:26, 2013 October 28 (CDT) | |||
changes collectors need to know about | ====changes collectors need to know about==== | ||
* set "VIC _EMIP" to inactive in [[s_Locations]] Ttenbergen 16:26, 2013 October 17 (CDT) | * set "VIC _EMIP" to inactive in [[s_Locations]] Ttenbergen 16:26, 2013 October 17 (CDT) | ||
* updated dx_chooser to use categories properly; '''if you previously found this hard to use for searching and filtering, please give it another try Ttenbergen 19:29, 2013 October 17 (CDT) | * updated dx_chooser to use categories properly; '''if you previously found this hard to use for searching and filtering, please give it another try Ttenbergen 19:29, 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. | |||
** 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) | |||
====changes collectors don't need to know about==== | |||
changes collectors don't need to know about | |||
* added columns "program" and "active" to table [[s_Locations]]. | * added columns "program" and "active" to table [[s_Locations]]. | ||
** active will determine if visible in dropdown | ** active will determine if visible in dropdown | ||
| Line 21: | 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 57: | 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 134: | 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 155: | Line 220: | ||
** added code to module sending to send the data Ttenbergen 17:04, 2013 July 29 (CDT) | ** added code to module sending to send the data Ttenbergen 17:04, 2013 July 29 (CDT) | ||
* updated sub "OpenOutputDBs" to open remaining tables in centralized_data.mdb Ttenbergen 17:11, 2013 July 29 (CDT) | * updated sub "OpenOutputDBs" to open remaining tables in centralized_data.mdb Ttenbergen 17:11, 2013 July 29 (CDT) | ||
* added remaining tables to centralized_data.mdb Ttenbergen 17:13, 2013 July 29 (CDT) | * added remaining tables to centralized_data.mdb. Ttenbergen 17:13, 2013 July 29 (CDT) | ||
** '''(this also means that the YES, NO items in pharmacy ccmdb are no longer going into pharmacy.mdb, then are going into centralized.mdb''') (Trish) | |||
*** No, this did not change anything about what goes into pharmacy.mdb. It just happened put the pharmacy info into a secondary place where we found it today. The change that stopped the yes/no stuff from being sent happened at a different time.-Ttenbergen 23:33, 2013 November 19 (CST) | |||
****well not clear to us when the change was made. If it wasn't here then delete this and let us know where it says in change log clearly when this was done. Thanks.[[User:TOstryzniuk|Trish Ostryzniuk]] 10:07, 2013 November 20 (CST) | |||
=== ver 2013-07-03 === | === ver 2013-07-03 === | ||
| Line 176: | Line 244: | ||
* Fixed send error | * Fixed send error | ||
** Fixed query ''Send_Pharmacy'' | ** Fixed query ''Send_Pharmacy'' | ||
*** I suspect this or the previous change that this tried to fix is where the sending to pharmacy broke. Ttenbergen 23:37, 2013 November 19 (CST) | |||
=== ver 2013-06-03 === | === ver 2013-06-03 === | ||
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 201: | Line 270: | ||
*** added RecordStatus stuff to Sending | *** added RecordStatus stuff to Sending | ||
** replaced references to FinalCheck in VBA. | ** replaced references to FinalCheck in VBA. | ||
** edited queries to let content through | ** edited queries to let content through if RecordStatus = "Complete" rather than if FinalChecked; or to include Recordstatus instead FinalCheck | ||
*** EdsCC | *** EdsCC | ||
*** EdsMed | *** EdsMed | ||
| Line 370: | 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]] | ||