PRAVAILSTART and PRAVAILFINISH in PRTEAM

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

I am looking at the PRTEAM table.

There are allocations showing in UI but in database PRAVAILSTART and PRAVAILFINISH columns are showing blank for most of the records. 

How are those fields populated at Database table?

Resolution

By default, the PRAVAILSTART and PRAVAILFINISH columns at the PRTEAM table are calculated based on the Investment Start and Investment Finish Dates.

By default when you add a team member to a project is allocated from the Investment Start to Finish Date.

On the above scenario the PRAVAILSTART and PRAVAILFINISH columns at the PRTEAM table are blank.

When you change the team member allocation start or finish dates, then those update the PRAVAILSTART and PRAVAILFINISH columns at the PRTEAM table.