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

m Text replacement - "PL_missing_L_Tables_content" to "Reconnect_check_missing_L Tables_content query"
m Text replacement - "[[Category: " to "[[Category:"
 
(5 intermediate revisions by the same user not shown)
Line 100: Line 100:
rolled out Ttenbergen 17:07, 2016 October 27 (CDT)
rolled out Ttenbergen 17:07, 2016 October 27 (CDT)
* query ''query NDC_VAP_unacceptable_date'' - had false negative, added restriction where date can't be after [[dispo_DtTm]]
* query ''query NDC_VAP_unacceptable_date'' - had false negative, added restriction where date can't be after [[dispo_DtTm]]
* form viewer - allowing inactive values for previous location and pre-admit inpatient location
* form viewer - allowing inactive values for [[Previous Location]] and [[Pre-admit Inpatient Institution]]


=== 2016-10-27-2 ===
=== 2016-10-27-2 ===
Line 144: Line 144:
* added module updaters with sub Morden_Winkler_Boundarytrails() and several helper functions to update groups of items in s_dispo Ttenbergen 13:09, 2016 September 29 (CDT)
* added module updaters with sub Morden_Winkler_Boundarytrails() and several helper functions to update groups of items in s_dispo Ttenbergen 13:09, 2016 September 29 (CDT)
** was run.  Ttenbergen 17:57, 2016 October 3 (CDT)
** was run.  Ttenbergen 17:57, 2016 October 3 (CDT)
* added (and ran) queries for [[Centralized_data.mdb_Change_Log#2016-Oct-03]]
* added (and ran) queries for [[Centralized_data.accdb]]_Change_Log#2016-Oct-03]]
** they were run. Ttenbergen 17:51, 2016 October 3 (CDT)
** they were run. Ttenbergen 17:51, 2016 October 3 (CDT)


Line 158: Line 158:
rolled Ttenbergen 17:01, 2016 September 19 (CDT)
rolled Ttenbergen 17:01, 2016 September 19 (CDT)
* Made viewer same as CCMDB (ADL Tab and moved reg fields we continue to use into the Dispo tab)
* Made viewer same as CCMDB (ADL Tab and moved reg fields we continue to use into the Dispo tab)
* removed query ''ages'' that used to calculate [[age]], since Julie gets this from [[Created_Variables_Common table]] Ttenbergen 15:07, 2016 September 19 (CDT)
* removed query ''ages'' that used to calculate [[age]], since Julie gets this from [[Created_Variables_Common_2021 table]] Ttenbergen 15:07, 2016 September 19 (CDT)


===2016-09-08===
===2016-09-08===
Line 346: Line 346:




[[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]]