Centralized data front end.mdb Change Log 2015

see the Development Documentation Category for other development logs

Change Log

do before rolling out:
- update L_Person to be same as in dev, ie add PHIN (long) and last_update (date)

not rolled yet Ttenbergen 13:28, 2015 January 22 (CST)

setting up for Encounter processing
- added tables L_Person and L_Hospitalization to Function confirm_files_and_links() that is triggered by the "Re-connect data" button
- added query encounter_lister
- added module Encounter_processing with Sub Encounter_processor()

rolled but with old version number I think Ttenbergen 15:30, 2015 January 20 (CST)

updated query created_varibles_CC to calculate neuropoints properly. Ttenbergen 15:30, 2015 January 20 (CST)

copied to x:\ Ttenbergen 21:34, 2015 January 19 (CST)

added queries to move legacy BRR Entries from Var2 into Tmp
- 1_Var2_BRR_1_to_Tmp
- 1_Var2_BRR_2_cleanout_Var2
updated query created_Apache_details to be 15-(GCS) (was just GCS).
changed var2 dropdown to draw row content the same way as Var 1 (as in CCMDB.mdb) Ttenbergen 18:01, 2015 January 19 (CST)
added query L_Dxs_w_primary which includes a field "is_primary" to allow easy searching for primary_dxs. uses query Primary_admit Ttenbergen 18:24, 2015 January 19 (CST)
deleted old legacy query 1_time_only_set_3000_tr_date_to_null Ttenbergen 20:18, 2015 January 19 (CST)