Baseline Info (Cost Plan/Budget Plan)

[Anon Anon]

Hi,

I have baselined my project. Baseline includes costplan and budget plan details as well. so i need to read the monthly costplan/budget plan information from baseline.

Can anyone tell me from which table & curve i have to use to fetch the information.

Thanks in advance.
TIDI

[navzjoshi00]

Hello

You can use the following tables -
fin_plans
fin_financials
fin_cost_plan_details

Regards
NJ

[Anon Anon]

I am looking for Baseline Monthly Cost for Costplan/Budget plan.
I have used these tables
PRJ_BLB_SLICES
PRJ_BLB_SLICEREQUESTS
PRJ_BASELINE_DETAILS
PRJ_BASELINES

which timeslice curve i have to used for finding out details?

[Anon Anon]

Hi Tidi,

Please use the PMA_FINANCIAL_VALUES table which is stored the cost information (Cost Plan & Budget Plan) based on monthly and also cost information are stoed in ODF_SSL_CST_DTL_COST. Please use the below query, to fetch the information about cost plan / budget plan cost details.
if you have any query, please let me know.

SELECT PMA.* FROM PMA_FINANCIAL_VALUES PMA, INV_INVESTMENTS INV where INV.CODE = '090000008' and INV.ODF_OBJECT_CODE = 'project' AND PMA.OBJECT_ID = INV.ID AND PMA.FINANCIAL_TYPE IN ('PLAN_CST')

SELECT PMA.* FROM PMA_FINANCIAL_VALUES PMA, INV_INVESTMENTS INV where INV.CODE = '090000008' and INV.ODF_OBJECT_CODE = 'project' AND PMA.OBJECT_ID = INV.ID AND PMA.FINANCIAL_TYPE IN ('BDGT_CST')


Select * from ODF_SSL_CST_DTL_COST

Thanks
Senthil.

[Anon Anon]

Hi Tidi,I'm now looking for the same thing. Are you able to share what you've found? When I've checked the PMA financial tables, they don't appear to differentiate baseline amounts from forecasted, nor from budgeted amounts.

[Deactivated User]

I don't think do. Baselines and financial plans have each a life of their own.

See also

https://communities.ca.com/web/ca-clarity-global-user-community/message-board/-/message_boards/message/105635437?p_p_auth=prisut0Y&#p_19

 

Martti K.

[Anon Anon]

Ok, I guess what I was basing my hope on was this snippet in the v13 Tech Ref Guide, under the table 'PRJ_BASELINE_DETAILS' saying that the prextension column is a blob for effort and cost. This column appears on my development v13.1.0 environment, and I was hoping that I could find the sliced version of the cost item, at the 'project' level (not task, assignments) - any pointers greatly appreciated

PREXTENSION

The curves for the baselined effort and the cost of the object.

[Deactivated User]

Don't throw you hopes away yet.

If you accept the baseline cost you can use the user defined timeslices and add what need (in case you find it in the list)

There is another group for non-current baselines. This is from v13.2

Martti K.

[Anon Anon]

great pointer! I have also found those items in my 13.1 environment, plus the noncurrent ones too. I'll experiment with a number of the various 'baseline' options, and see how I go. First attempt will be with the 'current baseline project cost' item, and i'll post back... 

[Anon Anon]

i can't seem to reconcile the numbers in the slices vs those in the front end.... are you aware if the baseline slices include all types of costs, labour, expense etcera? it appears to me that so far, it only shows labour related baseline costs...

[Deactivated User]

Don't know. Open a case with support.

 

Martti K.