Security object models

The following illustration shows some relationships of the ProducerCode entity.

The GroupProducerCodes array contains the GroupProducerCode entities available to the Group. The GroupProducerCode entity has foreign keys to the ProducerCode and Group entities. The Group entity has two derived arrays of ProducerCode entities. These contain the producer codes which apply to the users in the group. The ProducerCodes derived array contains the list of producer codes associated with this group. The InheritedProducerCodes derived array contains the producer codes inherited from parent groups. (Remember that groups can be arranged in a hierarchy of groups.)

The UserProducerCodes array contains the UserProducerCode entities available to the User. These are the producer codes assigned directly to the user. The UserProducerCode entity has foreign keys to the ProducerCode, Role, and User entities. The AdditionalProducerCodes derived array provides another way to access the producer codes directly assigned to the user.

The User entity has an additional derived arrays of ProducerCode entities. The InheritedProducerCodes derived array contains the producer codes inherited from the group or groups that the user belongs to. These producer codes apply to the user.