Centralized data front end.accdb Change Log 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 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)

2022-12-08

copied to server Ttenbergen 13:49, 2023 February 2 (CST)

• updated Created _Variables_CC maker query resp Created Variables CC 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
  • query L_ICD10_Charlson_component_points
  • query L_ICD10_Charlson_dxs
  • query L_ICD10_Charlson_score
  • query Charlson_Score_pre_and_ICD10

Earlier changes

See Centralized data front end.accdb Change Log 2022