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 NameField TypeColumn TypeDescription
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

Prompt Table: OPRDEFN2

EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
FORMIDCharacter(70)VARCHAR2(70) NOT NULLForm ID
WORKLIST_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets a worklist generated
EMAIL_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets workflow email generated
FORMS_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets workflow Lotus forms generated
EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19