Veeva provides Out of the Box values in the Role_vod field of the Affiliation_vod object as it is a picklist field. Can new values be added to the Role field of Affiliations?
The user is able to add or edit the values in the Role_vod field of the Affiliation_vod object. The user needs to clear Veeva Cache after the change.
Note: SOI does not support Record Type restrictions by Role.
CRM Documentation: Sphere of Influence