AnsweredAssumed Answered

Question on PRASSIGNMENT and PRJ_BASELINE_DETAILS

Question asked by mei_fm on Jun 5, 2012
Latest reply on Jul 9, 2012 by another_martink
Hi,

Question on prassignment and prj_baseline_details table:

In which case that prj_baseline_details.object_type = 'task' IF the link is prassignment.prid = prj_baseline_details.object_id?

I thought that if I link prassignment.prid = prj_baseline_details.object_id then prj_baseline_details.object_type will always be 'assignment'

Example:

Case 1 - Using the above link but object_type = ASSIGNMENT
PRASSIGNMENT table


PRID
PRTASKID
PRRESOURCEID
12345
23456
34567
12346
23456
34568


PRJ_BASELINE_DETAILS Table


OBJECT_ID
OBJECT_TYPE
USAGE_SUM
12345
ASSIGNMENT 288000
12346
ASSIGNMENT
288000

Case 2- Using the above link but 1 of it is with object_type = TASK
PRASSIGNMENT table


PRID
PRTASKID
PRRESOURCEID
12347
23457
34569
12348
23457
34560

PRJ_BASELINE_DETAILS Table


OBJECT_ID
OBJECT_TYPE
USAGE_SUM
12347
ASSIGNMENT
288000
12348
TASK
19209600

CASE 2 above happens with:
- some projects with multiple baselines and with just 1 baseline
- In prassignment table, prid = 12348 (for example) does not have any baseline but prj_baseline_details is showing values in usage_sum

I'm actually doing reports that show Initial Baseline (Baseline 1) and Current Baseline, however there are some projects with tasks that show different baseline value. When I queried, I found the excess numbers is due to CASE 2 above.

Can anyone help explain to me please? Thanks a lot!


Mei

Outcomes