View source for PHI.mdb

Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI. Contains primarily [[L PHI table]].

File Location: X:\CCMDB\PHI\phi.mdb

== phi.mdb change log ==
=== 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.mdb]] by collector
# at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to [[Regional Server]]\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 [[X:\]]CCMDB\PHI and to import it into x:\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.mdb]] using [[centralized_data_front_end.mdb]]

== 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: <file>M:\Passwords_MainOffice_use</file>


[[Category: IT Instructions]]
[[Category: 2013 data upgrades]]
[[Category:Password]]
[[Category: PHI]]