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 - "[[Category: " to "[[Category:"
 
(3 intermediate revisions by the same user not shown)
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)
Line 552: Line 552:
** contains L_Dxs where adm_acqu = "Task"
** contains L_Dxs where adm_acqu = "Task"


[[Category: Development Documentation]]
[[Category:Development Documentation]]
[[category:2013 data upgrades]]
[[category:2013 data upgrades]]
[[Category: Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]