CCMDB.mdb Change Log 2014: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - " ccmdb.accdb" to " CCMDB.accdb" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 195: | Line 195: | ||
* changes that should be invisible | * changes that should be invisible | ||
** disabled sending to [[PDA_Pending.mdb]] Ttenbergen 10:26, 2014 September 15 (CDT) | ** disabled sending to [[PDA_Pending.mdb]] Ttenbergen 10:26, 2014 September 15 (CDT) | ||
** changed way send_dttm is use to ensure local settings date format can not mess up the time stamp in | ** changed way send_dttm is use to ensure local settings date format can not mess up the time stamp in [[centralized_data.mdb]]. Ttenbergen 10:26, 2014 September 15 (CDT) | ||
=== 2014-Aug-25 === | === 2014-Aug-25 === | ||
| Line 239: | Line 239: | ||
* changed sending so pharm and labs are not synched for medicine, waste of time. Ttenbergen 14:53, 2014 August 7 (CDT) | * changed sending so pharm and labs are not synched for medicine, waste of time. Ttenbergen 14:53, 2014 August 7 (CDT) | ||
* cleaned up send_progress form (had some leftovers) and moved ICU-only stuff over to the side in it - Ttenbergen 14:57, 2014 August 7 (CDT) | * cleaned up send_progress form (had some leftovers) and moved ICU-only stuff over to the side in it - Ttenbergen 14:57, 2014 August 7 (CDT) | ||
* updated error message given when centralized_data.mdb not found on server to contact main office. - Ttenbergen 14:59, 2014 August 7 (CDT) | * updated error message given when [[centralized_data.mdb]] not found on server to contact main office. - Ttenbergen 14:59, 2014 August 7 (CDT) | ||
=== 2014-Jul-31-2 === | === 2014-Jul-31-2 === | ||
rolled out Ttenbergen 11:02, 2014 August 7 (CDT) | rolled out Ttenbergen 11:02, 2014 August 7 (CDT) | ||
* updated the s_alldiagnoses with version in centralized_data.mdb for consistency Ttenbergen 13:36, 2014 July 31 (CDT) | * updated the s_alldiagnoses with version in [[centralized_data.mdb]] for consistency Ttenbergen 13:36, 2014 July 31 (CDT) | ||
* corrected [[AaDO2]] scoring calculation to not be Null if AaDO2 <=0 Ttenbergen 16:41, 2014 July 31 (CDT) | * corrected [[AaDO2]] scoring calculation to not be Null if AaDO2 <=0 Ttenbergen 16:41, 2014 July 31 (CDT) | ||
* disabled ARF change query, it omitted that only those set to "enter" should be set to "". oi. Ttenbergen 10:39, 2014 August 7 (CDT) | * disabled ARF change query, it omitted that only those set to "enter" should be set to "". oi. Ttenbergen 10:39, 2014 August 7 (CDT) | ||
| Line 277: | Line 277: | ||
rolled out Ttenbergen 16:06, 2014 July 28 (CDT) | rolled out Ttenbergen 16:06, 2014 July 28 (CDT) | ||
* constrained the dropdown for Apache ARF to only existing content, which will prevent a "blank" from being entered Ttenbergen 10:36, 2014 July 21 (CDT) | * constrained the dropdown for Apache ARF to only existing content, which will prevent a "blank" from being entered Ttenbergen 10:36, 2014 July 21 (CDT) | ||
* updated error message when sending record that already exists as not-incomplete in centralized_data.mdb to state that most likely this is because of a wrong location or patient ID. Ttenbergen 11:09, 2014 July 24 (CDT) | * updated error message when sending record that already exists as not-incomplete in [[centralized_data.mdb]] to state that most likely this is because of a wrong location or patient ID. Ttenbergen 11:09, 2014 July 24 (CDT) | ||
* updated new patient generator to set Form_View.Ap_ARF = Null for medicine patients for consistent data in the back end. - Ttenbergen 14:59, 2014 July 28 (CDT) | * updated new patient generator to set Form_View.Ap_ARF = Null for medicine patients for consistent data in the back end. - Ttenbergen 14:59, 2014 July 28 (CDT) | ||
* added update code to set all existing medicine patients ARF to null Ttenbergen 15:04, 2014 July 28 (CDT) | * added update code to set all existing medicine patients ARF to null Ttenbergen 15:04, 2014 July 28 (CDT) | ||
| Line 327: | Line 327: | ||
* changed [[s_Locations]] to make STB_A5 and STB_B4 inactive - Ttenbergen 10:08, 2014 June 25 (CDT) | * changed [[s_Locations]] to make STB_A5 and STB_B4 inactive - Ttenbergen 10:08, 2014 June 25 (CDT) | ||
* deleted old dev query ''s_charlson_comorbid_wiki_list_generator'' Ttenbergen 10:30, 2014 June 25 (CDT) | * deleted old dev query ''s_charlson_comorbid_wiki_list_generator'' Ttenbergen 10:30, 2014 June 25 (CDT) | ||
* messed around with [[ | * messed around with [[s_charlson_dxs table]] and dependencies of to eliminate duplication and potential for confusion Ttenbergen 11:14, 2014 June 25 (CDT) | ||
* '''to fix sending''' - re-enabled function overlap from last update, is used during sending after all... Ttenbergen 10:22, 2014 June 26 (CDT) | * '''to fix sending''' - re-enabled function overlap from last update, is used during sending after all... Ttenbergen 10:22, 2014 June 26 (CDT) | ||
| Line 338: | Line 338: | ||
* changed Apache admit type to not allow anything other than dropdown values and blank, blank will not allow checking apache complete. Ttenbergen 12:41, 2014 June 23 (CDT) | * changed Apache admit type to not allow anything other than dropdown values and blank, blank will not allow checking apache complete. Ttenbergen 12:41, 2014 June 23 (CDT) | ||
* fixes to s_alldiagnoses legacy entries: disallow collection for 3097, 84602, 79497, 39997, 83197, 80697, 59997, 77797, 84897, 21997, should have been like that already but was missed during imports and updates somehow Ttenbergen 12:48, 2014 June 23 (CDT) | * fixes to s_alldiagnoses legacy entries: disallow collection for 3097, 84602, 79497, 39997, 83197, 80697, 59997, 77797, 84897, 21997, should have been like that already but was missed during imports and updates somehow Ttenbergen 12:48, 2014 June 23 (CDT) | ||
* imported newest version of module ''Apache_Scoring'' from [[ | * imported newest version of module ''Apache_Scoring'' from [[Centralized_data_front_end.accdb]] Ttenbergen 13:18, 2014 June 23 (CDT) | ||
** made some tweaks to integrate it Ttenbergen 14:00, 2014 June 23 (CDT) | ** made some tweaks to integrate it Ttenbergen 14:00, 2014 June 23 (CDT) | ||
** renamed Apache scoring callers in module check_forms so they are never same as in ApacheScoring Ttenbergen 13:21, 2014 June 23 (CDT) | ** renamed Apache scoring callers in module check_forms so they are never same as in ApacheScoring Ttenbergen 13:21, 2014 June 23 (CDT) | ||
| Line 381: | Line 381: | ||
** added table ''s_locations_allowed_collection'' Ttenbergen 11:14, 2014 June 2 (CDT) | ** added table ''s_locations_allowed_collection'' Ttenbergen 11:14, 2014 June 2 (CDT) | ||
** updated query ''s_Locations_local'' to use new table to restrict options Ttenbergen 11:17, 2014 June 2 (CDT) | ** updated query ''s_Locations_local'' to use new table to restrict options Ttenbergen 11:17, 2014 June 2 (CDT) | ||
* get Birth_MY into centralized_data.mdb | * get Birth_MY into [[centralized_data.mdb]] | ||
** updated queries ''send_Centralized_1L_Log__intermediate'', ''Send_Centralized_1L_Log_append'' and ''Send_Centralized_1L_Log_update''Ttenbergen 11:29, 2014 June 2 (CDT) | ** updated queries ''send_Centralized_1L_Log__intermediate'', ''Send_Centralized_1L_Log_append'' and ''Send_Centralized_1L_Log_update''Ttenbergen 11:29, 2014 June 2 (CDT) | ||
* imported from centralized newest versions of | * imported from centralized newest versions of | ||
| Line 390: | Line 390: | ||
=== 2014-05-01 === | === 2014-05-01 === | ||
rolled - Ttenbergen 15:13, 2014 May 1 (CDT) | rolled - Ttenbergen 15:13, 2014 May 1 (CDT) | ||
* fixed query "send_set_oLog_to_sent" to properly link on Pat_ID ''and location'', which was missing, leading to seemingly random patients being set to "Sent". This should address [[Bug - Incomplete patients are being set to "sent" in | * fixed query "send_set_oLog_to_sent" to properly link on Pat_ID ''and location'', which was missing, leading to seemingly random patients being set to "Sent". This should address [[Bug - Incomplete patients are being set to "sent" in Centralized_data.accdb]]. Ttenbergen 10:26, 2014 May 1 (CDT) | ||
* query "Minimal_dataset_incomplete", [[Minimal Data Set]] | * query "Minimal_dataset_incomplete", [[Minimal Data Set]] | ||
** confirmed that there is no check for admit time; some collectors were entering fake times to be able to sent Ttenbergen 10:43, 2014 May 1 (CDT) | ** confirmed that there is no check for admit time; some collectors were entering fake times to be able to sent Ttenbergen 10:43, 2014 May 1 (CDT) | ||
| Line 420: | Line 420: | ||
=== 2014-03-13 === | === 2014-03-13 === | ||
rolled out Ttenbergen 10:41, 2014 March 24 (CDT) | rolled out Ttenbergen 10:41, 2014 March 24 (CDT) | ||
* changing how data is transferred to [[centralized_data.mdb]] | * changing how data is transferred to [[[[centralized_data.mdb]]]] | ||
** changed the send_centralized_ queries to include both incomplete and complete patients | ** changed the send_centralized_ queries to include both incomplete and complete patients | ||
** added code near the end of sending to set [[RecordStatus field]] to "sent" in centralized as well, was only done in ccmdb_data.mdb before. Ttenbergen 11:26, 2014 March 21 (CDT) | ** added code near the end of sending to set [[RecordStatus field]] to "sent" in centralized as well, was only done in ccmdb_data.mdb before. Ttenbergen 11:26, 2014 March 21 (CDT) | ||
| Line 445: | Line 445: | ||
rolled out Ttenbergen 15:15, 2014 March 3 (CST) | rolled out Ttenbergen 15:15, 2014 March 3 (CST) | ||
* de-activated the [[Allied Health Consults]] project entries in s_tmp - Ttenbergen 16:11, 2014 February 28 (CST) | * de-activated the [[Allied Health Consults]] project entries in s_tmp - Ttenbergen 16:11, 2014 February 28 (CST) | ||
* confirmed that send function is checking that centralized_data.mdb is present - Ttenbergen 16:36, 2014 February 28 (CST) | * confirmed that send function is checking that [[centralized_data.mdb]] is present - Ttenbergen 16:36, 2014 February 28 (CST) | ||
* confirmed that dates in registry now work consistently re input mask vs format - Ttenbergen 16:38, 2014 February 28 (CST) | * confirmed that dates in registry now work consistently re input mask vs format - Ttenbergen 16:38, 2014 February 28 (CST) | ||
* added checks for [[ER Wait]] validation: Ttenbergen 17:12, 2014 February 28 (CST) | * added checks for [[ER Wait]] validation: Ttenbergen 17:12, 2014 February 28 (CST) | ||
| Line 483: | Line 483: | ||
* refactored function CCMDB_age to be able to use it with parameters (birth, admit). Ttenbergen 15:40, 2014 January 2 (CST) | * refactored function CCMDB_age to be able to use it with parameters (birth, admit). Ttenbergen 15:40, 2014 January 2 (CST) | ||
* commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from table | * commented out functions GCS_Eye, GCS_motor, GCS_verbal. Don't seem to be used anywhere, and if they were, the scores should now come from [[s_GCS table]]. Ttenbergen 16:08, 2014 January 2 (CST) | ||
** updated Transition Coordinator function to draw Apache scoring from new location Ttenbergen 18:39, 2014 January 15 (CST) | ** updated Transition Coordinator function to draw Apache scoring from new location Ttenbergen 18:39, 2014 January 15 (CST) | ||
* changed function Ap_Chronic to be able to take CH and AT as parameters rather than draw from form Ttenbergen 16:08, 2014 January 2 (CST) | * changed function Ap_Chronic to be able to take CH and AT as parameters rather than draw from form Ttenbergen 16:08, 2014 January 2 (CST) | ||
| Line 508: | Line 508: | ||
[[Category:CCMDB.accdb]] | [[Category:CCMDB.accdb]] | ||
[[Category: Change Logs CCMDB]] | [[Category:Change Logs CCMDB]] | ||