Some would argue that this is why you should only have one identity attribute per entity, but I've certainly encountered situations where it's felt convenient to have multiple notions of identity.

ideally yes but unfortunately it’s all too common to have foreign unique ids

Agreed; You could potentially make these unique distinct instead of unique identity, but you're still gonna get errors, so may not be so helpful.

you mean unique value instead of identity?

LoL; Yes