Centralized data front end.accdb Change Log 2019: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 36: | Line 36: | ||
* query updates/creations: | * query updates/creations: | ||
** [[NDC_cardioversion_dx_vs_TISS]] - implemented | ** [[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 | ** [[Query NDC_CRRT_TISS_CCI]] | ||
** [[Query | ** [[Query NDC_PD_TISS_CCI]] | ||
** [[Query | ** [[Query NDC_HD_TISS_CCI]] | ||
** [[Query | ** [[Query NDC_Dxs_vs_TISS_Dialysis]] | ||
** [[Query | ** [[Query NDC_Pacemaker_acquired_vs_TISS]] | ||
* deleted | * deleted | ||
** "NDC Missing TransferDate w pivot" as confirmed by Julie on that page | ** "NDC Missing TransferDate w pivot" as confirmed by Julie on that page | ||
Revision as of 11:25, 7 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-07
not rolled yet Ttenbergen 08:38, 2019 January 7 (CST)
- updated Form LinkList that is triggered from "open suspect links" (used in Correcting suspect links) button to eliminate an error it was giving involving the ancient survive/expire field. However, this form is still not working right, and won't until Deceased patients is worked out. Added question about this there. Chances are we don't need this any more since this stuff is usually done with PLs and NDCs now. Left question in Deceased patients to deal with when that is resolved. Ttenbergen 08:38, 2019 January 7 (CST)
- updated to name additional D_ID fields so this will work in query dropdown:
2019-01-02
copied to server Ttenbergen 23:24, 2019 January 6 (CST)
- added rudimentary CCI and ICD10 forms; will need to make better
- 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