Get Approved Timesheets From Project

[Maruf]

Hi
I am writing a .NET standalone program. The normal Task
Assignment/Approval process is: <according to my requirement>
1. Create a Task in MSP, assign it to resource and Publish.
2. In web access, appropriate resource completed the task.
3. Administrator Approves the task and updates the Project.

I want to get all the approved tasks in all projects. I dont know how i
should do it.

1. Triggers on ProjectServer tables <what tables and what data should be
picked up?>
2. Query which fulfils the requirement. <What will be the query?>
3. Use PDS or write macros in MSP so that everytime something is approved,
it is logged in my custom database. <what will be the code?>

Any help would be appreciated.

Thanks,
Maruf

 

[Sean]

There are two ways to get the data.
1. Use PDS, AssignmentsGet. See detail in PDS reference for PS2003.
2. Use ADO.NET to connect databse and retrieve data directly. For all
proved timesheet data, it is stored in MSP_WEB_WORK or
MSP_VIEW_PROJ_ASSN_TP_BY_DAY.