Administrative Time Explained

re: Administrative Time Explained

ivovh — Wed, 18 Feb 2009 18:35:59 GMT

Thanks David. Would you know how time recorded in the admin time categories can be reported on through cubes or by querying the reproting DB through an SSRS report? For example, we might be interested in knowing how many sick days have been taken over a period of time?

re: Administrative Time Explained

Billy — Wed, 04 Mar 2009 23:41:20 GMT

Eureka. That makes sense - thanks for the blog

re: Administrative Time Explained

David Ducolon — Thu, 05 Mar 2009 02:28:33 GMT

You must query the RDB and here is the query that I suggest you start with.

Dave

-- Query to report on "Working" Admin time

-- Notes

-- 1. Line Class UID has three types:

-- 0 - Standard Line classification

-- 1 - Non working admin time (generates a calendar exception and decrements resource capacity in msp_epmresourcebyday)

-- 2 - Working admin time (generates a pseudo-assignment to tell the PM that the resource is doing this)

-- 2. The line classes are localized, so sites with language packs installed should use the LCID to get the right string

-- 3. The query uses the resource name dimension (so if a resource's name has changed you'll get records for each name)

-- to use the current name join through to msp_epmresource using the ResourceUID property

-- 4. The values are summed because of the journalling structure of the schema (changes come in as adjustments)

-- pmc 02/20-09

SELECT TSR.ResourceName, TSA.TimeByDay, TSC.ClassName, SUM(TSA.PlannedWork) AS N'Planned', SUM(TSA.ActualWorkBillable) AS N'Actual'

FROM dbo.MSP_TimesheetActual AS TSA -- Stores planned & actual work per day

INNER JOIN dbo.MSP_TimesheetLine AS TSL

ON TSA.TimesheetLineUID = TSL.TimesheetLineUID -- Tells us what line type the actual belongs to

INNER JOIN dbo.MSP_TimesheetClass AS TSC

ON TSL.ClassUID = TSC.ClassUID -- Tells us all the line types

INNER JOIN dbo.MSP_Timesheet AS TS

ON TS.TimesheetUID = TSL.TimesheetUID -- Tells us who's timesheet the line belongs to

INNER JOIN dbo.MSP_TimesheetResource AS TSR

ON TS.OwnerResourceNameUID = TSR.ResourceNameUID -- tells us the TS resource name when the TS was submitted

WHERE TSC.LCID = 1033 -- EN-US

AND TSC.Type = 2 -- "working" Admin time, generates a dummy assignment

GROUP BY TSR.ResourceName, TSA.TimeByDay,TSC.ClassName -- Group to aggregate out journalling

The ClassUID is the same thing as Admin Categories. these are stored in the same table and come across to the RDB in the same field.

re: Administrative Time Explained

Nita — Thu, 19 Mar 2009 12:26:52 GMT

Hi David,

Where we can find actual work per resources per day. In what table. Could you advise. Thanks before.

Vacation calendar viewable by organization

Calvin Schimmel — Wed, 25 Mar 2009 21:12:25 GMT

My client has a vacation calendar that contains all the vacation time for individuals in the organization. I want to transition this to Project Server which works well for having staff request their vacation days by entering and allowing workflow to route to their supervisor. My question is: How do I make this vacation calendar viewable by all staff so that if you want to see when an individual is scheduled for vacation or who is on vacation for a specific day you can see that?

Thanks

re: Administrative Time Explained

Bob — Sun, 05 Apr 2009 14:40:51 GMT

Hi David,

I have an issue with Admin time and was wondering if you could give me your view?

Project Server was set up with timesheets and users were suppose to report updates on a daily basis. After a while we realised that this wasn't fitting our business and so decided to switch to weekly updates. I changed the Server Settings of Timesheets to have weekly updates. This worked fine for task updates. However once I made this change the admin time fields seem to lock and I couldn't diretly enter admin time into the grid. I have to add admin time by the planning dialogue.

Is this standard functionality? As soon as I switch back to daily (i.e. a 7 day grid) I can add admin time directly into the grid again.

All information in books and online seem to be related to having updates daily, no once has documented a weekly timesheet.

Cheers

Bob

re: Administrative Time Explained

Angeldb — Tue, 07 Apr 2009 01:56:23 GMT

Unfortunately, my company had the need to publish certain Administrative tasks to certain individuals. For instance, we wanted to restrict which of our Engineers could charge 'Quote Development' instead of making it viewable to everyone.

We also needed those tasks be able to carry Enterprise Custom Fields for use in reporting our time back to our ERP system. Administrative Time in 2007 does not give you this capability.

I see that you did streamline the Administrative Time in 2007, but I much prefer the flexibility offered with 2003. It was easy to discern Administrative projects from Billable ones. Perhaps it could have been built as an option rather than stripped from the new version.

Oh well.

-Angel

re: Administrative Time Explained

Marcello — Wed, 20 May 2009 17:32:01 GMT

Is there a way to create an overview (preferably in the Resource Assignments view) of the Administrative time.

I need to have a complete overview of working and non-working hours.

Thanks in advance.

re: Administrative Time Explained

Brett — Wed, 03 Jun 2009 05:30:43 GMT

Sir,

Before you add any more features, PLEASE go get the basic functionality working. One of my biggest gripes with Project is that task names disappear between save/open cycles. When a task group is collapsed, sometimes the next time I open the file and un-collapse (ie expand) the tasks, THEY ARE BLANK. All the dates and resources, etc.. are there, but the NAMES ARE ALL BLANK. So, I have to go to an old version, and copy back all the names, checking one by one that I account for row deletions, additions. Over and over..

GET THE BASIC FUNCTIONALITY WORKING.

No one uses Project because they love it, we use it because we must at work; hence the extraordinary frustration you read about every day..

This example was only one of many basic functionality items that does not work reliably.

re: Administrative Time Explained

Ray — Thu, 16 Jul 2009 14:37:43 GMT

Is there a way to have a specific category always display for individual users timesheets instead of all users timesheets?

re: Administrative Time Explained

Sheila Schmedes — Mon, 27 Jul 2009 18:57:23 GMT

We are testing Planned Admin Time and when type a description when requesting the time, the description comes up blank when the manager views the request for approval. When the requestor goes back in, the description is still there....just the manager can't see it. We want to use this as a communication that the requestor has gotten required approval. Any suggestions?

thanks

re: Administrative Time Explained

Subramanya Sithamraju — Fri, 31 Jul 2009 06:52:16 GMT

re: Administrative Time Explained

Wim — Tue, 22 Sep 2009 12:55:20 GMT

Hi,

We are using Project Server 2007.

After creating the relevant timesheets and some administrative categories, I entereded in one of my timesheets for one of the days "8h" at "Vacancy", which is defined as Status = open, Work Type = Non Work, Approve = Yes and Always Display selected.

At first, I clicked on "Save" and as a result, the green bullit at Vacancy turned to yellow (right).

Then, I clicked on "Save and Submit" and as a result the message in red appears: "The submitted timesheet contains lines which either are pending approval or have been rejected. You must either delete these lines from your timesheet or obtain approvals and resubmit." (right).

When I turned to the user which is the Timesheet manager for this resource, I saw the approval request for "Vacancy" with "0h". I originally requested 8h vacancy. Why has this value turned to zero instead of 8 hours?

When the Timesheet manager approves the vacancy request, my timesheet shows the correct 8h Vacancy with the green status.

Does anyone know why the approval request showed 0 hours instead of 8 hours?

Many thanks in advance!