ROLEUSER_VW

index back

Role User View


Select B.ROLEUSER, B.ROLENAME, A.DESCR, A.OPRID, A.EMAILID, A.FORMID, A.WORKLIST_USER_SW, A.EMAIL_USER_SW, A.FORMS_USER_SW, A.EMPLID from PS_ROLEXLATOPR A, PSROLEUSER B WHERE A.ROLEUSER = B.ROLEUSER

PeopleSoft Field Name Field Type Column Type Description
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRDEFN2

EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
FORMID Character(70) VARCHAR2(70) NOT NULL Form ID
WORKLIST_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets a worklist generated
EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated
FORMS_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow Lotus forms generated
EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19