Clarity

  • 1.  Timesheet with 0 hours

    Posted Mar 05, 2015 06:13 AM

    Hi ,

     

    Resources who are not allocated to any project are submitting 0 hours in their timesheet.

    These details, the timesheet with 0 hours, are not present in the PPA_WIP or any related tables.

    From where can I get the information in the database? Which table contains this information about the 0 hours time entry.

     

    Thanks,

    Ashwini Ananthan



  • 2.  Re: Timesheet with 0 hours
    Best Answer

    Posted Mar 05, 2015 06:42 AM

    PRTIMESHEET contains the timesheet header, PRTIMEENTRY contains the timeentry lines.

     

    Prior to POSTING then there may be entries in PRTIMEENTRY that total zero hours (practsum), but after posting these get removed so you would just be left with a PRTIMESHEET of prstatus = 4 (posted) with no matching PRTIMEENTRY records.