Centralized data front end.accdb Change Log 2019

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

2019-01-02

not rolled yet Ttenbergen 16:15, 2019 January 2 (CST)

• updated Function confirm_files_and_links() to include the new tables used in ICD10 and CCI:
  • s_CCI_Categories
  • s_CCI_Categories_Collection_Mode
  • s_ICD10_APACHE_Como_patterns
  • s_ICD10_APACHE_Dx_patterns
  • s_ICD10_Charlson_Como_conditions
  • s_ICD10_Charlson_Como_patterns
  • s_ICD10_Block_Dxs
  • s_ICD10_Blocks
• imported queries and modified to use D_ID instead of Pat_ID as appropriate:
  • L_ICD10_APACHE_Comorbids
  • L_ICD10_APACHE_Dx
  • L_ICD10_Charlson_Agepts
  • L_ICD10_Charlson_component_points
  • L_ICD10_Charlson_dxs
  • L_ICD10_Charlson_score
  • s_ICD10_APACHE_Comorbids
  • s_ICD10_APACHE_Dx
  • s_ICD10_Charlson_Comorbids
• query updates/creations:
  • NDC_cardioversion_dx_vs_TISS - implemented
  • TISS Errors TISS date out of admission - added L_Problems link and changed the date range tested to be Dispo_DtTm within the last year.
  • TISS Errors vent vs vent2300 - implemented
  • TISS Errors Vent vs mechanism - implemented
  • Query NDC CRRT TISS CCI
  • Query NDC PD TISS CCI
  • Query NDC HD TISS CCI
  • Query NDC Dxs vs TISS Dialysis
  • Query NDC Pacemaker acquired vs TISS
• deleted
  • "NDC Missing TransferDate w pivot" as confirmed by Julie on that page
  • "NDC_Pacemaker_TISS_wo_acquired" - was rolled in with query NDC Pacemaker acquired vs TISS
  • NDC_VAP_no_TISS deleted for now; the old one was old dxs so no longer any good, and check currently does not make sense under new collection rules.
• renamed "NDC missing L Tables content" to PL missing L Tables content as confirmed by Julie since that is really something that needs to be run before linking

2018-11-23

• see Centralized data front end.accdb Change Log 2018