REQUISITION_POSTED State Code Giving Strange Results — 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

REQUISITION_POSTED State Code Giving Strange Results

in Reporting and Analytics for HCM 1 comment

Hello,

I have a need to find the most recent date a requisition was posted and unposted. For compliance purposes, we need to ensure our jobs are being posted for a minimum of 5 days when being posted on the External Career Site. In order to find the most recent posted and unposted date, I used LSQL to join the Subject Areas (attached if helpful). I noticed a large number of jobs showing as 0 days posted, meaning they were posted and unposted on the same day. I dug into the results, and it seems to be

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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