Centralized data front end.accdb Change Log 2023: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| (23 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> | {{DISPLAYTITLE:Centralized_data_front_end.accdb Change Log 2023}}__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'' | ''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]]. | 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 == | == Log == | ||
=== 2023 === | |||
See [[Centralized data front end.accdb Change Log 2024]] | |||
=== 2023-08-15 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 10:53, 2023 August 15 (CDT) | |||
* tweak to [[Reconnect_check_orphans query]] for easier eyeballing until I can fix this [[User:Ttenbergen|Ttenbergen]] 10:53, 2023 August 15 (CDT) | |||
=== 2023-06-28 === | |||
rolled out [[User:Ttenbergen|Ttenbergen]] 10:45, 2023 June 28 (CDT) | |||
* updated [[Query NDC_dx_implying_death_across_encounters]] which has apparently had a broken first service date since we changed how that is done [[User:Ttenbergen|Ttenbergen]] 10:30, 2023 June 28 (CDT) | |||
=== 2023-06-07 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 15:21, 2023 June 7 (CDT) | |||
* deleted old [[Link_suspect_not_same_visitAdmitDtTm query ]] and renamed query ''link_suspect_not_same_visitAdmitDtTm_foo'' to that | |||
=== 2023-04-23 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 09:15, 2023 April 25 (CDT) | |||
* fixed handshake button [[User:Ttenbergen|Ttenbergen]] 09:15, 2023 April 25 (CDT) | |||
=== 2023-04-23 === | |||
copied to server[[User:Ttenbergen|Ttenbergen]] 17:23, 2023 April 23 (CDT) | |||
* a bunch of queries had columns aliased to "expr" in the re-import; deleted all queries and re-imported them, seems better this round. | |||
=== 2023-04-20 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 14:20, 2023 April 20 (CDT) | |||
* Updated [[S ICD10 Charlson Como patterns table]] according to new list from Allan Garland [[User:Ttenbergen|Ttenbergen]] 16:16, 2023 April 20 (CDT) | |||
** also updated [[Charlson Comorbidities in ICD10 codes]] ans [[S ICD10 Charlson Como patterns table]] [[User:Ttenbergen|Ttenbergen]] 16:23, 2023 April 20 (CDT) | |||
=== 2023-02-09 === | === 2023-02-09 === | ||
copied to server [[User:Ttenbergen|Ttenbergen]] 14:20, 2023 April 20 (CDT) | |||
* '''experienced some corruption where file was big and could no longer compact; re-imported into a clean DB and recompiled, which brought forward some errors it should have found before, fixed those''' [[User:Ttenbergen|Ttenbergen]] 14:18, 2023 April 20 (CDT)* updated compact_and_reconnect(), it was still trying to reconnect L_Dxs and L_Como table [[User:Ttenbergen|Ttenbergen]] 10:18, 2023 April 20 (CDT)* updated [[Calc created variables button]] to create the 2021 queries rather than the old ones [[User:Ttenbergen|Ttenbergen]] 16:57, 2023 April 19 (CDT) | |||
* removed the old, undated created variables queries [[User:Ttenbergen|Ttenbergen]] 16:57, 2023 April 19 (CDT) | |||
* updated [[Created_Variables_CC_2021 table]] and [[Created_Variables_CC_maker_2021 query]] to eliminate the duplicate fields ''Ap_Chronic'' and ''chronic_pts'' [[User:Ttenbergen|Ttenbergen]] 13:03, 2023 February 9 (CST) | * updated [[Created_Variables_CC_2021 table]] and [[Created_Variables_CC_maker_2021 query]] to eliminate the duplicate fields ''Ap_Chronic'' and ''chronic_pts'' [[User:Ttenbergen|Ttenbergen]] 13:03, 2023 February 9 (CST) | ||
* updated function ApScore_pH() to return 0 rather than Null when receiving a Null input [[User:Ttenbergen|Ttenbergen]] 12:02, 2023 February 23 (CST) | |||
=== 2022-12-08 === | === 2022-12-08 === | ||
copied to server [[User:Ttenbergen|Ttenbergen]] 13:49, 2023 February 2 (CST) | copied to server [[User:Ttenbergen|Ttenbergen]] 13:49, 2023 February 2 (CST) | ||
* updated [[ | * updated Created_Variables_CC_maker query (see [[Created_Variables_CC_maker_2021 query]]) resp Created_Variables_CC_table (see [[Created_Variables_CC_2021 table]]) to remove fields [[Ap Chronic]] (ie old L_Log field), 'CH' and ''chronic_pts'' (ie duplicate of ApTotal_Chronic). [[User:Ttenbergen|Ttenbergen]] 11:44, 2022 December 8 (CST) | ||
* update [[S_ICD10_Charlson_Comorbids query]] to pull in [[S_ICD10_Charlson_Como_conditions table]] already, before it was being pulled in only at the L_ query stage [[User:Ttenbergen|Ttenbergen]] 12:09, 2023 February 1 (CST) | * update [[S_ICD10_Charlson_Comorbids query]] to pull in [[S_ICD10_Charlson_Como_conditions table]] already, before it was being pulled in only at the L_ query stage [[User:Ttenbergen|Ttenbergen]] 12:09, 2023 February 1 (CST) | ||
* updated [[S_ICD10_Charlson_Como_conditions table]] to use same group names as in [[s_ICD10_Charlson_Como_patterns table]] | * updated [[S_ICD10_Charlson_Como_conditions table]] to use same group names as in [[s_ICD10_Charlson_Como_patterns table]] | ||