TL_PCHTIME_VW

(SQL View)
 Index Back

Reported Punch Time

This view contains reported punch time.

SELECT EMPLID ,EMPL_RCD ,PUNCH_DTTM ,PUNCH_TYPE ,TIMEZONE ,TL_QUANTITY ,TRC , DUR ,PUNCH_TIME FROM PS_TL_RPTD_TIME WHERE PUNCH_TYPE <> '0'

Error starting at line : 96,689 File @ C:\Metadata\_pthtml.sql In command - BEGIN ptref.pthtml('TL_PCHTIME_VW'); END; Error report - ORA-01403: no data found ORA-06512: at "SYSADM.PTREF", line 255 ORA-06512: at line 1 01403. 00000 - "no data found" *Cause: No data was found from the objects. *Action: There was no data from the objects which may be due to end of fetch.