Time posted for a team member show under the team's assignment
Article ID: 385766
Updated On:
Products
Issue/Introduction
When a resource is part of a team and they post time to the task their team is assigned to, the actual hours show on the team's assignment and not the actual resource's assignment.
We cannot then tell which resource posted time to the assignment (through the team). The same can be found for financial transactions.
Resolution
This is working as designed.
If you want to track the actual resource's time they will need to be added separately to the project/investment staff page as well as the task.
Then the resource has the option to post time as themselves or part of the team.
They will see the task twice on their timesheet, one identified as Team and one identified with the resource's name.
Additional Information
You can track the timesheet as well as financials back using database queries. Here you will see that the assignment on the prtimeentry table points to the team assignment if posting to the team. However the prtimesheet table will show for the specific resource and not the team resource. If needed by day you would need to link to the slice table.
Financial transactions (PPA_WIP table) has join back to the prtimesheet table as well as the prtimeentry table.
Simple query to find the actual records for a timesheet would be
SELECT t.PRNAME,
ts.PRSTATUS,
s.SLICE_DATE,
s.SLICE,
r.FULL_NAME
FROM prtimesheet ts
INNER JOIN SRM_RESOURCES r
ON ts.PRRESOURCEID = r.ID
INNER JOIN PRTIMEENTRY te
ON ts.PRID = te.PRTIMESHEETID
INNER JOIN PRASSIGNMENT a
ON te.PRASSIGNMENTID = a.PRID
INNER JOIN PRTASK t
ON a.PRTASKID = t.PRID
INNER JOIN INV_INVESTMENTS i
ON t.PRPROJECTID = i.ID
INNER JOIN PRJ_BLB_SLICES s
ON te.PRID = s.PRJ_OBJECT_ID
WHERE s.SLICE_REQUEST_ID = 55555
AND ts.PRID = <timesheet ID>
You could modify this to use the resource's full_name or other database table fields.
For PPA_WIP:
PPA_WIP.externalbatchid = PRTIMESHEET.prid
PPA_WIP.externalid =PRTIMEENTRY.prid
Feedback
