PHI.mdb: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (2 intermediate revisions by the same user not shown) | |||
| 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\MED_CCMED | File Location: {{S:\MED\MED_CCMED|CCMDB\PHI\phi.mdb}} | ||
== phi.mdb change log == | == phi.mdb change log == | ||
| Line 7: | Line 7: | ||
* I suspect it was rolled out; if it had not been there would still be a problem. Ttenbergen 16:29, 2017 January 3 (CST) | * I suspect it was rolled out; if it had not been there would still be a problem. Ttenbergen 16:29, 2017 January 3 (CST) | ||
*not rolled out yet Ttenbergen 10:56, 2016 October 3 (CDT) | *not rolled out yet Ttenbergen 10:56, 2016 October 3 (CDT) | ||
* fixing mistake from bulk change of STB_B5 data: see | * fixing mistake from bulk change of STB_B5 data: see [[Centralized_data.accdb]]_Change_Log#2016-Oct-03]] | ||
=== 2015-04-15 === | === 2015-04-15 === | ||
| Line 17: | Line 17: | ||
== How PHI data travels == | == How PHI data travels == | ||
# regular data enter into [[CCMDB.accdb]] by collector | # regular data enter into [[CCMDB.accdb]] by collector | ||
# at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to | # at sending, query ''send_PHI'' is called to export '''all''' (ie not only complete) records to {{Regionalserver|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\MED_CCMED | # [[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 {{S:\MED\MED_CCMED|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.accdb]] using [[Centralized_data_front_end.accdb]] | # PHI.mdb can be re-linked with [[Centralized_data.accdb]] using [[Centralized_data_front_end.accdb]] | ||
| Line 30: | Line 30: | ||
[[Category: IT Instructions]] | [[Category:IT Instructions]] | ||
[[Category: 2013 data upgrades]] | [[Category:2013 data upgrades]] | ||
[[Category:Password]] | [[Category:Password]] | ||
[[Category: PHI]] | [[Category:PHI]] | ||