ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

PRAVAILSTART and PRAVAILFINISH in PRTEAM

book

Article ID: 226890

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM On Premise Clarity PPM SaaS 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.