Base View idvJobManagerLink

Description

This view represents the links between jobs 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

JobInternalId

Internal identifier of the job

ManagerInternalId

Internal identifier of staff member representing the manager

 

  •