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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
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

Default: Y

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

Default: Y

EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
ROLEUSER_ALTCharacter(30)VARCHAR2(30) NOT NULLAlternate Role User

Prompt Table: PSOPRDEFN_SRCH

ROLEUSER_SUPRCharacter(30)VARCHAR2(30) NOT NULLSupervisor Role User

Prompt Table: PSOPRDEFN_SRCH

EFFDT_FROMDate(10)DATEEffective Date From
EFFDT_TODate(10)DATEEffective Date To
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19