CCMDB Wiki

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

← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(27 intermediate revisions by 2 users not shown)
Line 4: Line 4:


== Log ==
== Log ==
=== 2020-... ===
See [[Centralized data front end.accdb Change Log 2020]]
=== 2019-11-18 ===
rolled out
* mgmt tools:
** added [[Query Mgmt_EFT_edit]]
=== 2019-11-17 ===
=== 2019-11-17 ===
not rolled yet
rolled out
* added new queries:  
* mgmt tools:  
** [[Query Mgmt_CompletDelays]]
** added [[Query Mgmt_CompleteDelays]]
** [[Query Mgmt_StartDelays]]
** added [[Query Mgmt_StartDelays]]
** reviewed [[Query Mgmt_Collector_Admission_Count]]
** reviewed [[Query Mgmt_Collector_Admission_Count]]
** added [[Mgmt_EFTs table]]
** added [[Mgmt_months table]]
** added [[Query Mgmt_EFT_total]]


=== 2019-09-24 ===
=== 2019-09-24 ===
Line 21: Line 32:
=== 2019-09-18 ===
=== 2019-09-18 ===
rolled out Ttenbergen 17:35, 2019 September 18 (CDT)
rolled out Ttenbergen 17:35, 2019 September 18 (CDT)
* changed ccmdb.mdb to ccmdb.accdb, and centralized_data.mdb to centralized_data.accdb Ttenbergen 17:35, 2019 September 18 (CDT)
* changed [[CCMDB.accdb]] to [[CCMDB.accdb]], and centralized_data.mdb to centralized_data.accdb Ttenbergen 17:35, 2019 September 18 (CDT)


=== 2019-09-11 ===
=== 2019-09-11 ===
Line 29: 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 53: 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 66: 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 74: 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 [[query NDC_Dxs_vs_TISS_Dialysis]] to no longer require a TISS for apparently requiring Dxs since KDIGO definitions don't require dialysis.
* 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 [[PL missing L Tables content]]
*  updated [[Reconnect_check_missing_L Tables_content query]]


===2019-03-26===
===2019-03-26===
Line 95: 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 103: 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 126: 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 133: Line 144:
* 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 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:  
* updated to name additional D_ID fields so this will work in query dropdown:  
** [[query NDC CLI No AcqDX but CLI DateinTMPV2]]
** ''query NDC CLI No AcqDX but CLI DateinTMPV2''
** [[query NDC CLI AcqDX but NoCLI DateinTMPV2]]
** ''query NDC CLI AcqDX but NoCLI DateinTMPV2''
** [[Query NDC_cardioversion_dx_vs_TISS]]
** [[Query NDC_cardioversion_dx_vs_TISS]]
** [[Query TISS_Errors_vent_vs_vent2300]]
** [[Query TISS_Errors_vent_vs_vent2300]]
Line 170: Line 181:
** "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_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_vent_vs_vent2300]] - implemented
** [[Query TISS_Errors_vent_vs_vent2300]] - implemented
** [[Query TISS_Errors_Vent_vs_mechanism]] - implemented
** Query TISS_Errors_Vent_vs_mechanism - implemented
** [[Query NDC_Dialysis_TISS_CCI]]
** [[Query NDC_Dialysis_TISS_CCI]]
** "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_Dxs_vs_TISS_Dialysis"
** [[Query NDC_Pacemaker_acquired_vs_TISS]]
** [[Query NDC_Pacemaker_acquired_vs_TISS]]
* deleted
* deleted
Line 180: 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-11-23===
===2018-...===
* see [[Centralized data front end.accdb Change Log 2018]]
* see [[Centralized data front end.accdb Change Log 2018]]


== Related articles ==
{{Related Articles}}


 
[[Category:Development Documentation]]
 
[[Category:Centralized data front end.accdb]]
[[Category: Development Documentation]]
[[Category: Centralized data front end.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2019"