Tracking edits to online timesheets

M

Moses Bunting

We are trying to use the Project Web Access timesheets as our official
company timesheets. In doing so, we need to have an audit trail of all edits
to the timesheet data, not just the final submission. For example, if
someone enters 8 hrs for a task, then later changes it to 10 hrs, we need to
see two log entries, one for the original insertion and one for the update.
We have identified the MSP_WEB_WORK table as the source for this information,
and plan to use SQL Server triggers to record the log entries.

The problem is we can't figure out how to identify which "Project User" is
making the changes. The available SQL Server user references always point
back to the generic login Project Server uses to access the db. And since
someone's manager or project manager can influence changes to the
MSP_WEB_WORK table, through approvals or adjustments, we can't always assume
that the user equals the resource.

Any ideas? Thank you.
 
G

Gary L. Chefetz \(MVP\)

Moses:

Might I suggest that you look hard at some of the add-on timesheet modules
that ISVs are offering for Project Server. In it's current incarnation, the
timesheeting system in Project Server is very good at progressing project
plans, but not very suitable for driving payroll, which demands a much
higher level of auditability than Project Server is currently designed for.
It's also unable to cogently capture code-level charging in and unable to do
expense tracking. The price points I've seen are not bad and most of them
come with a wealth of built-in audit and management reporting. Consider not
reinventing the wheel. Plus, it's risky in the post-SOX world.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Custom PWA Field in My Timesheet Cannot Be Queried 1
Timesheet approval routes 0
Update approved timesheet in Project Server 2007? 4
Deputy for timesheet approver 0
Timesheet / Task Approval 0
Serious Performance Issue on EPM Timesheet implementation 6
Major Issue with April CU - Timesheet Deployment 9

Top