Centralized data front end.accdb Change Log 2017: Difference between revisions

← Older edit

@@ Line 2: / Line 2: @@
 ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
-This article is the change log for [[Centralized data front end.mdb]]. See [[Centralized data front end.mdb Change Request]] for requested changes.
+This article is the change log for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Request]] for requested changes.
 == Log ==
+*Go to: [[Centralized data front end.accdb Change Log 2018]]
+=== 2017-12-13 ===
+Rolled out
+*Updated s_dispo_collection_location table. [[User:TOstryzniuk|Trish Ostryzniuk]] 12:35, 2017 December 13 (CST)
+=== 2017-11-17===
+changed on Pagasa's desk and copied to master Ttenbergen 14:07, 2017 November 17 (CST)
+* updated the dropdown for the [[Dispo field]] to allow Pagasa to enter absolutely anything in [[s_dispo table]] so she can update for discharge to ER/UC.
+=== 2017-11-02===
+changed on Trish copy & rolled out. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:00, 2017 November 2 (CDT)
+*added [[Query Mgmt_Collector_Admission_Count]]
+=== 2017-10-30 ===
+Changed on Pagasa's PC and rolled out.[[User:PTorres|PTorres]] 16:08, 2017 October 30 (CDT)
+Fixed  the reconnect DSM because the table name changed.
+=== 2017-10-24 ===
+Changed on Pagasa's PC and rolled out. Ttenbergen 11:32, 2017 October 24 (CDT)
+* updated the query for [[Orphans in Centralized_data.accdb]]to no longer have multi-laptop per location special case.
+* added query ''Sending_at_wrong_time'' to allow Trish to see who is sending outside of the [[Designated sending times]].
+=== 2017-07-18 ===
+Changes done on Pagasa's PC and rolled out. Ttenbergen 11:02, 2017 July 18 (CDT)
+* added chart column to patient list
+* added chart and PHIN filter buttons
+* changed column widths to fit Pagasa's screen
+=== 2017-05-23 ===
+(I think I rolled this out, ''link_suspect_mismatch_pre_inpt_should_be_ours__incomplete'' was present)
+* fixed query ''link_suspect_not_same_visitAdmitDtTm'' to mirror Julie's checks: **if to-from match
+**the difference of dispo1 and adm2 is
+***Within our collection area: < 1 day
+***Outside our collection area: < 7 days
+* added query ''link_suspect_mismatch_pre_inpt_should_be_ours__incomplete'' to catch pairs where the second entry doesn't have appropriate pre-inpt entry. Ttenbergen 17:33, 2017 May 23 (CDT)
+=== 2017-05-03 ===
+rolled out Ttenbergen 11:17, 2017 May 3 (CDT)
+* updated to Access 2007, ie renamed to *.accdb
+* added  [[DSM Labs Consistency check.accdb]] resp L_Labs_Flowsheet_DSM table.
+** added to Function ''confirm_files_and_links()''
+** form ''L_Labs_Flowsheet_DSM''
+=== 2017-04-25 ===
+rolled from Pagasa's desk
+* updated delete functionality to deal with new [[L_TISS_Item table]] Ttenbergen 13:28, 2017 April 25 (CDT)
+=== 2017-04-24 ===
+rolled from Pagasa's desk
+* added query ''TISS_Errors_duplicate_Items''
+* updated and tweaked several of the other changes implemented in previous version upon testing w Pagasa.
+=== 2017-04-20 ===
+was rolled out
+TISS Changes
+* cleanup: deleted queries
+** ''2016-09-19_L_TISSForm''
+** ''2016-09-19_TISSItem''
+** ''TISS_IDs''
+** ''TISS_Viewer''
+* updated re-connector Function confirm_files_and_links() to use new TISS data structure. Ttenbergen 11:53, 2017 April 20 (CDT)
+* updated queries:
+** ''NDC_Pacemaker_acquired_wo_TISS''
+** ''NDC_Pacemaker_TISS_wo_acquired''
+** ''NDC_zCRRT_TISS_no_tmp''
+** ''NDC_zCRRT_tmp_no_TISS''
+** ''TISS_Connect''
+** ''TISS_DailyScore''
+** ''TISS_Errors_NrTISSDays_NE_LOS''
+* front end
+** fixed patient finder button to apply filter instead of search, much faster
+=== 2017-03-06 ===
+rolled out from Pagasa's PC.[[User:PTorres|PTorres]] 15:50, 2017 March 6 (CST)
+*Modified query TISS_Errors_NrTissDays_NE_LOS_or_today.--[[User:PTorres|PTorres]] 15:50, 2017 March 6 (CST)
+=== 2017-02-27-2 ===
+rolled out from Pagasa's PC Ttenbergen 16:18, 2017 February 27 (CST)
+fix to earlier today
+=== 2017-02-27 ===
+rolled out Ttenbergen 12:52, 2017 February 27 (CST)
+* queries for [[CRRT#CFE_checks]] Ttenbergen 12:52, 2017 February 27 (CST)
+=== 2017-02-07 ===
+rolled out Ttenbergen 13:40, 2017 February 7 (CST)
+* fixing query ''TISS_IDs'' (was still using old s_locations table) to fix query ''NDC_Pacemaker_tiss_wo_acquired''. Ttenbergen 13:27, 2017 February 7 (CST)
 === 2017-02-01-3 ===
 rolled out 13:38, 2017 February 1 (CST)
@@ Line 23: / Line 112: @@
 === 2017-01-19-2 ===
 rolled out Ttenbergen 17:54, 2017 January 19 (CST)
-* updated query ''link_suspect_not_same_visitAdmitDtTm'' and added helper query ''link_Int_suspect_not_same_visitAdmitDtTm_int'' Ttenbergen 17:54, 2017 January 19 (CST)
+* updated ''[[link_suspect_not_same_visitAdmitDtTm query]]'' and added helper query ''link_Int_suspect_not_same_visitAdmitDtTm_int'' Ttenbergen 17:54, 2017 January 19 (CST)
 === 2017-01-19 ===
@@ Line 35: / Line 124: @@
 === 2017-01-05 ===
 rolled by Sheila's account, by Tina [[User:Srusnak|Srusnak]] 14:55, 2017 January 5 (CST)
-* updated NDC_VAP_unacceptable_date query, it was listing the l_problems D_ID  and therefore didn't work in the dropdown. [[User:Srusnak|Srusnak]] 14:55, 2017 January 5 (CST)
+* updated [[query NDC_VAP_unacceptable_date]] query, it was listing the [[L Problem table]].D_ID  and therefore didn't work in the dropdown. [[User:Srusnak|Srusnak]] 14:55, 2017 January 5 (CST)
-[[Category: Development Documentation]]
+[[Category:Development Documentation]]
-[[category: 2013 data upgrades]]
+[[Category:Centralized data front end.accdb]]
-[[Category: Centralized data front end.mdb]]