 |
 |
|
|
This view presents the information within view ibvLatestJobInstance joined to standard categorisation for the containing client and job
Type = End user view giving current status of the latest job instance for a client and job type combination with categorisation
Inherits columns from view ibvClientCategorisation plus
Inherits columns from view ibvJobCategorisation plus
| InternalId | Internal identifier of the job instance - see idvJobInstance |
| ClientObjectType | Object type of the client for whom the work is done - see idvJobInstance |
| ClientInternalId | Internal identifier of the client for whom the work is done - see idvJobInstance |
| PeriodStart | Start date for period covered (if relevant) - see idvJobInstance |
| PeriodEnd | End date for period covered (if relevant) - see idvJobInstance |
| StatutoryDeadline | Any associated statutory deadline - see idvJobInstance |
| ScheduledStart | Scheduled start date - see idvJobInstance |
| ScheduledComplete | Scheduled completion date - see idvJobInstance |
| CompletionLoggedBy | Internal identifier of staff member who logged job completion - see idvJobInstance |
| CompletionLogged | Date completion of job logged - see idvJobInstance |
| Status | Status as recorded on the job instance table itself - see idvJobInstance |
| StageInternalId | The internal identifier of the latest completed job stage (if any) |
| TemplateInternalId | Internal identifier of the template the job stage is derived from (if any) |
| StageDue | Any due date marked on the latest completed job stage (if any) |
| StageCompleted | Date the latest completed job stage was marked completed (if any) |
| WhoCompletedStage | Internal identifier of staff member who marked the latest completed job stage as completed (if any). |
| StageDescription | The description of the latest completed job stage (if any). If there is none then this will be 'No stages complete' |
| StageSequence | The sequence number of the latest completed job stage (within the job profile). If there is no completed job stage this is zero. |
| SortableDescription | The description of the latest completed job stage preceeded by the stage sequence number (so that the column can be meaningfully used for sorting on) |
| JobStatus | The deduced status of the job
|
| JobStatusLogged | If the job has been completed, or has avalid latest stage complete, then this is the date logged against the status |
| JobStatusLoggedBy | If the job has been completed, or has avalid latest stage complete, then this is internal identifier of the staff member who logged the status |
| 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 |