SQL for compa ratio — 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 for compa ratio

Summary:

Need correct SQL to find Compa Ratio

Content (required):

Hello,

I am writing a report for the business that includes the compa ratio as one of the columns. And the SQL I've written is correct......most of the time. There's a handful of people though that don't seem to have the right compa ratio listed in the database, even though the correct compa ratio is displayed in the UI. I thought I might show the community the SQL that I've written and see if there's anything different I should do.


This is basically what I've got:

SELECT asg.assignment_number, asg.assignment_status_type, sal.date_from, sal.date_to, sal.compa_ratio, pg.grade_code, rtv.minimum, rtv.maximum, rtv.mid_value, sal.salary_amount

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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