What's new in Customer Journeys?

Connect and learn more! ×
Trying to create a BI report to fetch out the payroll element entry data for employee. — 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

Trying to create a BI report to fetch out the payroll element entry data for employee.

Received Response
43
Views
9
Comments

Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's will come and stored in individual compensation (i.e. : Award Compensation) and in element entri

While hiring an employee, the employee is on pending worker state once he is converted into employee the pending worker record will goes to INACTIVE state the employee record will be in ACTIVE. When the employee is hired as a pending worker he will be rewarded with "BONUS". Once the employee is converted from pending worker to employee this BONUS will reflect in individual compensation (i.e. : Award Compensation).Here in query the active record for that employee is not at all capturing in report even if we hardcode assignment_type as 'E' and status as 'ACTIVE".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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