How to includes fields in the Enterprise Resource Pool.

[Micheal]

Hi,

I want to include new columns(fields) which regarding with the keeping of
users information in the Enterprise Resource Pool. which I want to show
you in the project web access views and in reports (which I made in sql
server reporting services)

How do I do this ?

Regards

Micheal

 

[Chak]

Hi Michaeal,

You need to define new columns on Enterprise global. I understood
that you want to include resource information, so do the following:

1) Add new fileds to Enterprise global:

a) Open the enterprise global

b) Tools -> Customize -> Enterprise Fileds

c) Choose the Resource option under Field

d) Choose required Type from dropdown

e) Rename the Field ( The column name you want to include for
resource info)

2) Add the new columns to Resource Sheet view using Enterprise Global

3) Modify the View in PWA to show the new columns.


Thanks
Chak

 

[Micheal]

Hi,

I want to know if enter the resource information in these fields at the time
when i add the resource in the enterprise resource pool.

in which table these resources information will be saved and how i can get
these information with the resource name through TSQL Queries in my sql
server reporting services reports.

regards
Micheal

 

[Chak]

Hi,

Here is the info:

1) Resource standard info like name, rate etc will find in
MSP_RESOURCES table:

Select RES_UID,RES_ID,RES_NAME from MSP_RESOURCES
where proj_id = 1 and Res_UID > 0

OR

Select * from MSP_RESOURCES


2) if you are using Enterprise Text Fields in resource pool, look for
MSP_TEXT_FIELDS

Select * From MSP_TEXT_FIELDS
Where PROJ_ID = 1

(TEXT_REF_UID is the RES_UID in MSP_RESOURCES table, join these two
fields to get the values.)

TEXT_FIELD_ID the uinique numeric value for Enterprise field, each
enterprise field will have unique numeric value.)

3) If you are uing any enterprise number field in resource pool, use
MSP_NUMBER_FIELDS

Similarly MSP_OUTLINE_CODES, MSP_DATE_FIELDS, MSP_FLAG_FIELDS

I hope this will be helful for you.

Regards
Chak

 

[Chak]

Hi,

Here is the info:

1) Resource standard info like name, rate etc will find in
MSP_RESOURCES table:

Select RES_UID,RES_ID,RES_NAME from MSP_RESOURCES
where proj_id = 1 and Res_UID > 0

OR

Select * from MSP_RESOURCES


2) if you are using Enterprise Text Fields in resource pool, look for
MSP_TEXT_FIELDS

Select * From MSP_TEXT_FIELDS
Where PROJ_ID = 1

(TEXT_REF_UID is the RES_UID in MSP_RESOURCES table, join these two
fields to get the values.)

TEXT_FIELD_ID the uinique numeric value for Enterprise field, each
enterprise field will have unique numeric value.)

3) If you are uing any enterprise number field in resource pool, use
MSP_NUMBER_FIELDS

Similarly MSP_OUTLINE_CODES, MSP_DATE_FIELDS, MSP_FLAG_FIELDS

I hope this will be helful for you.

Regards
Chak

 

[Chak]

Hi,

Here is the info:

1) Resource standard info like name, rate etc will find in
MSP_RESOURCES table:

Select RES_UID,RES_ID,RES_NAME from MSP_RESOURCES
where proj_id = 1 and Res_UID > 0

OR

Select * from MSP_RESOURCES


2) if you are using Enterprise Text Fields in resource pool, look for
MSP_TEXT_FIELDS

Select * From MSP_TEXT_FIELDS
Where PROJ_ID = 1

(TEXT_REF_UID is the RES_UID in MSP_RESOURCES table, join these two
fields to get the values.)

TEXT_FIELD_ID the uinique numeric value for Enterprise field, each
enterprise field will have unique numeric value.)

3) If you are uing any enterprise number field in resource pool, use
MSP_NUMBER_FIELDS

Similarly MSP_OUTLINE_CODES, MSP_DATE_FIELDS, MSP_FLAG_FIELDS

I hope this will be helful for you.

Regards
Chak

 

[Chak]

Hi,

I want to know if enter the resource information in these fields at the time
when i add the resource in the enterprise resource pool.

in which table these resources information will be saved and how i can get
these information with the resource name through TSQL Queries in my sql
server reporting services reports.

regards
Micheal

******************************************************
Hi,


Here is the info:


1) Resource standard info like name, rate etc will find in
MSP_RESOURCES table:


Select RES_UID,RES_ID,RES_NAME from MSP_RESOURCES
where proj_id = 1 and Res_UID > 0


OR


Select * from MSP_RESOURCES


2) if you are using Enterprise Text Fields in resource pool, look for
MSP_TEXT_FIELDS


Select * From MSP_TEXT_FIELDS
Where PROJ_ID = 1


(TEXT_REF_UID is the RES_UID in MSP_RESOURCES table, join these two
fields to get the values.)


TEXT_FIELD_ID the uinique numeric value for Enterprise field, each
enterprise field will have unique numeric value.)


3) If you are using any enterprise number fields in resource pool, use
MSP_NUMBER_FIELDS


Similarly MSP_OUTLINE_CODES, MSP_DATE_FIELDS, MSP_FLAG_FIELDS


I hope this will be helful for you.


Regards
Chak

 

[Chak]

Hi,

I want to know if enter the resource information in these fields at the time
when i add the resource in the enterprise resource pool.

in which table these resources information will be saved and how i can get
these information with the resource name through TSQL Queries in my sql
server reporting services reports.

regards
Micheal

**************************************
Hi,


Here is the info:


1) Resource standard info like name, rate etc will find in
MSP_RESOURCES table:


Select RES_UID,RES_ID,RES_NAME from MSP_RESOURCES
where proj_id = 1 and Res_UID > 0


OR


Select * from MSP_RESOURCES


2) if you are using Enterprise Text Fields in resource pool, look for
MSP_TEXT_FIELDS


Select * From MSP_TEXT_FIELDS
Where PROJ_ID = 1


(TEXT_REF_UID is the RES_UID in MSP_RESOURCES table, join these two
fields to get the values.)


TEXT_FIELD_ID the uinique numeric value for each Enterprise field,
TEXT_FIELD_VALUE is the resource info value.)


3) If you are using any enterprise number fielda in resource pool, use
MSP_NUMBER_FIELDS


Similarly MSP_OUTLINE_CODES, MSP_DATE_FIELDS, MSP_FLAG_FIELDS


Regards
Chak

 

[Chak]

Hi,


Here is the info:


1) Resource standard info like name, rate etc will find in
MSP_RESOURCES table:


Select RES_UID,RES_ID,RES_NAME from MSP_RESOURCES
where proj_id = 1 and Res_UID > 0


OR


Select * from MSP_RESOURCES


2) if you are using Enterprise Text Fields in resource pool, look for
MSP_TEXT_FIELDS


Select * From MSP_TEXT_FIELDS
Where PROJ_ID = 1


(TEXT_REF_UID is the RES_UID in MSP_RESOURCES table, join these two
fields to get the values.)


TEXT_FIELD_ID the uinique numeric value for Enterprise field, each
enterprise field will have unique numeric value. TEXT_FIELD_VALUE is
the resource info appearing in resource pool for enterprise text
column.)


3) If you are using any enterprise number fields in resource pool, use
MSP_NUMBER_FIELDS


Similarly MSP_OUTLINE_CODES, MSP_DATE_FIELDS, MSP_FLAG_FIELDS

Regards
Chak