Base View idvStaffBranchLink

Description

This view represents the links between staff members and branches.

The view is phrased to cope with inadvertent duplicate relationships on the database, and behave in the same way as the software would. In particular it is guaranteed to return a singleton result for each primary object.

You should also note that the default relationship (staff linked with main agent) is not normally present on the database. So this view represents the exceptions, not the totality.

For use by

Base view suitable for advanced end users.

Columns