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

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2020"

@@ Line 4: / Line 4: @@
 == Log ==
-=== 2020-01-?? ===
+=== 2021 ===
-Changes to [[Query NDC Postal Code over time]] that may not have been rolled out right?
+See [[Centralized data front end.accdb Change Log 2021]]
-{{Discuss | Pagasa, did this change get rolled out right? }}
+===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 ==
@@ Line 16: / Line 92: @@
-[[Category: Development Documentation]]
+[[Category:Development Documentation]]
-[[Category: Centralized data front end.accdb]]
+[[Category:Centralized data front end.accdb]]