I'm trying to pre populate a form based on jobrequisition.position.positionlevel and pairing that level with the appropriate "pto bucket", which is a one to many type of relationship and not stored in GHR
For the SQL report we have utilizes a number of when/then identifiers because we have 3 pto buckets, but 10 position levels.
I have the position level populating on the form, I just need to figure out a way to have the appropriate 'pto bucket' populate as well.
Any suggestions?
TIA!
Laura
