SQL to extract all valid grades for all jobs — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL to extract all valid grades for all jobs

edited May 19, 2020 3:41PM in Human Capital Management 5 comments

Summary

SQL to extract all valid grades for all jobs

Content

Hi All,

I am looking for an SQL query to get all active job name and associated valid grade. I tried but could not find any common joining column between per_jobs_f & per_grades_f table except set_id. However joining with set_id does not show actual valid grade associated with a particular job.

Can anyone please help?

 

Regards,

Abhradeep

Version

R20B

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!