Hockey, I don't think that would necessarily be a good solution. AC has issues when trying to find a patient who has changed her/his name. This means there is not a name history table. And what you would be dealing with is yet another set of "legacy" issues.

The best way to do this is for FAP to have a column called XSUID which stands for
External System UniqueID - this stores the value of the AC or any EHR's Unique ID in a separate column and FAP stores its own UniqueID. That way it does not matter what changes come to AC, FAP will work independent of AC.

But I do not work for either of these companies, and any advice given here is caveat emptor.

"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~ Alvin Toffler