would doing something like selecting a newid() help?

for example, have them do something like this:

SELECT

NEWID() AS RefID,

OtherColumnsButNotTheRealID

Into TableForExport

From tblPatients

--OR

SELECT

identity(int,1,) AS RefID,

OtherColumnsButNotTheRealID

Into TableForExport

From tblPatients

then have them send you the TableforExport, which would not have the sensitive column.

they could do the same for patient names as well, if they needed to...just select a number instead of a patient name.