PV_CHNG_RST_WL

(SQL Table)
Index Back

Req 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 APPR_INSTANCE Number(9,0) DECIMAL(9) NOT NULL Unique number for each runtime occurrence of a virtual approver process
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
10 PV_DTTM DateTime(26) TIMESTAMP NOT NULL Date and Time Requested

Default Value: %DateTime

11 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
12 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
13 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
14 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
15 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity