Centralized data front end.mdb Change Log 2016: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →2016-07-04: log |
Ttenbergen (talk | contribs) m →2016-07-04: log |
||
| Line 12: | Line 12: | ||
* changing to use new fields | * changing to use new fields | ||
** query ''ages'' - [[age]] | ** 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'' | |||
* clean-up | |||
** deleted query ''created_variables_select'' | |||
** deleted query ''Created_Variables_ts'' | |||
** deleted query ''created_vars_selectonly'' | |||
** deleted table 's_HospitalCodes_updt'' | |||
=== 2016-05-26 === | === 2016-05-26 === | ||
Revision as of 16:45, 4 July 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
- clean-up
- deleted query created_variables_select
- deleted query Created_Variables_ts
- deleted query created_vars_selectonly
- deleted table 's_HospitalCodes_updt
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)