CCMDB.mdb Change Log 2013: Difference between revisions

m Text replacement - "S Tmp" to "s_tmp table"
 
(129 intermediate revisions by 5 users not shown)
Line 7: Line 7:


== Versions ==
== Versions ==
=== need to resolve ===
==Changes ==
* add relationships to centralized_data.mdb
=== 2013-12-13 ===
* resolve whether to mandate colour
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 ===
rolled out Ttenbergen 11:26, 2013 October 28 (CDT)
 
====changes collectors need to know about====
* 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)
* 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====
* added columns "program" and "active" to table [[s_Locations]].
** active will determine if visible in dropdown
** program will be used in [[centralized_data.mdb]] to filter patients into CC or Med only piles Ttenbergen
** 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)
* 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 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)
 
=== ver 2013-10-03-2 ===
rolled out Ttenbergen 10:25, 2013 October 9 (CDT)
* fixing problems with the delete queries that send to centralized. Ttenbergen 15:06, 2013 October 3 (CDT)
** updated Send_Centralized_L_Como_delete Ttenbergen 14:04, 2013 October 8 (CDT)
** updated Send_Centralized_L_Dxs_delete Ttenbergen 14:11, 2013 October 8 (CDT)
** updated Send_Centralized_L_Labs_Flowsheet_delete Ttenbergen 14:11, 2013 October 8 (CDT)
** updated Send_Centralized_L_Pharm_Flowsheet_delete Ttenbergen 14:12, 2013 October 8 (CDT)
** updated Send_Centralized_L_TmpV2_delete Ttenbergen 14:14, 2013 October 8 (CDT)
 
=== ver 2013-10-03 ===
rolled out Ttenbergen 14:29, 2013 October 3 (CDT)
 
(I had made this version while off-line, just entering log after the fact.)
* updated query send_Centralized_1L_Log__intermediate to include sentDtTm
* updated Send_Centralized_1L_Log_append to include sentDtTm
* updated Send_Centralized_1L_Log_update to include sentDtTm
 
* added code to form_mainform to
** DoCmd.ShowToolbar "Formatting (Form/Report)", acToolbarNo
** DoCmd.ShowToolbar "Form Design", acToolbarNo
** always show full menus (CommandBars.AdaptiveMenus = False)
 
=== ver 2013-09-12 ===
rolled out Ttenbergen 17:41, 2013 September 12 (CDT)
'''Changes collectors don't need to know about: '''
* updated Send_Centralized_L_Labs_Flowsheet_append to include D_ID, was accidentally missed at implementation. Ttenbergen 17:35, 2013 September 12 (CDT)
* updated Send_Centralized_L_Pharm_Flowsheet_append, it was not sending anything before. Ttenbergen 17:40, 2013 September 12 (CDT)
 
=== ver 2013-09-11 ===
rolled out [[User:Bcloutier|Bcloutier]] 16:28, 2013 September 11 (CDT)
 
'''Changes Collectors Need to Know'''
*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'''
*Added Restriction to disallow duplicate [[Admit From & Discharged To]] codes within the Code field on the [[S AdmitDischarge]] [[User:Bcloutier|Bcloutier]] 13:49, 2013 September 11 (CDT)
 
=== ver 2013-09-05-2 ===
rolled out Ttenbergen 13:43, 2013 September 5 (CDT)
* correction to query Send_Centralized_L_Pharm_Flowsheet_append
 
=== ver 2013-09-05 ===
rolled out Ttenbergen 11:56, 2013 September 5 (CDT)
 
'''Changes collectors don't need to know:'''
* updated send function to use the new queries added in previous version. Ttenbergen 11:56, 2013 September 5 (CDT)
 
=== ver 2013-08-12 ===
rolled out Ttenbergen 12:27, 2013 August 29 (CDT)
 
'''Changes collectors should know about:'''
* on Pharmacy screen, fixed pop-up hints:
** added pariet to rabeprazole for PPI
** added "linezolid (Zyvoxam), daptomycin (Cubicin), quinipristin/dalfopristin" for Vanco alternatives
* changed column order in [[Patient List]] as requested Ttenbergen 11:32, 2013 August 29 (CDT)
* changed date input mask for admit/transfer/discharge to be consistent with the way the dates are displayed Ttenbergen 12:12, 2013 August 29 (CDT)
 
'''Changes collectors don't need to know:'''
* added Send_Centralized_L_Como__intermediate
* added Send_Centralized_L_Como_append
* added Send_Centralized_L_Como_delete
* added Send_centralized_L_Como_update
* added Sent_Centralized_L_TmpV2__intermediate
* added Send_Centralized_L_TmpV2_append
* added Send_Centralized_L_TmpV2_delete
* added Send_Centralized_L_TmpV2_update
* added Send_Centralized_L_Labs_Flowsheet__intermediate
* added Send_Centralized_L_Labs_Flowsheet_append
* added Send_Centralized_L_Labs_Flowsheet_update
* added Send_Centralized_L_Pharm_Flowsheet_append
* added Send_Centralized_L_Pharm_Flowsheet_delete
* added Send_Centralized_L_Pharm_Flowsheet_update
* updated Convert_DB() to put in place [[CCMDB_data.mdb_Change_Log#2013-08-12]]
* updated Regional_server_connected() to also check for presence of centralized_data.mdb Ttenbergen 10:45, 2013 August 29 (CDT)
* updated query send_Centralized_1L_Log__intermediate to mask birth-date by setting all to first of the month; this is to reduce changes of identifying patients Ttenbergen 11:41, 2013 August 29 (CDT)


=== ver 2013-08-01 ===
=== ver 2013-08-01 ===
not rolled out yet Ttenbergen 13:36, 2013 July 31 (CDT)
rolled out Ttenbergen 17:07, 2013 August 8 (CDT)
* changed tmp entry for QAInf from "CLI (call Basil Evan'''s''' if MICU/SICU/IICU)" to loose the "s" in Evans - Ttenbergen 09:36, 2013 August 1 (CDT)
* changed tmp entry for QAInf from "CLI (call Basil Evan'''s''' if MICU/SICU/IICU)" to loose the "s" in Evans - Ttenbergen 09:36, 2013 August 1 (CDT)
==== . . .  Overstay Changes ====
==== . . .  Overstay Changes ====
* cleaned up s_tmp to have only one line for each overstay option, used to require more when only certain hospitals were participating Ttenbergen 09:51, 2013 August 1 (CDT) Hurrah!!!.(trish) didn't think anyone other than maintainer of the s_tmp table would care... but glad you like it :0) Ttenbergen 12:33, 2013 August 1 (CDT)
* changed Overstay Tmp dropdown option "Form data missing" to "DPST data missing" Ttenbergen 09:51, 2013 August 1 (CDT)
* changed Overstay Tmp dropdown option "Form data missing" to "DPST data missing" Ttenbergen 09:51, 2013 August 1 (CDT)
* added request for confirmation that this is the colour to send, and changed code so it is only added to tmp if "yes" is clicked.Ttenbergen 10:02, 2013 August 1 (CDT)  
* added request for confirmation that this is the colour to send, and changed code so it is only added to tmp if "yes" is clicked.Ttenbergen 10:02, 2013 August 1 (CDT)  
* added check to require a colour or a "DPST data missing" to be present Ttenbergen 12:52, 2013 August 1 (CDT)
* changed overstay code so that overstay will now replace entry in tmp rather than add new one, and only after asking if this is for good Ttenbergen 13:43, 2013 August 1 (CDT)
** this has been commented out in tmp_checker for now while discussion about it continues Ttenbergen 15:02, 2013 August 1 (CDT)
* eliminated check location_is_part_of_overstay() because all locations are on now
* changed so that overstay will now replace entry in tmp rather than add new one, and only after asking if this is for good Ttenbergen 13:43, 2013 August 1 (CDT)
* colour will now be automatically added to beginning of Notes field. Ttenbergen 14:52, 2013 August 1 (CDT)
* colour will now be automatically added to beginning of Notes field. Ttenbergen 14:52, 2013 August 1 (CDT)
* Collectors don't need to know the following:
** cleaned up s_tmp to have only one line for each overstay option, used to require more when only certain hospitals were participating Ttenbergen 09:51, 2013 August 1 (CDT)
** added check to require a colour or a "DPST data missing" to be present Ttenbergen 12:52, 2013 August 1 (CDT)
*** this has been commented out in tmp_checker for now while discussion about it continues Ttenbergen 15:02, 2013 August 1 (CDT)
** eliminated check location_is_part_of_overstay() because all locations are on now
==== . . .  New Data Repository ====
==== . . .  New Data Repository ====
Collectors don't need to know any of this at this time.
* added 18 char text field d_id to [[centralized_data.mdb]].L_Log and updated it to [R_location]-[Pat_ID]Ttenbergen 15:23, 2013 August 1 (CDT)
* added 18 char text field d_id to [[centralized_data.mdb]].L_Log and updated it to [R_location]-[Pat_ID]Ttenbergen 15:23, 2013 August 1 (CDT)
* changed [[centralized_data.mdb]].L_Dxs.Pat_ID to 18 char text D_Id; changed Diag_ID to 30 char text field. Ttenbergen 15:28, 2013 August 1 (CDT)
* changed [[centralized_data.mdb]].L_Dxs.Pat_ID to 18 char text D_Id; changed Diag_ID to 30 char text field. Ttenbergen 15:28, 2013 August 1 (CDT)
* renamed send to centralized queries to include table name, e.g. Send_Centralized_1L_Log_append; updated queries to use new d_id Ttenbergen 16:01, 2013 August 1 (CDT)
* renamed send to centralized queries to include table name, e.g. Send_Centralized_1L_Log_append; updated queries to use new d_id Ttenbergen 16:01, 2013 August 1 (CDT)
* updated Send_Centralized_L_Dxs_append to send with new combined diag_id Ttenbergen 16:50, 2013 August 1 (CDT)
* updated Send_Centralized_L_Dxs_append to send with new combined diag_id Ttenbergen 16:50, 2013 August 1 (CDT)
* created Send_Centralized_L_Dxs_delete Ttenbergen 16:19, 2013 August 8 (CDT)
* confirmed that minimal data set check query minimal_data_set_incomplete includes check for R_Location (to make sure that d_id can be generated). Ttenbergen 16:52, 2013 August 8 (CDT)
* confirmed that queries update only things that are RecordStatus = "incomplete" in centralized.mdbTtenbergen 16:52, 2013 August 8 (CDT)
* added new sending queries to Sub Send_Data() Ttenbergen 16:55, 2013 August 8 (CDT)


=== ver 2013-07-31-2 ===
=== ver 2013-07-31-2 ===
Line 37: 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 58: 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 79: 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 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 104: 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 is RecordStatus = "Complete" rather than if FinalChecked; or to include Recordstatus instead FinalCheck
** edited queries  to let content through if RecordStatus = "Complete" rather than if FinalChecked; or to include Recordstatus instead FinalCheck
*** EdsCC  
*** EdsCC  
*** EdsMed
*** EdsMed
Line 273: 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]]