Skip to main content
Planview Customer Success Center

How to track in the DB any time submission that was ever rejected even if it was corrected and resubmitted.

Question
How to track in the DB any time submission that was ever rejected even if it was corrected and resubmitted?

 

Answer
Use the following SQL statement to find out which time submissions were in rejected status:
select * FROM Time WHERE RejectReason IS NOT NULL

To check if it was resubmitted check the status of the time record.