UPG_SAC_AET

(SQL Table)
Index Back

SAC Upgrade State Record

SAC Upgrade State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
3 COUNTER2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Counter 2
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name
7 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
8 EOAWLEVEL Number(1,0) SMALLINT NOT NULL Level e.g. Header = 0, Line = 1.
0=Header
1=Line
9 EOAWEVENT Character(3) VARCHAR2(3) NOT NULL Approval Workflow Events for Notification
A=On Final Approval
AD=Ad Hoc Delete
AH=Ad Hoc Insert
B=Push Back
D=On Final Denial
E=On Error
ES=On Escalate
H=Hold Step
L=Locked Out
NAN=No Approver Necessary
PC=Processing Complete
PL=On Process Launch
R=On Reactivate
RA=Route for Approval
RI=Request Information
RIA=Request Information Added
RR=Route for Review
RS=On Reassign
SC=On Step Complete
T=On Terminate
W=On Cancel
10 EOAWPARTICIPANT Character(3) VARCHAR2(3) NOT NULL Approval Workflow Events for Notification
A=Approvers
D=Dynamic
DA=Delegate Approver
DR=Delegate Requester
E=External
PA=Proxy Approver
PR=Proxy Requester
R=Requester
S=Administrator
U=User List
V=Reviewers
11 EOAWRECNAME_XREF Character(15) VARCHAR2(15) NOT NULL Cross Reference Table
12 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
13 SELECT_CLAUSE Character(254) VARCHAR2(254) NOT NULL Select Clause