PHI.mdb

From CCMDB Wiki
Revision as of 17:49, 2014 February 3 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

Data sent via Copy PHI.bat and PHI copy automation and query send_PHI

  • first name
  • last name
  • full DOB (as opposed to the month/year sent to Centralized data.mdb
  • PHIN
  • hospital chart number

in addition the following field is included to re-link the data:

  • D_ID: R_Location & "-" & Pat_ID

This data will be stored in X:\CCMDB\PHI\phi.mdb

phi.mdb change log

2014-02-03

  • added indices for firstname, lastname, phin and chart, to speed up linking tables.
Retrieved from "https://ccmdb.kuality.ca/index.php?title=PHI.mdb&oldid=36755"