PHI.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (minor - all article related to PHI in one category)
m (m)
Line 1: Line 1:
Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI
Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI. Contains primarily [[L PHI table]].
* 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


File Location: X:\CCMDB\PHI\phi.mdb


== phi.mdb change log ==
== phi.mdb change log ==

Revision as of 12:44, 2015 August 17

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

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.mdb using centralized_data_front_end.mdb

Password

Located: M:\Passwords_mainoffice