Clarity

  • 1.  is it possible to find the date and time for user entered timehseet

    Posted Apr 10, 2018 02:40 AM

    Is it possible to find the date and time for user entered timesheet.

     

    can you please advise on this



  • 2.  Re: is it possible to find the date and time for user entered timehseet

    Broadcom Employee
    Posted Apr 10, 2018 03:06 AM

    Hi Muthukumar,

    The timesheet table stores the last modified date and time and not the submitted time in particular. 

    This means, if the timesheet has been submitted and later approved/rejected, then the last action time on the timesheet will be in the tables. However you can find who submitted the timesheet. 

    PRTIMESHEET is the table you might want to look into for these info. 

     

    Thanks,

    Jerin



  • 3.  Re: is it possible to find the date and time for user entered timehseet

    Posted Apr 10, 2018 03:11 AM

    Hi Sebastian,

    Thanks for your Reply..

    I want Date and Time when the time entries were made on entire timesheet..



  • 4.  Re: is it possible to find the date and time for user entered timehseet

    Broadcom Employee
    Posted Apr 10, 2018 03:15 AM

    Like as I said, if the timesheet is already approved/rejected or posted, then we cannot get he date and time when the timesheet was submitted. 

     

    prtimesheet.promodtime is what gives the latest activity on the timesheet. 

     

    If the timesheet is still in submitted status, then check the above column and you should get the details. 



  • 5.  Re: is it possible to find the date and time for user entered timehseet

    Posted Apr 10, 2018 09:20 AM

    When a timesheet is created a record is created in prtimesheet.

    When a timeentry is made a record in prtimeentry is created.

    The prdmod field will tell the time the entry was last updated which is regardless of the timesheet creation or status.



  • 6.  Re: is it possible to find the date and time for user entered timehseet

    Broadcom Employee
    Posted Apr 10, 2018 11:07 AM
    How can the last edited time be obtained before a timesheet is posted?

    1. The PRTIMESHEET.prmodtime will be updated when the timesheet is edited, saved, approved, or returned.

     

    2. After the Post Timesheets job processes a timesheet
    a. PRTIMESHEET.posted_time will be set
    b. PRTIMESHEET.prmodtime will get set to the PRTIMESHEET.posted_time

     

    3. If the goal is to obtain the latest 
    PRTIMESHEET.prmodtime when it approved, a customization will need to be considered.