CCMDB.mdb Change Log 2012: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "S_Tmp" to "s_tmp table" |
||
| (39 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.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 === | === ver 2012-11-16 === | ||
rolled out Ttenbergen 18:35, 2012 November 16 (EST) | rolled out Ttenbergen 18:35, 2012 November 16 (EST) | ||
* tweaked form sizes for laptop screen -Ttenbergen 12:36, 2012 November 16 (EST) | * '''changes collectors need to know about''': | ||
* fixed bug [[Incomplete TMP entry can't be seen or edited]] Ttenbergen 13:08, 2012 November 16 (EST) | ** tweaked form sizes for laptop screen -Ttenbergen 12:36, 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) | ** fixed bug [[Incomplete TMP entry can't be seen or edited]] Ttenbergen 13:08, 2012 November 16 (EST) | ||
* implemented [[Check Trauma codes without subcodes]] Ttenbergen 14:06, 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 [[Automatic Generation of TMP entries]] Ttenbergen 17:53, 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 === | === ver 2012-11-15 === | ||
| Line 22: | Line 69: | ||
rolled out Ttenbergen 18:26, 2012 November 5 (EST) | 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) | * added a "Transferred form" entry to [[Overstay Predictor Project Collection Instructions|Overstay]] Ttenbergen 18:22, 2012 November 5 (EST) | ||
* updated query [[ | * updated query [[Query check overstay not entered]] to reflect different starting dates at StB. | ||
* fixing Allied Health issue Con described | * fixing Allied Health issue Con described | ||
| Line 52: | Line 99: | ||
** adding code to automatically store the colour generated by the Overstay button Ttenbergen 15:56, 2012 October 19 (CDT) | ** 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 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 [[ | *** added columns to table [[s_tmp table]] to control functionality Ttenbergen 15:56, 2012 October 19 (CDT) | ||
*** adding filters to use those columns to | *** 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) | **** tmp tab viewing (only there if auto_cant_edit is false) Ttenbergen 15:56, 2012 October 19 (CDT) | ||
| Line 66: | Line 113: | ||
=== ver 2012-10-15 === | === ver 2012-10-15 === | ||
rolled out Ttenbergen 14:19, 2012 October 15 (CDT) | rolled out Ttenbergen 14:19, 2012 October 15 (CDT) | ||
* reverted change to form [[Patient List]] to version before [[#ver 2012-09-06]] as per | * 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 === | === ver 2012-10-01-01 === | ||
| Line 108: | 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 | * 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 158: | 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 | * changed Confusion/Delirium NYD to just [[Confusion/Delirium]] | ||
=== ver 2012-06-07 === | === ver 2012-06-07 === | ||
| Line 193: | 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; | *** 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 262: | 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 | 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 285: | Line 332: | ||
* Allow spaces in First Name (fix function real_char) | * Allow spaces in First Name (fix function real_char) | ||
[[Category:CCMDB.accdb]] | |||
[[Category: | |||
[[Category: Change Logs CCMDB]] | [[Category: Change Logs CCMDB]] | ||