Fast Formula (Participation and Rate Eligibility) - Compare Current Job to Prior Job

Summary:

We need to evaluate eligibility for a performance document, based on a change in job, comparing the current job to the prior job on the assignment.

Content (required):

I am trying to identify a database item (DBI) or formula function that will provide the job name prior to the latest assignment change, so that I can compare and determine eligibility for a performance document. Here is an example:

In this case, I want to pull 'Widget Maker' into my formula. I am comparing the two job names as part of the eligibility criteria (I can get the current job from a DBI).