Looks like it might be Person_Link.PeLi_Type.

Team Equation Thank you. That's definitely the table. Any idea what the proper linking is to join from the Person table? If I link on Pers_PersonId and Pers_companyId it seems like I've still got a join to do. Do you know where PeLi_PersonLinkId is meant to link? I see that it's the primary key so might just be auto-incrementing, but I'm getting some duplicates in a result set so I'm curious about the table structure. Thanks for the advice.

I believe it would be something like:

SELECT Person_Link.PeLi_Type, Person.*
FROM Person INNER JOIN
Person_Link ON Person.Pers_PersonId = Person_Link.PeLi_PersonId

Or, possibly, this... but the inclusion of CompanyID seems unnecessary:

SELECT Person_Link.PeLi_Type, Person.*
FROM Person INNER JOIN
Person_Link ON Person.Pers_PersonId = Person_Link.PeLi_PersonId AND Person.Pers_CompanyId = Person_Link.PeLi_CompanyID

Thanks for the suggestion- yes that's exactly how I wrote it as well. But for some reason I was still seeing multiple PersonIds against a single PeLi_PersonLinkId value, returning duplicates. Maybe an issue in my data then- thanks again for the ideas!

Don't forget to exclude deleted records:

where PeLi_Deleted is null and Pers_Deleted is null