Valid Job Grade reporting

Summary

We are trying to determine if we have muliple Valid Grades for Job Codes

Content

We found some Job Codes with multiple Valid Grades and I am having difficulty writing a report to check all of the Jobs

I tried Workforce Management - Worker Assignment Real Time subject area, but it stacks all the Grades in the Valid Grade field and I cannot determine if each grade has its own effective dated row or if they cross over into another row (which is the problem)

I also tried to create a Data Model, but only found the Job data (PER_JOBS_F) and no luck joining the Grade table (PER_GRADES_F)