Centralized data front end.mdb Change Log 2015

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

2015-Jan-22

do before rolling out update centralized_data:
- update L_Person to be same as in dev, ie 
-- add PHIN (long)
--- add a unique index for PHIN 
--add field last_update (date)
-- make Person_ID random from incremental

- update L_Log
-- add field Person_ID (long) 
-- add field Hospitalization_ID (long) 

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()

2015-Jan-20

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)

2015-Jan-05

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)