Centralized data front end.accdb Change Log 2019: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 29: | Line 29: | ||
** [[Query 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. | ** [[Query 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 vent2300]] - implemented | ||
** [[TISS Errors Vent vs mechanism]] - implemented | |||
===2018-11-23=== | ===2018-11-23=== | ||
Revision as of 15:33, 6 January 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
- Query 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