PT_WF_NOTIFY_WL

index back

Generic Message Worklist


PeopleSoft Field Name Field Type Column Type Description
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
CREATEOPRID Character(30) VARCHAR2(30) NOT NULL A user's ID
CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
WL_SUBJECT Character(254) VARCHAR2(254) NOT NULL Subject
WORKLIST_DESCR Character(50) VARCHAR2(50) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19