CCMDB Wiki

CCMDB.mdb Change Log 2012: Difference between revisions

← Older edit
m Text replacement - "S_Tmp" to "s_tmp table"
 
(156 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 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 16:24, 2012 July 20 (CDT)
* added the "form data missing" entry for the [[Overstay_Predictor_Project_Collection_Instructions#Entering_the_Nursing_Discharge_Screen_Tool_data_into_CCMDB.mdb|Overstay Project]]
* added check to work if there is no entry for any of the [[Overstay_Predictor_Project_Collection_Instructions#Entering_the_Nursing_Discharge_Screen_Tool_data_into_CCMDB.mdb|Overstay Project form]] and fixed other checks
* changed diagnosis name to [[Violent 2nd to dementia]] [[User:Ttenbergen|Ttenbergen]] 13:46, 2012 July 17 (CDT)
* implemented Rodrigo's most recent coefficients for [[Overstay_Predictor_Project_Collection_Instructions]].[[User:Ttenbergen|Ttenbergen]] 16:24, 2012 July 20 (CDT)
=== ver 2012-07-06 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 15:42, 2012 July 6 (CDT)
* changed Confusion/Delirium NYD to just [[Confusion/Delirium]]
=== ver 2012-06-07 ===
Rolled out [[User:Ttenbergen|Ttenbergen]] 15:16, 2012 June 28 (CDT)
This also applies to [CCMDB_data.mdb_Change_Log#2012-06-07] [[User:Ttenbergen|Ttenbergen]] 17:33, 2012 June 7 (CDT)
* did a compile on all code and identified a lot of left-overs; commented them out [[User:Ttenbergen|Ttenbergen]] 16:13, 2012 June 7 (CDT)
** specifically some of the rejecter functions were changed [[User:Ttenbergen|Ttenbergen]] 16:15, 2012 June 7 (CDT)
* changed the DB_converter module to cope with [CCMDB_data.mdb_Change_Log#2012-06-07] [[User:Ttenbergen|Ttenbergen]] 16:13, 2012 June 7 (CDT)
** Changed pharmacy check to not require admit or discharge times; not always available at the time of completing the pharm entry. [[User:Ttenbergen|Ttenbergen]] 15:05, 2012 June 18 (CDT)
=== ver 2012-05-09 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:01, 2012 May 9 (CDT)
* Regional server addressing hard-coded to fix problem with unresolved address causing Pagasa report to not be generated. [[User:Ttenbergen|Ttenbergen]] 12:54, 2012 May 9 (CDT)
=== ver 2012-05-03 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 13:24, 2012 May 3 (CDT)
* moved sending of .csv to the end of the send function to ensure that if anything goes wrong that data will not be sent, i.e. if collectors check for it they won't assume that if it is there, all else went OK as well[[User:Ttenbergen|Ttenbergen]] 13:24, 2012 May 3 (CDT)
* fixed problem where not entering a Postal Code would give a bad procedure call error[[User:Ttenbergen|Ttenbergen]] 13:24, 2012 May 3 (CDT)
=== ver 2012-05-02 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 11:45, 2012 May 2 (CDT)
* Fix for send problems, collectors were getting an "insert into" error upon sending. Data for pharmacy and tmp would not have been sent.
** there was a problem with query ''L_Pharm_FlowSheet_sum''; not sure how it happened since I don't think I changed anything in it; fixed now
=== ver 2012-04-12 ===
=== ver 2012-04-12 ===
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:09, 2012 April 12 (CDT)
rolled out [[User:Ttenbergen|Ttenbergen]] 16:36, 2012 May 1 (CDT)


* '''Changes Collectors need to know about: '''
* '''Changes Collectors need to know about: '''
** locked Pat_ID field in Form_View, changing Pat_ID was causing errors in checkers; '''unlocked Pat_ID in Patient List instead since it doesn't run chekers. [[User:Ttenbergen|Ttenbergen]] 10:46, 2012 April 12 (CDT)
** locked Pat_ID field in Form_View, changing Pat_ID was causing errors in checkers; '''unlocked Pat_ID in Patient List instead since it doesn't run checkers. [[User:Ttenbergen|Ttenbergen]] 10:46, 2012 April 12 (CDT)
** 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; '''''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 21: Line 248:
** made fields for vars that are no longer used invisible, '''waiting for confirmation if there are more, emailed Trish''' [[User:Ttenbergen|Ttenbergen]] 13:12, 2012 April 12 (CDT)
** made fields for vars that are no longer used invisible, '''waiting for confirmation if there are more, emailed Trish''' [[User:Ttenbergen|Ttenbergen]] 13:12, 2012 April 12 (CDT)
** [[Pharmacy_collection#Data_Integrity_Rules]]
** [[Pharmacy_collection#Data_Integrity_Rules]]
*** removed tab in form_view
*** removed tab in patient viewer form [[User:Ttenbergen|Ttenbergen]] 14:41, 2012 April 12 (CDT)
*** implemented data integrity rules (must have one line, can't have count > (LOS+2)
*** implemented data integrity rules (must have one line, can't have count > (LOS+2)[[User:Ttenbergen|Ttenbergen]] 14:41, 2012 April 12 (CDT)


* Changes behind the scenes
* Changes behind the scenes
Line 30: Line 257:
** moved postal code checks from temp checker into checkforms, will now run based on checkmarks/finalcheck. [[User:Ttenbergen|Ttenbergen]] 12:22, 2012 April 12 (CDT)
** moved postal code checks from temp checker into checkforms, will now run based on checkmarks/finalcheck. [[User:Ttenbergen|Ttenbergen]] 12:22, 2012 April 12 (CDT)
** deleted Pharm form [[User:Ttenbergen|Ttenbergen]] 13:47, 2012 April 12 (CDT)
** deleted Pharm form [[User:Ttenbergen|Ttenbergen]] 13:47, 2012 April 12 (CDT)
** deleted lines to call lab and pharmacy pivoters from sub Pivot_all [[User:Ttenbergen|Ttenbergen]] 14:56, 2012 April 12 (CDT)
** deleted query L_PharmacySort, L_Labsort had already been deleted [[User:Ttenbergen|Ttenbergen]] 14:56, 2012 April 12 (CDT)
** deleted table s_drugs and s_counts [[User:Ttenbergen|Ttenbergen]] 14:56, 2012 April 12 (CDT)


=== ver 2012-04-02 ===
=== ver 2012-04-02 ===
Line 79: 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 102: 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"