CCMDB Wiki

CCMDB.mdb Change Log 2012: Difference between revisions

← Older edit
No edit summary
m Text replacement - "S_Tmp" to "s_tmp table"
 
(132 intermediate revisions by 4 users not shown)
Line 1: Line 1:
'''''see [[Log (disambiguation)]] for other uses of the term "Log"
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''


Line 6: Line 7:


== Versions ==
== Versions ==
=== ver 2012-12-21 ===
rolled out Ttenbergen 17:37, 2012 December 21 (EST)
* changes collectors need to know about:
*# implementing sending of modified [[Minimal Data Set]] to [[Centralized_data.mdb]] Ttenbergen 13:15, 2012 December 21 (EST)
* details collectors don't need to know:
** to implement (1),
*** added connection to OpenOutputDBs and CloseOutputDbs Ttenbergen 13:18, 2012 December 21 (EST)
*** changed Sub Send_Data() to trigger sending data to centralized_data.mdbTtenbergen 13:18, 2012 December 21 (EST)
=== ver 2012-12-19 ===
rolled out Ttenbergen 18:35, 2012 December 19 (EST)
* changes relevant to data collectors:
** changed new patient generator to '''automatically generate [[Postal code collection]]''' entry Ttenbergen 16:14, 2012 December 19 (EST)
** [[Congestive Heart Failure]] 10305 - CHF - 2nd to hypertension could '''not be used as a comorbid for cc''', only for medicine; can be used in cc as well now. Ttenbergen 16:33, 2012 December 19 (EST)
** for '''HSC Med''', changed available options for [[Med Var 2 - Discharge-to Ward]] and [[Med Var 1 - Admit-from Ward]] Ttenbergen 17:17, 2012 December 19 (EST)
=== ver 2012-12-10 ===
rolled out Ttenbergen 18:20, 2012 December 10 (EST)
* changed wording in CCMDB.mdb s_alldiagnoses for ''79415 - Post OP Bleeding GI'' to [[Surgery for Post OP GI Bleeding]]
=== ver 2012-12-05 ===
rolled out Ttenbergen 19:22, 2012 December 5 (EST)
* Concordia collectors need to know: added Concordia Ambulatory Care to [[Admit From & Discharged To]] locations. Ttenbergen 19:22, 2012 December 5 (EST)
=== ver 2012-12-03 ===
rolled out Ttenbergen 17:20, 2012 December 3 (EST)
* added s_tmp entry to implement [[IABP project]]. Ttenbergen 17:20, 2012 December 3 (EST)
=== ver 2012-11-22 ===
rolled out Ttenbergen 17:44, 2012 November 22 (EST)
* changes collectors need to know:
** overstay error triggered for ICU Gra, fixed query ''check_overstay_not_entered'' to exclude GRA ICU Ttenbergen 16:21, 2012 November 22 (EST)
** changed sorting of L_Tmp form to have entries show sorted better Ttenbergen 17:20, 2012 November 22 (EST)
** fixed error that was making GRA MED Overstay turn red for all; (ran decompile to fix problem with program stopping in a spot in the VBA code that previously had a debug stop.) Ttenbergen 16:28, 2012 November 22 (EST)
=== ver 2012-11-19 ===
rolled out.- [[User:Ttenbergen | Tina Tenbergen]] 14:48, 2012 November 21 (EST)
* eliminated generation of PDA Status.csv during sending Ttenbergen 15:34, 2012 November 19 (EST)
* applied fix to [[Check Trauma codes without subcodes]] to exclude the trauma codes that don't have subcodes. -[[User:Ttenbergen | Tina Tenbergen]] 14:41, 2012 November 21 (EST)
=== ver 2012-11-16 fix ===
rolled out Ttenbergen 10:59, 2012 November 19 (EST)
Forgot to update the version before rollout.
This update will fix the ADL check for Overstay. The last version introduced a check that didn't work and always said the ADLs are missing, this should fix that. Ttenbergen 10:59, 2012 November 19 (EST)
=== ver 2012-11-16 ===
rolled out Ttenbergen 18:35, 2012 November 16 (EST)
* '''changes collectors need to know about''':
** tweaked form sizes for laptop screen -Ttenbergen 12:36, 2012 November 16 (EST)
** fixed bug [[Incomplete TMP entry can't be seen or edited]] Ttenbergen 13:08, 2012 November 16 (EST)
** fixed bug where trying to evaluate colour for [[Overstay]] would give a null error and blacken the button when [[ADL]]s were not filled in. Ttenbergen 13:47, 2012 November 16 (EST)
** implemented [[Check Trauma codes without subcodes]] Ttenbergen 14:06, 2012 November 16 (EST)
** implemented [[Automatic Generation of TMP entries]] Ttenbergen 17:53, 2012 November 16 (EST)
=== ver 2012-11-15 ===
rolled out Ttenbergen 17:49, 2012 November 15 (EST)
* fixed error in query s_tmp_overstay_from which was causing error when checking the "tmp" checkbox for a patient who has a form missing entry (removed form-missing criteria). Ttenbergen 17:49, 2012 November 15 (EST)
=== ver 2012-11-05 ===
rolled out Ttenbergen 18:26, 2012 November 5 (EST)
* added a "Transferred form" entry to [[Overstay Predictor Project Collection Instructions|Overstay]] Ttenbergen 18:22, 2012 November 5 (EST)
* updated query [[Query check overstay not entered]] to reflect different starting dates at StB.
* fixing Allied Health issue Con described
=== ver 2012-11-01 ===
Rolled out Ttenbergen 21:01, 2012 November 1 (EDT)
* Changes affecting collectors:
** enabled [[Overstay Predictor Project Collection Instructions | Overstay project]] for StB
** changed label for y/n heparin to say "heparin cont inf" to distinguish from heparin S/C
** set up [[Allied_Health_Consults]] project entries in s_tmp
** made Pharm_flow and Labs tabs invisible for medicine Ttenbergen 20:09, 2012 November 1 (EDT)
* Changes behind the scenes:
* [[Overstay Predictor Project]] for STB
** added entries to s_tmp Ttenbergen 15:38, 2012 November 1 (EDT)
** added check to ensure an overstay entry is present for pt who should have one Ttenbergen 21:01, 2012 November 1 (EDT)
that is counted Ttenbergen 15:41, 2012 November 1 (EDT)
=== ver 2012-10-19 ===
rolled out Ttenbergen 22:19, 2012 October 24 (CDT)
* changes that will affect data collection
** changed pharmacy form:
*** can see several lines for counted drugs to facilitate counting
*** increase space for counted drugs so I could tilt them again, rather than having to have them vertical
**** tilted to 30degrees, i.e. flatter than before the Sept change, should be easier on necks...
*** no more lines for y/n drugs, takes up least space and has simplest entry that way
*** increased font size for counted drugs
*** "hover" feature will still be available
*** corrected the LOS checker for Pharmacy Ttenbergen 21:50, 2012 October 23 (CDT)
* behind-the-scenes changes, should not affect data collection:
** adding code to automatically store the colour generated by the Overstay button Ttenbergen 15:56, 2012 October 19 (CDT)
** added sub Generate_tmp_entry to be programmatically add tmp entries (this also sets us up for [[Automatic Generation of TMP entries]] but that is not implemented yet) Ttenbergen 15:56, 2012 October 19 (CDT)
*** added columns to table [[s_tmp table]] to control functionality Ttenbergen 15:56, 2012 October 19 (CDT)
*** adding filters to use those columns to
**** tmp tab viewing (only there if auto_cant_edit is false) Ttenbergen 15:56, 2012 October 19 (CDT)
**** project and item dropdown in tab  Ttenbergen 15:59, 2012 October 19 (CDT)
**** project and item dropdown dropdown in editor  Ttenbergen 16:06, 2012 October 19 (CDT)
** data changes
*** removed table [[L_Pharm]] and updated VBA in DB_Connect() etc to no longer look for it
*** deleted drugs no longer counted or now y/n as of 2012-09 from [[L_Pharm_Flowsheet]]
*** added y/n drugs to table L_Log (each patient can only have one of each...)
*** changed query L_Pharm_FlowSheet_sum to use L_Log Pharm_* to generate data for y/n drugs Ttenbergen 15:37, 2012 October 22 (CDT)
*** updated converter to accommodate new data structure Ttenbergen 21:28, 2012 October 22 (CDT)
=== ver 2012-10-15 ===
rolled out Ttenbergen 14:19, 2012 October 15 (CDT)
* reverted change to form [[Patient List]] to version before [[#ver 2012-09-06]] as per "Feedback_Request_-_Patient_List"; except that room is still removed.Ttenbergen 12:41, 2012 October 15 (CDT)
=== ver 2012-10-01-01 ===
rolled out Ttenbergen 16:37, 2012 October 1 (CDT)
* corrected spelling for [[Churg-Strauss Syndrome]] --Ttenbergen 16:37, 2012 October 1 (CDT)
=== ver 2012-10-01 ===
rolled out Ttenbergen 11:02, 2012 October 1 (CDT)
* change [[Panelling or Discharge Planning]]
=== ver 2012-09-26-5 ===
rolled out Ttenbergen 16:40, 2012 September 26 (CDT)
* changed Diags form to display diagnoses that have been deleted. When we deleted [[Panelling or Discharge Planning]] collectors were getting errors about it but unable to change it because the lines were no longer visible. Ttenbergen 16:40, 2012 September 26 (CDT)
**removing 90600 is causing problems.  Sorry about that, therefore, this is what we will do until we actually go to ICD 10:
***Restore DX code 906 but split as follows:
****906-1 Paneling
****906-2 Discharge planning
=== ver 2012-09-26-4 ===
rolled out Ttenbergen 15:28, 2012 September 26 (CDT)
* enabled scroll bar in Pharmacy tab Ttenbergen 15:28, 2012 September 26 (CDT)
=== ver 2012-09-26-3 ===
rolled out Ttenbergen 15:02, 2012 September 26 (CDT)
* to fix problems with LOS check in Pharmacy, changed LOS for purpose of PharmCheck to
** WorksheetFunction.Ceiling(Nz(Form_View.R_DisDate) + Nz(Form_View.R_DisTime, 1) - Nz(Form_View.R_AdmDate, 0), 1)
=== ver 2012-09-26-2 ===
rolled out Ttenbergen 10:17, 2012 September 26 (CDT)
* fixed problem with MR button created by changes in ver 2012-09-06Ttenbergen 10:17, 2012 September 26 (CDT)
=== ver 2012-09-26 ===
rolled out Ttenbergen 09:14, 2012 September 26 (CDT)
* previous change broke the sorting buttons on the PatientList. Fixed. Ttenbergen 09:14, 2012 September 26 (CDT)
* compiled the code for clean-up, eliminated references to some old fields that no longer exist. Ttenbergen 09:14, 2012 September 26 (CDT)
=== ver 2012-09-06 ===
Rolled out Ttenbergen 16:36, 2012 September 25 (CDT)
==== changes collectors need to know ====
* deleted diagnosis [[Panelling or Discharge Planning]][[User:Ttenbergen|Ttenbergen]] 14:03, 2012 September 11 (CDT)
* changed wording for [[QA Septic Shock]] entry "First SBP<90" to "BP Criteria" [[User:Ttenbergen|Ttenbergen]] 11:06, 2012 September 12 (CDT)
* added [[HSC H6]] to [[Admit From & Discharged To]] list -- [[User:Ttenbergen|Ttenbergen]] 16:17, 2012 September 20 (CDT)
* Pharmacy
** made changes for new pharmacy counts vs y/n entries -- [[User:Ttenbergen|Ttenbergen]] 18:03, 2012 September 19 (CDT)
** made remaining count fields in pharmacy wider so at least part of a 3rd digit is visible; left at that due to lack of space -- [[User:Ttenbergen|Ttenbergen]] 11:48, 2012 September 20 (CDT)
* implemented changes discussed in old wiki page "Feedback Request - Patient List":
** eliminated room number -- [[User:Ttenbergen|Ttenbergen]] 11:54, 2012 September 20 (CDT)
** combined fields to save space into '''LastName, FirstName (DOB|chart|PHIN)''' -- [[User:Ttenbergen|Ttenbergen]] 11:58, 2012 September 20 (CDT)
** increased space for the notes field on Patient list; still, only the very first bit will be visible -- [[User:Ttenbergen|Ttenbergen]] 12:22, 2012 September 20 (CDT)
==== other changes ====
* cleaned up s_varoptions for
** legacy [[Med Var 5]] options
** legacy [[Med Var 3]] options[[User:Ttenbergen|Ttenbergen]] 18:21, 2012 September 6 (CDT)
* changed [[Overstay Predictor Project Collection Instructions|Overstay]] to change how missing data is handled [[User:Ttenbergen|Ttenbergen]] 14:16, 2012 September 13 (CDT)
* removed "Compact/repair" button from Main Form, it never worked and can't work while program is open. See [[Fix]] for instructions on what to do when you might have wanted to use this button. Ttenbergen 14:30, 2012 September 21 (CDT)
=== ver 2012-08-31 - Transition to new Regional Server ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:57, 2012 August 31 (CDT)
* changed VBA over to use new regional server[[User:Ttenbergen|Ttenbergen]] 14:17, 2012 August 31 (CDT)
** changed Function Regional_server() to return "\\ad.wrha.mb.ca\WRHA\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\"
** searched for any remaining instances of sbghnwfs0102 and replaced with Regional_server()
** confirmed that sending code does not include any references to he old regional server
* updated some fonts on the viewer to be consistent [[User:Ttenbergen|Ttenbergen]] 14:28, 2012 August 31 (CDT)
=== ver 2012-08-22 ===
rolled out yet [[User:Ttenbergen|Ttenbergen]] 16:03, 2012 August 22 (CDT)
* reverted sorting of the DxChooser form to sort by code; somehow got changed unintentionally. [[User:Ttenbergen|Ttenbergen]] 15:43, 2012 August 22 (CDT)
=== ver 2012-07-27 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 14:04, 2012 August 21 (CDT)
* added the from_residence entries for [[Overstay_Predictor_Project_Collection_Instructions|Overstay Project]]
* changed algorithm for overstay to include residence info [[User:Ttenbergen|Ttenbergen]] 14:06, 2012 July 27 (CDT)
* changed algorithm for overstay to make "exceptions" yellow, not green [[User:Ttenbergen|Ttenbergen]] 14:06, 2012 July 27 (CDT)
* '''waiting for an answer to [[Overstay_Predictor_Project_Collection_Instructions#colour_if_data_is_missing]] before finishing implementation [[User:Ttenbergen|Ttenbergen]] 14:06, 2012 July 27 (CDT)
**''' will leave this as guesswork for now, can fix later, I need to roll this out because it has a collection fix in it. [[User:Ttenbergen|Ttenbergen]] 13:58, 2012 August 21 (CDT)
* changed overstay checker to only run at overstay locations (for the rest the button should just go/stay gray) [[User:Ttenbergen|Ttenbergen]] 13:56, 2012 August 21 (CDT)
=== ver 2012-07-13 ===
=== ver 2012-07-13 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:24, 2012 July 20 (CDT)
rolled out [[User:Ttenbergen|Ttenbergen]] 16:24, 2012 July 20 (CDT)
Line 17: Line 205:
rolled out [[User:Ttenbergen|Ttenbergen]] 15:42, 2012 July 6 (CDT)
rolled out [[User:Ttenbergen|Ttenbergen]] 15:42, 2012 July 6 (CDT)


* changed [[Confusion/Delirium NYD]] to just Confusion/Delirium
* changed Confusion/Delirium NYD to just [[Confusion/Delirium]]


=== ver 2012-06-07 ===
=== ver 2012-06-07 ===
Line 52: Line 240:
** implementing[[Overstay Predictor Project]] [[User:Ttenbergen|Ttenbergen]] 10:48, 2012 April 12 (CDT)
** implementing[[Overstay Predictor Project]] [[User:Ttenbergen|Ttenbergen]] 10:48, 2012 April 12 (CDT)
*** added variables to the tmp table[[User:Ttenbergen|Ttenbergen]] 10:11, 2012 April 12 (CDT)
*** added variables to the tmp table[[User:Ttenbergen|Ttenbergen]] 10:11, 2012 April 12 (CDT)
*** added overstay indicator to main form; clicking it will give the colour; '''''[ http://team.kuality.ca/wiki/index.php/Transition_Coordinator algorithm] not implemented yet.''''' [[User:Ttenbergen|Ttenbergen]] 11:03, 2012 April 12 (CDT)
*** added overstay indicator to main form; clicking it will give the colour; Transition_Coordinator algorithm [[User:Ttenbergen|Ttenbergen]] 11:03, 2012 April 12 (CDT)
** added [[CAP-Community Acquired Pneumonia#data integrity rules]] [[User:Ttenbergen|Ttenbergen]] 11:30, 2012 April 12 (CDT)
** added [[CAP-Community Acquired Pneumonia#data integrity rules]] [[User:Ttenbergen|Ttenbergen]] 11:30, 2012 April 12 (CDT)
*** changed label for CAP dx so that a search in DXs on CAP will find it [[User:Ttenbergen|Ttenbergen]] 11:36, 2012 April 12 (CDT)
*** changed label for CAP dx so that a search in DXs on CAP will find it [[User:Ttenbergen|Ttenbergen]] 11:36, 2012 April 12 (CDT)
Line 121: Line 309:
rolled out [[User:Ttenbergen|Ttenbergen]] 15:38, 10 January 2012 (CST)
rolled out [[User:Ttenbergen|Ttenbergen]] 15:38, 10 January 2012 (CST)


tested via [[Test_Plans_2012#ver 2012-01-05 testing]][[User:Ttenbergen|Ttenbergen]] 15:38, 10 January 2012 (CST)
tested via (Test_Plans_2012#ver 2012-01-05 testing - article was cleaned up Ttenbergen 09:46, 2014 June 2 (CDT))[[User:Ttenbergen|Ttenbergen]] 15:38, 10 January 2012 (CST)


* changes collectors will notice...
* changes collectors will notice...
Line 144: Line 332:
* Allow spaces in First Name (fix function real_char)
* Allow spaces in First Name (fix function real_char)


 
[[Category:CCMDB.accdb]]
 
[[Category: IT Instructions]]
[[Category: Development Documentation]]
[[Category: Change Logs CCMDB]]
[[Category: Change Logs CCMDB]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2012"