Extracting Timecard / Hours Worked

G

Gene Dudley

I've just been tasked with implementing Project Server and need some help.
One of the main objectives of the implementation is to use PWA for entering
actual hours worked each week, and then using that information to drive a
legacy payroll system to pay employees based on the hours they worked. I
see the interface between Project Server and the legacy payroll system as a
high-risk area so I've spent the past 2 days pouring through docs trying to
get a handle on how PWA stores and updates actual hours worked. To date I
have not come across much documentation regarding what tables in the Project
Server DB are involved in recording time updates. I've found the docs on
the CD that detail each table but that really doesn't give me what I need as
it is at too low a level. I've also reversed engineered the DB, but with
over 200 tables it will take me quite a bit of time to figure out what
tables are involved in the timecard process.

My questions - (1) is there any decent documentation on the tables involved
in updating time worked on tasks and (2) is their an existing ER model for
Project Server or do I have to work with my reversed engineered?

Thanks in advance for any help!

Gene Dudley
 
L

Lon

The only book I've found, though I haven't looked in the
last couple of months, is Project Server 2002 by Qimao
Zhang. I would not rate it as an especially good resource
but it may be the only game in town. It does go into some
detail on tables, columns and what is stored there. As
for where to get your payroll information, MSP_WEB_WORK is
the table to start with. Be aware that it has some quirks
in terms of how the data is stored. For instance if the
same amount of time is entered against the same task on
consecutive days, it will be stored as a single record.
See the post just previous to yours regarding "Extracting
time from MSP_WEB_WORK for some insight. If you look,
also at MSP_WEB_RESOURCES, MSP_WEB_ASSIGNMENTS and
MSP_WEB_PROJECTS you'll begin to get a better picture and
the joins will be pretty obvious. Hope this helps.
 
G

Gene Dudley

Thanks Lon, you were right, the joins were fairly obvious once I got into
it.

Gene
 
Top