CCMDB Wiki

CCMDB.mdb Change Log 2013: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Text replacement - "S Tmp" to "s_tmp table"
 
(26 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 ===
not rolled out yet Ttenbergen 13:20, 2013 November 25 (CST)
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)
* made legacy code for paneling (and all legacy codes) invisible in the dropdown for dx_chooser. Ttenbergen 14:33, 2013 November 25 (CST)
* 2YY for dates
* 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===
===2013-11-18===
Line 19: Line 37:
** input mask is 00/LLL/0000;;_
** input mask is 00/LLL/0000;;_
** format is yyyy/mmm/dd
** format is yyyy/mmm/dd
*does the year in registration need to be recorded as 4 digits?; it is much easier to enter 2 as before --[[User:SCortilet|SCortilet]] 11:07, 2013 November 22 (CST)
** I could change it back. Made it that way to be consistent. Trish/Pagasa, any objections to a 2YY input mask? Ttenbergen 12:44, 2013 November 25 (CST)
***input mask and display should be the same for date which includes the year.  Want to keep it obvious and consistent, Admit, discharge transfer dates, Tmp file dates, patient LIST dates. User:TOstryzniuk|Trish Ostryzniuk]] 19:59, 2013 November 25 (CST)


====Changes collectors don't need to know ====
====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)
* 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)]]
** 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 33: 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 [[S Tmp]] entry for project '''[[Comfort_Care]]''' Ttenbergen 11:27, 2013 November 11 (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 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]] entry ''Palliative Care'' to [[Palliative Service]] Ttenbergen 11:30, 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)
* 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 62: 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) {{discussion}}
** 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 71: 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 table [[A_Info]] that are no longer used: RegSrv and data_path Ttenbergen 18:52, 2013 October 17 (CDT)
* 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 107: 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 Lodge]] from HSC medicine wards. [[User:Bcloutier|Bcloutier]] 13:49, 2013 September 11 (CDT)
*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 184: 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 234: 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 http://ltc.umanitoba.ca/wikis with http://ccmdb.kuality.ca Ttenbergen 12:20, 2013 June 3 (EDT)
* replaced all mentions in VBA of ltc.umanitoba.ca/wikis with http://ccmdb.kuality.ca Ttenbergen 12:20, 2013 June 3 (EDT)
* added [[9200 - Tracheobronchitis]]
* added 9200 - Tracheobronchitis
* eliminated [[3005 - Bronchitis]]
* 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 code tmpchecker() to reject if not "collection_allowed" Ttenbergen 12:50, 2013 June 3 (EDT)
** 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 424: 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 site infection‎]] to list as an ''infection'' - Ttenbergen 17:51, 2013 January 25 (EST)
* 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: IT Instructions]]
[[Category:CCMDB.accdb]]
[[Category: Development Documentation]]
[[Category: Change Logs CCMDB]]
[[Category: Change Logs CCMDB]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2013"