CCMDB.mdb Change Log 2011: Difference between revisions
Ttenbergen (talk | contribs) m →ver 2011-05-04: link fix |
Ttenbergen (talk | contribs) |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 156: | 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 174: | 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 189: | 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 222: | Line 222: | ||
* 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 241: | 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 296: | 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 313: | 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 332: | 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 426: | 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]] | |||