Centralized data front end.mdb Change Log 2016: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →2016-07-04: m |
Ttenbergen (talk | contribs) m →2016-07-05: rolled |
||
| Line 4: | Line 4: | ||
== Change Log == | == Change Log == | ||
'''''must update batch files to correspond with CCMDB coming from ccmdb_program now.''''' | |||
=== 2016-07-05 === | |||
rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT) | |||
*Updates to | |||
** query ''Created_... | |||
** query ''Created_... | |||
** query ''L_Log_PHI'' | |||
=== 2016-07-04 === | |||
rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT) | |||
* changed "Re-Connect Data" button to draw from c:\ccmdb_program\ccmdb.mdb instead; '''''must update batch files to correspond''''' | * changed "Re-Connect Data" button to draw from c:\ccmdb_program\ccmdb.mdb instead; '''''must update batch files to correspond''''' | ||
| Line 20: | Line 26: | ||
** query ''PatientList'' | ** query ''PatientList'' | ||
** query ''PL_SamePHIN_Site_Diff_chart'' | ** query ''PL_SamePHIN_Site_Diff_chart'' | ||
* clean-up | * clean-up | ||
Revision as of 15:34, 5 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
must update batch files to correspond with CCMDB coming from ccmdb_program now.
2016-07-05
rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (CDT)
- Updates to
- query Created_...
- query Created_...
- query L_Log_PHI
2016-07-04
rolled with caution that push pull won't work right now. Ttenbergen 16:34, 2016 July 5 (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
- 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)