Clarity

  • 1.  Daily Acutals from timesheets

    Posted Sep 18, 2013 11:12 AM
    Hi All,

    Is there a way to get daily actuals entered by each resources from timesheets which are not in posted status.

    I know we can get daily actuals entered by resources from PRJ_BLB_SLICE_D_ACT table but it gives information only if the timesheet is posted, I want the daily actuals for timesheets which are in not posted status.


    Thanks


  • 2.  RE: Daily Acutals from timesheets

    Posted Sep 18, 2013 11:17 AM
    You need to look at a "Time Entries" slice - a daily one.

    I think that number 55555 / DAILYRESOURCETIMECURVE is out-of-the-box (from V13 onwards) - otherwise you can just create your own.

    The slice object_id is the PRTIMEENTRY.PRID.

    --

    Some previous discussions on this subject;

    Break PRTIMEENTRY Into Daily Totals
    Getting Timesheet Data using NSQL


  • 3.  Re: RE: Daily Acutals from timesheets