Centralized data.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Bcloutier (talk | contribs)
mNo edit summary
 
(25 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Data Repository containing a de-identified copy of all data sent. De-identified by excluding chart, phin, names, and by using only month and year of birth.  
''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. Indentifiers are stored in [[PHI.mdb]] which is accessible only to [[:Category:Main Office|main office]].  
==Live Date==
May 20, 2014


== Location ==
== Location ==
<file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\Centralized_data.mdb</file>
{{Regionalserver|Output\Centralized_data.mdb}}


== Availability ==
Centralized_data.mdb might not be available at its network location between the hours of 10:30 to 17:00 CST.  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
 
===Green Links===
To create a complete reference to an external file use the:  <nowiki><file></file></nowiki> tags
 
As a new user I found some hand-crafted references to files that were incomplete or required more familiarity with the network/system to decipher.  All of the files that were causing me issue were external to the wiki - these files all reside in various file-shares on the internal network.  I would find descriptive text along the lines of the following (slightly exaggerated):  On the regional server go to the project folder and open the data file
 
*These green links were implemented so that there would be accuracy in documenting files external to the wiki. 
*The links are complete references to the files we use with no descriptive text slowing down the process of finding the files.
*You can right click on the link and select 'Copy Link Location' then paste that into windows explorer (file browser) address bar
*You can drag and drop the links
 
For general purpose security your browser is configured to prevent file access on your computer or local network.  This behaviour prevents malicious web pages from accessing your hard-drive.  So be careful if you decide to alter this behavior.
 
[[User:Bcloutier|Bcloutier]] 09:25, 2013 October 18 (CDT)


== How does data get into Centralized data.mdb ==
== How does data get into Centralized data.mdb ==
[[CCMDB.mdb_Change_Log_2012#ver_2012-12-21 | version 2012-12-21]] implemented sending of data to Centralized_data.mdb.
see [[Sending Patients]]
 
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. {{Question IT}}


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


[[Category:Data Repository]]
== Related articles ==
[[Category:2013 data upgrades]]
{{Related Articles}}
 
[[Category: Data Repository]]
[[Category: Password]]
[[Category: Centralized_data.mdb| *]]

Latest revision as of 13:31, 2019 September 12

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

Live Date

May 20, 2014

Location

Regional Server\Output\Centralized_data.mdb (full address: \\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\Output\Centralized_data.mdb)

Availability

Centralized_data.mdb might not be available at its network location between the hours of 10:30 to 17:00 CST. See Pull down centralized data.vbs if it needs to be retrieved locally.

Password

Located: M:\Passwords_MainOffice_use

How does data get into Centralized data.mdb

see Sending Patients

Dependencies

TISS28 Data.mdb pulls data from Centralized data.mdb.

Related articles

Related articles: