EOTP_APPROVE_WL

(SQL Table)
Index Back

Service Approval Worklist

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
2 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
3 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
4 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
5 INSTANCEID Number(10,0) DECIMAL(10) NOT NULL For a given worklist the unique number of rows in PSWORKLIST
6 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier
7 EOTP_PARTNERID Number(15,0) DECIMAL(15) NOT NULL Partner ID
8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 EOTP_SERVICEID Number(15,0) DECIMAL(15) NOT NULL Service ID
10 EOTP_COMPNAME Character(30) VARCHAR2(30) NOT NULL Company Name
11 EOTP_SVCSTATUS Character(1) VARCHAR2(1) NOT NULL Service Status
A=Approved
C=Cancelled
I=Processing Approval
N=New
P=Pending Approval
R=Rejected
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description