PHI.mdb: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) FOR TINA - delays of PHI files showing up on X in PHI folder when SENDING to centralized |
Ttenbergen (talk | contribs) m m |
||
| Line 23: | Line 23: | ||
#* this means that previously sent data will get updated, e.g. if a name or PHIN is corrected or added | #* this means that previously sent data will get updated, e.g. if a name or PHIN is corrected or added | ||
# [[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 | # [[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 | ||
#* [[Pull down centralized data.vbs]] will do this as well to make sure it is done before pulling | |||
# PHI.mdb can be re-linked with [[centralized_data.mdb]] using [[centralized_data_front_end.mdb]] | # PHI.mdb can be re-linked with [[centralized_data.mdb]] using [[centralized_data_front_end.mdb]] | ||
Revision as of 12:58, 2015 April 20
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
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
- regular data enter into CCMDB.mdb by collector
- 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
- 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
- Pull down centralized data.vbs will do this as well to make sure it is done before pulling
- PHI.mdb can be re-linked with centralized_data.mdb using centralized_data_front_end.mdb
Password
Located: M:\Passwords_mainoffice
Delays on network from SENT time
- Noted there can be up to a 1 hour delay between when collector SENDS data to centralized.mdb and when SEND PHI files shows up on X to be moved into PHI.mdb? What the heck is with this long delay? This occurred with STB E5 (1 hr delay) and SICU (30 mins delay) TODAY. Pagasa, has now revealed that she has always noted delays, but had not mentioned it that she noted at times it shows up eventually. It is good to note this is an additional reason why PHI.mdb and L_log don't match...........for some reason you have to wait for it. Trish Ostryzniuk 14:16, 2015 April 17 (CDT)