PHI.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 7: Line 7:
in addition the following field is included to re-link the data:
in addition the following field is included to re-link the data:
*  D_ID: R_Location & "-" & Pat_ID  
*  D_ID: R_Location & "-" & Pat_ID  
This data will be stored in X:\CCMDB\PHI\phi.mdb


[[Category: 2013 data upgrades]]
[[Category: 2013 data upgrades]]

Revision as of 08:17, 2013 October 18

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