FSPC_USR_LST_VW (SQL View)	Index Back
FSPC User Sec Vw FSPC user security view

FSPC_USR_LST_VW

(SQL View)

FSPC User Sec Vw

FSPC user security view

SELECT OPRID , OPRDEFNDESC FROM PSOPRDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FSPC_PERMISSION Character(30) VARCHAR2(30) NOT NULL FSWC - URL Permission Type (User, Role, Permission List)

2 FSPC_DESCR Character(40) VARCHAR2(40) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FSPC_PERMISSION	Character(30)	VARCHAR2(30) NOT NULL	FSWC - URL Permission Type (User, Role, Permission List)
2	FSPC_DESCR	Character(40)	VARCHAR2(40) NOT NULL	Description