Where is the 'proposal description' in PS2007

[scubaal]

In PS2007 it is possible to create a 'proposal'. During the process
you are asked for a proposal description. This is an ideal place to
put a short description suitable for execs, which is exactly what we
want to use it for. We want to report on it......but have no idea
where it sits in the database?
Where is it held for a proposal and where does it go when the proposal
becomes a project?
Al.

 

[scubaal]

Great when you solve your own problem:

It seems the files are in the PROJECTS table in each database -
prefixed with a 'W':

select WPROJ_DESCRIPTION,PROJ_NAME from MSP_PROJECTS

shows the information. When the proposal is converted to a project the
information remains - you just cant see it!

So to make is useable for reporting create a couple of views in the
Project_reporting database:

CREATE VIEW [dbo].[MSP_PROJECTS_WORKING_VIEW] AS
SELECT * FROM [ProjectServer_Draft].dbo.MSP_PROJECTS
CREATE VIEW [dbo].[MSP_PROJECTS_PUBLISHED_VIEW]
AS SELECT * FROM [ProjectServer_Published].dbo.MSP_PROJECTS

Once that has been done you can use the WPROJ_DESCRIPTION in reports
by creating a join on the PROJ_UID column.