PC_WIZ_PSLOPRVW (SQL View)	Index Back
Projects List wtih User Secrty This view brings up the projects in which the current user is a team member and his security profile has access to update it.

PC_WIZ_PSLOPRVW

(SQL View)

Projects List wtih User Secrty

This view brings up the projects in which the current user is a team member and his security profile has access to update it.

SELECT SPRO.OPRID , SPRO.BUSINESS_UNIT , SPRO.PROJECT_ID FROM PS_SEC_PROJLST_OPR SPRO , PS_PROJ_ROLE_SECVW PROL , PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = SPRO.BUSINESS_UNIT AND SCR.RECNAME = 'PROJ_ROLE' AND PROL.SETID = SCR.SETID AND PROL.PROJ_ROLE = SPRO.PROJ_ROLE AND PROL.PROJ_ACCESS_CD = 'W'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField