Enterprise Custom Fields stored in Database?

[Shane]

Hello Guys,

Looking for a quick answer to a straight forward question here.

Using Project Server 2007, when an enterprise custom field is created, what
database table strores this information?

Thanks in advance
Shane

 

[Barbara - Austria]

Hi Shane,

you will find these fields in views in Reporting DBs ending with _UserView.
They are added automatically at the end of these views. Exception: Values for
multi-value custom fields are not pulled into these views. You will need to
get them in a different way. If you need that, let me know.

Regards
Barbara

 

[Eric_H]

I could use the information about fields with multiple selection... That
would be a HUGE help...
Thanks,
Eric

 

[Barbara - Austria]

Hi Eric_H,

I have created a look up table LookUpTable4MultiValue, a field on task
level Field4Multivalue. This creates views in Reporting DB:
MSPCFTASK_Field4Multivalue and MSPLT_LookUpTable4MultiValue.
Example:
SELECT dbo.MSP_EpmProject_UserView.ProjectName,
dbo.MSP_EpmTask_UserView.TaskName,
dbo.MSPLT_LookUpTable4MultiValue_UserView.MemberValue,
dbo.MSPLT_LookUpTable4MultiValue_UserView.MemberDescription
FROM dbo.MSP_EpmProject_UserView INNER JOIN
dbo.MSP_EpmTask_UserView ON
dbo.MSP_EpmProject_UserView.ProjectUID = dbo.MSP_EpmTask_UserView.ProjectUID
INNER JOIN
dbo.MSPCFTASK_Field4MultiValue_AssociationView ON
dbo.MSP_EpmTask_UserView.TaskUID =
dbo.MSPCFTASK_Field4MultiValue_AssociationView.EntityUID INNER JOIN
dbo.MSPLT_LookUpTable4MultiValue_UserView ON

dbo.MSPCFTASK_Field4MultiValue_AssociationView.LookupMemberUID =
dbo.MSPLT_LookUpTable4MultiValue_UserView.LookupMemberUID

Does it help?

Regards
Barbara

 

[Eric_H]

We'll give it a shot... THANKS!

Hi Eric_H,

I have created a look up table LookUpTable4MultiValue, a field on task
level Field4Multivalue. This creates views in Reporting DB:
MSPCFTASK_Field4Multivalue and MSPLT_LookUpTable4MultiValue.
Example:
SELECT dbo.MSP_EpmProject_UserView.ProjectName,
dbo.MSP_EpmTask_UserView.TaskName,
dbo.MSPLT_LookUpTable4MultiValue_UserView.MemberValue,
dbo.MSPLT_LookUpTable4MultiValue_UserView.MemberDescription
FROM dbo.MSP_EpmProject_UserView INNER JOIN
dbo.MSP_EpmTask_UserView ON
dbo.MSP_EpmProject_UserView.ProjectUID = dbo.MSP_EpmTask_UserView.ProjectUID
INNER JOIN
dbo.MSPCFTASK_Field4MultiValue_AssociationView ON
dbo.MSP_EpmTask_UserView.TaskUID =
dbo.MSPCFTASK_Field4MultiValue_AssociationView.EntityUID INNER JOIN
dbo.MSPLT_LookUpTable4MultiValue_UserView ON

dbo.MSPCFTASK_Field4MultiValue_AssociationView.LookupMemberUID =
dbo.MSPLT_LookUpTable4MultiValue_UserView.LookupMemberUID

Does it help?

Regards
Barbara

 

[Eric_H]

Barbara,
thanks that is a great start, could you hook me up with more details on how
you created the view itself???

 

[Barbara - Austria]

Hi Eric_H,

I am not sure if I understand your question correctly?

Whenever you create a lookup table (e.g. xxx), the corresponding view
dbo.MSPLT_xxx_UserView will be created automatically in Reporting DB.

Whenever you create a multivalue field yyy on Task level, the
correspondig view dbo.MSPCFTASK_yyy_AssociationView will also be there.
(There will also be a MSPCFASSN_yyy_AssociationView to get your value on
assignment level). There are two columns: EntityUID can be linked with
TaskUID, LookupMemberUID can be linked to MSPLT_xxx_UserView.

Does that answer your question?
Regards
Barbara

Am 18.02.2010 16:50, schrieb Eric_H: