Centralized data front end.accdb Change Log 2023: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→2023-02-09) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 11: | Line 11: | ||
=== 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]] | ||
Revision as of 15:23, 2023 April 19
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 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: |
|