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 | AWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 8 | AWLEVEL | Number(1,0) | SMALLINT NOT NULL | Level e.g. Header = 0, Line = 1. |
| 9 | AWEVENT | 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 PC=Processing Complete PL=On Process Launch R=On Reactivate RA=Route for Approval RR=Route for Review RS=On Reassign SC=On Step Complete T=On Terminate |
| 10 | AWPARTICIPANT | Character(3) | VARCHAR2(3) NOT NULL |
Approval Workflow Events for Notification
A=Approvers D=Dynamic R=Requester S=Administrator U=User List V=Reviewers |
| 11 | SELECT_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Select Clause |