 |
 |
|
|
This view shows the information within the view idvToDo along with the standard categorisation for any relevant client plus staff members and jobs.
The full categorisation information on a staff member (ibvStaffCategorisation) is based on the staff member that the 'to do' is assigned to. The job information (when relevant) may be deduced via a linked job instance or a linked job stage.
This view is suitable for any user wanting access to outstanding 'to do' tasks in system with categorisation.
This view Inherits columns from the following view:
JobId |
The visible identifier of any related job |
JobClientId |
The visible identifier of the client associated with any related job. Normally this will be the same as the client associated with the to do, but it could, in principle, be different |
JobType |
Visible identifier of job type of any related job |
JobTypeDescription |
Description of job type of any related job |
JobGroup |
Visible identifier of job group of any related job |
JobGroupDescription |
Description of the job group of any related job |
JobPartner |
The visible identifier of partner associated with any related job |
JobPartnerName |
The name of partner associated with any related job |
JobPartnerBranch |
The visible identifier of branch associated with the partner associated with any related job |
JobPartnerBranchDesc |
The description of the branch associated with the partner associated with any related job |
JobManager |
The visible identifier of manager associated with any related job |
JobManagerName |
The name of the manager associated with any related job |
JobManagerBranch |
The visible identifier of the branch associated with the manager associated with any related job |
JobManagerBranchDesc |
The description of the branch associated with the manager associated with any related job |
AssignedBy |
The visible identifier of staff member who assigned the 'to do' item |
AssignedByName |
The name of staff member who assigned the 'to do' item |
CreatedBy |
The visible identifier of staff member who created the 'to do' item |
CreatedByName |
The name of staff member who created the 'to do' item |