Difference between revisions of "Centralized data front end.accdb Change Log 2021"

From CCMDB Wiki
Jump to navigation Jump to search
 
(15 intermediate revisions by the same user not shown)
Line 4: Line 4:


== Log ==
== Log ==
=== 2021-08-26 ===
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 August 25 (CDT)
* made query structure for [[Created_FirstLocation query]] in [[CFE]] the same as counterpart in [[CCMDB.accdb]], and updated ''created_variables_common_2021'' query to use the new field names.
=== 2021-08-25 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 11:54, 2021 August 26 (CDT)
* created crosstab queries to replace pivot tables since 2019 doesnt' support them any more:
** [[CT_Summary_Discharges query]] to replace old ''P_Summary_Discharges query''
** [[CT_Summary_Discharges_FiscalYear query]] to replace old ''P_Summary_Discharges_FiscalYear query''
=== 2021-08-24 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 August 25 (CDT)
* fixed [[created_AdmitDtTm query]] to explicitly turn the date into date data type; somehow the query turned it into something else that was being sorted differently on Pagasa's computer than on Tina's. [[User:Ttenbergen|Ttenbergen]] 14:06, 2021 August 24 (CDT)
* created crosstab queries to replace pivot tables since 2019 doesnt' support them any more:
** [[CT_Count_of_Admissions query]] to replace old ''P_Count_of_Admissions query''
** [[CT_Outstandings_Dispo query]] confirmed, replaces old ''P_Outstandings_Dispo''
** [[CT_Outstandings query]] (though not a crosstab because not needed) to replace ''P_Outstandings''
=== 2021-08-05 ===
=== 2021-08-05 ===
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 14:46, 2021 August 5 (CDT)
copied to server [[User:Ttenbergen|Ttenbergen]] 11:20, 2021 August 24 (CDT)
* updated algorithm behind [[Populate linking pairs]] which had been generating twin pairs.
* updated [[Link suspect mismatch pre inpt ours incomplete query]] to only look a the last three years


=== 2021-08-04 ===
=== 2021-08-04 ===
Line 19: Line 40:
=== 2021-07-20 ===
=== 2021-07-20 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 17:00, 2021 July 20 (CDT)
copied to server [[User:Ttenbergen|Ttenbergen]] 17:00, 2021 July 20 (CDT)
* made a crosstab query ''P_Outstandings_Dispo'' to replace [[Query P_Outstandings_Dispo]] to test as replacement for Pivot Tables, since those no longer work in Access 2019 [[User:Ttenbergen|Ttenbergen]] 16:55, 2021 July 20 (CDT)
* made a crosstab query ''P_Outstandings_Dispo'' to replace ''Query P_Outstandings_Dispo'' to test as replacement for Pivot Tables, since those no longer work in Access 2019 [[User:Ttenbergen|Ttenbergen]] 16:55, 2021 July 20 (CDT)


=== 2021-07-15 ===
=== 2021-07-15 ===
Line 51: Line 72:
Copied to server
Copied to server
* updated to list by laptop:  
* updated to list by laptop:  
** [[query P_Outstandings]]
** ''query P_Outstandings''
** [[query P_Outstandings_Dispo]]
** ''query P_Outstandings_Dispo''
* tweaked  
* tweaked  
** [[Link suspect transfer ready before arrive date]] and then stopped when I realized that will go away with the old [[Transfer Ready DtTm field]].
** [[Link suspect transfer ready before arrive date]] and then stopped when I realized that will go away with the old [[Transfer Ready DtTm field]].

Latest revision as of 15:01, 2021 September 16

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-08-26

not rolled out yet Ttenbergen 12:40, 2021 August 25 (CDT)

2021-08-25

copied to server Ttenbergen 11:54, 2021 August 26 (CDT)

2021-08-24

copied to server Ttenbergen 12:40, 2021 August 25 (CDT)

  • fixed created_AdmitDtTm query to explicitly turn the date into date data type; somehow the query turned it into something else that was being sorted differently on Pagasa's computer than on Tina's. Ttenbergen 14:06, 2021 August 24 (CDT)
  • created crosstab queries to replace pivot tables since 2019 doesnt' support them any more:

2021-08-05

copied to server Ttenbergen 11:20, 2021 August 24 (CDT)

2021-08-04

copied to server Ttenbergen 14:46, 2021 August 5 (CDT)

2021-07-27

copied to server Ttenbergen 22:31, 2021 August 3 (CDT)

  • tweak to query encounter_clean_3_del_pers_where_no_L_Person which is part of Person ID field generate person ids; it was failing, but because of how we run these queries that was not visible.
  • updated algorithm behind Populate linking pairs which was impracticably slow under Access 2019

2021-07-20

copied to server Ttenbergen 17:00, 2021 July 20 (CDT)

  • made a crosstab query P_Outstandings_Dispo to replace Query P_Outstandings_Dispo to test as replacement for Pivot Tables, since those no longer work in Access 2019 Ttenbergen 16:55, 2021 July 20 (CDT)

2021-07-15

copied to server Ttenbergen 17:25, 2021 July 15 (CDT)

2021-04-21

copied to server Ttenbergen 15:20, 2021 June 3 (CDT)

2021-02-11

copied to server Ttenbergen 14:39, 2021 February 11 (CST)

2021-02-04

copied to server Ttenbergen 14:30, 2021 February 4 (CST)

2021-01-21

Copied to server

2021-01-20

Pagasa has copied to server

  • updated P_Count_of_sent query to be laptop based and to more closely show Pagasa what she actually needs.
  • removed defunct queries
    • Query NDC CLI AcqDX but NoCLI DateinTMPV2
    • Query NDC CLI No AcqDX but CLI DateinTMPV2

Earlier changes

See Centralized data front end.accdb Change Log 2020

Related articles

Related articles: