View source for Centralized data front end.accdb Change Log 2020

__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. -->
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
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 ==
=== 2021 ===
See [[Centralized data front end.accdb Change Log 2021]]

===2020-12-17 ===
moved to master[[User:Ttenbergen|Ttenbergen]] 14:11, 2020 December 17 (CST)
* updated [[PL_SamePhin_Diff_DOB_Sex]] to not check for names any more [[User:Ttenbergen|Ttenbergen]] 13:27, 2020 December 17 (CST)

===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===
rolled out 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===
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)

===2020-04-08===
copied to server Ttenbergen 20:00, 2020 April 8 (CDT)
* changed [[Link suspect mismatch pre inpt ours incomplete query]] to only look at last 500 days to speed it up, it was looking at data from 2005. 
* tweaked form Likely_match (aka cat button form) to add service location to make it easier to eyeball how the patient travelled. Ttenbergen 14:47, 2020 April 8 (CDT)

to move to [[CCMDB.accdb Change Log 2020]] but kept here for now to have it in one place:
* tweaked entries in [[S dispo table]] for STB_E6 to fix linking queries.

===2020-03-04===
rolled out Ttenbergen 14:06, 2020 March 22 (CDT)
* added '''temp''' query ''COV_Pat_ID_matcher'' to help with covid cleanup for H4 laptop

===2020-03-04===
rolled out Ttenbergen 17:59, 2020 March 4 (CST)
* implemented deletion of earlier records for [[Update of D ID to include a laptop identifier]]
* '''temp'''
** query ''9_D_ID_change__int_finder'' 
** query ''9_D_ID_change__int'' 
** query ''9_D_ID_1_L_PHI_Deleter''
** query ''9_D_ID_2_L_Log_Deleter''

===2020-02-19===
rolled out [[User:PTorres|PTorres]] 13:26, 2020 February 21 (CST)
*added [[link_suspect_transfer_ready_greater_than_dispo]]
*added [[ link_suspect_transfer_ready_before_arrive_date]]

=== 2020-01-29 ===
* 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?

== Earlier changes ==
See [[Centralized data front end.accdb Change Log 2019]]

== Related articles == 
{{Related Articles}}


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