PHI.mdb: Difference between revisions

No edit summary
m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED"
Line 1: Line 1:
Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI. Contains primarily [[L PHI table]].
Data sent via [[Copy PHI.bat]] and [[PHI copy automation]] and query send_PHI. Contains primarily [[L PHI table]].


File Location: {{S:\MED\CCMED}}CCMDB\PHI\phi.mdb
File Location: {{S:\MED\MED_CCMED}}CCMDB\PHI\phi.mdb


== phi.mdb change log ==
== phi.mdb change log ==
Line 19: Line 19:
# 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
#* 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 {{S:\MED\CCMED}}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 {{S:\MED\MED_CCMED}}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  
#* [[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.accdb]]
# PHI.mdb can be re-linked with [[Centralized data.mdb]] using [[Centralized_data_front_end.accdb]]