Centralized data.mdb: Difference between revisions
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 4: | Line 4: | ||
== Location == | == Location == | ||
<file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\Centralized_data.mdb</file> | <file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\Centralized_data.mdb</file> | ||
*See: [[External Files]] in regards to what green link means. | |||
See | |||
== How does data get into Centralized data.mdb == | == How does data get into Centralized data.mdb == | ||
| Line 21: | Line 16: | ||
== Dependencies == | == Dependencies == | ||
[[TISS28 Data.mdb]] pulls data from Centralized data.mdb. | [[TISS28 Data.mdb]] pulls data from Centralized data.mdb. | ||
==Infrastructure/Redesign meeting minutes== | |||
Minutes from meetings and design flowchart can be found: | |||
*X:\DatabaseInfrastRedesign | |||
[[Category:Data Repository]] | [[Category:Data Repository]] | ||
[[Category:2013 data upgrades]] | [[Category:2013 data upgrades]] | ||
Revision as of 14:27, 2013 November 7
Data Repository containing a de-identified copy of all data sent from Critical Care and Medicine. De-identified by excluding chart, phin, names, and by using only month and year of birth. The development of this database has been in progress since early this year (2013) and it is currently being run in tandem with current data repository ICU TMSX & Medicine MedTMS.
Location
<file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\Centralized_data.mdb</file>
- See: External Files in regards to what green link means.
How does data get into Centralized data.mdb
version 2012-12-21 implemented sending of data to Centralized_data.mdb.
This is accomplished by queries run at sending time. See sub send_data() for details.
Finding and fixing Errors
Will need to implement tools in centralized_data.mdb to help Pagasa with error checking. All data will be checked. Pagasa will correct "sent" data, for incomplete data she will notify collector. Doing that should probably be facilitated. Possibly in the future we can have a mechanism where Pagasa can just "reject" data that is bad, and where it will be sent back to collectors, either at n&b time, start time, or send time... needs to be thought about. Template:Question IT
Dependencies
TISS28 Data.mdb pulls data from Centralized data.mdb.
Infrastructure/Redesign meeting minutes
Minutes from meetings and design flowchart can be found:
- X:\DatabaseInfrastRedesign