PHI.mdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m →‎phi.mdb change log: changed date format
TOstryzniuk (talk | contribs)
FOR TINA - delays of PHI files showing up on X in PHI folder when SENDING to centralized
Line 27: Line 27:
==Password==
==Password==
Located:  M:\Passwords_mainoffice
Located:  M:\Passwords_mainoffice
==Delays on network from SENT time==
{{Discussion}}
*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.  [[User:TOstryzniuk|Trish Ostryzniuk]] 14:16, 2015 April 17 (CDT)


[[Category: IT Instructions]]
[[Category: IT Instructions]]
[[Category: 2013 data upgrades]]
[[Category: 2013 data upgrades]]

Revision as of 13:16, 2015 April 17

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

  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

Delays on network from SENT time

Template:Discussion

  • 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)