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

m Text replacement - "[[Category: " to "[[Category:"
 
(126 intermediate revisions by 3 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 ===
rolled out
* mgmt tools:
** added [[Query Mgmt_CompleteDelays]]
** added [[Query Mgmt_StartDelays]]
** reviewed [[Query Mgmt_Collector_Admission_Count]]
** added [[Mgmt_EFTs table]]
** added [[Mgmt_months table]]
** added [[Query Mgmt_EFT_total]]
=== 2019-09-24 ===
rolled from Pagasa's desk
* updated more things for reconnector
=== 2019-09-19 ===
rolled out from Trish's desk
* updated several things I got wrong in reconnector on first try.
=== 2019-09-18 ===
rolled out 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 ===
rolled out [[User:PTorres|PTorres]] 13:48, 2019 September 11 (CDT)
* fix to [[query NDC_TISS_CCI_endoscopic]]
===2019-08-08===
(must have been rolled, pagasa had it...)
* 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]
** removed [ApTotal_Neuro] from call to [APACHE_Total]
* updated Function APACHE_Total to not add [ApTotal_Neuro] since it's now already included
* clean-up: deleted query ''created_variables_CC_maker1''
===2019-07-25===
rolled out [[User:PTorres|PTorres]] 13:51, 2019 July 25 (CDT)
*[[Query NDC Trach_Dx_TISS]] Tina tweaked the query.
===2019-06-13===
rolled out [[User:PTorres|PTorres]] 14:10, 2019 June 13 (CDT)
*[[Query NDC Trach_Dx_TISS]] Tina tweaked the query.
===2019-06-04===
rolled out [[User:PTorres|PTorres]]
*[[Query NDC Dialysis TISS CCI]] filter for ICU only
*[[Query NDC TISS CCI endoscopic]] filter the date starts 2019
===2019-05-15===
* updated [[Query L ICD10 Charlson component points]] to use " Comorbid or Admit" and not "Comorbid or Acquired" as per Julie's comment in [[Charlson Comorbidity scoring in ICD10 codes]].
===2019-05-09-3===
rolled out 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===
rolled out Ttenbergen 18:06, 2019 May 9 (CDT)
* changed [["email collector about patient data" button]] and [["copy patient demographics for questioning" button]] to include [[D ID field]].
===2019-05-09===
rolled out --[[User:PTorres|PTorres]] 14:20, 2019 May 9 (CDT)
*Delete Query [[Query NDC CLI unacceptable date]]
===2019-05-02===
rolled out[[User:PTorres|PTorres]] 15:49, 2019 May 2 (CDT)
''P Outstanding Dispo query''
===2019-04-25===
rolled out [[User:PTorres|PTorres]] 11:55, 2019 April 25 (CDT
*Tiss query also available in the downlist.
===2019-04-09===
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.
===2019-03-27===
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 [[Reconnect_check_missing_L Tables_content query]]
===2019-03-26===
rolled out [[User:PTorres|PTorres]] 14:16, 2019 March 26 (CDT)
* updated [[Query L_ICD10_primary]] added the dispo date.
* updated [[Query Primary_admit]] added the dispo date
===2019-03-21===
rolled out Ttenbergen 11:33, 2019 March 21 (CDT)
* deleted query ''L_ICD10_Charlson_Agepts'' - turns out we don't include the age in our Charlson
* fixed queries ''s_ICD10_Charlson_Comorbids'', ''L_ICD10_Charlson_score''
* imported from [[CCMDB.accdb]]: [[Query s ICD10 Chapter block dxs]]
* updated [[Query L_ICD10_primary]] to include chapter and block info from [[Query s ICD10 Chapter block dxs]]
===2019-03-20===
rolled
* tweaks to ''Query NDC Dxs vs TISS Dialysis'' [[User:PTorres|PTorres]] 11:45, 2019 March 20 (CDT)
===2019-03-13===
rolled by Pagasa Ttenbergen 17:05, 2019 March 13 (CDT)
* updated [[query NDC_Trach_Dx_TISS]]; this was the first look at he query and there were lots of false positives. Ttenbergen 17:05, 2019 March 13 (CDT)
===2019-03-06===
rolled [[User:PTorres|PTorres]] 14:12, 2019 March 6 (CST)
*update [[Reconnect_check_missing_L Tables_content query]] can now add to [[L_Problem]]
===2019-02-07===
rolled [[User:PTorres|PTorres]] 09:38, 2019 February 7 (CST)
* 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
* removed the "open suspect links" button
* updated [[query NDC_VAP_No_AcqDX_but_VAP_DateinTMPV2]] to exclude dispo > 2019
* deleted query "Query NDC discharged incomplete" as it is not used.
* deleted  done in [[Query NDC Dialysis TISS CCI]] now.
** query "Query NDC CRRT TISS CCI"
** Query NDC HD TISS CCI
** Query NDC PD TISS CCI
===2019-01-30===
rolled to server Ttenbergen 09:00, 2019 February 7 (CST)
* updated [[Query L_Dxs_w_primary]] and component "Primary_admit" to only list for patients discharged before 2019-01-01
* added query [[Query L_ICD10_primary]]
===2019-01-30===
*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
* [[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.
===2019-01-07===
rolled Ttenbergen 09:29, 2019 January 30 (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:
** ''query NDC CLI No AcqDX but CLI DateinTMPV2''
** ''query NDC CLI AcqDX but NoCLI DateinTMPV2''
** [[Query NDC_cardioversion_dx_vs_TISS]]
** [[Query TISS_Errors_vent_vs_vent2300]]
** [[Query NDC_Dialysis_TISS_CCI]]
** "Query NDC_PD_TISS_CCI"
** "Query NDC_HD_TISS_CCI"
* updated Function confirm_files_and_links() to no longer reconnect "s_ICD10_Block_Dxs", "s_ICD10_Blocks"
* fixed problem with [[link_suspect_negative_transit_time query]]
* re-connected the L_ICD10_subform_form to allow viewing dx descriptions rather than codes; turns out things are still fast, so the slow-down problem before must have been due to the CCI forms, which I don't need to re-connect because they list names already.
===2019-01-02===
===2019-01-02===
not rolled yet Ttenbergen 16:15, 2019 January 2 (CST)
copied to server Ttenbergen 23:24, 2019 January 6 (CST)
* added rudimentary CCI and ICD10 forms; will need to make better
* 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]]:  
* updated Function confirm_files_and_links() to include the new tables used in [[ICD10]] and [[CCI]]:  
Line 27: Line 178:
** s_ICD10_Charlson_Comorbids
** s_ICD10_Charlson_Comorbids
* query updates/creations:  
* query updates/creations:  
** [[NDC_cardioversion_dx_vs_TISS]] - implemented
** [[Query 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_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
** [[Query TISS_Errors_vent_vs_vent2300]] - implemented
** [[TISS Errors Vent vs mechanism]] - implemented
** Query TISS_Errors_Vent_vs_mechanism - implemented
** [[Query NDC CRRT 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
** "NDC Missing TransferDate w pivot" as confirmed by Julie on that page
** "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_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]]