CCMDB Wiki

CCMDB.mdb Change Log 2012: Difference between revisions

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(90 intermediate revisions by 3 users not shown)
Line 7: 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.accdb]] 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_Consults]] 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 ===
=== ver 2012-10-01 ===
rolled out Ttenbergen 11:02, 2012 October 1 (CDT)
rolled out Ttenbergen 11:02, 2012 October 1 (CDT)
Line 18: Line 130:
****906-1 Paneling
****906-1 Paneling
****906-2 Discharge planning
****906-2 Discharge planning
*Those who currently have 90600 coded up to admit date say Sept 27th should be able to send in as in.  Admit after Sept 27 then must use a subcode with code 906.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:11, 2012 September 26 (CDT)
{{discussion}}
Are these still problems with v...5, or can you send now with the newest version? I'd rather not make this more complicated, and the above would.Ttenbergen 09:02, 2012 September 27 (CDT)
{{discussion}}
*I just want to clarify that we are no longer using the paneling or discharge code.  The above changes are only to be used to fix an error if you encounter it with pts that have previously had this code in their Dx list. Judy 06:58, 2012 September 27 (CDT)


=== ver 2012-09-26-4 ===
=== ver 2012-09-26-4 ===
Line 50: Line 155:
* deleted diagnosis [[Panelling or Discharge Planning]][[User:Ttenbergen|Ttenbergen]] 14:03, 2012 September 11 (CDT)
* 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)
* changed wording for [[QA Septic Shock]] entry "First SBP<90" to "BP Criteria" [[User:Ttenbergen|Ttenbergen]] 11:06, 2012 September 12 (CDT)
* added H6 to [[Admit From & Discharged To]] list -- [[User:Ttenbergen|Ttenbergen]] 16:17, 2012 September 20 (CDT)
* added [[HSC H6]] to [[Admit From & Discharged To]] list -- [[User:Ttenbergen|Ttenbergen]] 16:17, 2012 September 20 (CDT)
* Pharmacy
* Pharmacy
** made changes for new pharmacy counts vs y/n entries -- [[User:Ttenbergen|Ttenbergen]] 18:03, 2012 September 19 (CDT)
** 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)
** 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 [[Feedback Request - Patient List]]:
* implemented changes discussed in old wiki page "Feedback Request - Patient List":
** eliminated room number -- [[User:Ttenbergen|Ttenbergen]] 11:54, 2012 September 20 (CDT)
** 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)
** combined fields to save space into '''LastName, FirstName (DOB|chart|PHIN)''' -- [[User:Ttenbergen|Ttenbergen]] 11:58, 2012 September 20 (CDT)
Line 100: 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 135: 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 204: 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 227: Line 332:
* Allow spaces in First Name (fix function real_char)
* Allow spaces in First Name (fix function real_char)


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