CCMDB.mdb Change Log 2012
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 2012-04-12
not rolled out yet Ttenbergen 10:09, 2012 April 12 (CDT)
- Changes Collectors need to know about:
- locked Pat_ID field in Form_View, changing Pat_ID was causing errors in checkers; unlocked Pat_ID in Patient List instead since it doesn't
run chekers. Ttenbergen 10:46, 2012 April 12 (CDT)
- implementingOverstay Predictor Project Ttenbergen 10:48, 2012 April 12 (CDT)
- added variables to the tmp tableTtenbergen 10:11, 2012 April 12 (CDT)
- added overstay indicator to main form; clicking it will give the colour; algorithm not implemented yet. Ttenbergen 11:03, 2012 April 12 (CDT)
- implementingOverstay Predictor Project Ttenbergen 10:48, 2012 April 12 (CDT)
- Changes behind the scenes
- adding Overstay Module for Overstay Predictor Project to generate Overstay colour Ttenbergen 10:11, 2012 April 12 (CDT)
- adding form elements to give colour for Overstay Predictor Project Ttenbergen 10:11, 2012 April 12 (CDT)
- added variables for Overstay Predictor Project to the tmp tableTtenbergen 10:11, 2012 April 12 (CDT)
run chekers. Ttenbergen 10:46, 2012 April 12 (CDT)
ver 2012-04-02
rolled out Ttenbergen 12:09, 2012 April 2 (CDT)
- re-enabled the QA Septic Shock Temp Study. Ttenbergen 12:09, 2012 April 2 (CDT)
ver 2012-03-16
rolled out Ttenbergen 17:43, 2012 March 16 (CDT)
- added cisatracurium to hints for paralytics in pharmacy form Ttenbergen 17:27, 2012 March 16 (CDT)
- confirmed eptifibatide and added tirofiban to hints for biologics in pharmacy form Ttenbergen 17:30, 2012 March 16 (CDT)
- Changed DX code label: 42900 to Liver Transplant, had been "Liver Transplant Problems"Ttenbergen 17:37, 2012 March 16 (CDT)
- added erthyropoietin to hints for EPO-type drugs Ttenbergen 17:39, 2012 March 16 (CDT)
ver 2012-03-09
rolled out Ttenbergen 15:51, 2012 March 9 (CST)
- Updated database to be current version of Access in preparation for some future changes. Everything should look the same as before, no visible changes.
ver 2012-03-01
rolled out Ttenbergen 13:14, 2012 March 1 (CST)
- Fixed diagnosis yellowing error
- diagnosis were yellow even when nothing was wrong. Reason is form got actually saved with yellow fields, meaning they were yellow rather than neutral on open. changed default colour back to neutral.
ver 2012-01-18
rolled out Ttenbergen 09:44, 2012 February 16 (CST)
Changes collectors should know about
- corrected error for Panelling/Discharge Planning error to read that admit and transfer date need to be same (used to wrongly say admit and discharge date) Ttenbergen 12:08, 27 January 2012 (CST)
- Pharmacy changes
- added "eptifibatide" to Pharm_Flow bottom biologics hover-over Ttenbergen 11:54, 27 January 2012 (CST)
- changed font colours to all-same (black and dark blue) to improve contrast. Ttenbergen 12:21, 27 January 2012 (CST)
- changed "azoles" label in pharmacy to "azoles (anti-fungal)" Ttenbergen 12:22, 27 January 2012 (CST)
- changed 'hospital_previous dropdown' to show town name first (i.e. sort by town name) Ttenbergen 12:31, 27 January 2012 (CST)
- checks for Med Var 1 - Admit-from Ward and Med Var 2 - Discharge-to Ward will trigger correctly now
Changes behind the scenes
- changed the order in which error msgs are displayed for reg complete to not have errors dropped off the edge of the screen by the repeat errors I still have not been able to fix. Ttenbergen 13:33, 18 January 2012 (CST)
- deleted "re-send pharmacy" button and associated VBA, we are done with that. Ttenbergen 11:36, 27 January 2012 (CST)
- Error discovered in programming: relocated DisTo_Var2_reconcile from Discharge-Date validator to discharge-to validator, had been put there mistakenly. see Med Var 2 - Discharge-to Ward Ttenbergen 16:25, 27 January 2012 (CST)
- Error discovered in programming: relocated AdFrom_Var1_reconcile from Admit-Date validator to admit-from validator, had been put there mistakenly. see Med Var 1 - Admit-from Ward Ttenbergen 16:25, 27 January 2012 (CST)
- Error discovered in programming: RnVars_Yellower wasn't being run by FinalCheck_Click(), added it to the list of checks run Ttenbergen 16:33, 27 January 2012 (CST)
- changed adm/trans/dis Dt/tm validation to not each run ADT_Chronological and long_LOS so the error won't show 6 times. Check is only triggered by checking registry complete now. To make sure nothing slips through, any change to the dt/tm fields will uncheck reg complete now. Ttenbergen 16:41, 27 January 2012 (CST)
- changed Pharm_Flow double-click so it will work right when double-clicking to up previously typed value. (made Sub up_one write value to table before upping it) Ttenbergen 14:47, 2012 February 9 (CST)
- changed Function admit1 to work properly when the diagnosis priority is not an integer Ttenbergen 15:55, 2012 February 9 (CST)
- spun out Function Panelling_admit_transfer_same to control better when it is run, ie. make sure it runs when dx or either date changes Ttenbergen 16:24, 2012 February 9 (CST)
ver 2012-01-05
rolled out Ttenbergen 15:38, 10 January 2012 (CST)
tested via Test_Plans_2012#ver 2012-01-05 testingTtenbergen 15:38, 10 January 2012 (CST)
- changes collectors will notice...
- changed colouring of L_Pharm_Flow_* forms to improve contrast Ttenbergen 16:45, 5 January 2012 (CST)
- changed dropdowns for Med Var 1 and Med Var 2 to allow wards from other hospitals, sorting the local wards first Ttenbergen 08:46, 6 January 2012 (CST)
- added the */+/- buttons to the date in tmp form as well (good suggestion Debbie) Ttenbergen 08:55, 6 January 2012 (CST)
- added the */+/- buttons to the date in Pharmacy form as well (good suggestion Marie) Ttenbergen 15:01, 6 January 2012 (CST)
- added label for boolean for postal codes to show that it should be checked if unavailable Ttenbergen 15:03, 6 January 2012 (CST)
- added check to require that either a postal code is present or the checkbox is checked Ttenbergen 15:59, 6 January 2012 (CST)
- adding Panelling_or_Discharge_Planning#Data Integrity RuleTtenbergen 16:50, 6 January 2012 (CST)
- added blank line requirement for Pharmacy collection Ttenbergen 11:17, 9 January 2012 (CST)
- took DeviceUse Study off the dropdown for tmp studies Ttenbergen 14:08, 9 January 2012 (CST)
- fixed the Pat_ID that had somehow gone missing from sending, also added send_dttm to Pharmacy sending for future troubleshooting. Ttenbergen 16:15, 9 January 2012 (CST)
- added ugly pink temporary Re-send Pharmacy button to re-send pharmacy for previously sent patients (i.e. patients that have "record" set to "sent")Ttenbergen 16:44, 9 January 2012 (CST)
- re-applied the long-stay change that got deleted together with the Pharmacy Sending fix. Ttenbergen 16:57, 9 January 2012 (CST)
- behind-the-scenes changes...
- deleted L_Pharm_Flow because not used now, *top and *bott are straight on the View form instead Ttenbergen 16:45, 5 January 2012 (CST)
ver 2012-01-04
rolled out Kmorris2 13:26, 4 January 2012 (CST)
- Allow spaces in First Name (fix function real_char)