Base View idvStaffJobStageLink

Description

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

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

JobStageInternalId

Internal identifier of the job stage

StaffInternalId

Internal identifier of the staff member

 

  •