Status Manager Field

[lountk]

We are trying to pull data from the Project Reporting content database
(project server 2007) and I can't seem to find where the status manager field
is. Can someone help me locate it? If I look at a project plan using
Project Server 2007, there is a field called "staus manager". The name
listed is the name of the person that "approves" the time submitted from the
resource(s) that is assigned to the task. I can't find this field in any of
the database views/tables. I'm thinking it may be a "calculated" field but I
can't seem to figure out the logic. Can you help? thanks

 

[Jonathan Sofer [MVP]]

Louise,

I don't think "Status Manager" exists in the reporting database. The only
reference to "Status Manager" in the RDB schema (from the Project Server
2007 SDK) is under "dbo.MSP_EpmProject_UserView" in the comments section of
field "ProjectOwnerName" where it states "Name of the project owner, who is
the project manager. The project manager can be different from project
status manager, who manage task updates and assignments."

I think you can only pull this data from the Published DB which is not
supported or recommended by Microsoft. Here is a query I put together that
I believe pulls this data but I give no guarantees to the accuracy of this
data. For some reason it seems to store this data against the assignment
even though you can only set the "Status Manager" value against an entire
task in Project Professional.

SELECT TOP (100) PERCENT
dbo.MSP_PROJECTS.PROJ_NAME,
dbo.MSP_TASKS.TASK_ID,
dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_RESOURCES.RES_NAME AS [Assigned To],
MSP_RESOURCES_1.RES_NAME AS [Status Manager]
FROM dbo.MSP_ASSIGNMENTS INNER JOIN
dbo.MSP_PROJECTS ON dbo.MSP_ASSIGNMENTS.PROJ_UID = dbo.MSP_PROJECTS.PROJ_UID
INNER JOIN dbo.MSP_RESOURCES ON dbo.MSP_ASSIGNMENTS.RES_UID =
dbo.MSP_RESOURCES.RES_UID
INNER JOIN dbo.MSP_RESOURCES AS MSP_RESOURCES_1 ON
dbo.MSP_ASSIGNMENTS.WRES_UID_MANAGER = MSP_RESOURCES_1.RES_UID
INNER JOIN dbo.MSP_TASKS ON dbo.MSP_ASSIGNMENTS.TASK_UID =
bo.MSP_TASKS.TASK_UID
ORDER BY dbo.MSP_PROJECTS.PROJ_NAME, dbo.MSP_TASKS.TASK_ID, [Assigned To]

Hope this helps,