Centralized data front end.mdb Change Log 2014: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "PL_1orphans" to "Reconnect_check_orphans query " |
Ttenbergen (talk | contribs) m links to s_charlson_dxs table |
||
| Line 178: | Line 178: | ||
* updated s_como to make left_join to charlsons; s_como is subset of s_alldxs that are comos, not just that are charlsons. Ttenbergen 16:13, 2014 July 21 (CDT) | * updated s_como to make left_join to charlsons; s_como is subset of s_alldxs that are comos, not just that are charlsons. Ttenbergen 16:13, 2014 July 21 (CDT) | ||
* set up queries 1_use_only_fix_dx_casing, 1_use_only_med_apache_null_after_SAPS, 1_use_only_update_3000_transfer_dates_to_null; emailed Pagasa/Julie/Trish with use instructions Ttenbergen 17:26, 2014 July 21 (CDT) | * set up queries 1_use_only_fix_dx_casing, 1_use_only_med_apache_null_after_SAPS, 1_use_only_update_3000_transfer_dates_to_null; emailed Pagasa/Julie/Trish with use instructions Ttenbergen 17:26, 2014 July 21 (CDT) | ||
* replaced s_charlson_dxs with version from [[CCMDB.accdb]] that includes which are allowed as admit/complications Ttenbergen 11:18, 2014 July 24 (CDT) | * replaced [[s_charlson_dxs table]] with version from [[CCMDB.accdb]] that includes which are allowed as admit/complications Ttenbergen 11:18, 2014 July 24 (CDT) | ||
* Charlson comorbid scoring; added/updated queries Ttenbergen 12:18, 2014 July 24 (CDT) | * Charlson comorbid scoring; added/updated queries Ttenbergen 12:18, 2014 July 24 (CDT) | ||
** Charlson_Comorbid_Score | ** Charlson_Comorbid_Score | ||
| Line 197: | Line 197: | ||
* made viewer form's fields trans and discharge date formats consistent with other fields, ie dd-mmm-yyyy Ttenbergen 16:04, 2014 July 17 (CDT) | * made viewer form's fields trans and discharge date formats consistent with other fields, ie dd-mmm-yyyy Ttenbergen 16:04, 2014 July 17 (CDT) | ||
* updated query s_como to include charlson score Ttenbergen 16:14, 2014 July 17 (CDT) | * updated query s_como to include charlson score Ttenbergen 16:14, 2014 July 17 (CDT) | ||
* updated query s_charlson_dxs to loose allow_admit and allow_como columns, those are addressed in s_alldiagnoses Ttenbergen 16:14, 2014 July 17 (CDT) | * updated query [[s_charlson_dxs table]] to loose allow_admit and allow_como columns, those are addressed in s_alldiagnoses Ttenbergen 16:14, 2014 July 17 (CDT) | ||
* updated query charlson_comorbid_score_detail to use s_como Ttenbergen 16:14, 2014 July 17 (CDT) | * updated query charlson_comorbid_score_detail to use s_como Ttenbergen 16:14, 2014 July 17 (CDT) | ||
* updated query charlson_comorbid_score to use charlson_comorbid_score_detail Ttenbergen 16:14, 2014 July 17 (CDT) | * updated query charlson_comorbid_score to use charlson_comorbid_score_detail Ttenbergen 16:14, 2014 July 17 (CDT) | ||
| Line 228: | Line 228: | ||
copied to x: Ttenbergen 14:46, 2014 June 27 (CDT) | copied to x: Ttenbergen 14:46, 2014 June 27 (CDT) | ||
* removed explicit edit restrictions from patient list because they were breaking the NDC dropdown Ttenbergen 14:05, 2014 June 27 (CDT) | * removed explicit edit restrictions from patient list because they were breaking the NDC dropdown Ttenbergen 14:05, 2014 June 27 (CDT) | ||
* integrated "changed table ''s_charlson_dxs'' to not duplicate values that should come from s_alldiagnoses. " as in CCMDB [[CCMDB.mdb_Change_Log_2014#2014-Jun-23]] Ttenbergen 14:08, 2014 June 27 (CDT) | * integrated "changed table ''[[s_charlson_dxs table]]'' to not duplicate values that should come from s_alldiagnoses. " as in CCMDB [[CCMDB.mdb_Change_Log_2014#2014-Jun-23]] Ttenbergen 14:08, 2014 June 27 (CDT) | ||
=== 2014-06-26-2 === | === 2014-06-26-2 === | ||