PHI.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "</file>" to ""
m changed to .accdb
Line 24: Line 24:
# [[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
# [[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  
#* [[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]]
# PHI.mdb can be re-linked with [[centralized_data.accdb]] using [[centralized_data_front_end.mdb]]


== Availability ==
== Availability ==

Revision as of 22:42, 2017 June 11

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

2016-Oct-03

Template:Discussion?

  • I suspect it was rolled out; if it had not been there would still be a problem. Ttenbergen 16:29, 2017 January 3 (CST)


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

  1. regular data enter into CCMDB.mdb by collector
  2. 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
  3. 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
  4. PHI.mdb can be re-linked with centralized_data.accdb 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: M:\Passwords_MainOffice_use