FSPC_PRM_LST_VW (SQL View)	Index Back
FSPC PermList Sec Vw FSPC Permission List security view

FSPC_PRM_LST_VW

(SQL View)

FSPC PermList Sec Vw

FSPC Permission List security view

SELECT CLASSID , CLASSDEFNDESC FROM PSCLASSDEFN

# 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