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

Salary Range Report ALL Jobs (Active and Inactive)

Received Response
81
Views
3
Comments

Summary:

I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to the Job. I do not have the skill to write sql, but it is my understanding that using logical sql might be the only way to:

Show ALL job codes whether active or inactive regardless if a worker is assigned

Identify Salary and Hourly Min-Mid-Max (Salary Basis) Some jobs have both Salary and Hourly Min-Mid-Max 

Values are Currency 2 decimal places only

Does anyone by chance know of the logical sql for this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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