Centralized data front end.accdb Change Log 2018: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
|||
| (22 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> | __NOTOC__ <!-- This hides the table of contents so collectors can immediately see the most recent change without scrolling. --> | ||
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs'' | ''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs'' | ||
This article is the change log for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Request]] for requested changes. | This article is the change log for [[Centralized data front end.accdb]]. See [[Centralized data front end.accdb Change Request]] for requested changes. | ||
== Log == | == Log == | ||
=== 2019-... === | |||
see [[Centralized data front end.accdb Change Log 2019]] | |||
===2018-11-23=== | |||
'''uploaded to Master''' | |||
*Not working. Made some changes: ''TISS_Errors_Has 48(Invasive mechanical ventilation at 23:00 marked) but no Tiss 18(ETT or trach marked)''. Don't know how to link the dates?-- | |||
===2018-11-21=== | |||
'''uploaded to Master''' | |||
*Not working. Started Query: ''TISS_Errors_Has 48(Invasive mechanical ventilation at 23:00 marked) but no Tiss 18(ETT or trach marked)''. Don't know how to link the dates?--[[User:PTorres|PTorres]] 12:49, 2018 November 21 (CST) | |||
*The two query listed below are working.--[[User:PTorres|PTorres]] 13:05, 2018 November 21 (CST) | |||
**TISS_Errors_No_Tiss | |||
**link_suspect_mismatch_to_ours_incomplete | |||
===2018-11-18=== | |||
'''not uploaded yet''' Ttenbergen 23:47, 2018 November 18 (CST) | |||
* updated [[query NDC_VAP_no_TISS]] to no longer consider spontaneous breathing. | |||
===2018-11-06=== | |||
uploaded to master. Ttenbergen 18:55, 2018 November 6 (CST) | |||
* updated to include CLI/ICD10 | |||
** "NDC CLI No AcqDX but CLI DateinTMPV2" | |||
** ''query NDC CLI AcqDX but NoCLI DateinTMPV2'' | |||
** [[query check_ICD10_CLI_vs_CCI_CentralLine]] | |||
* tweaked ND_sub_CLI_has_CLI_TmpV2 | |||
* likely tweaked other NDC queries, got a little carried away; see wiki changes for 2018-11-06 if there are questions. | |||
===2018-09-11=== | ===2018-09-11=== | ||
*made query ''NDC_CLIvsNoTISS17'' | *made query ''NDC_CLIvsNoTISS17'' | ||
copied to server | copied to server | ||
===2018-06-28=== | ===2018-06-28=== | ||
copied to server | copied to server | ||
* made | * made [[Query L_CCI_Combined]] and ''L_CCI_Combined_ComponentSubQ'' to provide combined CCI data for Julie | ||
* removed the ICD10/CCI tab from patient viewer - with it there pt took 16s to open, now down to 1s | * removed the ICD10/CCI tab from patient viewer - with it there pt took 16s to open, now down to 1s | ||
* deleted a bunch of old dated queries (eg 20160101_Something) | * deleted a bunch of old dated queries (eg 20160101_Something) | ||
| Line 25: | Line 51: | ||
* made [[DC Treatment]] field visible in patient viewer form, for some reason it was invisible. | * made [[DC Treatment]] field visible in patient viewer form, for some reason it was invisible. | ||
* detached Lab_DSM data and labelled that tab as "not currently used" - the data is stored elsewhere and not currently being hooked up to CFE | * detached Lab_DSM data and labelled that tab as "not currently used" - the data is stored elsewhere and not currently being hooked up to CFE | ||
* imported forms from [[CCMDB. | * imported forms from [[CCMDB.accdb]]: | ||
** ICD10Chooser | ** ICD10Chooser | ||
** L_ICD10_subform | ** L_ICD10_subform | ||
| Line 49: | Line 75: | ||
* fix to queries | * fix to queries | ||
** ''ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component'' | ** ''ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component'' | ||
** ''NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2'' | ** ''Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2'' | ||
===2018-02-07=== | ===2018-02-07=== | ||
| Line 58: | Line 84: | ||
** link_suspect_mismatch_pre_inpt_should_be_ours__incomplete | ** link_suspect_mismatch_pre_inpt_should_be_ours__incomplete | ||
* ran data update query to change all entries for [[QA Infection CLI]] to "Central Line Infection" as currently used; informed Julie [[User:PTorres|PTorres]] 11:08, 2018 February 7 (CST) | * ran data update query to change all entries for [[QA Infection CLI]] to "Central Line Infection" as currently used; informed Julie [[User:PTorres|PTorres]] 11:08, 2018 February 7 (CST) | ||
* updated query | * updated query ''P_Outstanding_Dispo query'' to really only list those with [[Dispo_DtTm]] 11:25, 2018 February 7 (CST) | ||
*deleted query ''P_Outstandings_Admits'' because it is a twin of | *deleted query ''P_Outstandings_Admits'' because it is a twin of ''query P_Outstandings'' | ||
=== 2018-01-02 === | === 2018-01-02 === | ||
| Line 66: | Line 92: | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||
[[Category: Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||