Base View idvStaffDepartmentLink

Description

This view represents the links between staff members and departments.

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

StaffInternalId

Internal identifier of the staff member

DepartmentInternalId

Internal identifier of Department

 

  •