PSPT_WSWORKLIST

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PT_REQUEST_MSG_ID Character(128) VARCHAR2(128) NOT NULL Message ID
2 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
3 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
4 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
5 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
6 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
7 PT_WS_RESP_SENT Number(1,0) SMALLINT NOT NULL Response sent to the caller.
8 PT_WSA_INFO Long Character CLOB Web Service Addressing Info
9 IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID