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-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
  • 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