Base View idvStaffJobInstanceLink

Description

This view represents the links between Staff members and Job Instances.

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

 

For use by

Base view suitable for advanced end users.

 

Columns

JobInstanceInternalId

Internal identifier of the job instance

StaffInternalId

Internal identifier of the staff member