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

Table HWM_TM_EVENTS

edited Dec 17, 2019 5:09PM in Workforce Management 1 comment

Summary

Has something changed with this table? A simple query is not showing Web Clock punches made after 19D update 19D

Content

The query below lists all web clock punches for a given employee till Oct 15th. But nothing after that. We got the 19D update the night of Oct 15th. Looking for direction on where to look further.

 

select reporter_id PersonNum,

 TO_CHAR(event_time_real,'MM/DD/YYYY') EventDate, TO_CHAR(event_time_real,'HH24:MI:SS AM') Eventtime, event_time_real,

Decode(event_type,'ORA_HWM_IN','In', 'ORA_HWM_OUT' ,'Out',Null) Event, device_id, status, created_by, creation_date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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