PT_WF_NOT_USRL

index back

Workflow Notification Address

Contains information about a user as a recipient of a workflow notification

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
EMAIL_TOCharacter(254)VARCHAR2(254) NOT NULLEMAIL_TO
OPRALIASTYPECharacter(3)VARCHAR2(3) NOT NULLUser ID Type
EMAIL_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets workflow email generated

Y/N Table Edit

WORKLIST_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets a worklist generated

Y/N Table Edit

WF_RECIPIENT_TYPECharacter(1)VARCHAR2(1) NOT NULLRecipient Type
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19