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

Dashboard prompts using sql query

Accepted answer
edited Aug 24, 2021 3:25PM in Reporting and Analytics for HCM 3 comments


Need to create dashboard prompts using sql query as the relevant subject areas for prompt data is not available


Hi Experts,

I have a requirement to have payroll period as a prompt in my dashboard based on which I need to display some non-payroll data.

The payroll period fields are present in subject areas like Payroll Run Results Real Time and Payroll Balances Real Time. But the period data is present only if the payroll is run for the period. The periods details are not present in these subject areas for the periods where the payroll is not run for any employees but are present in period details section in payroll definition setup.


Howdy, Stranger!

Log In

To view full details, sign in.


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