PSPERMPFLCLS_VW (SQL View)	Index Back
Permlist used in Proc. Profile This SQL view provides a list of all Permission Lists in use as a Process Profile Permissions List. It is used by the Purge_Permlist page to prevent the deletion of a Permissions List if it is currently in use as a Process Profile Permissions List.

PSPERMPFLCLS_VW

(SQL View)

Permlist used in Proc. Profile

This SQL view provides a list of all Permission Lists in use as a Process Profile Permissions List. It is used by the Purge_Permlist page to prevent the deletion of a Permissions List if it is currently in use as a Process Profile Permissions List.

SELECT DISTINCT PRCSPRFLCLS , COUNT(*) FROM PSOPRDEFN WHERE PRCSPRFLCLS <> ' ' GROUP BY PRCSPRFLCLS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
2	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number