RS_ADDROLE_TMP

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_ROLE Character(5) VARCHAR2(5) NOT NULL SetID Role is used in the resource profile to allow select a valid project role.
Prompt Table: SP_SETID_NONVW

2 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
Prompt Table: RS_PROJROLE_VW

3 CAPACITY Signed Number(14,2) DECIMAL(12,2) NOT NULL SCP- Forecasted Supply stored as capacity.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_ROLE	Character(5)	VARCHAR2(5) NOT NULL	SetID Role is used in the resource profile to allow select a valid project role. Prompt Table: SP_SETID_NONVW
2	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: RS_PROJROLE_VW
3	CAPACITY	Signed Number(14,2)	DECIMAL(12,2) NOT NULL	SCP- Forecasted Supply stored as capacity.