? re: dbo.MSP_EpmProject_UserView

[anovak]

In this view, what is the difference between these two columns:

ProjectRegularWork
ProjectBudgetWork

I assume "Regular" has something to do with overtime work.

Which column is equivalent to the "Work" column we see in PWA, etc.?

Also, can you safely create a view from a view? I have an example of
a report written in VBA that uses a base table in the reporting
database to create a view prior to invoking subroutines that produce
the report (in Excel). However, all of the project-level custom
fields are located in the MSP_EpmProject_UserView (which I need to
reference).

Thanks,
Andy Novak
UNT

 

[Jonathan Sofer [MVP]]

If you look at the schema for the reporting database, it reads

ProjectRegularWork - Total non-overtime time scheduled for a project.
ProjectBudgetWork - Budget work and material resources for a project.

ProjectRegularWork is the field you want to use to pull the "Work" data in
PWA.

You can create a view from a view. There is no issue with doing this.
There might be some performance consideration however, ask your DBAs for
advice on that. In most cases, I don't see this as being an issue though.

Jonathan

 

[Frank Cowell]

Where can I find the schema definitions?

Thanks,

Frank

 

[Dale Howard [MVP]]

Frank --

Navigate to the Microsoft Download Center at the following URL:

http://www.microsoft.com/downloads/...FamilyID=2672f6f9-7028-4b30-99a2-18cb1eed1abe

Hope this helps.

 

[Frank Cowell]

Thanks Dale, much appreciated!

Frank --

Navigate to the Microsoft Download Center at the following URL:

http://www.microsoft.com/downloads/...FamilyID=2672f6f9-7028-4b30-99a2-18cb1eed1abe

Hope this helps.