Centralized data.accdb: Difference between revisions

(33 intermediate revisions by 3 users not shown)

Line 1:

~~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.~~

''see also [[Centralized_data.accdb Change Log]]

~~The development of this database has been in progress since early this year and it is currently being run~~ in ~~tandem with current data repository ICU~~ [[~~TMSX~~]] ~~& Medicine~~ [[~~MedTms~~]].

Centralized.data.mdb is a data repository containing a de-identified copy of all data sent from Critical Care and Medicine. Indentifiers are stored in [[PHI.mdb]] which is accessible only to [[:Category:Main Office|main office]].

==Live Date==

May 20, 2014

== Location ==

~~<file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\~~Output\Centralized_data.~~mdb</file>~~

== Availability ==

[[Centralized_data.accdb]] might not be available at its network location outside of [[Designated sending times]]. See [[Pull down centralized data.vbs]] if it needs to be retrieved locally.

==Password==

~~Hi, hello, what is a green link above that leads to nowhere? I have seen and few of these being planted around. Thanks. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:20, 2013 October 9 (CDT)~~

Located: {{M:|Passwords_MainOffice_use}}

~~See the answer here:~~ [[~~External Files~~]]

== How does data get into [[Centralized_data.accdb]] ==

see [[Sending Patients]]

== ~~How does data get into Centralized data.mdb~~ ==

== Dependencies ==

[[~~CCMDB~~.~~mdb_Change_Log_2012#ver_2012-12-21 | version 2012-12-21~~]] ~~implemented sending of~~ data to Centralized_data.~~mdb~~.

[[TISS28 Data.mdb]] pulls data from [[Centralized_data.accdb]].

~~This is accomplished by queries run at~~ [[~~sending~~]] ~~time. See sub send_data() for details~~.

== Legacy ==

[[Conversion of Centralized data.mdb to Centralized data.accdb]] - some places refer to a .mdb, same file earlier version

== ~~Finding and fixing Errors~~ ==

== Related articles ==

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. {{~~Question IT~~}}

~~== Dependencies ==~~

~~[[TISS28 Data.mdb]] pulls data from Centralized data.mdb.~~

[[Category:Data Repository]]

[[Category:~~2013 data upgrades~~]]

[[Category:Password]]

[[Category:Centralized_data.accdb| *]]

@@ Line 1: / Line 1: @@
-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.
+''see also [[Centralized_data.accdb Change Log]]
-The development of this database has been in progress since early this year and it is currently being run in tandem with current data repository ICU [[TMSX]] & Medicine [[MedTms]].
+Centralized.data.mdb is a data repository containing a de-identified copy of all data sent from Critical Care and Medicine. Indentifiers are stored in [[PHI.mdb]] which is accessible only to [[:Category:Main Office|main office]].
+==Live Date==
+May 20, 2014
 == Location ==
-<file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\Centralized_data.mdb</file>
+{{Regionalserver|Output\[[Centralized_data.accdb]]}}
+== Availability ==
+[[Centralized_data.accdb]] might not be available at its network location outside of [[Designated sending times]].  See [[Pull down centralized data.vbs]] if it needs to be retrieved locally.
-{{Discussion}}
+==Password==
-Hi, hello, what is a green link above that leads to nowhere? I have seen and few of these being planted around.  Thanks.  [[User:TOstryzniuk|Trish Ostryzniuk]] 18:20, 2013 October 9 (CDT)
+Located: {{M:|Passwords_MainOffice_use}}
-See the answer here:  [[External Files]]
+== How does data get into [[Centralized_data.accdb]] ==
+see [[Sending Patients]]
-== How does data get into Centralized data.mdb ==
+== Dependencies ==
-[[CCMDB.mdb_Change_Log_2012#ver_2012-12-21 | version 2012-12-21]] implemented sending of data to Centralized_data.mdb.
+[[TISS28 Data.mdb]] pulls data from [[Centralized_data.accdb]].
-This is accomplished by queries run at [[sending]] time. See sub send_data() for details.
+== Legacy ==
+[[Conversion of Centralized data.mdb to Centralized data.accdb]] - some places refer to a .mdb, same file earlier version
-== Finding and fixing Errors ==
+== Related articles ==
-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. {{Question IT}}
+{{Related Articles}}
-== Dependencies ==
-[[TISS28 Data.mdb]] pulls data from Centralized data.mdb.
 [[Category:Data Repository]]
-[[Category:2013 data upgrades]]
+[[Category:Password]]
+[[Category:Centralized_data.accdb| *]]