CCMDB Wiki

Centralized data front end.accdb Change Log 2020: Difference between revisions

← Older edit
mNo edit summary
mNo edit summary
 
(21 intermediate revisions by 3 users not shown)
Line 4: Line 4:


== Log ==
== Log ==
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
=== 2021 ===
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
See [[Centralized data front end.accdb Change Log 2021]]
This article is the change log for [[Centralized data front end.accdb]]. Also see [[Centralized data front end.accdb Change Request]] and [[CFE Data Integrity Checks]].


== Log ==
===2020-12-17 ===
===2020=04-21-1===
moved to master[[User:Ttenbergen|Ttenbergen]] 14:11, 2020 December 17 (CST)
not rolled yet Ttenbergen 16:39, 2020 April 21 (CDT)
* updated [[PL_SamePhin_Diff_DOB_Sex]] to not check for names any more [[User:Ttenbergen|Ttenbergen]] 13:27, 2020 December 17 (CST)
* furhter tweaks to [[Query Covid_rept]]
 
* added [[Form Covid_rept]] to better manage formatting. Ttenbergen 16:39, 2020 April 21 (CDT)
===2020-12-03 ===
rolled out [[User:Ttenbergen|Ttenbergen]] 10:35, 2020 December 3 (CST)
* added new s_ tables for [[Cognos EPR Report]] to the connector: [[s_Cognos_Services table]], [[s_Cognos_Units table]]
 
===2020-10-15===
rolled out - [[User:PTorres|PTorres]] 12:56, 2020 October 15 (CDT)
*New Table added: [[L_Problems_D_ID table]]
 
===2020-09-24===
rolled out.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:01, 2020 September 24 (CDT)
*Updated table: Mgmt EFT table (still need to added in Medicine EFT change dates for STB and HSC)
*Updated query: Mgmt laptop_ID_discharged
 
===2020-08-05===
changes on Pagasa Ttenbergen 13:14, 2020 August 5 (CDT)
* eliminated all [[Boarding Loc]]
* updated [[Link suspect mismatch to ours incomplete query]]
** eliminated old exceptions for Vic locations
** shortened date range to >#1/1/2015#
* deleted query "link_suspect_mismatch_to_ours__incomplete2" that was not used and not documented, we must have set that up for testing at some point...
 
===2020-07-09===
*not rolled out.  Ttenbergen 17:30, 2020 July 9 (CDT) [[User:TOstryzniuk|Trish Ostryzniuk]] 17:02, 2020 September 24 (CDT)
changes on Trish Ttenbergen 17:30, 2020 July 9 (CDT)
* added query p_count_of_admissions_by_laptop
 
===2020-04-26===
copied to master Ttenbergen 20:44, 2020 April 26 (CDT)
* total re-do of [[Reconnect_check_orphans query ]] to fix problem with using same [[Service/Location]] and [[Pat_ID]] on two different laptops (ie with two different [[Laptop identifier]]s) Ttenbergen 20:39, 2020 April 26 (CDT)
* added [[Person_ID]] to "Query Covid_rept" as requested by Julie Ttenbergen 20:39, 2020 April 26 (CDT)
 
===2020-04-21-1===
copied to master Ttenbergen 16:43, 2020 April 21 (CDT)
* further tweaks to "Query Covid_rept"
* added "Form Covid_rept" to better manage formatting. Ttenbergen 16:39, 2020 April 21 (CDT)


===2020-04-21===
===2020-04-21===
rolled out Ttenbergen 10:14, 2020 April 21 (CDT)
rolled out Ttenbergen 10:14, 2020 April 21 (CDT)
* updated [[Query Covid_rept]] to include [[Arrive DtTm]]. Ttenbergen 10:14, 2020 April 21 (CDT)
* updated "Query Covid_rept" to include Arrive DtTm. Ttenbergen 10:14, 2020 April 21 (CDT)


===2020-04-19===
===2020-04-19===
rolled it at some point but didn't update this at the time.  
rolled it at some point but didn't update this at the time.  
* set up [[Query Covid_rept]] and its intermediate queries Covid_rept_int_COV, Covid_rept_int_Obs Ttenbergen 23:45, 2020 April 19 (CDT)
* set up "Query Covid_rept" and its intermediate queries Covid_rept_int_COV, Covid_rept_int_Obs Ttenbergen 23:45, 2020 April 19 (CDT)


===2020-04-08===
===2020-04-08===
Line 51: Line 84:
* Tweak to link_Int_suspect_not_same_visitAdmitDtTm_int (used by [[Link suspect not same visitAdmitDtTm query]]) which was suddenly not working when Pagasa got back from vacation. [[User:PTorres|PTorres]] 10:18, 2020 January 29 (CST)
* Tweak to link_Int_suspect_not_same_visitAdmitDtTm_int (used by [[Link suspect not same visitAdmitDtTm query]]) which was suddenly not working when Pagasa got back from vacation. [[User:PTorres|PTorres]] 10:18, 2020 January 29 (CST)
* Changes to [[Query NDC Postal Code over time]] that may not have been rolled out right?
* Changes to [[Query NDC Postal Code over time]] that may not have been rolled out right?
===2019===
* see [[Centralized data front end.accdb Change Log 2019]]
== Related articles ==
{{Related Articles}}
[[Category: Development Documentation]]
[[Category: Centralized data front end.accdb]]


== Earlier changes ==
== Earlier changes ==
Line 69: Line 92:




[[Category: Development Documentation]]
[[Category:Development Documentation]]
[[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.accdb_Change_Log_2020"