Hello!
How i get the sql queries - status of users timesheet submissions in
Microsoft Office Project Server 2007. Timesheet status can be in
progress (submitted but not yet approved), approved, or not created.
The report, organized by timesheet period, includes all resources who
submit timesheets to the manager for approval. The report query
selects all open timesheet periods.