Centralized data.accdb: Difference between revisions

(25 intermediate revisions by 3 users not shown)

Line 1:

''see also [[~~Centralized data~~.~~mdb~~ Change Log]]

''see also [[Centralized_data.accdb 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.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==

~~Centralized.mdb~~ is ~~linked~~ to ~~other Access databases, such as~~ [[~~Tasks_1.mdb~~]]~~, [[Pharmacy~~.~~mdb]], [[TmpV2_1.mdb]] by [[Centralized data front end.mdb]]~~

May 20, 2014

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

== Availability ==

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

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

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

==Password==

Located: {{M:|Passwords_MainOffice_use}}

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

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

* finding: [[~~Centralized data Vetting Process~~]]

see [[Sending Patients]]

* fixing: [[~~Questioning data back to collectors~~]]

== Dependencies ==

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

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

~~{{Discussion}}~~

*would like a s_table with item names for TISS28 that can be used in centralized.[[~~User:TOstryzniuk|Trish Ostryzniuk~~]] ~~13:33~~, ~~2014 April 14 (CDT)~~

== Legacy ==

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

== Related articles ==

[[Category:Data Repository]]

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

[[Category:Password]]

[[Category:Centralized_data.accdb| *]]

@@ Line 1: / Line 1: @@
-''see also [[Centralized data.mdb Change Log]]
+''see also [[Centralized_data.accdb 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.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==
-Centralized.mdb is linked to other Access databases, such as [[Tasks_1.mdb]], [[Pharmacy.mdb]], [[TmpV2_1.mdb]] by [[Centralized data front end.mdb]]
+May 20, 2014
-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>
+{{Regionalserver|Output\[[Centralized_data.accdb]]}}
-*See: [[External Files]] in regards to what green link means.
-== How does data get into Centralized data.mdb ==
+== Availability ==
-[[CCMDB.mdb_Change_Log_2012#ver_2012-12-21 | version 2012-12-21]] implemented sending of data to Centralized_data.mdb.
+[[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.
-This is accomplished by queries run at [[sending]] time. See sub send_data() for details.
+==Password==
+Located: {{M:|Passwords_MainOffice_use}}
-== Finding and fixing Errors ==
+== How does data get into [[Centralized_data.accdb]] ==
-* finding: [[Centralized data Vetting Process]]
+see [[Sending Patients]]
-* fixing: [[Questioning data back to collectors]]
 == Dependencies ==
-[[TISS28 Data.mdb]] pulls data from Centralized data.mdb.
+[[TISS28 Data.mdb]] pulls data from [[Centralized_data.accdb]].
-{{Discussion}}
-*would like a s_table with item names for TISS28 that can be used in centralized.[[User:TOstryzniuk|Trish Ostryzniuk]] 13:33, 2014 April 14 (CDT)
+== Legacy ==
+[[Conversion of Centralized data.mdb to Centralized data.accdb]] - some places refer to a .mdb, same file earlier version
+== Related articles ==
+{{Related Articles}}
 [[Category:Data Repository]]
-[[Category:2013 data upgrades]]
+[[Category:Password]]
+[[Category:Centralized_data.accdb| *]]