Centralized data front end.accdb Change Log 2019: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 40: | Line 40: | ||
===2019-08-08=== | ===2019-08-08=== | ||
(must have been rolled, pagasa had it...) | (must have been rolled, pagasa had it...) | ||
* updated [[Created | * updated Created Variables CC maker query (see [[Created Variables CC maker 2021 query]]) as per email exchange between Julie and Allan: | ||
** added (as in sum) field [ApTotal_Neuro] to field [ApTotal_Physiological] | ** added (as in sum) field [ApTotal_Neuro] to field [ApTotal_Physiological] | ||
** removed [ApTotal_Neuro] from call to [APACHE_Total] | ** removed [ApTotal_Neuro] from call to [APACHE_Total] | ||
| Line 64: | Line 64: | ||
===2019-05-09-3=== | ===2019-05-09-3=== | ||
rolled out Ttenbergen 22:57, 2019 May 9 (CDT) | rolled out Ttenbergen 22:57, 2019 May 9 (CDT) | ||
* changed the data type for the [[ER Delay]] in [[ | * changed the data type for the [[ER Delay]] in Created_Variables_Common table (see [[Created_Variables_Common_2021 table]]) to 'single' to be same as other transfer delay and LOS, as per request from Julie by email from 2019-03-27 Ttenbergen 22:57, 2019 May 9 (CDT) | ||
===2019-05-09-2=== | ===2019-05-09-2=== | ||
| Line 77: | Line 77: | ||
rolled out[[User:PTorres|PTorres]] 15:49, 2019 May 2 (CDT) | rolled out[[User:PTorres|PTorres]] 15:49, 2019 May 2 (CDT) | ||
''P Outstanding Dispo query'' | |||
===2019-04-25=== | ===2019-04-25=== | ||
| Line 85: | Line 85: | ||
===2019-04-09=== | ===2019-04-09=== | ||
rolled out Ttenbergen 11:10, 2019 April 10 (CDT) | rolled out Ttenbergen 11:10, 2019 April 10 (CDT) | ||
* updated | * updated ''query NDC_Dxs_vs_TISS_Dialysis'' to no longer require a TISS for apparently requiring Dxs since KDIGO definitions don't require dialysis. | ||
===2019-03-27=== | ===2019-03-27=== | ||
rolled out [[User:PTorres|PTorres]] 10:26, 2019 March 27 (CDT) | rolled out [[User:PTorres|PTorres]] 10:26, 2019 March 27 (CDT) | ||
* Updated subform L_ICD10_subform_form to open by default in datasheet mode so new dxs can be added. | * Updated subform L_ICD10_subform_form to open by default in datasheet mode so new dxs can be added. | ||
* updated [[ | * updated [[Reconnect_check_missing_L Tables_content query]] | ||
===2019-03-26=== | ===2019-03-26=== | ||
| Line 106: | Line 106: | ||
===2019-03-20=== | ===2019-03-20=== | ||
rolled | rolled | ||
* tweaks to | * tweaks to ''Query NDC Dxs vs TISS Dialysis'' [[User:PTorres|PTorres]] 11:45, 2019 March 20 (CDT) | ||
===2019-03-13=== | ===2019-03-13=== | ||
| Line 114: | Line 114: | ||
===2019-03-06=== | ===2019-03-06=== | ||
rolled [[User:PTorres|PTorres]] 14:12, 2019 March 6 (CST) | rolled [[User:PTorres|PTorres]] 14:12, 2019 March 6 (CST) | ||
*update [[ | *update [[Reconnect_check_missing_L Tables_content query]] can now add to [[L_Problem]] | ||
===2019-02-07=== | ===2019-02-07=== | ||
rolled [[User:PTorres|PTorres]] 09:38, 2019 February 7 (CST) | rolled [[User:PTorres|PTorres]] 09:38, 2019 February 7 (CST) | ||
* update to [[ | * update to [[Reconnect_check_missing_L Tables_content query]] to exclude Labs check since no more labs in 2019 | ||
* increased number of queries shown in Apply Query | * increased number of queries shown in Apply Query | ||
* removed the "open suspect links" button | * removed the "open suspect links" button | ||
| Line 137: | Line 137: | ||
*copied to Master [[User:PTorres|PTorres]] 10:22, 2019 January 30 (CST) | *copied to Master [[User:PTorres|PTorres]] 10:22, 2019 January 30 (CST) | ||
* updated query "NDC_missing_L_Tables_content" - was broken because still looking at old l_dxs and l_como; but also tweaked false positives | * updated query "NDC_missing_L_Tables_content" - was broken because still looking at old l_dxs and l_como; but also tweaked false positives | ||
* [[ | * [[Reconnect_check_missing_L Tables_content query]] - had false positives due to wrong CCI logic | ||
* also re-imported some old CLI, CRRT and VAP queries to be able to check them until the last pre-ICD10 patients are gone. | * also re-imported some old CLI, CRRT and VAP queries to be able to check them until the last pre-ICD10 patients are gone. | ||
| Line 185: | Line 185: | ||
** "Query NDC_PD_TISS_CCI" | ** "Query NDC_PD_TISS_CCI" | ||
** "Query NDC_HD_TISS_CCI" | ** "Query NDC_HD_TISS_CCI" | ||
** | ** "Query NDC_Dxs_vs_TISS_Dialysis" | ||
** [[Query NDC_Pacemaker_acquired_vs_TISS]] | ** [[Query NDC_Pacemaker_acquired_vs_TISS]] | ||
* deleted | * deleted | ||
| Line 191: | Line 191: | ||
** "NDC_Pacemaker_TISS_wo_acquired" - was rolled in with [[query NDC Pacemaker acquired vs TISS]] | ** "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. | ** "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 [[ | * renamed "NDC missing L Tables content" to [[Reconnect_check_missing_L Tables_content query]] as confirmed by Julie since that is really something that needs to be run before linking | ||
===2018-...=== | ===2018-...=== | ||
| Line 199: | Line 199: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||
[[Category: Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||