Project and Portfolio Management Practitioners Forum
cancel

Tracking actual FTE/Hrs for the staffing profiles

Highlighted
Varun Singh
Respected Contributor.

Tracking actual FTE/Hrs for the staffing profiles

in 6.0 we used to have the planned and actuals FTE in the table.

the actuals in the staffing profile used to come from the automatic rollup from the attached project for which time is logged.

In 7.5, When we fill the timesheets, Is there any table from which we can get this data i,e actuals effort for staffing profile lines.


In itg_compressed_elements table, we get the actuals only when entered manually and we do not see any data which is being rolled up automatically from the timesheets.

There is another potential table called as "krsc_work_item_assgiments" table where old data is there after an upgrade showing actual and planned FTES. When we fill the new timesheets, the data does not get populated in this table.

We have following parameters set in the server.conf

com.kintana.core.server.WORK_ITEM_BREAKDOWN_SERVICE_DELAY 30
com.kintana.core.server.WORK_ITEM_BREAKDOWN_SERVICE_ENABLED true
com.kintana.core.server.WORK_ITEM_UPDATE_SERVICE_DELAY 120
com.kintana.core.server.WORK_ITEM_UPDATE_SERVICE_ENABLED true

Is there any other table from where we can get the actual FTE of the staffing profiles.

In the cost & Effort section of Project settings, we have enabled the option of "Use actual information from the work plan and Time Management when viewing actuals in the staffing profile".

Arguing with a fool, proves there are two
2 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Tracking actual FTE/Hrs for the staffing profiles

KRSC_STAFF_PROF_PERIOD_SUM?
Nisha Kurien
Honored Contributor.

Re: Tracking actual FTE/Hrs for the staffing profiles

Check in the table RSC_STAFF_PROFILE_ACTUAL

- Nisha Kurien