Centralized data front end.accdb Change Log 2020

From CCMDB Wiki
Jump to navigationJump to search

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

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

2020-10-15

rolled out - PTorres 12:56, 2020 October 15 (CDT)

  • New Table added: L_Problems_D_ID

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)

2020-04-21-1

copied to master Ttenbergen 16:43, 2020 April 21 (CDT)

2020-04-21

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

2020-02-19

rolled out PTorres 13:26, 2020 February 21 (CST)

2020-01-29

2019

Related articles

Related articles:

Earlier changes

See Centralized data front end.accdb Change Log 2019

Related articles

Related articles: