This view represents the links between 'to do' items and job instances or job stages.
The view is not phrased to cope with duplicate relationships on the database as they could, in principle, be legitimate. Ergo caveat implementor.
Type = Base view suitable for advanced end user use
ToDoInternalId | Internal identifier of the 'to do' object |
ObjectType2 | 64 = related object is a job instance, 71 = related object is a job stage. If wishing to specify the type as a criteria then use this column in preference to TargetObjectType (which provides the same information). This column is directly indexed, TargetObjectType is computed. |
TargetObjectType | 'I' related object is a job instance, 'S' related object is a job stage |
TargetInternalId | Internal identifier of the target object |