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

BIP report for Missing time

in Workforce Management

Summary:

I am trying to build BIP report to send notiifcations when an employee has missed entering either the start or the stop time in time card. Below is the SQL that we are using.

We are not able to find the right field to filter on so that report can fetch only todays data. Can you please help me with field that i can filter on so that report fetches the data all theh employees who have not entered the time for today?

Content (please ensure you mask any confidential information):

SELECT

papf.person_number,


ppnf.full_name        AS employee_name,
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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