PHI.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (42 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] | Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI. Contains primarily [[L PHI table]]. | ||
[[Category: 2013 data upgrades]] | File Location: {{S:\MED\MED_CCMED|CCMDB\PHI\phi.mdb}} | ||
== phi.mdb change log == | |||
=== 2016-Oct-03 === | |||
* I suspect it was rolled out; if it had not been there would still be a problem. Ttenbergen 16:29, 2017 January 3 (CST) | |||
*not rolled out yet Ttenbergen 10:56, 2016 October 3 (CDT) | |||
* fixing mistake from bulk change of STB_B5 data: see [[Centralized_data.accdb]]_Change_Log#2016-Oct-03]] | |||
=== 2015-04-15 === | |||
* changed the date format for DOB to dd-mmm-yyyy, eg 12-oct-1999 Ttenbergen 14:01, 2015 April 15 (CDT) | |||
=== 2014-02-03 === | |||
* added indices for firstname, lastname, phin and chart, to speed up linking tables. | |||
== How PHI data travels == | |||
# regular data enter into [[CCMDB.accdb]] by collector | |||
# at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to {{Regionalserver|Output\_PHI}} | |||
#* this means that previously sent data will get updated, e.g. if a name or PHIN is corrected or added | |||
# [[PHI copy automation]]: a scheduled task uses [[Copy PHI.bat]] to move the files to {{S:\MED\MED_CCMED|CCMDB\PHI}} and to import it into {{S:\MED\MED_CCMED|CCMDB\PHI\PHI.mdb}} | |||
#* [[Pull down centralized data.vbs]] will do this as well to make sure it is done before pulling | |||
# PHI.mdb can be re-linked with [[Centralized_data.accdb]] using [[Centralized_data_front_end.accdb]] | |||
== Availability == | |||
PHI.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}} | |||
[[Category:IT Instructions]] | |||
[[Category:2013 data upgrades]] | |||
[[Category:Password]] | |||
[[Category:PHI]] | |||
Latest revision as of 11:56, 30 July 2025
Data sent via Copy PHI.bat and PHI copy automation and query send_PHI. Contains primarily L PHI table.
File Location: S:\MED\Med_CCMED\CCMDB\PHI\phi.mdbS:\MED\Med_CCMED\CCMDB\PHI\phi.mdb
phi.mdb change log
2016-Oct-03
- I suspect it was rolled out; if it had not been there would still be a problem. Ttenbergen 16:29, 2017 January 3 (CST)
- not rolled out yet Ttenbergen 10:56, 2016 October 3 (CDT)
- fixing mistake from bulk change of STB_B5 data: see Centralized_data.accdb_Change_Log#2016-Oct-03]]
2015-04-15
- changed the date format for DOB to dd-mmm-yyyy, eg 12-oct-1999 Ttenbergen 14:01, 2015 April 15 (CDT)
2014-02-03
- added indices for firstname, lastname, phin and chart, to speed up linking tables.
How PHI data travels
- regular data enter into CCMDB.accdb by collector
- at sending, query send_PHI is called to export all (ie not only complete) records to Regional Server\Output\_PHI\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\Output\_PHI
- this means that previously sent data will get updated, e.g. if a name or PHIN is corrected or added
- PHI copy automation: a scheduled task uses Copy PHI.bat to move the files to S:\MED\Med_CCMED\CCMDB\PHIS:\MED\Med_CCMED\CCMDB\PHI and to import it into S:\MED\Med_CCMED\CCMDB\PHI\PHI.mdbS:\MED\Med_CCMED\CCMDB\PHI\PHI.mdb
- Pull down centralized data.vbs will do this as well to make sure it is done before pulling
- PHI.mdb can be re-linked with Centralized_data.accdb using Centralized_data_front_end.accdb
Availability
PHI.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 (full address: \\ad.wrha.mb.ca\wrha\HSC\shared\WRHA\WRHA_CCMED\Passwords_MainOffice_use)