Centralized data front end.accdb Change Log 2019: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) 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=== | ||
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. | ||
** [[ | ** [[Query TISS_Errors_vent_vs_vent2300]] - implemented | ||
** | ** Query TISS_Errors_Vent_vs_mechanism - implemented | ||
** [[Query | ** [[Query NDC_Dialysis_TISS_CCI]] | ||
** | ** "Query NDC_PD_TISS_CCI" | ||
** | ** "Query NDC_HD_TISS_CCI" | ||
** | ** "Query NDC_Dxs_vs_TISS_Dialysis" | ||
** [[Query | ** [[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 [[ | * 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-...=== | ||
* 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]] |