Centralized data front end.mdb Change Log 2016

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.

Change Log

2016-07-04

must update batch files to correspond not rolled yet Ttenbergen 15:55, 2016 July 4 (CDT)

• changed "Re-Connect Data" button to draw from c:\ccmdb_program\ccmdb.mdb instead; must update batch files to correspond
• changing to use new fields
  • query ages - age
  • query created_Apache_details - Created Variables
  • query L_Log_PHI - added new fields and changed ward, hosp, program to draw from s_dispo table
  • query J_in-process_records - now pulls Service/Location
  • query Labs_requester
  • query TISS_admitted_date_range
  • query PatientList
  • query PL_SamePHIN_Site_Diff_chart
  • query

• clean-up
  • deleted query created_variables_select
  • deleted query Created_Variables_ts
  • deleted query created_vars_selectonly
  • deleted table 's_HospitalCodes_updt
  • deleted query L_Log_PHI_time_hm, use L_Log_PHI instead
  • deleted query L_Dispo
  • deleted table R_completePTList
  • deleted table s_dispo_legacy_codes
  • deleted query s_dispo_combiner
  • deleted query s_locations_local

2016-05-26

rolled Ttenbergen 13:09, 2016 May 26 (CDT)

• removing some old one-of queries that should be done with Ttenbergen 11:01, 2016 May 26 (CDT)
  • 1_acp__test
  • 1_acp_admit
  • 1_acp_end
  • 1_change_complication_CAP_to_HAP
  • 11_5B_adm
  • 11_5B_dis
• added three queries starting with 2016-05-26_GRAW3_to_S3 to do conversion; emailed Pagasa to run them Ttenbergen 13:08, 2016 May 26 (CDT)

2016-05-05

rolled out Ttenbergen 21:24, 2016 May 4 (CDT)

• added three new tables S_dispo table, S_pre_acute_living_situation table, S_previous_service_table to reconnector code Ttenbergen 21:07, 2016 May 4 (CDT)
• added fields on Pagasa's form Ttenbergen 21:07, 2016 May 4 (CDT)
• added query L_Dispo for Julie to access in SAS to resolve the entries as text Ttenbergen 21:20, 2016 May 4 (CDT)

2016-04-14

rolled Ttenbergen 17:55, 2016 April 14 (CDT)

• fixed password protection to be same as our other programs. Ttenbergen 17:55, 2016 April 14 (CDT)

2016-01-28

rolled out Ttenbergen 15:50, 2016 January 28 (CST)

• updating Query NDC missing Ls to not list incompletes even for dxs. Ttenbergen 15:50, 2016 January 28 (CST)

2016-01-21

rolled out.--Ttenbergen 17:19, 2016 January 21 (CST)

• added CFE Query NDC missing Ls to find missing mandatory child entries Ttenbergen 17:19, 2016 January 21 (CST)
• updated query ADL_Scores to refer to ALERT rather than MOST Ttenbergen 17:26, 2016 January 21 (CST)