CCMDB.mdb Change Log 2011: Difference between revisions

(142 intermediate revisions by 2 users not shown)

Line 6:

== Versions ==

=== ver 2011-12-14 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:48, 15 December 2011 (CST)

* Increased warning threshold for long-stay units from 70 to 120 days[[User:Ttenbergen|Ttenbergen]] 10:23, 14 December 2011 (CST)

* fixed output routine for new pharmacy data, all was there except the Pat_ID. [[User:Ttenbergen|Ttenbergen]] 15:16, 15 December 2011 (CST)

=== ver 2011-12-13 ===

rolled out [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 12:59, 13 December 2011 (CST)

=== ver 2011-12-12 ===

re-rolled out [[User:Ttenbergen|Ttenbergen]] 17:28, 12 December 2011 (CST)

* new Pharm data was not visible, added L_Pharm_Flowsheet table to DB_Connect() [[User:Ttenbergen|Ttenbergen]] 11:44, 12 December 2011 (CST)

* fixed output for pharm_flowhseet (broken because drotregin is not there any longer) [[User:Ttenbergen|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 [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 14:46, 12 December 2011 (CST)

* fixed problem with data storage in new pharm-flow [[User:Ttenbergen|Ttenbergen]] 17:28, 12 December 2011 (CST)

=== ver 2011-12-09 ===

rolled out [[User:Ttenbergen|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 now'''[[User:Ttenbergen|Ttenbergen]] 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''' [[User:Ttenbergen|Ttenbergen]] 13:53, 11 December 2011 (CST)

* added '''Compact/repair button''' - this may speed up your news and backups... [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:08, 9 December 2011 (CST)

** removed drotrecogin from new pharmacy list since it is no longer available [[User:Ttenbergen|Ttenbergen]] 10:54, 11 December 2011 (CST)

** changed label for Heparinoids to danaparoid since that's the only one available for now. [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 16:54, 11 December 2011 (CST)

====Background changes====

* added "spare1" through "spare6" to [[L Pharm Flowsheet]] table.[[User:Ttenbergen|Ttenbergen]] 11:04, 11 December 2011 (CST)

* changed ARF sending to accomodate new structure[[User:Ttenbergen|Ttenbergen]] 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)[[User:Ttenbergen|Ttenbergen]] 18:04, 11 December 2011 (CST)

=== ver 2011-12-08 ===

rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 15:07, 30 November 2011 (CST)

* [[Minimal Data Set]] was not accepting empty Admit Time after recent change, it now accepts blank again. [[User:Ttenbergen|Ttenbergen]] 15:07, 30 November 2011 (CST)

* another fix for the mindataset, wasn't coping right with admit time = null[[User:Ttenbergen|Ttenbergen]] 18:17, 30 November 2011 (CST)

=== ver 2011-11-25 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 10:51, 28 November 2011 (CST)

* added IICU B5 to Var1/2 Med

** waiting for confirmation from Julie that this will be OK [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 10:47, 28 November 2011 (CST)

* fixed the images output. Again. [[User:Ttenbergen|Ttenbergen]] 10:47, 28 November 2011 (CST)

=== ver 2011-11-18 ===

rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 12:19, 18 November 2011 (CST)

* changed dropdown width for sex field, before the dropdown content would not be shown completely [[User:Ttenbergen|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 [[User:Ttenbergen|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" [[User:Ttenbergen|Ttenbergen]]

* changed check for minimal dataset to make sure that admit, transfer and discharge are chronological if entered [[User:Ttenbergen|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)[[User:Ttenbergen|Ttenbergen]] 11:06, 18 November 2011 (CST)

** made send_imaging query [[User:Ttenbergen|Ttenbergen]] 11:06, 18 November 2011 (CST)

** removed old references to L_ALT_LOC from code since variable isn't used any longer [[User:Ttenbergen|Ttenbergen]] 12:35, 18 November 2011 (CST)

** deleted old query "1", would have been a test for something that had not been cleaned up. [[User:Ttenbergen|Ttenbergen]] 15:45, 18 November 2011 (CST)

=== ver 2011-10-25 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:07, 25 October 2011 (CDT)

* changed drop-down for [[DeviceUse Study]] as per discussion with Laura [[User:Ttenbergen|Ttenbergen]] 15:07, 25 October 2011 (CDT)

=== ver 2011-10-17 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:20, 17 October 2011 (CDT)

* made changes for pilot for [[DeviceUse Study]][[User:Ttenbergen|Ttenbergen]] 11:20, 17 October 2011 (CDT)

* made dropdown wider for "item" entry in tmp form [[User:Ttenbergen|Ttenbergen]] 11:20, 17 October 2011 (CDT)

=== ver 2011-10-11 ===

Rolled out [[User:Ttenbergen|Ttenbergen]] 15:34, 13 October 2011 (CDT)

* added Pericardial Tap/Window 76303 to the OR DXs list. [[User:Ttenbergen|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)'''[[User:Ttenbergen|Ttenbergen]] 15:27, 13 October 2011 (CDT)

=== ver 2011-09-22 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)

* added instructions field to the temp editor [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)

* set the [[DeviceUse Study]] entries to active to test that study [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)

* confirmed that the item options for temp studies are sorted alphabetically [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)

=== ver 2011-09-09 ===

not rolled out yet [[User:Ttenbergen|Ttenbergen]] 09:49, 9 September 2011 (CDT)

* changed the versioning to draw from table "version" [[User:Ttenbergen|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. --[[User:TOstryzniuk|TOstryzniuk]] 15:53, 9 September 2011 (CDT)

=== ver 2011-09-01 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 14:53, 8 September 2011 (CDT)

* added Trauma [[Subdural Hematoma - POST OP]] to [[Check_ORDx]] must have got deleted somehow [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:55, 1 September 2011 (CDT)

* set following studies to inactive:

** [[EuroScore]] [[User:Ttenbergen|Ttenbergen]] 18:00, 1 September 2011 (CDT)

** [[Early ID study]] [[User:Ttenbergen|Ttenbergen]] 14:51, 8 September 2011 (CDT)

** [[QASeptic]] [[User:Ttenbergen|Ttenbergen]] 14:51, 8 September 2011 (CDT)

=== ver 2011-08-11 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:17, 15 August 2011 (CDT)

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

=== ver 2011-08-10 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 10:14, 10 August 2011 (CDT)

* fixed error msg for 48-hr after admission error for QA Inf. [[User:Ttenbergen|Ttenbergen]] 10:14, 10 August 2011 (CDT)

=== ver 2011-08-08 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 15:19, 8 August 2011 (CDT)

* added [[RIS/PACS#Data_Acquisition]] to data being sent [[User:Ttenbergen|Ttenbergen]] 14:11, 8 August 2011 (CDT)

=== ver 2011-07-29 ===

rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 15:59, 29 July 2011 (CDT)

=== ver 2011-07-28 ===

not rolled out yet [[User:Ttenbergen|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]]. [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 11:57, 28 July 2011 (CDT)

* changed timing of checks on form_view from "beforeupdate" to "afterupdate" and made sure data written first. [[User:Ttenbergen|Ttenbergen]] 12:27, 28 July 2011 (CDT)

=== ver 2011-07-25 ===

rolled out [[User:Ttenbergen|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!) [[User:Ttenbergen|Ttenbergen]] 13:15, 25 July 2011 (CDT)

=== ver 2011-07-21 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:13, 25 July 2011 (CDT)

* adding compensation for CON/COR abnormality [[User:Ttenbergen|Ttenbergen]] 17:42, 21 July 2011 (CDT)

=== ver 2011-07-18-3 ===

rolled out [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:55, 20 July 2011 (CDT)

===ver 2011-07-18-3 ===

rolled out [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 15:28, 20 July 2011 (CDT)

===ver 2011-07-18-2 ===

rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|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)[[User:Ttenbergen|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 [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 12:32, 20 July 2011 (CDT)

=== ver 2011-07-13 ===

rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 13:16, 6 July 2011 (CDT)

* made [[Von Willebrand Disease]] collectable as diagnosis.

=== ver 2011-06-03 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 11:20, 3 June 2011 (CDT)

*fixed [[ER Wait]]

=== ver 2011-06-02 ===

rolled out [[User:Ttenbergen|Ttenbergen]] 17:54, 2 June 2011 (CDT)

* fixed FIO2 80 ventilated 85 Vent to 80 ventilated 80 Vent [[User:Ttenbergen|Ttenbergen]] 15:22, 2 June 2011 (CDT)

* added [[ER Wait]] [[User:Ttenbergen|Ttenbergen]] 17:46, 2 June 2011 (CDT)

=== ver 2011-05-04 ===

~~not~~ rolled out ~~yet~~ [[User:Ttenbergen|Ttenbergen]] 10:59, 4 May 2011 (CDT)

rolled out [[User:Ttenbergen|Ttenbergen]] 20:20, 31 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~~. ~~[[User:Ttenbergen|Ttenbergen]] 11:08~~, ~~4 May 2011 (CDT)~~

'''Changes that you might come across: ''''

** same change made to BP and ABG forms [[User:Ttenbergen|Ttenbergen]] 11:08, 4 May 2011 (CDT)

* 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. [[User:Ttenbergen|Ttenbergen]] 11:08, 4 May 2011 (CDT)

* ~~s_drugs~~ table ~~consolidation -~~ There are some ~~duplicate/misspelled~~ entries ~~in the s_drugs table. The way they represent in the sent data is the same~~ for ~~both of a given version. In many cases the duplicates where generated when I added a second space to the most common set of options so they would sort to~~ the ~~top~~. ~~In order to not cause problems with already entered data in those cases the~~ duplicates are ~~already set to "legacy"~~, ~~meaning they don't show up in the dropdowns for any new~~ entries~~. They were retained in the table in case there are long stay patients. I don't think~~ it~~'s worth managing when~~ to ~~delete them since they don't have an impact. There were a few other oddities that were not~~ set to ~~legacy before, and that I am setting to legacy~~ now~~, namely:~~

* 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 [[~~Admit%2C_Transfer_and_Discharge_date_and_time~~#~~Transfer_Date_and_Time~~]]

* added checks to improve validating [[Transfer Ready date and time]]

** a blank transfer date will be flagged under some circumstances [[User:Ttenbergen|Ttenbergen]] 15:25, 4 May 2011 (CDT)

** a blank transfer time will no longer be accepted if a transfer date is present [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:37, 4 May 2011 (CDT)

* added check such that inconsistent tmp entries (e.g. Item for a different Project) will be disallowed [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 17:07, 4 May 2011 (CDT)

* Confirmed that there is a working check that '''[[Moves for Medicine]]''' times are between admit and discharge [[User:Ttenbergen|Ttenbergen]] 17:23, 4 May 2011 (CDT)

* Adding extreme APACHE checking. [[User:Ttenbergen|Ttenbergen]] 16:23, 9 May 2011 (CDT)

* changed View form by disallowing addition of records within form to prevent scrolling to new patient. [[User:Ttenbergen|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]] [[User:Ttenbergen|Ttenbergen]] 16:01, 13 May 2011 (CDT)

* fixed mBP ApScore so BP <=49 is 4 points. [[User:Ttenbergen|Ttenbergen]] 17:01, 13 May 2011 (CDT)

* fixed BP Helper so it can store the ApPts [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 20:17, 31 May 2011 (CDT)

=== ver 2011-04-27 ===

Line 30:

Line 241:

'''Changes collectors should know about:'''

* '''changed default sort order''' of patient list to descending Pat_ID as requested by several collectors [[User:Ttenbergen|Ttenbergen]] 15:16, 21 April 2011 (CDT)

* added '''[[CCMDB.~~mdb~~ keyboard shortcuts]]''' [[User:Ttenbergen|Ttenbergen]] 17:29, 21 April 2011 (CDT)

* added '''[[CCMDB.accdb keyboard shortcuts]]''' [[User:Ttenbergen|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''' [[User:Ttenbergen|Ttenbergen]] 15:29, 21 April 2011 (CDT)

Line 85:

Line 296:

rolled out. [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 14:31, 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. [[User:Ttenbergen|Ttenbergen]] 14:31, 23 March 2011 (CDT)

=== ver 2011-02-16 ===

Line 102:

Line 313:

* Changed hints for Apache values, added midpoints: NA, WBC, HR, RR 18, Temp, mean BP, CO2, Hct, K, Cr [[User:Ttenbergen|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. [[User:Ttenbergen|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 up[[User:Ttenbergen|Ttenbergen]] 12:51, 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 up[[User:Ttenbergen|Ttenbergen]] 12:51, 25 February 2011 (CST)

* deleted queries that were remnant from old labs system and conversion [[User:Ttenbergen|Ttenbergen]] 13:02, 25 February 2011 (CST)

** L_Labsort

Line 121:

Line 332:

* fixed AP_Age for no DOB

* changed AdDt_combined to default to "now" if not entered [[User:Ttenbergen|Ttenbergen]] 18:02, 25 February 2011 (CST)

* added JKL3 (burn unit) to ~~Var1~~/2 ~~options~~

* added [[HSC JK3|JKL3]] (burn unit) to [[Var 1 - Admit-from Ward]]/[[Var 2 - Discharge-to Ward]]

* added "explicit" setting to options, which forces declaration of variables and reduces errors due to misspelled vars. (sometime in March)

Line 215:

Line 426:

* changed conversion routine so it would not try to re-convert those who already converted if this program is started. [[User:Ttenbergen|Ttenbergen]] 17:18, 3 January 2011 (CST)

[[Category: ~~IT Instructions]]~~

[[Category:CCMDB.accdb]]

~~[[Category: Development Documentation~~]]

[[Category:Change Logs CCMDB]]

[[Category: Change Logs CCMDB]]

@@ Line 6: / Line 6: @@
 == Versions ==
+=== ver 2011-12-14 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:48, 15 December 2011 (CST)
+* Increased warning threshold for long-stay units from 70 to 120 days[[User:Ttenbergen|Ttenbergen]] 10:23, 14 December 2011 (CST)
+* fixed output routine for new pharmacy data, all was there except the Pat_ID. [[User:Ttenbergen|Ttenbergen]] 15:16, 15 December 2011 (CST)
+=== ver 2011-12-13 ===
+rolled out [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 12:59, 13 December 2011 (CST)
+=== ver 2011-12-12 ===
+re-rolled out [[User:Ttenbergen|Ttenbergen]] 17:28, 12 December 2011 (CST)
+* new Pharm data was not visible, added L_Pharm_Flowsheet table to DB_Connect() [[User:Ttenbergen|Ttenbergen]] 11:44, 12 December 2011 (CST)
+* fixed output for pharm_flowhseet (broken because drotregin is not there any longer) [[User:Ttenbergen|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 [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 14:46, 12 December 2011 (CST)
+* fixed problem with data storage in new pharm-flow [[User:Ttenbergen|Ttenbergen]] 17:28, 12 December 2011 (CST)
+=== ver 2011-12-09 ===
+rolled out [[User:Ttenbergen|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 now'''[[User:Ttenbergen|Ttenbergen]] 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''' [[User:Ttenbergen|Ttenbergen]] 13:53, 11 December 2011 (CST)
+* added '''Compact/repair button''' - this may speed up your news and backups... [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:08, 9 December 2011 (CST)
+** removed drotrecogin from new pharmacy list since it is no longer available [[User:Ttenbergen|Ttenbergen]] 10:54, 11 December 2011 (CST)
+** changed label for Heparinoids to danaparoid since that's the only one available for now. [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 16:54, 11 December 2011 (CST)
+====Background changes====
+* added "spare1" through "spare6" to [[L Pharm Flowsheet]] table.[[User:Ttenbergen|Ttenbergen]] 11:04, 11 December 2011 (CST)
+* changed ARF sending to accomodate new structure[[User:Ttenbergen|Ttenbergen]] 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)[[User:Ttenbergen|Ttenbergen]] 18:04, 11 December 2011 (CST)
+=== ver 2011-12-08 ===
+rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 15:07, 30 November 2011 (CST)
+* [[Minimal Data Set]] was not accepting empty Admit Time after recent change, it now accepts blank again. [[User:Ttenbergen|Ttenbergen]] 15:07, 30 November 2011 (CST)
+* another fix for the mindataset, wasn't coping right with admit time = null[[User:Ttenbergen|Ttenbergen]] 18:17, 30 November 2011 (CST)
+=== ver 2011-11-25 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:51, 28 November 2011 (CST)
+* added IICU B5 to Var1/2 Med
+** waiting for confirmation from Julie that this will be OK [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 10:47, 28 November 2011 (CST)
+* fixed the images output. Again. [[User:Ttenbergen|Ttenbergen]] 10:47, 28 November 2011 (CST)
+=== ver 2011-11-18 ===
+rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 12:19, 18 November 2011 (CST)
+* changed dropdown width for sex field, before the dropdown content would not be shown completely [[User:Ttenbergen|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 [[User:Ttenbergen|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" [[User:Ttenbergen|Ttenbergen]]
+* changed check for minimal dataset to make sure that admit, transfer and discharge are chronological if entered [[User:Ttenbergen|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)[[User:Ttenbergen|Ttenbergen]] 11:06, 18 November 2011 (CST)
+** made send_imaging query [[User:Ttenbergen|Ttenbergen]] 11:06, 18 November 2011 (CST)
+** removed old references to L_ALT_LOC from code since variable isn't used any longer [[User:Ttenbergen|Ttenbergen]] 12:35, 18 November 2011 (CST)
+** deleted old query "1", would have been a test for something that had not been cleaned up. [[User:Ttenbergen|Ttenbergen]] 15:45, 18 November 2011 (CST)
+=== ver 2011-10-25 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:07, 25 October 2011 (CDT)
+* changed drop-down for [[DeviceUse Study]] as per discussion with Laura [[User:Ttenbergen|Ttenbergen]] 15:07, 25 October 2011 (CDT)
+=== ver 2011-10-17 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:20, 17 October 2011 (CDT)
+* made changes for pilot for [[DeviceUse Study]][[User:Ttenbergen|Ttenbergen]] 11:20, 17 October 2011 (CDT)
+* made dropdown wider for "item" entry in tmp form [[User:Ttenbergen|Ttenbergen]] 11:20, 17 October 2011 (CDT)
+=== ver 2011-10-11 ===
+Rolled out [[User:Ttenbergen|Ttenbergen]] 15:34, 13 October 2011 (CDT)
+* added Pericardial Tap/Window 76303 to the OR DXs list. [[User:Ttenbergen|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)'''[[User:Ttenbergen|Ttenbergen]] 15:27, 13 October 2011 (CDT)
+=== ver 2011-09-22 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)
+* added instructions field to the temp editor [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)
+* set the [[DeviceUse Study]] entries to active to test that study [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)
+* confirmed that the item options for temp studies are sorted alphabetically [[User:Ttenbergen|Ttenbergen]] 12:15, 22 September 2011 (CDT)
+=== ver 2011-09-09 ===
+not rolled out yet [[User:Ttenbergen|Ttenbergen]] 09:49, 9 September 2011 (CDT)
+* changed the versioning to draw from table "version" [[User:Ttenbergen|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. --[[User:TOstryzniuk|TOstryzniuk]] 15:53, 9 September 2011 (CDT)
+=== ver 2011-09-01 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 14:53, 8 September 2011 (CDT)
+* added Trauma	[[Subdural Hematoma - POST OP]] to [[Check_ORDx]] must have got deleted somehow [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:55, 1 September 2011 (CDT)
+* set following studies to inactive:
+** [[EuroScore]] [[User:Ttenbergen|Ttenbergen]] 18:00, 1 September 2011 (CDT)
+** [[Early ID study]] [[User:Ttenbergen|Ttenbergen]] 14:51, 8 September 2011 (CDT)
+** [[QASeptic]] [[User:Ttenbergen|Ttenbergen]] 14:51, 8 September 2011 (CDT)
+=== ver 2011-08-11 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:17, 15 August 2011 (CDT)
+* implemented warning values revised by Julie, Marie, Laura and Tina as per [[APACHE Scoring table]] [[User:Ttenbergen|Ttenbergen]] 16:34, 11 August 2011 (CDT)
+=== ver 2011-08-10 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 10:14, 10 August 2011 (CDT)
+* fixed error msg for 48-hr after admission error for QA Inf. [[User:Ttenbergen|Ttenbergen]] 10:14, 10 August 2011 (CDT)
+=== ver 2011-08-08 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 15:19, 8 August 2011 (CDT)
+* added [[RIS/PACS#Data_Acquisition]] to data being sent [[User:Ttenbergen|Ttenbergen]] 14:11, 8 August 2011 (CDT)
+=== ver 2011-07-29 ===
+rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 15:59, 29 July 2011 (CDT)
+=== ver 2011-07-28 ===
+not rolled out yet [[User:Ttenbergen|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]]. [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 11:57, 28 July 2011 (CDT)
+* changed timing of checks on form_view from "beforeupdate" to "afterupdate" and made sure data written first. [[User:Ttenbergen|Ttenbergen]] 12:27, 28 July 2011 (CDT)
+=== ver 2011-07-25 ===
+rolled out [[User:Ttenbergen|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!) [[User:Ttenbergen|Ttenbergen]] 13:15, 25 July 2011 (CDT)
+=== ver 2011-07-21 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:13, 25 July 2011 (CDT)
+* adding compensation for CON/COR abnormality [[User:Ttenbergen|Ttenbergen]] 17:42, 21 July 2011 (CDT)
+=== ver 2011-07-18-3 ===
+rolled out [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:55, 20 July 2011 (CDT)
+===ver 2011-07-18-3 ===
+rolled out [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 15:28, 20 July 2011 (CDT)
+===ver 2011-07-18-2 ===
+rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|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)[[User:Ttenbergen|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 [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 12:32, 20 July 2011 (CDT)
+=== ver 2011-07-13 ===
+rolled out [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 13:16, 6 July 2011 (CDT)
+* made [[Von Willebrand Disease]] collectable as diagnosis.
+=== ver 2011-06-03 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 11:20, 3 June 2011 (CDT)
+*fixed [[ER Wait]]
+=== ver 2011-06-02 ===
+rolled out [[User:Ttenbergen|Ttenbergen]] 17:54, 2 June 2011 (CDT)
+* fixed FIO2 80 ventilated 85 Vent to 80 ventilated 80 Vent [[User:Ttenbergen|Ttenbergen]] 15:22, 2 June 2011 (CDT)
+* added [[ER Wait]] [[User:Ttenbergen|Ttenbergen]] 17:46, 2 June 2011 (CDT)
 === ver 2011-05-04 ===
-not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:59, 4 May 2011 (CDT)
+rolled out [[User:Ttenbergen|Ttenbergen]] 20:20, 31 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. [[User:Ttenbergen|Ttenbergen]] 11:08, 4 May 2011 (CDT)
+'''Changes that you might come across: ''''
-** same change made to BP and ABG forms [[User:Ttenbergen|Ttenbergen]] 11:08, 4 May 2011 (CDT)
+* 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. [[User:Ttenbergen|Ttenbergen]] 11:08, 4 May 2011 (CDT)
-* s_drugs table consolidation - There are some duplicate/misspelled entries in the s_drugs table. The way they represent in the sent data is the same for both of a given version. In many cases the duplicates where generated when I added a second space to the most common set of options so they would sort to the top. In order to not cause problems with already entered data in those cases the duplicates are already set to "legacy", meaning they don't show up in the dropdowns for any new entries. They were retained in the table in case there are long stay patients. I don't think it's worth managing when to delete them since they don't have an impact. There were a few other oddities that were not set to legacy before, and that I am setting to legacy now, namely:
+* 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 [[Admit%2C_Transfer_and_Discharge_date_and_time#Transfer_Date_and_Time]]
+* added checks to improve validating [[Transfer Ready date and time]]
+** a blank transfer date will be flagged under some circumstances [[User:Ttenbergen|Ttenbergen]] 15:25, 4 May 2011 (CDT)
+** a blank transfer time will no longer be accepted if a transfer date is present [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 16:37, 4 May 2011 (CDT)
+* added check such that inconsistent tmp entries (e.g. Item for a different Project) will be disallowed [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 17:07, 4 May 2011 (CDT)
+* Confirmed that there is a working check that '''[[Moves for Medicine]]''' times are between admit and discharge [[User:Ttenbergen|Ttenbergen]] 17:23, 4 May 2011 (CDT)
+* Adding extreme APACHE checking. [[User:Ttenbergen|Ttenbergen]] 16:23, 9 May 2011 (CDT)
+* changed View form by disallowing addition of records within form to prevent scrolling to new patient. [[User:Ttenbergen|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]] [[User:Ttenbergen|Ttenbergen]] 16:01, 13 May 2011 (CDT)
+* fixed mBP ApScore so BP <=49 is 4 points. [[User:Ttenbergen|Ttenbergen]] 17:01, 13 May 2011 (CDT)
+* fixed BP Helper so it can store the ApPts [[User:Ttenbergen|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 [[User:Ttenbergen|Ttenbergen]] 20:17, 31 May 2011 (CDT)
 === ver 2011-04-27 ===
@@ Line 30: / Line 241: @@
 '''Changes collectors should know about:'''
 * '''changed default sort order''' of patient list to descending Pat_ID as requested by several collectors [[User:Ttenbergen|Ttenbergen]] 15:16, 21 April 2011 (CDT)
-* added '''[[CCMDB.mdb keyboard shortcuts]]''' [[User:Ttenbergen|Ttenbergen]] 17:29, 21 April 2011 (CDT)
+* added '''[[CCMDB.accdb keyboard shortcuts]]''' [[User:Ttenbergen|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''' [[User:Ttenbergen|Ttenbergen]] 15:29, 21 April 2011 (CDT)
@@ Line 85: / Line 296: @@
 rolled out. [[User:Ttenbergen|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. [[User:Ttenbergen|Ttenbergen]] 14:31, 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. [[User:Ttenbergen|Ttenbergen]] 14:31, 23 March 2011 (CDT)
 === ver 2011-02-16 ===
@@ Line 102: / Line 313: @@
 * Changed hints for Apache values, added midpoints: NA, WBC, HR, RR 18, Temp, mean BP, CO2, Hct, K, Cr [[User:Ttenbergen|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. [[User:Ttenbergen|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 up[[User:Ttenbergen|Ttenbergen]] 12:51, 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 up[[User:Ttenbergen|Ttenbergen]] 12:51, 25 February 2011 (CST)
 * deleted queries that were remnant from old labs system and conversion [[User:Ttenbergen|Ttenbergen]] 13:02, 25 February 2011 (CST)
 ** L_Labsort
@@ Line 121: / Line 332: @@
 * fixed AP_Age for no DOB
 * changed AdDt_combined to default to "now" if not entered [[User:Ttenbergen|Ttenbergen]] 18:02, 25 February 2011 (CST)
-* added JKL3 (burn unit) to Var1/2 options
+* added [[HSC JK3|JKL3]] (burn unit) to [[Var 1 - Admit-from Ward]]/[[Var 2 - Discharge-to Ward]]
 * added "explicit" setting to options, which forces declaration of variables and reduces errors due to misspelled vars. (sometime in March)
@@ Line 215: / Line 426: @@
 * changed conversion routine so it would not try to re-convert those who already converted if this program is started. [[User:Ttenbergen|Ttenbergen]] 17:18, 3 January 2011 (CST)
-[[Category: IT Instructions]]
+[[Category:CCMDB.accdb]]
-[[Category: Development Documentation]]
+[[Category:Change Logs CCMDB]]
-[[Category: Change Logs CCMDB]]