ROLEXLATOPR_ARC

index back

Role User Archive Table


PeopleSoft Field NameField TypeColumn TypeDescription
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

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

Y/N Table Edit

EMAIL_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets workflow email generated

Y/N Table Edit

Default: Y

FORMS_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets workflow Lotus forms generated

Y/N Table Edit

EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
ROLEUSER_ALTCharacter(30)VARCHAR2(30) NOT NULLAlternate Role User
ROLEUSER_SUPRCharacter(30)VARCHAR2(30) NOT NULLSupervisor Role User
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19