Centralized data front end.mdb Change Log 2014: Difference between revisions

m Text replacement - "PL_Diff_Phin_SameLN_FN_DOB" to "PL_DiffPhin_SameLN_FN_DOB"
m Text replacement - "Centralized_data.mdb" to "Centralized data.accdb"
Line 102: Line 102:
=== 2014-10-09 - 2 ===
=== 2014-10-09 - 2 ===
rolled out Ttenbergen 18:27, 2014 October 9 (CDT)
rolled out Ttenbergen 18:27, 2014 October 9 (CDT)
* moved S_Standard_emails into [[Centralized_data.mdb]] Ttenbergen 18:27, 2014 October 9 (CDT)
* moved S_Standard_emails into [[[[Centralized data.accdb]]]] Ttenbergen 18:27, 2014 October 9 (CDT)
* updated function ''confirm_files_and_links'' to run against [[CCMDB.accdb]] for s_ tables Ttenbergen 18:27, 2014 October 9 (CDT)
* updated function ''confirm_files_and_links'' to run against [[CCMDB.accdb]] for s_ tables Ttenbergen 18:27, 2014 October 9 (CDT)
* updated reconnect button so it only gives the count if the L_Log, L_PHI and L_LogPHI are not the same. No sense having a gopher otherwise. Ttenbergen 18:27, 2014 October 9 (CDT)
* updated reconnect button so it only gives the count if the L_Log, L_PHI and L_LogPHI are not the same. No sense having a gopher otherwise. Ttenbergen 18:27, 2014 October 9 (CDT)
Line 310: Line 310:
* added to table '''s_admitDischarge''' column "hosp" and "ward", and indexed and populated Ttenbergen 22:39, 2014 May 20 (CDT)
* added to table '''s_admitDischarge''' column "hosp" and "ward", and indexed and populated Ttenbergen 22:39, 2014 May 20 (CDT)
* added indices to table ''s_locations'' - Ttenbergen 10:25, 2014 May 21 (CDT)
* added indices to table ''s_locations'' - Ttenbergen 10:25, 2014 May 21 (CDT)
* updated query NDC_Orphans to reflect [[Orphans_in_Centralized_data.mdb#ward.2Funits_with_more_than_one_collector]] Ttenbergen 22:35, 2014 May 26 (CDT)
* updated query NDC_Orphans to reflect [[Orphans_in_[[Centralized data.accdb]]#ward.2Funits_with_more_than_one_collector]] Ttenbergen 22:35, 2014 May 26 (CDT)
* fixed function "transfer_time_maker"; it was failing when the transfer date is null. Ttenbergen 18:14, 2014 May 28 (CDT)
* fixed function "transfer_time_maker"; it was failing when the transfer date is null. Ttenbergen 18:14, 2014 May 28 (CDT)
* added fields to create_variables: Ttenbergen 18:14, 2014 May 28 (CDT)
* added fields to create_variables: Ttenbergen 18:14, 2014 May 28 (CDT)