Task ETC vs Timesheet ETC

[navzjoshi00]

For one of the resources, the ETC at timesheet level is different from ETC at task level.

We tried resetting the SLICE_STATUS field to 1 in the prassignment table, and then, ran Time Slicing job, but in vain ... :sad

Any if we can solve this mystery ???

NJ

[Deactivated User]

In the timesheet is that ETC or Pending ETC.
ETC is coming from prassignment.prestsum. That is the project manager set ETC in the project plan
Pending ETC is coming from prassignment.prpendestsum. That is the user set ETC and displayed as proposed ETC in Clarity.
Both go into the ETC column in the timesheet.


Martti K.

[navzjoshi00]

The ETC column in the timesheet for the resource for the task shows 160
The ETC column in the task assigned to the resource for the task shows 128

So, you are saying that the ETC in the timesheet is the pending ETC ? I was under the impression that both are ETCs, and that they should be the same

Quick question - If they are not the same then what could be the reason ? Has the resource changed the ETC ? In that case, how do we make it / is there a possibility to sync with the ETC figure on the task ?

NJ

[Anon Anon]

If a resource has changed the ETC for a task on their timesheet, as Martti says, this is now the "Pending ETC" - it will appear on the timesheet highlighted in a different colour though so you can spot it, but it is displayed in the SAME position on the timesheet screen instead of the "normal ETC"

On the DATABASE it is held in a different column (to the "normal" ETC) - so if you look on the DB you should be able to see the assignment's normal ETC and any pending ETC.

When the PROJECT MANAGER accepts the newly Pending ETC (eg in OWB) then the Pending ETC is moved to the normal ETC and the Pending ETC is removed (on the database), and the highlighting on the Timesheet GUI gets removed.

--

So if you do NOT have a Pending ETC for the task and you still have discrepancies.... I'm confused. :wacko:


Database :

PRASSIGNMENT.PRESTSUM - the "normal" ETC (belongs to the project manager)

PRASSIGNMENT.PRPENDESTSUM - the "Pending " ETC (belongs to the timesheet booker)

[Deactivated User]

How the ETC box is displayed reveals if the user has changed the value coming from the project plan. If it is highlighted then the User Did It.
The other way is to display the Proposed ETC in Clarity. If there is a value then User Did It.
You could also ask the user.
If not and the difference is repeatedly there (eg. on more than one timesheet) then it is a corruption.
The only way I know to handle pending ETC is in OWB with the accept/delete pending ETC.
I have not tried to use edit mode in Clarity to to set the Proposed ETC to zero and to set the real ETC after that.


Martti K.



.

[navzjoshi00]

"How the ETC box is displayed reveals if the user has changed the value coming from the project plan. If it is highlighted then the User Did It" ... :sad

Unfortunately, it is not highlighted ... :sad

NJ

[Deactivated User]

How does it look if you have it in OWB and display the task and assignment ETC total and tabulated and Pending ETC?

Martti K.

[Anon Anon]

Yes, you should somewhere else other than the GUI (like on the database as I've been trying to suggest!!! - or as Martti suggests, in OWB)

... in the Clarity GUI you could have changed the display mode to FTE for example, that would help confuse you.....

[Deactivated User]

If you query the database what are the values of
prassignment.prestsum
prassignment.prpendestsum


Martti K.

[navzjoshi00]

PRESTSUM = 387360
PRPENDESTSUM = NULL / BLANK

NJ

[Deactivated User]

387360/3600 = 106,7 hours.
What is the timesheet ETC today and the asssigment ETC (where do you look at the assigment ETC?)

They are not likely to be 160 and 128 anymore.

When you say task ETC, are there other resources assigned to the same task?

Martti K.

[navzjoshi00]

"What is the timesheet ETC today and the asssigment ETC (where do you look at the assigment ETC?)"

Looking at the Timesheet ETC, for the timesheet 7/2/12 - 7/8/12, ETC = 103.60
Looking at the Task ETC (for that resource), ETC = 107.60

"When you say task ETC, are there other resources assigned to the same task?" - Yes

NJ

[Deactivated User]

107.60 is correct hours for the task (387360/3600) sorry about that.
There is no pending ETC so 103.60 should be the correct number for the assignment.

When you say 107,6 for the task. Is that the one resource only and not any other?
Where do you look at that?

Martti K.

[navzjoshi00]

"When you say 107,6 for the task. Is that the one resource only and not any other?" - For one resource (the resource where we see discrepancy)


"Where do you look at that?"

Clicking on the Task, and then clicking on Assignment Properties icon

http://<server>/niku/app?action=projmgr.assignmentProperties&id=<assignmentid>&returnAction=projmgr.taskPropertiesReturn&projectId=<projectid>


NJ

[Deactivated User]

That should be for a single resource only and the same value as in the assignment section of the task properties view.
If you look at the Assignments sub tab you can see the ETC at task level and at the assignment level for each resource.

Based on what you say you are definitely looking at the rights things and 107,60 what is expected to be displayed on timesheets and not 103.60 when the user has not set pending ETC (pending ETC = 0)
No explanation.
Open a case with support.

Martti K.

[navzjoshi00]

Have done that ... :sad

Still under investigation by CA ... :sad

Will let you know if I hear anything from them

NJ

[Deactivated User]

Did you supply them with logs and trace?
Hopefully they get to the bottom of it.

Martti K.