Duration field data issue in Sql tables in Project server 2013.

Copper Contributor

Hi All,


I want to add duration column to the my SSRS report, But the data was showing wrongly in the sql  server pwa table.


when i open project from ms project the duration was showing as 109.88 days but in the MSP_EpmProject_UserView or any other project tables the project duration was showing as 1359.5.


Can any one please help me which table and column name i need to take for the duration.

my environment is project server 2013 with latest August 2020 CU.







0 Replies