Originally Posted by
June7
Structure is an attribute of Grade or Employee, can't be both. The data is correct by the link through Job to Grade to Structure. Or maybe I have it backwards, employee link to structure to grade to job? Tried it, doesn't work.
Can grade be independent from job - as in government service, two different jobs (accountant, nurse) can have the same grade (GS-9). Job categories can be assigned a pay scale range. Nurse I is GS-5 - GS-9 and Nurse II GS-9 - GS-13, and the pay rate for an employee in each job category would fall within the range.
So I see you are entering the salary into employee record and this value is not by link to a pay rate table. You want a join as a check that the salary falls with the range?
I really don't know how the Structure code fits into this.