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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

Getting the P_DATE as a column

edited Apr 3, 2020 12:06PM in Reporting and Analytics for HCM 1 comment

Summary

Getting the prompted date to be the date in a column.

Content

Is there anyway of being able to get the P_DATE that you have set as a prompt to show in a column?

I would like to be able to get a column that shows the P_Date unless the effective start date of an employee is later than the prompted date.

E.g. I want to run a report from 01/12/2019, anybody that started before that date will have that date in said column but anybody that started after said date will have their start date in. I am using "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Date Start" to get the employee's start date.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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