CCMDB Wiki

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

← Older edit
PTorres (talk | contribs)
CCMDB_legit, approved
1,617 edits
m Text replacement - "[[Category: " to "[[Category:"
 
(16 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 ===
=== 2017-10-24 ===
Changed on Pagasa's PC and rolled out. Ttenbergen 11:32, 2017 October 24 (CDT)
Changed on Pagasa's PC and rolled out. Ttenbergen 11:32, 2017 October 24 (CDT)
* updated the query for [[Orphans in Centralized data.mdb]] to no longer have multi-laptop per location special case.
* 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]].
* added query ''Sending_at_wrong_time'' to allow Trish to see who is sending outside of the [[Designated sending times]].


Line 94: 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 query ''link_suspect_not_same_visitAdmitDtTm'' and added helper query ''link_Int_suspect_not_same_visitAdmitDtTm_int'' Ttenbergen 17:54, 2017 January 19 (CST)
* 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 106: 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 l_problems D_ID  and therefore didn't work in the dropdown. [[User:Srusnak|Srusnak]] 14:55, 2017 January 5 (CST)
* 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: 2013 data upgrades]]
[[Category:Centralized data front end.accdb]]
[[Category: Centralized data front end.accdb]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data_front_end.accdb_Change_Log_2017"