PHI.mdb: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 9: | Line 9: | ||
This data will be stored in X:\CCMDB\PHI\phi.mdb | 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. | |||
[[Category: 2013 data upgrades]] | [[Category: 2013 data upgrades]] | ||
Revision as of 17:49, 2014 February 3
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.