Skip to main content
Planview Customer Success Center

How are the PlannedDay and PlannedFTE fields in the taskassignment table calculated?

These fields are calculated from the PlannedHours field, taking into account the number of working days and the daily conversion factor of the resource of the task assignment:

  • Planned Days = Planned Hours / daily conversion factor
  • Planned FTE = Planned Hours / number of working days / daily conversion factor

These calculations are done in real time by SQL Server itself and fully automatically. There are no jobs or triggers involved.