PRCSDEFNNOTIFY

index back

Process Defn - Notification

This table contains all users or users in roles that are to be notified based on the selected option as to when the person(s) need to be notified

PeopleSoft Field Name Field Type Column Type Description
PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
DISTID Character(30) VARCHAR2(30) NOT NULL Distribution ID

Prompt Table: %EDITTABLE

DISTIDTYPE Character(3) VARCHAR2(3) NOT NULL Distribution ID Type
2=User ID
3=Role Name
NOTIFYONERROR Number(1,0) SMALLINT NOT NULL Notify On Error
NOTIFYONSUCCESS Number(1,0) SMALLINT NOT NULL Notify On Success
NOTIFYDISABLED Character(1) VARCHAR2(1) NOT NULL Notify Disabled
NOTIFYONWARNING Number(1,0) SMALLINT NOT NULL Notify On Warning
PTPSNOTIFYTYPE Character(1) VARCHAR2(1) NOT NULL Type
1=EMail
2=Pop-up Notification
3=Notification Window
PTPSCANCEL Number(2,0) SMALLINT NOT NULL On Cancel
PTPSDELETE Number(2,0) SMALLINT NOT NULL On Delete
PTPSHOLD Number(2,0) SMALLINT NOT NULL On Hold
PTPSQUEUED Number(2,0) SMALLINT NOT NULL On Queued
PTPSINITIATED Number(2,0) SMALLINT NOT NULL On Initiated
PTPSPROCESSING Number(2,0) SMALLINT NOT NULL On Processing
PTPSCANCELLED Number(2,0) SMALLINT NOT NULL On Cancelled
PTPSNOTSUCCESS Number(2,0) SMALLINT NOT NULL On Not Success
PTPSASSIGNED Number(2,0) SMALLINT NOT NULL On Assigned
PTPSPENDING Number(2,0) SMALLINT NOT NULL On Pending
PTPSBLOCKED Number(2,0) SMALLINT NOT NULL On Blocked
PTPSRESTART Number(2,0) SMALLINT NOT NULL On Restart
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20