How to find the administrative time spent by a resource

D

Dave

Hello All,

I am trying to generate a report on the time spent by a resource on a
project and the total non-working time spent by a resource. I was able to
get the details on the time spent by a resource on a project, but what I was
not able to get the administrative time spent by a resource.

I am generating a SQL Reporting Services 2005 report. I would greatly
appreciate it if someone could let me know where the administrative time is
stored in the reporting database.

Thanks
Dave
 
R

Rod Gill

All timesheet data is in the timesheet tables. See the schema in the Project
SDK downloadable from Microsoft for free

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
D

Dave

Thanks for that Rod, but the administrative time does not seem to be
available in the reporting database. The MSP_TimesheetActual table seems to
be the only table that has actual time and it only has the following
information.
ActualWorkBillable
ActualWorkNonBillable
ActualOvertimeWorkBillable
ActualOvertimeWorkNonBillable
PlannedWork
It does not contain any information about the time spent on administrative
tasks. Although the time spent on all the other elements is listed, it does
not mention non-working time.

Am I missing something here?

Regards,
Dave
 
R

Rod Gill

Yep,

ActualWorkBillable for the Administrative project is what you want.
TimesheetTask says which admin task. I know they are there as I have done
timesheet reports for two clients recently using these tables.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
D

Dave

Thanks for that Rod. I was just wondering what the other hours fields are
for? they all seem to be blank.

Regards,
Dave
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Reporting Administrative Time 1
Project Pro - Reports (Resource work) 0
Admin Time Off handling 0
Resource Manager would like to Assign Resource to non-project time 3
Project Server 2007 Multiple resource rate 3

Top