Base View idvJobInstance

Description

This view exposes the rows in ISOL1445 that represent individual instances of client jobs.

 

Type = Base view suitable for advanced end user use

 

Columns

InternalId The internal identifier of the job instance
ClientObjectType The object type of the client object for whom the job is done
ClientInternalId The internal id of the client object for whom the job is done
JobInternalId The internal id of the parent job
JobTypeInternalId The internal identifier of the job type
PeriodStart The start date of the period that the instance applies to
PeriodEnd The end date of the period that the instance applies to
StatutoryDeadline Any associated statutory deadline
ScheduledStart Scheduled start date
ScheduledComplete Scheduled date for completion
CompletionLoggedBy Internal identifier of staff member who logged completion
CompletionLogged When job instance completion was logged
Status PND = Pending, PLN = Planning, SCH = Scheduled

 

This view is directly inherited by the following views: