PHI.mdb: Difference between revisions

Revision as of 16:25, 2015 April 23

Data sent via Copy PHI.bat and PHI copy automation and query send_PHI

in addition the following field is included to re-link the data:

This data will be stored in X:\CCMDB\PHI\phi.mdb

changed the date format for DOB to dd-mmm-yyyy, eg 12-oct-1999 Ttenbergen 14:01, 2015 April 15 (CDT)

added indices for firstname, lastname, phin and chart, to speed up linking tables.

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

Located: M:\Passwords_mainoffice

@@ Line 29: / Line 29: @@
 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: 2013 data upgrades]]
 [[Category:Password]]