Timesheet Custom Fields

[David F-H]

Project Server 2007 (SP1 + Aug Cum hotfixes) & SQL Server 2005

I have added some assignment level custom fields to the Timesheet, which a
user can update when editing their "My Timesheet" view. I assume that the
information is stored in the Published database, but I can't find it anywhere
in the Reporting database - I've looked through the tables and views, and
although I can see how the project related custom fields are stored, I can't
seem to find the timesheet custom fields. I am thinking that custom fields
stored with the timesheet are not propogated to the Reporting database ?

Can someone please clarify this?

 

[Gary L. Chefetz]

David:

Task level custom enterprise fields do not carry a distinct value at the
assignment level. Therefore, the data stored at the task level is "rolled
down" to the assignment level. Just so you don't run into value conflicts,
understand that if you have more than one resource assigned to a task, that
the last person to update the custom field determines the value.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[David F-H]

Hello Gary,
I'm not sure that I understand you - my experience is that task level custom
fields do carry a distinct value at the assignment level. I have created
some task level custom fields and have assigned different values to them at
the assignment level (where multiple resources are assigned to a task), and
they are held as distinct values. I have also set the option "Roll down,
unless manually specified" when creating the custom fields. When you assign
a custom value at the task level, it will roll down to the assignment level
unless there has already been a value entered at the assignment level.
Similarly, you can change the custom value at the assignment level after it
has been rolled down from the task level.

Custom fields names are stored in the attributename column in the
MSP_EpmMetaDataAttribute table (in the Reporting db), and there are special
names generated for assignment level custom fields that are the same as the
task custom field names with "_T" appended to the names. So for example, I
have created a custom field called "tskActivity", and this also creates a
"tskActivity_T" custom field behind the scenes.

Now I believe that this is all stored in relation to projects, BUT you can
add custom fields to the "My Timesheet" view and the user can enter values
for them, which can be different values to those stored in the project.
However, the values are obviously stored somewhere in the Published database
and are associated with the timesheet (rather than the project), as these
values are retained whenever you open the timesheet. So, my question is
where (if at all) these timesheet related custom field values are stored in
the Reporting database ?

 

[Gary L. Chefetz]

try: dbo.MSP_TIMESHEET_CUSTOM_FIELD_VALUES

You need to refrence these by timesheet and timesheet line.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[David F-H]

Thanks Gary,
I have already had a look at this table, but it resides in the published
database, which I find far more esoteric than the Reporting database. Also,
my understanding is that we should not base any code on the Published
database, as it is not supported for open access and thus not guaranteed
against changes in future upgrades.
I take it then that the timesheet custom values information just isn't
available in the Reporting database ?