PHI.mdb: Difference between revisions

How PHI data travels: confirmed that PHI data gets updated.
Line 17: Line 17:
== How PHI data travels ==
== How PHI data travels ==
# regular data enter into [[CCMDB.mdb]] by collector
# 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
# 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
# [[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.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]]