BI Publisher (MOSC)

MOSC Banner

Which tables to use for Grade Rate Minimum and Maximum Salary along with Grade code

edited Jul 23, 2024 10:44AM in BI Publisher (MOSC) 5 commentsAnswered ✓

Hi all,

I need to pull out Grade Rate details in a BI Report, which tables I should join ? I need Grade Code, Minimum Salary and Maximum Salary against that specific Grade code in a specific Legislative code. I used the below query but the Grade_Ladder_ID is blank in grate rate table. Any Idea how to achieve this ?


select

distinct

pgf.grade_code, prvf.minimum, prvf.maximum

from

PER_GRADES_F pgf, PER_GRADES_IN_LADDERS_F pgilf, per_rates_f prf, PER_RATE_VALUES_F prvf

where

pgf.GRADE_ID = pgilf.GRADE_ID

and prf.GRADE_LADDER_ID = pgilf.GRADE_LADDER_ID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center