Centralized data.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m Text replacement - "[[Category: " to "[[Category:"
 
(28 intermediate revisions by 3 users not shown)
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 ==
== 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: [[vetting]]
see [[Sending Patients]]
* fixing: [[Questioning data back to collectors]]


== Dependencies ==
== Dependencies ==
[[TISS28 Data.mdb]] pulls data from Centralized data.mdb.
[[TISS28 Data.mdb]] pulls data from [[Centralized_data.accdb]].


== 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:Data Repository]]
[[Category:2013 data upgrades]]
[[Category:Password]]
[[Category:Centralized_data.accdb| *]]

Latest revision as of 10:32, 30 July 2025

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. Indentifiers are stored in PHI.mdb which is accessible only to main office.

Live Date

May 20, 2014

Location

Regional Server\​Output\Centralized_data.accdb\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\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.

Password

Located: M:\​Passwords_MainOffice_use (full address: \\ad.wrha.mb.ca\wrha\HSC\shared\WRHA\WRHA_CCMED\Passwords_MainOffice_use)

How does data get into Centralized_data.accdb

see Sending Patients

Dependencies

TISS28 Data.mdb pulls data from Centralized_data.accdb.

Legacy

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

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data.accdb&oldid=165972"