PHI.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
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
* first name
* first name
* last name
* last name
Line 5: Line 5:
* PHIN
* PHIN
* hospital chart number
* hospital chart number
in addition the following field is included to re-link the data:
*  D_ID: R_Location & "-" & Pat_ID


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

Revision as of 15:46, 2013 July 29

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