Hi,

In this post I will show you Department Custom fields, and Department Lookup table in MS PROJECT SERVER 2010!

This is a brand new “feature” in MS PROJECT SERVER 2010. Main purpose of this fields is to be a filter for custom fields. In previous version every custom field was visible to every user. So, if they were set like “required” no matter if user needed it or not, he or she was required to put or choose value!

There are two types of Department custom fields: Project and Resources.

Project type is tightly connected to Project Type, the next new powerful feature in MS PROJECT SERVER 2010! I will explain that in one of my upcoming posts.

The Resource type is tightly connected with Resources (or Users).

So, let us suppose that we have three custom fields:

• Profit Center – Required field
• Shoe number (I am trying to be funny) – Not Required field
• T-shirt number – Required field

Now suppose that Profit center is connected with Finance department, and other two fields are not connected with any department. We have John, Resource connected with Finance department, and Mary, Resource without any assigned department.

John will see all custom fields (Profit Center, Shoe number, and T-shirt number), and he will have to put value in Profit Center and T-shirt Number field!

Mary will see only Shoe number, and T-shirt number, and will have to put some value in T-shirt Number field!

OK! Where are those custom fields?

Here:

and:

Let’s take a look at Resource Departments custom field:

As you can see this field is non required.

Now it is the time to put some values in Department lookup table!

Now, I will assign MS PROJECT SERVER consulting to myself:

and:

and finally:

Notice that I have access to Profit Center Custom field! But not for a long! No I will change Department for this, Profit Center custom field, to Accounting!

and then:

Now, back to user Nenad Trajkovski:

The Profit Center custom field is not longer visible to me!

Regards!