CCMDB.mdb Change Log 2011: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| (44 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
== Versions == | == 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 === | === ver 2011-11-25 === | ||
rolled out [[User:Ttenbergen|Ttenbergen]] 10:51, 28 November 2011 (CST) | |||
* added IICU B5 to Var1/2 Med | * added IICU B5 to Var1/2 Med | ||
| Line 99: | Line 156: | ||
=== ver 2011-07-21 === | === ver 2011-07-21 === | ||
rolled out [[User:Ttenbergen|Ttenbergen]] 11:13, 25 July 2011 (CDT) | rolled out [[User:Ttenbergen|Ttenbergen]] 11:13, 25 July 2011 (CDT) | ||
* adding compensation for | * adding compensation for CON/COR abnormality [[User:Ttenbergen|Ttenbergen]] 17:42, 21 July 2011 (CDT) | ||
=== ver 2011-07-18-3 === | === ver 2011-07-18-3 === | ||
| Line 117: | Line 174: | ||
rolled out [[User:Ttenbergen|Ttenbergen]] 12:34, 20 July 2011 (CDT) | 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 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) | * 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) | * 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) | ||
| Line 132: | Line 189: | ||
* fix for [[Accidental scrolling off the Patient View screen]] | * 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) | * 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 | * 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 === | === ver 2011-07-06 === | ||
| Line 158: | Line 215: | ||
** Metoprolol Tab 75mg (set to legacy; Metoprolol Tab 75 mg remains) | ** Metoprolol Tab 75mg (set to legacy; Metoprolol Tab 75 mg remains) | ||
** Metoprolol Tab 125mg (set to legacy; Metoprolol Tab 125mg remains) | ** Metoprolol Tab 125mg (set to legacy; Metoprolol Tab 125mg remains) | ||
* added checks to improve validating [[ | * added checks to improve validating [[Transfer Ready date and time]] | ||
** a blank transfer date will be flagged under | ** 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 | ** 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) | * 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) | * 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) | * 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) | * 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 | * 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) | * 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 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) | ||
| Line 184: | Line 241: | ||
'''Changes collectors should know about:''' | '''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) | * '''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. | * 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. | ** 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) | * 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 239: | Line 296: | ||
rolled out. [[User:Ttenbergen|Ttenbergen]] 14:44, 23 March 2011 (CDT) | 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 | * 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 === | === ver 2011-02-16 === | ||
| Line 256: | 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) | * 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) | * 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 [[ | * 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) | * deleted queries that were remnant from old labs system and conversion [[User:Ttenbergen|Ttenbergen]] 13:02, 25 February 2011 (CST) | ||
** L_Labsort | ** L_Labsort | ||
| Line 275: | Line 332: | ||
* fixed AP_Age for no DOB | * 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) | * changed AdDt_combined to default to "now" if not entered [[User:Ttenbergen|Ttenbergen]] 18:02, 25 February 2011 (CST) | ||
* added JKL3 (burn unit) to | * 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) | * added "explicit" setting to options, which forces declaration of variables and reduces errors due to misspelled vars. (sometime in March) | ||
| Line 369: | 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) | * 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: | [[Category:CCMDB.accdb]] | ||
[[Category:Change Logs CCMDB]] | |||
[[Category: Change Logs CCMDB]] | |||