Centralized data.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m cat
Trish you had a question and I don't understand it.
Line 1: Line 1:
''see also [[Centralized data.mdb Change Log]]
''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.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]].  
 
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 ==
== Location ==
<file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\Centralized_data.mdb</file>
<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.


==Password==
==Password==
Located: M:\Passwords_MainOffice_use
See: <file>M:\Passwords_MainOffice_use</file>


== 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 == 
* finding: [[Centralized data Vetting Process]]
* fixing: [[Questioning data back to collectors]]


== Dependencies ==
== Dependencies ==
Line 30: Line 17:
** we should discuss what you are actually trying to do here. Talk to me, maybe put it into the calendar. Ttenbergen 14:16, 2014 September 19 (CDT)
** we should discuss what you are actually trying to do here. Talk to me, maybe put it into the calendar. Ttenbergen 14:16, 2014 September 19 (CDT)


[[Category:Data Repository]]
[[Category: Data Repository]]
[[Category:2013 data upgrades]]
[[Category: Password]]
[[Category: Password]]
[[Category: Centralized_data.mdb|*]]
[[Category: Centralized_data.mdb|*]]

Revision as of 10:41, 2015 April 30

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.

Location

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

Password

See: <file>M:\Passwords_MainOffice_use</file>

How does data get into Centralized data.mdb

see Sending Patients

Dependencies

TISS28 Data.mdb pulls data from Centralized data.mdb. Template:Discussion

  • would like a s_table with item names for TISS28 that can be used in centralized.Trish Ostryzniuk 13:33, 2014 April 14 (CDT)
    • we should discuss what you are actually trying to do here. Talk to me, maybe put it into the calendar. Ttenbergen 14:16, 2014 September 19 (CDT)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data.mdb&oldid=43421"