Centralized data front end.accdb Change Log 2018: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
|||
| (40 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=== | |||
*made query ''NDC_CLIvsNoTISS17'' | |||
copied to server | |||
===2018-06-28=== | |||
copied to server | |||
* 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 | |||
* deleted a bunch of old dated queries (eg 20160101_Something) | |||
===2018-05-18 === | |||
There was a version with that date for which no log entry had been made. Neither Pagasa nor Tina could remember what it was about when we next got ready to make a change a month later. | |||
===2018-04-19-2=== | |||
copied to server | |||
* changed Function confirm_files_and_links() to connect to [[DSM_Labs_data.accdb]] instead of [[DSM_Labs_Consistency_check.accdb]] Ttenbergen 12:14, 2018 May 18 (CDT) | |||
===2018-04-19-2=== | |||
copied to server | |||
* 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 | |||
* imported forms from [[CCMDB.accdb]]: | |||
** ICD10Chooser | |||
** L_ICD10_subform | |||
** CCI_Chooser | |||
** L_CCI_Component_subform | |||
** L_CCI_Picklist_subform | |||
* made ICD10/CCI subform | |||
* updated Function confirm_files_and_links() to include | |||
**[[L_CCI_Component table]] | |||
**[[L_CCI_Picklist table]] | |||
**[[L_ICD10 table]] | |||
**[[s_CCI_1 table]] | |||
**[[s_CCI_2 table]] | |||
**[[s_CCI_Picklist table]] | |||
**[[s_ICD10 table]] | |||
===2018-04-19=== | |||
sent to server | |||
* added query "L_tmp_SepticSet" to support [[Septic Shock Order Set]] Ttenbergen 09:21, 2018 April 19 (CDT) | |||
===2018-02-15=== | |||
* fix to queries | |||
** ''ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component'' | |||
** ''Query query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2'' | |||
===2018-02-07=== | ===2018-02-07=== | ||
| Line 13: | 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 ''P_Outstandings'' | *deleted query ''P_Outstandings_Admits'' because it is a twin of ''query P_Outstandings'' | ||
=== 2018-01-02 === | === 2018-01-02 === | ||
| Line 23: | Line 92: | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||
[[Category: Centralized data front end.accdb]] | [[Category:Centralized data front end.accdb]] | ||