AnsweredAssumed Answered

How can we read the PRTIMEENTRY table to get Actual Hours by prtimeentry.U

Question asked by Steve_Schock on Sep 4, 2009
Latest reply on Sep 6, 2009 by Paul_Maxwell
How can we read the PRTIMEENTRY table to get
the Actual Hours
by Day
by Timesheet (PRTIMESHEETID)
by Assignment (PRASSIGNMENTID)
by prtimeentry.User_LOV1?

Our new and big customer, University of Nebraska
works to a different work-week than we do.
(We are Mon->Sun, and they are Fri->Thurs.)
After they enter their timesheets using our weeks, they
they need to run a report that will show their time in
the week they use, to check for 40-hour totals and
for proper overtime and shift totals.

They are recording shift totals on the timesheet
in the user value 1 column which is:

niku.prtimeentry.USER_LOV1

They have created a cool, web-based report that works
off a view in our SQL server. This works well, except
that it does not include the shift information that is in
prtimeentry.USER_LOV1.

User needs a VIEW (for this report)
that shows:
Fact Date
Resource
Project
Task
prtimeentry.User_LOV1
Actual Hours by Day

Here is what we have tried:

1. do not see USER_LOV1 in the NBI Tables or the NBI Views.

2. do not see USER_LOV1 in DAIILYRESOURCEACTCURVE
or in PRJ_BLB_SLICES_S.

(Although I do not understand the codes in:
prj_blb_slices_s.SLICE_REQUEST_ID
prj_blb_slices_s.UNIT. )

3. XOG breaks this out nicely, but the user needs to be able
to complete a timesheet and then (almost immediately)
check the totals with this report...so XOG is not quick enough
to meet their needs.

The human side of this is a bit interesting. Our customer DBA is
very good with SQL, and (not understanding why the daily actuals
would be stored in the blob, prtimeentry.ACTCURVE) they are
feeling a very frustrated about Clarity.

Do you have any thoughts on how to proceed with this?

Thanks,

Steve Schock
State of Nebraska
402-471-0643


---------------------------------------------------------------------------

Outcomes