N
Nosh
I need to know the names of those who accept the timesheet entries of all the team members of any projects in project server. There is a table named MSP_WEB_WORK_APPROVAL in the database but strangly no changes are reflected there at all. In the Project Server database description page called 'PJSVRDB.HTML' the description for the required columns is as follows:
WAPPROVAL_STATUS tinyint Indicates whether the work entry was approved or rejected.
0 Pending
1 Approved
2 Rejected
But to my surprise every entry indicates 0.
Secondly in the column named WRES_ID_APPROVER every entry indicates -1 which should indicate the WRES_ID for the specified resource.
If there is any other way to find out the names of the approvers of project owners who have not approved their entry please let me know.
Thankyou
WAPPROVAL_STATUS tinyint Indicates whether the work entry was approved or rejected.
0 Pending
1 Approved
2 Rejected
But to my surprise every entry indicates 0.
Secondly in the column named WRES_ID_APPROVER every entry indicates -1 which should indicate the WRES_ID for the specified resource.
If there is any other way to find out the names of the approvers of project owners who have not approved their entry please let me know.
Thankyou