PT_WF_NOT_USRO2

index back

Workflow Notification Address

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

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
EMAIL_TO Character(254) VARCHAR2(254) NOT NULL EMAIL_TO
OPRALIASTYPE Character(3) VARCHAR2(3) NOT NULL User ID Type
EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated

Y/N Table Edit

WORKLIST_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets a worklist generated

Y/N Table Edit

WF_RECIPIENT_TYPE Character(1) VARCHAR2(1) NOT NULL Recipient Type
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20