Which Database table is it in?

[Rich C]

Hi Everyone

MSP2003
Project Server 2003

I am trying to run an automated report using tables from the project
database. Specifically, I am trying to extract Enterprise Outline Task Code
information but am unsure where the data is stored.

Example: this morning I created a new Enterprise Outline Task Code (Code 6)
in the Global file, populated the look-up table with some values, and then
saved the global file. Then I created a new project plan and assigned one of
the values from the new code to some of the tasks. I then published the plan.
I reopened the plan to check that the outline code values had been saved,
which they had.

The OLAP cube hasn't run yet so the MSP_CUBE_ENTERPRISE_TASK_OUTLINE_6 table
has no data in it. So in summary, where is the task outline code value stored
when the project plan is published?

Thanks

 

[Chak]

Hi Everyone

MSP2003
Project Server 2003

I am trying to run an automated report using tables from the project
database. Specifically, I am trying to extract Enterprise Outline Task Code
information but am unsure where the data is stored.

Example: this morning I created a new Enterprise Outline Task Code (Code 6)
in the Global file, populated the look-up table with some values, and then
saved the global file. Then I created a new project plan and assigned one of
the values from the new code to some of the tasks. I then published the plan.
I reopened the plan to check that the outline code values had been saved,
which they had.

The OLAP cube hasn't run yet so the MSP_CUBE_ENTERPRISE_TASK_OUTLINE_6 table
has no data in it. So in summary, where is the task outline code value stored
when the project plan is published?

Thanks

Rich,

188744594 Task Enterprise Project Outline Code6

In Project Server 2003, Outline codes are stored in table called
MSP_OUTLINE_CODES
By running SQL query, you can see the values that you defined in
enterprise global.

Example:

SELECT PROJ_ID, CODE_UID, OC_FIELD_ID, OC_NAME AS
EntTaskOutlineValue
FROM MSP_OUTLINE_CODES
WHERE (OC_FIELD_ID = 188744594 )

Please note that every enterprise custom filed will have own id
number. Please refer PDS for id numbers.
I looked it for you, for Task Enterprise Project Outline Code6, filed
id is 188744594


Thanks
Chak

 

[Chak]

Hi Everyone

MSP2003
Project Server 2003

I am trying to run an automated report using tables from the project
database. Specifically, I am trying to extract Enterprise Outline Task Code
information but am unsure where the data is stored.

Example: this morning I created a new Enterprise Outline Task Code (Code 6)
in the Global file, populated the look-up table with some values, and then
saved the global file. Then I created a new project plan and assigned one of
the values from the new code to some of the tasks. I then published the plan.
I reopened the plan to check that the outline code values had been saved,
which they had.

The OLAP cube hasn't run yet so the MSP_CUBE_ENTERPRISE_TASK_OUTLINE_6 table
has no data in it. So in summary, where is the task outline code value stored
when the project plan is published?

Thanks

Rich,


In Project Server 2003, Outline codes are stored in table called
MSP_OUTLINE_CODES
By running SQL query, you can see the values that you defined in
enterprise global.


Example:


SELECT PROJ_ID, CODE_UID, OC_FIELD_ID, OC_NAME AS
EntTaskOutlineValue
FROM MSP_OUTLINE_CODES
WHERE (OC_FIELD_ID = 188744594 )


Please note that every enterprise custom filed will have own id
number. Please refer PDS for id numbers.
I looked it for you, for Task Enterprise Project Outline Code6, feild
id is 188744594


Thanks
Chak