Centralized data.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(32 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Data Repository containing:
''see also [[Centralized data.mdb Change Log]]
* [[Serial number]]
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]].
* [[Location field|Location]]
==Live Date==
* [[Admit%2C_Transfer_and_Discharge_date_and_time#Admit_Date_and_Time | admit, transfer and discharge dates and times]]
May 20, 2014
* [[Survive / Expired]]
* [[Med Var 1 - Admit-from Ward]] you will be able to send without this, but Julie will not get all the data she needs to link patient stays together
* [[Med Var 2 - Discharge-to Ward]] you will be able to send without this, but Julie will not get all the data she needs to link


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


This is accomplished by queries run at [[sending]] time:
==Password==
* "Send_Centralized_update" (update existing records to data currently in the collector's ccmdb_data.mdb)
Located: M:\Passwords_MainOffice_use
* "Send_Centralized_append" (append new records from the collector's ccmdb_data.mdb)


== Finding and fixing Errors ==
== How does data get into Centralized data.mdb ==
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}}
see [[Sending Patients]]


== 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 ==
{{Related Articles}}
 
[[Category: Data Repository]]
[[Category: Password]]
[[Category: Centralized_data.mdb| *]]

Latest revision as of 14: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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Centralized_data.mdb&oldid=139063"