PSROLEXLATOPRVW

index back

Role User View

Relates Roleusers and Operators.
SELECT oprid , roleuser , descr , emailid , formid , worklist_user_sw , email_user_sw , forms_user_sw , emplid , roleuser_alt , roleuser_supr , effdt_from , effdt_to FROM ps_rolexlatopr

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
DESCR Character(30) VARCHAR2(30) NOT NULL Description
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

Default: Y

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

Default: Y

EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User

Prompt Table: PSOPRDEFN_SRCH

ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User

Prompt Table: PSOPRDEFN_SRCH

EFFDT_FROM Date(10) DATE Effective Date From
EFFDT_TO Date(10) DATE Effective Date To
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19