Salary Range Report ALL Jobs (Active and Inactive)
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?