Centralized data front end.accdb Change Log 2017

see the Development Documentation Category for other development logs

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. 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. 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.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.mdb 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.PTorres 15:50, 2017 March 6 (CST)

• Modified query TISS_Errors_NrTissDays_NE_LOS_or_today.--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)

• Fixed the PL_psedu_Phin_query not to give false positive error.

2017-02-01-2

rolled out Ttenbergen 10:47, 2017 February 1 (CST)

• created query TISS_Errors_NrTissDays_NE_LOS_or_today as copy of query TISS_Errors_NrTissDays_NE_LOS, but the new one uses today for LOS if dispo_dttm is missing. Ttenbergen 10:47, 2017 February 1 (CST)

2017-02-01

rolled out Ttenbergen 09:51, 2017 February 1 (CST)

• Fixed PseudoPHIN behaviour: updated query PL_2PHIN _Fake_or_blank, and instructions at Generating PseudoPHINs. Ttenbergen 09:17, 2017 February 1 (CST)

2017-01-25

rolled out Ttenbergen 14:44, 2017 January 25 (CST)

• added Accept_DtTm_missing field to query L Log PHI. Ttenbergen 14:42, 2017 January 25 (CST)

2017-01-19-2

rolled out 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

rolled out Ttenbergen 13:22, 2017 January 19 (CST)

• changed definition of L_Log_PHI to not include BirthMY field any longer. That field was removed.

2017-01-17

rolled out Ttenbergen 19:18, 2017 January 17 (CST)

• added Record Status Field to Link suspect negative transit time query.

2017-01-05

rolled by Sheila's account, by Tina 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. Srusnak 14:55, 2017 January 5 (CST)