ROLEXLATOPR_ARC

index back

Role User Archive Table


PeopleSoft Field Name Field Type Column Type Description
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
DESCR Character(30) VARCHAR2(30) NOT NULL Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

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

Y/N Table Edit

EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated

Y/N Table Edit

Default: Y

FORMS_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow Lotus forms generated

Y/N Table Edit

EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User
ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20