CCMDB Wiki

Centralized data front end.accdb Change Log 2019: Difference between revisions

← Older edit
mNo edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(6 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 Variables CC maker query]] as per email exchange between Julie and Allan:  
* 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 [[Created Variables common 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)
* 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]]
''P Outstanding Dispo query''


===2019-04-25===
===2019-04-25===
Line 90: Line 90:
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 [[PL missing L Tables content]]
*  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 [[Query NDC Dxs vs TISS Dialysis]] [[User:PTorres|PTorres]] 11:45, 2019 March 20 (CDT)
* 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 [[PL missing L Tables content]] can now add to [[L_Problem]]
*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 [[PL missing L Tables content]]  to exclude Labs check since no more labs in 2019
* 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
* [[PL missing L Tables content]] - had false positives due to wrong CCI logic
* [[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 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 [[PL missing L Tables content]] as confirmed by Julie since that is really something that needs to be run before linking
* 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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2019"