Centralized data front end.accdb Change Log 2023: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 10: | Line 10: | ||
* 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) | * updated function ApScore_pH() to return 0 rather than Null when receiving a Null input [[User:Ttenbergen|Ttenbergen]] 12:02, 2023 February 23 (CST) | ||
* 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) | |||
=== 2022-12-08 === | === 2022-12-08 === | ||
Revision as of 10:18, 20 April 2023
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-02-09
not rolled out yet Ttenbergen 13:48, 2023 February 2 (CST)
- 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)
- updated compact_and_reconnect(), it was still trying to reconnect L_Dxs and L_Como table Ttenbergen 10:18, 2023 April 20 (CDT)
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: |