Base View idvClientManagerLink

Description

This view represents the links between clients and their responsible managers.

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

 

For use by

Base view suitable for advanced end users.

 

Columns

ClientObjectType

Type of client object

ClientInternalId

Internal identifier of client object

ManagerInternalId

Internal identifier of staff member representing the manager

 

  •