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.mdb. See Centralized data front end.mdb Change Request for requested changes.

Log

2017-04-20

not yet rolled out Ttenbergen 11:53, 2017 April 20 (CDT) 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

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 query link_suspect_not_same_visitAdmitDtTm 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 NDC_VAP_unacceptable_date query, it was listing the l_problems D_ID and therefore didn't work in the dropdown. Srusnak 14:55, 2017 January 5 (CST)