CCMDB.mdb Change Log 2013: Difference between revisions

ver 2013-08-01: rolled out
Line 18: Line 18:
* changed tmp entry for QAInf from "CLI (call Basil Evan'''s''' if MICU/SICU/IICU)" to loose the "s" in Evans - Ttenbergen 09:36, 2013 August 1 (CDT)
* changed tmp entry for QAInf from "CLI (call Basil Evan'''s''' if MICU/SICU/IICU)" to loose the "s" in Evans - Ttenbergen 09:36, 2013 August 1 (CDT)
==== . . .  Overstay Changes ====
==== . . .  Overstay Changes ====
* cleaned up s_tmp to have only one line for each overstay option, used to require more when only certain hospitals were participating Ttenbergen 09:51, 2013 August 1 (CDT) Hurrah!!!.(trish) didn't think anyone other than maintainer of the s_tmp table would care... but glad you like it :0) Ttenbergen 12:33, 2013 August 1 (CDT)
* changed Overstay Tmp dropdown option "Form data missing" to "DPST data missing" Ttenbergen 09:51, 2013 August 1 (CDT)
* changed Overstay Tmp dropdown option "Form data missing" to "DPST data missing" Ttenbergen 09:51, 2013 August 1 (CDT)
* added request for confirmation that this is the colour to send, and changed code so it is only added to tmp if "yes" is clicked.Ttenbergen 10:02, 2013 August 1 (CDT)  
* added request for confirmation that this is the colour to send, and changed code so it is only added to tmp if "yes" is clicked.Ttenbergen 10:02, 2013 August 1 (CDT)  
* added check to require a colour or a "DPST data missing" to be present Ttenbergen 12:52, 2013 August 1 (CDT)
* changed overstay code so that overstay will now replace entry in tmp rather than add new one, and only after asking if this is for good Ttenbergen 13:43, 2013 August 1 (CDT)
** this has been commented out in tmp_checker for now while discussion about it continues Ttenbergen 15:02, 2013 August 1 (CDT)
* eliminated check location_is_part_of_overstay() because all locations are on now
* changed so that overstay will now replace entry in tmp rather than add new one, and only after asking if this is for good Ttenbergen 13:43, 2013 August 1 (CDT)
* colour will now be automatically added to beginning of Notes field. Ttenbergen 14:52, 2013 August 1 (CDT)
* colour will now be automatically added to beginning of Notes field. Ttenbergen 14:52, 2013 August 1 (CDT)
* Collectors don't need to know the following:
** cleaned up s_tmp to have only one line for each overstay option, used to require more when only certain hospitals were participating Ttenbergen 09:51, 2013 August 1 (CDT)
** added check to require a colour or a "DPST data missing" to be present Ttenbergen 12:52, 2013 August 1 (CDT)
*** this has been commented out in tmp_checker for now while discussion about it continues Ttenbergen 15:02, 2013 August 1 (CDT)
** eliminated check location_is_part_of_overstay() because all locations are on now
==== . . .  New Data Repository ====
==== . . .  New Data Repository ====
Collectors don't need to know any of this at this time.
* added 18 char text field d_id to [[centralized_data.mdb]].L_Log and updated it to [R_location]-[Pat_ID]Ttenbergen 15:23, 2013 August 1 (CDT)
* added 18 char text field d_id to [[centralized_data.mdb]].L_Log and updated it to [R_location]-[Pat_ID]Ttenbergen 15:23, 2013 August 1 (CDT)
* changed [[centralized_data.mdb]].L_Dxs.Pat_ID to 18 char text D_Id; changed Diag_ID to 30 char text field. Ttenbergen 15:28, 2013 August 1 (CDT)
* changed [[centralized_data.mdb]].L_Dxs.Pat_ID to 18 char text D_Id; changed Diag_ID to 30 char text field. Ttenbergen 15:28, 2013 August 1 (CDT)