GEN_MSG_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
GEN_MSG_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=High
2=Medium
3=Low
DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
FROM_ROLEUSER Character(30) VARCHAR2(30) NOT NULL From Roleuser
EMAIL_SUBJECT Character(30) VARCHAR2(30) NOT NULL Subject of the email
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19