CCMDB.mdb Change Log 2011

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-12-14

rolled out Ttenbergen 15:48, 15 December 2011 (CST)

• Increased warning threshold for long-stay units from 70 to 120 daysTtenbergen 10:23, 14 December 2011 (CST)
• fixed output routine for new pharmacy data, all was there except the Pat_ID. Ttenbergen 15:16, 15 December 2011 (CST)

ver 2011-12-13

rolled out Ttenbergen 08:53, 14 December 2011 (CST)

• fixed problem with sending Medicine data; removing the legacy fields broke one of the defaults in the EdsMed query. Ttenbergen 12:59, 13 December 2011 (CST)

ver 2011-12-12

re-rolled out Ttenbergen 17:28, 12 December 2011 (CST)

• new Pharm data was not visible, added L_Pharm_Flowsheet table to DB_Connect() Ttenbergen 11:44, 12 December 2011 (CST)
• fixed output for pharm_flowhseet (broken because drotregin is not there any longer) Ttenbergen 14:20, 12 December 2011 (CST)
• editing the notes box triggered a check of everything because some things depend on notes being present, this generated a Labs error; got rid of error by running only checks related to notes, made notes_checker to do this Ttenbergen 14:20, 12 December 2011 (CST)
• clicking "pick" in DxChooser would cause the OR_Dx check to run before the chosen dx had been written. Changed order, problem fixed. Ttenbergen 14:46, 12 December 2011 (CST)
• fixed problem with data storage in new pharm-flow Ttenbergen 17:28, 12 December 2011 (CST)

ver 2011-12-09

rolled out Ttenbergen 18:07, 11 December 2011 (CST)

Changes relevant to collectors

• changed LOS checking, errors should not come up multiple times any longer (this affects other re-checks as well - let me know if any errors don't list at all nowTtenbergen 15:44, 11 December 2011 (CST)
• changed how errors are displayed, this should reduce or eliminate double-listing of errors in the error box at the bottom of the screen - again, let me know if any errors don't list at all now Ttenbergen 13:53, 11 December 2011 (CST)
• added Compact/repair button - this may speed up your news and backups... Ttenbergen 15:30, 11 December 2011 (CST)
• Pharmacy Collection
  • changed new pharmacy entry for streptomycin; was a duplicate in both aminoglycosides and anti-TB drugs. Discussed with Allan Garland, decided to collect this only in anti-TB drugs. Ttenbergen 16:08, 9 December 2011 (CST)
  • removed drotrecogin from new pharmacy list since it is no longer available Ttenbergen 10:54, 11 December 2011 (CST)
  • changed label for Heparinoids to danaparoid since that's the only one available for now. Ttenbergen 11:00, 11 December 2011 (CST)
• fixed BP Helper (Sub Calc_Helper()); ranges used for Mean BP don't work for decimal point values, so I round the value first now; previously this error would have caused a BP of 92/28 to be listed as AP Score 0 rather than 4.
• checking first and last name to only include letters or hypens now Ttenbergen 16:54, 11 December 2011 (CST)

Background changes

• added "spare1" through "spare6" to L Pharm Flowsheet table.Ttenbergen 11:04, 11 December 2011 (CST)
• changed ARF sending to accomodate new structureTtenbergen 17:29, 11 December 2011 (CST)
• updated import routine for CCMDB_data.mdb_Change_Log#2011-12-11 (Convert_DB, almost same as last one, except ARF)Ttenbergen 18:04, 11 December 2011 (CST)

ver 2011-12-08

rolled out Ttenbergen 19:35, 8 December 2011 (CST)

• added sending for new Pharmacy collection data

ver 2011-12-05

rolled out to all to test the new things Ttenbergen 17:54, 8 December 2011 (CST)

• added pharmacy
  • see tab Pharm_Flow
  • only the first three fields at the top and the corticosteroids field are fully set up to:
    • add one by double-clicking
    • show hints when hovering over

• Added "PC", "PC" to tmp table for postal code collection, have not done any validation coding on it yet.
  • see Postal code collection re when it would be allowed to have no postal code

ver 2011-11-30

rolled out Ttenbergen 15:07, 30 November 2011 (CST)

• Minimal Data Set was not accepting empty Admit Time after recent change, it now accepts blank again. Ttenbergen 15:07, 30 November 2011 (CST)
• another fix for the mindataset, wasn't coping right with admit time = nullTtenbergen 18:17, 30 November 2011 (CST)

ver 2011-11-25

rolled out Ttenbergen 10:51, 28 November 2011 (CST)

• added IICU B5 to Var1/2 Med
  • waiting for confirmation from Julie that this will be OK Ttenbergen 13:14, 25 November 2011 (CST)
  • reverted that update, Julie confirmed that IICU has its own discharge-to, so should not be coded as Var1/2 Ttenbergen 10:47, 28 November 2011 (CST)
• fixed the images output. Again. Ttenbergen 10:47, 28 November 2011 (CST)

ver 2011-11-18

rolled out Ttenbergen 10:27, 24 November 2011 (CST)

Changes Data collectors will want to know about:

• added ADL coding info; double-click on the field and a msgbox will pop up Ttenbergen 12:16, 18 November 2011 (CST)
• changed sorting for the admit_from box to have home show up at top; let me know if it should show up after one of the local spots instead. Ttenbergen 12:19, 18 November 2011 (CST)
• changed dropdown width for sex field, before the dropdown content would not be shown completely Ttenbergen 12:24, 18 November 2011 (CST)
• fixed labels for var1-6 to correspond to program (CC vs Med), this had been broken for a while but I just found out Ttenbergen 12:24, 18 November 2011 (CST)
• added a count of sent records to the msg that shows up when you click "delete sent patients" Ttenbergen
• changed check for minimal dataset to make sure that admit, transfer and discharge are chronological if entered Ttenbergen 13:31, 18 November 2011 (CST)
• changed spelling of dx 19914 from "Interleuken Infusion- monitoring" to "Interleukin infusion monitoring"

changes not relevant to collector interface:

• data export to imaging was just overwriting, ...
  • added imaging.mdb to OpenOutputDBs and CloseOutputDBs (opens as O_Patients_Imaging)Ttenbergen 11:06, 18 November 2011 (CST)
  • made send_imaging query Ttenbergen 11:06, 18 November 2011 (CST)
  • removed old references to L_ALT_LOC from code since variable isn't used any longer Ttenbergen 12:35, 18 November 2011 (CST)
  • deleted old query "1", would have been a test for something that had not been cleaned up. Ttenbergen 15:45, 18 November 2011 (CST)

ver 2011-10-25

rolled out Ttenbergen 15:07, 25 October 2011 (CDT)

• changed drop-down for DeviceUse Study as per discussion with Laura Ttenbergen 15:07, 25 October 2011 (CDT)

ver 2011-10-17

rolled out Ttenbergen 11:20, 17 October 2011 (CDT)

• made changes for pilot for DeviceUse StudyTtenbergen 11:20, 17 October 2011 (CDT)
• made dropdown wider for "item" entry in tmp form Ttenbergen 11:20, 17 October 2011 (CDT)

ver 2011-10-11

Rolled out Ttenbergen 15:34, 13 October 2011 (CDT)

• added Pericardial Tap/Window 76303 to the OR DXs list. Ttenbergen 10:46, 12 October 2011 (CDT)
• added LA2 to the Med Var 2 - Discharge-to Ward and Med Var 1 - Admit-from Ward dropdowns
• removed duplicate GRA S4 from the Med Var 2 - Discharge-to Ward and Med Var 1 - Admit-from Ward dropdowns
• made comorbid list dropdown wider (let Tina know if you want other fields adjusted)Ttenbergen 15:27, 13 October 2011 (CDT)

ver 2011-09-22

rolled out Ttenbergen 12:15, 22 September 2011 (CDT)

• added instructions field to the temp editor Ttenbergen 12:15, 22 September 2011 (CDT)
• set the DeviceUse Study entries to active to test that study Ttenbergen 12:15, 22 September 2011 (CDT)
• confirmed that the item options for temp studies are sorted alphabetically Ttenbergen 12:15, 22 September 2011 (CDT)

ver 2011-09-09

not rolled out yet Ttenbergen 09:49, 9 September 2011 (CDT)

• changed the versioning to draw from table "version" Ttenbergen 09:49, 9 September 2011 (CDT)
• DeviceUse Study items added to s_tmp in ccmdb program master on Regional Server 8 pm. Laura to follow up and review and make changes to S_Tmp table as meetings take place or further clarification are made.
• Tina can show Laura K how to make any further changes, how to make active abd how to roll. The project is not active yet but the plan is to test from CON and STB MICU/CICU Oct 1.11. Laura and Julie to confirm start date. --TOstryzniuk 15:53, 9 September 2011 (CDT)

ver 2011-09-01

rolled out Ttenbergen 14:53, 8 September 2011 (CDT)

• added Trauma Subdural Hematoma - POST OP to Check_ORDx must have got deleted somehow Ttenbergen 16:49, 1 September 2011 (CDT)
• changed dx picker button on Dx form to require adm or acqu in dx type field before opening picker. Picker would give null error if the field was left empty before entering. Ttenbergen 16:55, 1 September 2011 (CDT)
• set following studies to inactive:
  • EuroScore Ttenbergen 18:00, 1 September 2011 (CDT)
  • Early ID study Ttenbergen 14:51, 8 September 2011 (CDT)
  • QASeptic Ttenbergen 14:51, 8 September 2011 (CDT)

ver 2011-08-11

rolled out Ttenbergen 11:17, 15 August 2011 (CDT)

• implemented warning values revised by Julie, Marie, Laura and Tina as per APACHE Scoring table Ttenbergen 16:34, 11 August 2011 (CDT)

ver 2011-08-10

rolled out Ttenbergen 10:14, 10 August 2011 (CDT)

• fixed error msg for 48-hr after admission error for QA Inf. Ttenbergen 10:14, 10 August 2011 (CDT)

ver 2011-08-08

rolled out Ttenbergen 15:19, 8 August 2011 (CDT)

• added RIS/PACS#Data_Acquisition to data being sent Ttenbergen 14:11, 8 August 2011 (CDT)

ver 2011-07-29

rolled out Ttenbergen 15:59, 29 July 2011 (CDT)

• to fix Date change bug I moved the date fields over a few pixels so they no longer are in the same space where the binocular buttons are on the patient list Ttenbergen 15:59, 29 July 2011 (CDT)

ver 2011-07-28

not rolled out yet Ttenbergen 11:57, 28 July 2011 (CDT)

• changed a bunch of docmd.close statements to be specific about what they were closing to prevent some unexpected results I encountered during testing for Date change bug. Ttenbergen 11:57, 28 July 2011 (CDT)
• I had made some change to sub uncheck_reg at some point over the last month or so as part of another fix. I think it is causing problems now, so I am tweaking that again. Ttenbergen 11:57, 28 July 2011 (CDT)
• changed timing of checks on form_view from "beforeupdate" to "afterupdate" and made sure data written first. Ttenbergen 12:27, 28 July 2011 (CDT)

ver 2011-07-25

rolled out Ttenbergen 13:15, 25 July 2011 (CDT)

• made "add patient" button close the patient viewer if currently open; this was necessary since otherwise the patient ID of the currently open patient would be changed, rather than a new patient added. (good catch Elaine!) Ttenbergen 13:15, 25 July 2011 (CDT)

ver 2011-07-21

rolled out Ttenbergen 11:13, 25 July 2011 (CDT)

• adding compensation for CON/COR abnormality Ttenbergen 17:42, 21 July 2011 (CDT)

ver 2011-07-18-3

rolled out Ttenbergen 16:55, 20 July 2011 (CDT)

• error check for discharge-to for expired patients wasn't working right since we changed "Expired - Autopsy" etc to just "Expired"; check works again now. Ttenbergen 16:55, 20 July 2011 (CDT)

ver 2011-07-18-3

rolled out Ttenbergen 15:28, 20 July 2011 (CDT)

• further fix to QA_Infection checking; no date/time must be allowed in order to be able to comply with collection rules as stated. Ttenbergen 15:28, 20 July 2011 (CDT)

ver 2011-07-18-2

rolled out Ttenbergen 15:22, 20 July 2011 (CDT)

• fixed some problems with the computer name adder...
• fix to QA_Infection#DtTm_has_to_be_min_48hrs_after_admission to allow 0 inf_date since no inf_date should be entered if infection present at admission.

ver 2011-07-18

rolled out Ttenbergen 12:34, 20 July 2011 (CDT)

• fixed bug where not having XBR or BRR for an arrest patient would not allow opening that patient (error routine crashed)Ttenbergen 12:01, 20 July 2011 (CDT)
• fixed query s_tmp_QAInf_LT_48_hrs_after_admit so it will cope properly with null values Ttenbergen 12:06, 20 July 2011 (CDT)
• added code to the Main form opener to automatically add the computer name to the A_Info table; we intermittently need this info, and this way we will have it without having to talk to collectors Ttenbergen 12:32, 20 July 2011 (CDT)

ver 2011-07-13

rolled out Ttenbergen 14:50, 15 July 2011 (CDT)

• added +, - and * (today) buttons to facilitate entering Admit, Transfer and Discharge times
  • Joyce had asked for default dates, didn't do those to reduce errors when someone forgets to update the dates
• changed alignment to "left" for columns "Notes" and "Chart" in Patient List
• changed priority checking for Pharmacy so there should not be so many "gophers"
• moved date validation to later in the check process so that the Long Stay warnings won't push other warnings off the screen.
• changed Location field in Patient Viewer to pull from s_locations_local, which only lists locations applicable for the collector's site
• changed instructions for the mBP in BP-calculator to recommend 120/80 instead of a midpoint
• XBR/BRR error wasn't highlighting cells, is now
• fix for Accidental scrolling off the Patient View screen
• improved error checking and msgs for adding patients (e.g. no ID added, ID already exists)
• checking for QA_Infection#DtTm_has_to_be_min_48hrs_after_admission using new query s_tmp_QAInf_LT_48_hrs_after_admit

ver 2011-07-06

rolled out Ttenbergen 13:16, 6 July 2011 (CDT)

• made Von Willebrand Disease collectable as diagnosis.

ver 2011-06-03

rolled out Ttenbergen 11:20, 3 June 2011 (CDT)

• fixed ER Wait

ver 2011-06-02

rolled out Ttenbergen 17:54, 2 June 2011 (CDT)

• fixed FIO2 80 ventilated 85 Vent to 80 ventilated 80 Vent Ttenbergen 15:22, 2 June 2011 (CDT)
• added ER Wait Ttenbergen 17:46, 2 June 2011 (CDT)

ver 2011-05-04

rolled out Ttenbergen 20:20, 31 May 2011 (CDT)

Changes that you might come across: '

• Some APACHE fields and some fields in the ABG and BP calculators would cause errors if the contents were deleted (they default to 0). I changed the fields to not allow blank entries. If anyone comes across an APACHE field that allows a blank, please let me know. Ttenbergen 11:08, 4 May 2011 (CDT)
• The S_drugs table that populates the dropdown in the Pharmacy tab had some extra entries. There are some entries that are there for legacy reasons, but are hidden from the dropdown. Made sure that all illegitimate duplicates are also hidden from dropdown. By hiding them, existing pharmacy entries should not be affected, but it should be impossible to set new pharmacy entries to those duplicate drug entries from now on. Affected drugs were
  • Cipro IV400 mg (set to legacy; Cipro IV 400 mg remains)
  • Metoprolol Tab 25 mg (reinstated, had been set to legacy but no correct twin was available)
  • Metoprolol Tab 75mg (set to legacy; Metoprolol Tab 75 mg remains)
  • Metoprolol Tab 125mg (set to legacy; Metoprolol Tab 125mg remains)
• added checks to improve validating Transfer Ready date and time
  • a blank transfer date will be flagged under some circumstances Ttenbergen 15:25, 4 May 2011 (CDT)
  • a blank transfer time will no longer be accepted if a transfer date is present Ttenbergen 15:25, 4 May 2011 (CDT)
• Re-enabled the QA_Infection integrity checks; they had got disabled because the end date had passed, fixed. Ttenbergen 16:37, 4 May 2011 (CDT)
• added check such that inconsistent tmp entries (e.g. Item for a different Project) will be disallowed Ttenbergen 16:52, 4 May 2011 (CDT)
• fixed the check that makes sure that entries for the Critical Care QAInf project are within the patient stay Ttenbergen 17:07, 4 May 2011 (CDT)
• Confirmed that there is a working check that Moves for Medicine times are between admit and discharge Ttenbergen 17:23, 4 May 2011 (CDT)
• Adding extreme APACHE checking. Ttenbergen 16:23, 9 May 2011 (CDT)
• changed View form by disallowing addition of records within form to prevent scrolling to new patient. Ttenbergen 12:04, 10 May 2011 (CDT)
• fixed and enabled code to convert to new data structure CCMDB_data.mdb_Change_Log#2011-05-13 Ttenbergen 16:01, 13 May 2011 (CDT)
• fixed mBP ApScore so BP <=49 is 4 points. Ttenbergen 17:01, 13 May 2011 (CDT)
• fixed BP Helper so it can store the ApPts Ttenbergen 17:16, 13 May 2011 (CDT)
• changed placeholder characters for any dates from _ to x to make it easier to see what the format should be Ttenbergen 20:17, 31 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.accdb 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:

• added a check to disallow sending if Registry Patient Type is not entered Ttenbergen 14:27, 21 April 2011 (CDT)

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 Function 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 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)

• added 'OVZ' to var 5 med as per Med_Var_5.

ver 2011-01-24

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

• added more fields for Early ID study Ttenbergen 16:26, 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)

• added GRA_Over to locations Ttenbergen 18:10, 5 January 2011 (CST)
• tweaked MR List Ttenbergen 18:10, 5 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)