Differentiate between accepted, rejectedand pending actual work

[Jacques]

I have developed a store procedure to extract the actual work captured per
person per project per day for a date range. I now need to differentiate
between whether the entiries have been accepted or rejected by the Project
Manager.
I can not find anything in the pjsvrdb.htm or pjdb.htm files that will allow
me to do this break up.

 

[Jacques]

Just to add more detail:
My MSP_WEB_WORK_APPROVAL table is empty.

 

[Ed Morrison]

Jacques,
If msp_Web_Assignments.WASSN_Actuals_Pending has a value of 2, the part or
all of the assignment was rejected by the project managaer. The
msp_web_work record with a value of 1 in WWork_Update_Status (a pending
record) is the time element that was specifically rejected.

If msp_web_work.wwork_update_status=0 and
msp_web_work.wwork_approval_status=1 then the time was accepted.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com