How is Timephased Hours Worked Data stored in the Project Server database

[Wegz]

Hi.

I hope someone can help me. I want another system to get data out of
our project server database. It needs to be able to get data on a
resource and show the resource's total hours per day on a project.
(basically like the timesheet view in resource usage)

This will then allow us to assign flags to determine what actual days
have been paid for or accured for our finance system. Its so we can
keep track of the costs being billed to us for contractors etc.

Now the only work values i can find in the database are total values.
EG. PROJECT 130 TASK ID 22 ACTUAL WORK 10 HOURS.

Is there somewhere in the databases that shows the timephased values:
eg.PROJECT 130, TASK ID 22 RESOURCE 4 --> DATE 1 WORK 2 HOURS; DATE 2
WORK 1 HOUR; DATE 3 WORK 7 HOURS?

Thanks.

Matthew

 

[Rod Gill]

Hi,

If your projects are published, then the best tables to use are the MSP_VIEW
tables. They have time phased data for you in a usable layout. The project
database is hard to interpret accurately so if the VIEW tables are not good
enough I recommend using automation to read the data firstly from the opened
project.

Schema for Project Server tables is in PJSVR.htm in one of project's program
folders.

 

[Reid McTaggart]

You might look at Tools > Options > Save. See the checkbox to "Expand
timephased data in the database."

Expand timephased data in the database:
Specifies whether Project saves timephased data in a readable format in the
Project database. If you clear this check box, Project will write timephased
data to a database in binary format, which allows for faster reading and
writing of data. By default, this check box is cleared.