Centralized data front end.accdb Change Log 2023: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| (30 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 === | |||
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 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) | |||
* 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]] | ||
* updated [[query L_ICD10_Charlson_dxs]] to include scores and not filter for dx type as per [[Charlson_Comorbidities_in_ICD10_codes#Summary]] | |||
* removed because being replaced with better naming convention: | |||
** Charlson_Comorbid_Score | |||
** Charlson_Comorbid_Score__detail | |||
** Charlson_Comorbid_Score_Admit_detail | |||
** Charlson_Comorbid_Score_Como_detail | |||
* added | |||
** [[query L_ICD10_Charlson_component_points]] | |||
** [[query L_ICD10_Charlson_dxs]] | |||
** [[query L_ICD10_Charlson_score]] | |||
** [[query Charlson_Score_pre_and_ICD10]] | |||
== Earlier changes == | == Earlier changes == | ||
Latest revision as of 16:06, 17 October 2024
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
2023
See Centralized data front end.accdb Change Log 2024
2023-08-15
copied to server Ttenbergen 10:53, 2023 August 15 (CDT)
- tweak to Reconnect_check_orphans query for easier eyeballing until I can fix this Ttenbergen 10:53, 2023 August 15 (CDT)
2023-06-28
rolled out 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 Ttenbergen 10:30, 2023 June 28 (CDT)
2023-06-07
copied to server 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 Ttenbergen 09:15, 2023 April 25 (CDT)
- fixed handshake button Ttenbergen 09:15, 2023 April 25 (CDT)
2023-04-23
copied to serverTtenbergen 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 Ttenbergen 14:20, 2023 April 20 (CDT)
- Updated S ICD10 Charlson Como patterns table according to new list from Allan Garland Ttenbergen 16:16, 2023 April 20 (CDT)
- also updated Charlson Comorbidities in ICD10 codes ans S ICD10 Charlson Como patterns table Ttenbergen 16:23, 2023 April 20 (CDT)
2023-02-09
copied to server 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 Ttenbergen 14:18, 2023 April 20 (CDT)* updated compact_and_reconnect(), it was still trying to reconnect L_Dxs and L_Como table Ttenbergen 10:18, 2023 April 20 (CDT)* updated Calc created variables button to create the 2021 queries rather than the old ones Ttenbergen 16:57, 2023 April 19 (CDT)
- removed the old, undated created variables queries 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 Ttenbergen 13:03, 2023 February 9 (CST)
- updated function ApScore_pH() to return 0 rather than Null when receiving a Null input Ttenbergen 12:02, 2023 February 23 (CST)
2022-12-08
copied to server Ttenbergen 13:49, 2023 February 2 (CST)
- 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). 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 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 query L_ICD10_Charlson_dxs to include scores and not filter for dx type as per Charlson_Comorbidities_in_ICD10_codes#Summary
- removed because being replaced with better naming convention:
- Charlson_Comorbid_Score
- Charlson_Comorbid_Score__detail
- Charlson_Comorbid_Score_Admit_detail
- Charlson_Comorbid_Score_Como_detail
- added
Earlier changes
See Centralized data front end.accdb Change Log 2022
Related articles
| Related articles: |