Centralized data front end.accdb Change Log 2017: Difference between revisions
Ttenbergen (talk | contribs) m changed to .accdb, replaced: Centralized data front end.mdb → Centralized data front end.accdb (3) |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (21 intermediate revisions by 3 users not shown) | |||
| Line 5: | Line 5: | ||
== Log == | == Log == | ||
*Go to: [[Centralized data front end.accdb Change Log 2018]] | |||
=== 2017-12-13 === | |||
Rolled out | |||
*Updated s_dispo_collection_location table. [[User:TOstryzniuk|Trish Ostryzniuk]] 12:35, 2017 December 13 (CST) | |||
=== 2017-11-17=== | |||
changed on Pagasa's desk and copied to master Ttenbergen 14:07, 2017 November 17 (CST) | |||
* updated the dropdown for the [[Dispo field]] to allow Pagasa to enter absolutely anything in [[s_dispo table]] so she can update for discharge to ER/UC. | |||
=== 2017-11-02=== | |||
changed on Trish copy & rolled out. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:00, 2017 November 2 (CDT) | |||
*added [[Query Mgmt_Collector_Admission_Count]] | |||
=== 2017-10-30 === | |||
Changed on Pagasa's PC and rolled out.[[User:PTorres|PTorres]] 16:08, 2017 October 30 (CDT) | |||
Fixed the reconnect DSM because the table name changed. | |||
=== 2017-10-24 === | |||
Changed on Pagasa's PC and rolled out. Ttenbergen 11:32, 2017 October 24 (CDT) | |||
* updated the query for [[Orphans in Centralized_data.accdb]]to no longer have multi-laptop per location special case. | |||
* added query ''Sending_at_wrong_time'' to allow Trish to see who is sending outside of the [[Designated sending times]]. | |||
=== 2017-07-18 === | |||
Changes done on Pagasa's PC and rolled out. Ttenbergen 11:02, 2017 July 18 (CDT) | |||
* added chart column to patient list | |||
* added chart and PHIN filter buttons | |||
* changed column widths to fit Pagasa's screen | |||
=== 2017-05-23 === | === 2017-05-23 === | ||
(I think I rolled this out, ''link_suspect_mismatch_pre_inpt_should_be_ours__incomplete'' was present) | |||
* fixed query ''link_suspect_not_same_visitAdmitDtTm'' to mirror Julie's checks: **if to-from match | * fixed query ''link_suspect_not_same_visitAdmitDtTm'' to mirror Julie's checks: **if to-from match | ||
**the difference of dispo1 and adm2 is | **the difference of dispo1 and adm2 is | ||
| Line 15: | Line 44: | ||
=== 2017-05-03 === | === 2017-05-03 === | ||
rolled out Ttenbergen 11:17, 2017 May 3 (CDT) | rolled out Ttenbergen 11:17, 2017 May 3 (CDT) | ||
* updated to Access 2007, ie renamed to *.accdb | * updated to Access 2007, ie renamed to *.accdb | ||
* added [[DSM Labs Consistency check.accdb]] resp | * added [[DSM Labs Consistency check.accdb]] resp L_Labs_Flowsheet_DSM table. | ||
** added to Function ''confirm_files_and_links()'' | ** added to Function ''confirm_files_and_links()'' | ||
** form ''L_Labs_Flowsheet_DSM'' | ** form ''L_Labs_Flowsheet_DSM'' | ||
| Line 83: | Line 112: | ||
=== 2017-01-19-2 === | === 2017-01-19-2 === | ||
rolled out Ttenbergen 17:54, 2017 January 19 (CST) | rolled out Ttenbergen 17:54, 2017 January 19 (CST) | ||
* updated | * updated ''[[link_suspect_not_same_visitAdmitDtTm query]]'' and added helper query ''link_Int_suspect_not_same_visitAdmitDtTm_int'' Ttenbergen 17:54, 2017 January 19 (CST) | ||
=== 2017-01-19 === | === 2017-01-19 === | ||
| Line 95: | Line 124: | ||
=== 2017-01-05 === | === 2017-01-05 === | ||
rolled by Sheila's account, by Tina [[User:Srusnak|Srusnak]] 14:55, 2017 January 5 (CST) | rolled by Sheila's account, by Tina [[User:Srusnak|Srusnak]] 14:55, 2017 January 5 (CST) | ||
* updated NDC_VAP_unacceptable_date query, it was listing the | * updated [[query NDC_VAP_unacceptable_date]] query, it was listing the [[L Problem table]].D_ID and therefore didn't work in the dropdown. [[User:Srusnak|Srusnak]] 14:55, 2017 January 5 (CST) | ||
[[Category: Development Documentation | [[Category:Development Documentation]] | ||
[[Category:Centralized data front end.accdb]] | |||
[[Category: Centralized data front end.accdb]] | |||