CCMDB Wiki

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

← Older edit
m link fix
m Text replacement - "[[Category: " to "[[Category:"
 
(7 intermediate revisions by the same user not shown)
Line 18: Line 18:
=== 2016-12-07 ===
=== 2016-12-07 ===
rolled out Ttenbergen 17:29, 2016 December 7 (CST)
rolled out Ttenbergen 17:29, 2016 December 7 (CST)
* [[PL_missing_L_Tables_content]]  - updated to not use old dispo fields any more. Ttenbergen 17:29, 2016 December 7 (CST)
* [[Reconnect_check_missing_L Tables_content query]]  - updated to not use old dispo fields any more. Ttenbergen 17:29, 2016 December 7 (CST)
* deleted old legacy tab in patient viewer Ttenbergen 17:29, 2016 December 7 (CST)
* deleted old legacy tab in patient viewer Ttenbergen 17:29, 2016 December 7 (CST)
* searched for remaining mentions of r_adm and r_dis etc and commented them out Ttenbergen 17:29, 2016 December 7 (CST)
* searched for remaining mentions of r_adm and r_dis etc and commented them out Ttenbergen 17:29, 2016 December 7 (CST)
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 260: Line 260:
** query ''PL_SameCHART_Site_Diff_PHIN''
** query ''PL_SameCHART_Site_Diff_PHIN''
** query ''PL_2PHIN _Fake_or_blank''
** query ''PL_2PHIN _Fake_or_blank''
** query ''[[PL_1orphans]]''
** query ''[[Reconnect_check_orphans query ]]''
** query ''P_Summary_Discharges_FiscalYear''
** query ''P_Summary_Discharges_FiscalYear''
** query ''P_Summary_Discharges''
** query ''P_Summary_Discharges''
Line 338: Line 338:
=== 2016-01-28 ===
=== 2016-01-28 ===
rolled out Ttenbergen 15:50, 2016 January 28 (CST)
rolled out Ttenbergen 15:50, 2016 January 28 (CST)
* updating ''[[PL_missing_L_Tables_content]]'' to not list incompletes even for dxs. Ttenbergen 15:50, 2016 January 28 (CST)
* updating ''[[Reconnect_check_missing_L Tables_content query]]'' to not list incompletes even for dxs. Ttenbergen 15:50, 2016 January 28 (CST)


=== 2016-01-21 ===
=== 2016-01-21 ===
rolled out.--Ttenbergen 17:19, 2016 January 21 (CST)
rolled out.--Ttenbergen 17:19, 2016 January 21 (CST)
* added CFE ''[[PL_missing_L_Tables_content]]'' to find missing mandatory child entries Ttenbergen 17:19, 2016 January 21 (CST)
* added CFE ''[[Reconnect_check_missing_L Tables_content query]]'' to find missing mandatory child entries Ttenbergen 17:19, 2016 January 21 (CST)
* updated query ''ADL_Scores'' to refer to ALERT rather than MOST Ttenbergen 17:26, 2016 January 21 (CST)
* updated query ''ADL_Scores'' to refer to ALERT rather than MOST Ttenbergen 17:26, 2016 January 21 (CST)




[[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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.mdb_Change_Log_2016"