Centralized data front end.accdb Change Log 2020: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m (→2020-07-09) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (13 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
== Log == | == 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=== | ===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 table: Mgmt EFT table (still need to added in Medicine EFT change dates for STB and HSC) | ||
*Updated query: Mgmt laptop_ID_discharged | *Updated query: Mgmt laptop_ID_discharged | ||
===2020-08-05=== | ===2020-08-05=== | ||
changes on Pagasa Ttenbergen 13:14, 2020 August 5 (CDT) | changes on Pagasa Ttenbergen 13:14, 2020 August 5 (CDT) | ||
| Line 28: | Line 39: | ||
===2020-04-26=== | ===2020-04-26=== | ||
copied to master Ttenbergen 20:44, 2020 April 26 (CDT) | copied to master Ttenbergen 20:44, 2020 April 26 (CDT) | ||
* total re-do of [[ | * 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 | * added [[Person_ID]] to "Query Covid_rept" as requested by Julie Ttenbergen 20:39, 2020 April 26 (CDT) | ||
===2020-04-21-1=== | ===2020-04-21-1=== | ||
copied to master Ttenbergen 16:43, 2020 April 21 (CDT) | copied to master Ttenbergen 16:43, 2020 April 21 (CDT) | ||
* further tweaks to | * further tweaks to "Query Covid_rept" | ||
* added | * 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 | * 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 | * 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 73: | 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? | ||
== Earlier changes == | == Earlier changes == | ||
| Line 91: | Line 92: | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||
[[Category: Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||
Latest revision as of 16:57, 2022 April 27
see the 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 masterTtenbergen 14:11, 2020 December 17 (CST)
- updated PL_SamePhin_Diff_DOB_Sex to not check for names any more Ttenbergen 13:27, 2020 December 17 (CST)
2020-12-03
rolled out 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 - PTorres 12:56, 2020 October 15 (CDT)
- New Table added: L_Problems_D_ID table
2020-09-24
rolled out.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) 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 identifiers) 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 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. 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: |