CCMDB.mdb Change Log 2011

From CCMDB Wiki
Jump to navigation Jump to search

see the Development Documentation Category for other development logs

The CCMDB.mdb Change Log logs changes made to the CCMDB.mdb. New entries should be made at the top to be immediately apparent.

Enter requested CCMDB changes for the next version in that article.

Versions

ver 2011-05-04

not rolled out yet Ttenbergen 10:59, 4 May 2011 (CDT)

  • some Apache values were slipping through the cracks when the default 0 is deleted; changed the fields to validate that blanks are not allowed. Ttenbergen 11:08, 4 May 2011 (CDT)
    • same change made to BP and ABG forms Ttenbergen 11:08, 4 May 2011 (CDT)

ver 2011-04-27

rolled out Ttenbergen 14:48, 27 April 2011 (CDT)

  • changed how the keyboard shortcuts are labelled in
    • Temp studies - put the labels on the header row
    • Dx Tab - made font bigger
    • Labs tab - put the labels on the header row

ver 2011-04-21

rolled out Ttenbergen 11:29, 26 April 2011 (CDT)

Changes collectors should know about:

  • changed default sort order of patient list to descending Pat_ID as requested by several collectors Ttenbergen 15:16, 21 April 2011 (CDT)
  • added CCMDB.mdb keyboard shortcuts Ttenbergen 17:29, 21 April 2011 (CDT)
    • added close button to enable key-only operation and fixed tab order in AADO2 and BP forms.
  • reverted patient list pick button and viewer close button functionality to what it was before changes earlier this month: this means sort order of patient list will be preserved in between patients again Ttenbergen 15:29, 21 April 2011 (CDT)
  • increased the space for the chart number on the MR Lists Ttenbergen 15:21, 21 April 2011 (CDT)
  • added KA (Oaks Ambulatory Care) to admit/discharge list Ttenbergen 14:27, 21 April 2011 (CDT)

Changes collectors may come across:

ver 2011-04-19

rolled out Ttenbergen 12:15, 19 April 2011 (CDT)

What this means to data collectors:

When the tmp checker button was pressed there was an error about a location not being entered for a patient when there really was no problem with the data. This update fixed that problem. Ttenbergen 12:15, 19 April 2011 (CDT)

changes

  • tmp checker was running into an error because it tried to get the location from the form, not from the table. No idea why this came up now, as I have not changed anything about this lately. Seems to be fixed now with changing how program looks for location. Ttenbergen 12:15, 19 April 2011 (CDT)

ver 2011-04-18

rolled out Ttenbergen 15:49, 18 April 2011 (CDT)

  • WBC would let through a blank (would appropriately give error for a 0); changed program to disallow blank WBC, will ask to put in 0 if not known yet. Also disallowed blanks for the other non-zero apache values SysBP, RR and HR. Ttenbergen 15:49, 18 April 2011 (CDT)

ver 2011-04-05-2

rolled out Ttenbergen 18:54, 5 April 2011 (CDT)

  • in viewer, moved code to open the patientlist from close button to close event. Ttenbergen 18:52, 5 April 2011 (CDT)
  • added hint text to the re-sort button in the diagnosis list and como list Ttenbergen

ver 2011-04-05

rolled out Ttenbergen 15:30, 5 April 2011 (CDT)

  • fixed/removed an error in FinalCheck_Click that was pushed forward by the Explicit statement Ttenbergen 15:30, 5 April 2011 (CDT)

ver 2011-03-29

rolled out Ttenbergen 10:09, 5 April 2011 (CDT)

  • increased font size for notes section to 14 Ttenbergen 11:44, 29 March 2011 (CDT)
  • added dt +/- for labs Ttenbergen 14:06, 1 April 2011 (CDT)
  • changed input template/format for date in labs so dashes don't need to be entered Ttenbergen 14:16, 1 April 2011 (CDT)
  • added keyboard shortcuts to the main screen to open the patient list (alt-p) or to send (alt-s) Ttenbergen 14:26, 1 April 2011 (CDT)
  • moved pH hints box so clicking on it will work (was partly hidden behind "}") Ttenbergen 15:32, 1 April 2011 (CDT)
  • changed viewer form to not allow addition to stop it from scrolling to blank Ttenbergen 15:34, 1 April 2011 (CDT)
  • automatically maximize patient window when opening from patientlist Ttenbergen 15:48, 1 April 2011 (CDT)
  • automatically close/hide toolbars when starting the program Ttenbergen 15:48, 1 April 2011 (CDT)
  • added "option explicit" to remaining forms Ttenbergen 16:49, 1 April 2011 (CDT)
  • removed temp checker from final-check checks since it applies to all patients, not only the current one. Temp checker will still run at send time or if the pre checker button is pressed. Ttenbergen 10:57, 4 April 2011 (CDT)
  • added a "requery" to the labs form to fix problem where mouse wheel would scroll down but not back up Ttenbergen 11:35, 4 April 2011 (CDT)
  • changed apache midpoint statement in hints Ttenbergen 17:16, 4 April 2011 (CDT)
  • removed left-over code references to serurea, urineoutput, dbili Ttenbergen 17:22, 4 April 2011 (CDT)
  • changed name of No Culture Sent or Resulted Ttenbergen 17:26, 4 April 2011 (CDT)

ver 2011-03-23

rolled out. Ttenbergen 14:44, 23 March 2011 (CDT)

  • after update, program wasn't allowing to check tmp checkbox if there were ANY errors in tmpchecker. Removed the check for now. Need to fix the check later. Ttenbergen 14:31, 23 March 2011 (CDT)

ver 2011-02-16

rolled out to rest Ttenbergen 11:40, 23 March 2011 (CDT)

test rolled out to HSC, StB E5 and OAKs. Ttenbergen 22 March 2011 (CDT)

  • fixed ABG scoring; numbers were not being applied after using the picker, or at all for the non-ph values Ttenbergen 14:29, 16 February 2011 (CST)
  • added a dirty = false when opening pt from patientlist to make sure that all changes in form are written before the data is opened in viewer Ttenbergen 14:32, 23 February 2011 (CST)
  • changed the labs on-update procedures. had set up some code earlier to make the cursor come to the latest file on the list upon update. Turns out that meant that, if you clicked into a new line, it would put you to the date field of the last line instead, leading you to accidentally enter there. I had added the code to ensure that the sum gets updated. Removed the code and put a 'Recalc' button next to the sum instead to force the recalc if desired. Ttenbergen 15:17, 23 February 2011 (CST)
  • updated Tmp_Checker to disallow apostrophes in comment box since they break the program. Ttenbergen 16:50, 23 February 2011 (CST)
  • Fixed MR list to sort by PatID, added second button for an MR list by Ln, Fn Ttenbergen 17:43, 23 February 2011 (CST)
  • finished implementing BP calculator form Ttenbergen 16:03, 24 February 2011 (CST)
  • moved the ARF checkbox next to the creatinine value on the APACHE form, since the two are related and since the creatinine Apache score depends on the ARF, fixed value, added criteria when to set ARF to yes. Ttenbergen 16:23, 24 February 2011 (CST)
  • changed width of var field dropdown description column to fit content. Ttenbergen 10:19, 25 February 2011 (CST)
  • Changed hints for Apache values, added midpoints: NA, WBC, HR, RR 18, Temp, mean BP, CO2, Hct, K, Cr Ttenbergen 10:34, 25 February 2011 (CST)
  • when opening Patient from Patientlist, the focus will go to errBox now; this was changed to protect the serial numbers, since people were accidentally editing them when first opening a patient. Ttenbergen 10:54, 25 February 2011 (CST)
  • Added location and program fields to S Tmp table and changed the dropdowns in tmp to be able to limit what shows upTtenbergen 12:51, 25 February 2011 (CST)
  • deleted queries that were remnant from old labs system and conversion Ttenbergen 13:02, 25 February 2011 (CST)
    • L_Labsort
    • ztmp_finalcheck_to_recordstatus
    • x_conv_L_settings_to_A_Info_int
    • x_conv_L_settings_to_A_Info
    • x_conv_L_Labs_to_L_Labs_Flowsheet
  • made converter from the old DB structure to the new
  • fixing data change issues
    • chart#, record dropdown in PatientList form
    • chart# in patientlist query
    • chart# and dc_treat in EdsCC and EdsMed
    • chart# in minimal_data_set_incomplete
    • record dropdown in View
    • sl_records in settings form
  • deleted "comp old new como" query, unused legacy Ttenbergen 17:45, 25 February 2011 (CST)
  • deleted "PathogenLinker" query, was broken unrelated to current changes, since it has not given an error I assume it's not used Ttenbergen 17:48, 25 February 2011 (CST)
  • fixed AP_Age for no DOB
  • changed AdDt_combined to default to "now" if not entered Ttenbergen 18:02, 25 February 2011 (CST)
  • added JKL3 (burn unit) to Var1/2 options
  • added "explicit" setting to options, which forces declaration of variables and reduces errors due to misspelled vars. (sometime in March)

ver 2011-02-04

rolled out Ttenbergen 16:06, 4 February 2011 (CST)

  • changed the early ID entries by adding numbers so they will list in a sensible order; updated Early ID study with new names.
  • changed temp item dropdown in tmpv2_editor to list items alphabetically, made fields wider. Ttenbergen 16:06, 4 February 2011 (CST)

ver 2011-01-28

rolled out Ttenbergen 16:13, 28 January 2011 (CST)

  • added Arsenic poisoning (49922) to s_alldiagnosis table Ttenbergen 15:33, 28 January 2011 (CST)
  • changed colonization dxs to make them easier to enter and review Ttenbergen 15:46, 28 January 2011 (CST)
    • eliminated generic 9900, Trish said without organizm it's not much use to enter it at all
    • VRE Colonization (without Infection)
    • ESBL Colonization (without Infection)
    • MRSA Colonization (without Infection)

ver 2011-01-26

rolled out Ttenbergen 10:08, 26 January 2011 (CST)

ver 2011-01-24

rolled out Ttenbergen 17:04, 24 January 2011 (CST)

ver 2011-01-18

rolled out Ttenbergen 16:07, 20 January 2011 (CST)

  • fixed sorting buttons for room field on Patient List Ttenbergen 16:29, 18 January 2011 (CST)
  • fixed ABG checker error that record must be present Ttenbergen 16:39, 18 January 2011 (CST)
  • fixed labs sums for blood and sputum, had been switched (no effect on output) Ttenbergen 16:39, 18 January 2011 (CST)
  • made last line active in labs upon opening form
  • made labs sorted by date
  • made sure all "set"s are followed by "set"s to nothing (maybe this will fix the add patient bug?) Ttenbergen 13:30, 19 January 2011 (CST)
  • fixed error in query s_tmp_PtReqMoveMissing that would have failed if no location was entered Ttenbergen 14:20, 19 January 2011 (CST)
    • this should also fix the problem where Deb didn't get a helpful error if she did not have a location entered.
  • fixed problem where "L" on patient viewer was yellow even if there were no lab problems Ttenbergen 14:20, 19 January 2011 (CST)
  • confirmed that there is a warning when trying to delete a line of labs Ttenbergen 14:21, 19 January 2011 (CST)
  • changed MR list to add and sort by Pat_ID, removed site/location as discussed in MR List Ttenbergen 14:25, 19 January 2011 (CST)
  • commented out all migration code and removed "sputums" button Ttenbergen 12:23, 20 January 2011 (CST)
  • removed StB CVICU and MICU from restriction that doesn't let ICU send to ICU. Ttenbergen 15:24, 20 January 2011 (CST)

ver 2011-01-17

rolled out Ttenbergen 14:54, 17 January 2011 (CST)

  • changed queries for Pagasa and Julie's pending output to list admit dates without times as just the date. Ttenbergen 14:54, 17 January 2011 (CST)

ver 2011-01-12-2

rolled out Ttenbergen 11:31, 12 January 2011 (CST)

  • further lab tweak Ttenbergen 11:31, 12 January 2011 (CST)

ver 2011-01-12

rolled out Ttenbergen 10:47, 12 January 2011 (CST)

  • correcting lab checking and sending so that "no labs" can be sent but is error checked.
  • changed lab check function to not let no labs through Ttenbergen 10:44, 12 January 2011 (CST)
  • fixed EdsCC query to not omit pts with no labs (even if that should no longer be possible) Ttenbergen 10:46, 12 January 2011 (CST)

ver 2011-01-06

rolled out yet Ttenbergen 13:31, 6 January 2011 (CST)

ver 2011-01-05

rolled out Ttenbergen 14:53, 5 January 2011 (CST)

  • re-aligned labels for lab flowsheets, Pentaspan/Voluven was not lining up Ttenbergen 10:42, 5 January 2011 (CST)
  • changed row height to fix scrolling in lab flowsheets. Ttenbergen 12:18, 5 January 2011 (CST)
  • fixed ABG wizard (wasn't entering patient ID into new records and failing) Ttenbergen 14:37, 5 January 2011 (CST)

ver 2011-01-04-3

rolled out Ttenbergen 19:32, 4 January 2011 (CST)

  • fixed tab order in Labs flowsheet Ttenbergen 14:03, 4 January 2011 (CST)
  • changed lab flosheet to update the sum upon every update (so you don't have to leave the record to update)Ttenbergen 14:03, 4 January 2011 (CST)
  • moved the spot in which the sputums query displays (was showing way at the bottom of the screen) Ttenbergen 15:59, 4 January 2011 (CST)
  • error logging...
    • disabled logging of "empty" errors as they are too common and not usually real errors. Ttenbergen 14:06, 4 January 2011 (CST)
    • fixed one entry error for pharmacy by removing "s from the error msg. Ttenbergen 15:59, 4 January 2011 (CST)
    • disabled error logging until I can resolve what is going wrong with it. Ttenbergen 19:00, 4 January 2011 (CST)
  • fixed sent report to work with the record set to "sent" rather than final_check. Ttenbergen 19:00, 4 January 2011 (CST)

ver 2011-01-04-2

rolled out. Ttenbergen 11:22, 4 January 2011 (CST)

  • fixed problem where the reg_complete checker could not process the new plain "expire" setting. Ttenbergen 11:16, 4 January 2011 (CST)
  • fixed error in lab_checks Ttenbergen 11:21, 4 January 2011 (CST)

ver 2011-01-04

Rolled out. Ttenbergen 11:04, 4 January 2011 (CST)

  • fixed import problem for labs where sputum wasn't being imported (ie for those who have not imported yet, sputums will import.
  • added a "sputums" button to the main screen in the interrim so that old sputums can be accessed to be copied across; putting notice about this on the Main Page. Ttenbergen 11:04, 4 January 2011 (CST)

ver 2011-01-03

Rolled out. Ttenbergen 17:18, 3 January 2011 (CST)

  • fixed pre-existing error in apache age function that somehow got brought up by other changes. Ttenbergen 15:40, 3 January 2011 (CST)
  • added routine to set "record" to "Sent" and "finalcheck" to "false" for sent patients at end of a successful send Ttenbergen 15:46, 3 January 2011 (CST)
  • changed "Delete FinalCheckeds" button to "Delete Sent Patients". Ttenbergen 15:58, 3 January 2011 (CST)
  • changed conversion routine so it would not try to re-convert those who already converted if this program is started. Ttenbergen 17:18, 3 January 2011 (CST)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2011&oldid=23622"