Centralized data.mdb: Difference between revisions
Ttenbergen (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 23: | Line 23: | ||
== Dependencies == | == Dependencies == | ||
[[TISS28 Data.mdb]] pulls data from Centralized data.mdb. | [[TISS28 Data.mdb]] pulls data from Centralized data.mdb. | ||
{{Discussion}} | |||
*would like a s-table to item labels for TISS28 that can be used in centralized.[[User:TOstryzniuk|Trish Ostryzniuk]] 13:33, 2014 April 14 (CDT) | |||
[[Category:Data Repository]] | [[Category:Data Repository]] | ||
[[Category:2013 data upgrades]] | [[Category:2013 data upgrades]] | ||
Revision as of 12:33, 2014 April 14
see also Centralized data.mdb Change Log Centralized.data.mdb is a 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. Indentifiers are stored in PHI.mdb.
Centralized.mdb is linked to other Access databases, such as Tasks_1.mdb, Pharmacy.mdb, TmpV2_1.mdb by Centralized data front end.mdb
Only main processing office can link Centralized.data.mdb with PHI.mdb.
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
- finding: Centralized data Vetting Process
- fixing: Questioning data back to collectors
Dependencies
TISS28 Data.mdb pulls data from Centralized data.mdb. Template:Discussion
- would like a s-table to item labels for TISS28 that can be used in centralized.Trish Ostryzniuk 13:33, 2014 April 14 (CDT)