Skip to main content
Planview Customer Success Center

In which table can the Primary Function and the Effective date on the Resource Setup page be found?

The Primary Function and the Effective date on the Resource Setup are stored in the table ManagerChanges (columns EffectiveDate and PrimaryFunctionId).
The primary function is also added in the table ResourceFunction.

Please note that you have an history in the table ManagerChanges, so to have the last items you need to use and “order by CreatedOn desc” statement.