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

2022-12-08

not rolled out yet Ttenbergen 11:44, 2022 December 8 (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