Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Help with an OTBI or SQL query to produce a list of all job codes with Grade information — 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

Help with an OTBI or SQL query to produce a list of all job codes with Grade information

Accepted answer
5
Views
16
Comments
in General Transactional Reporting (OTBI) 16 comments

Summary:

Hi All,

I am hoping someone can help me - I have been struggling with a report request for a while now and I didn't think it was going to be this hard

Our business users have asked for a list of all Jobs with their grade information (active and inactive) -this includes any future transactions as well.

I created an Analysis using Workforce Management - Worker Assignment Event Real Time pulling data from Job, Job-Additional Attributes, Grade, Grade-Additional Attributes

At first the report appeared to be working EXCEPT it doesn't show the future transactions

For example - in the case of a Grade Update - the change was made effective Dec 1 but the future record isn't showing and a previous grade update is not showing

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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