Co-Operative PeopleTools Table Reference

View: PS_PSROLEDEFN_VW	Return to Index
PSROLEDEFN_VW	Return to Index

Another view on Role Definition table to select all Roles except 'PeopleSoft Administrator'. (Note: View: PSROLEDEFN_SRCH selects different set of columns.)

Platform View Text
Default SELECT rolename , descr , %TextIn(descrlong) , rolestatus FROM PSROLEDEFN WHERE rolename <> 'PeopleSoft Administrator'

Platform	View Text
Default	SELECT rolename , descr , %TextIn(descrlong) , rolestatus FROM PSROLEDEFN WHERE rolename <> 'PeopleSoft Administrator'

PeopleSoft Field Name Description
ROLENAME The name of a Role in the Role Definition Table
DESCR Description
DESCRLONG Long Description
ROLESTATUS Role Status
A=Active
I=Inactive
Author: PeopleTools
Return to Index © Go-Faster Consultancy Ltd. Last updated 24 July 2010

PeopleSoft Field Name	Description
ROLENAME	The name of a Role in the Role Definition Table
DESCR	Description
DESCRLONG	Long Description
ROLESTATUS	Role Status A=Active I=Inactive

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

PSROLEDEFN_VW

View: PS_PSROLEDEFN_VW