USERCLASS_VW

Platform	View Text
Default	SELECT DISTINCT A.OPRID , A.ROLENAME , B.CLASSID FROM PSROLEUSER_VW A , PSROLECLASS B WHERE B.ROLENAME = A.ROLENAME

PeopleSoft Field Name	Description
OPRID	A user's ID
ROLENAME	The name of a Role in the Role Definition Table
CLASSID	The name of the class Prompt Table: PSCLASSDEFN

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010