Second Level View icvLatestJobInstance

Description

This view gives a subset of idvJobInstance corresponding to the latest job instance per client and job type.

Although illogical examples have been found that there can be more than one job instance for a particular client, job type and end date. It defines the latest job instance to be the one with the highest internal identifier picked from the set of those for which there is no later period end for the client and job type.

For use by

This view is only suitable for advanced users. Combination view isolating latest job instances by client and job type.

Columns

Inherits columns from view idvJobInstance

This view is directly inherited by the following view:

• ibvLatestJobInstance