approved timesheet hours

[Rose]

Does anyone know via SQL how to determine if timesheet hours
were approved by project manager. I tried using the
work_approval_status column in msp_web_work table and found that
relates to task assignment approval or rejection, and not the
approval of hours that were
posted to an assignment. Any help would be appreciated.

I also looked at the api and it appears the timesheets api assignmentsget
method is returning
the same, all hours that belong to either an approved or rejected task
assignment, rather than approved or rejected hours by a project manager for a
particular assignment.

 

[Ed Morrison]

Try MSP_WEB_WORK_APPROVAL. This table stores all timesheet approvals for
Project Server uses, including who approved the timesheet entry, the
assignment, start and finish dates, and approval status.