UPG_SAC_AET(SQL Table) |
Index Back |
---|---|
SAC Upgrade State RecordSAC 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 |