 |
 |
|
|
This view presents job stage information together with information about the latest 'to do' task associated with the stage (if any)
Type = End user view giving details of a job stage joined with the latest 'to do' item associated with it
Inherits columns from view icvJobStage plus
ToDoInternalId |
Internal identifier of any 'to do' item present. You can use the fact that this is not null as criteria for the existence of a 'to do' item. |
ToDoSubject |
Subject text for any 'to do' present |
ToDoPriority |
Priority text for any 'to do' present (see idvToDo) |
ToDoStatus |
Status of any 'to do' present (see idvToDo) |
ToDoDue |
Due date of any 'to do' present |
ToDoAssigned |
When any 'to do' present was assigned |
ToDoAssignedTo |
Identifier of staff member any 'to do' present is assigned to |
ToDoAssignedToName |
Name of staff member any 'to do' present is assigned to |
ToDoAssignedBy |
Identifier of staff member who assigned any 'to do' present |
ToDoAssignedByName |
Name of staff member who assigned any 'to do' present |
ToDoCompleted |
When any 'to do' present was completed |
ToDoStatusSet |
When the latest status was set on any 'to do' present |
ToDoStatusSetBy |
Identifier of staff member who set the latest status on any 'to do' present |
ToDoStatusSetByName |
Name of staff member who set the latest status on any 'to do' present |