Promotion: Displaying Job Eligibility Flag

Summary:

Content (required):

We have created a Compensation Plan for Promotion. The requirement is: while entering the Proposed Job we need to display a Flag (Yes/No) or score (0% or 100%) to indicate if the Employee has got the Qualifications required for the Proposed Job.

For example if the Proposed Job "Construction Manager" has a Pre-requisite "Bachler Degree" and the Employee has already got the Bachler Degree, then a field should show "Yes" otherwise it should show "No"

I think we can add a User Defined Column and set the default value based "Default and Override Formula" Fast formula which reads the Proposed Job and Checks the Employee's Degrees.