APPR_VA1_WRK(SQL Table) |
Index Back |
|---|---|
Virtual Approver Output Scroll |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 2 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 3 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 4 | APPR_REQ_SW | Character(1) | VARCHAR2(1) NOT NULL | Approval Required Switch |
| 5 | APPR_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Approval Action
A=Approve D=Deny R=Recycle |
| 6 | APPR_AMT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Amount Approved Flag |
| 7 | APPR_QTY_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Approval Qty Flag |
| 8 | APPR_INSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Unique number for each runtime occurrence of a virtual approver process |
| 9 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 10 | APP_ROW_NUMBER | Number(3,0) | SMALLINT NOT NULL | Application Row Number |
| 11 | VI_ROW_NUMBER | Number(3,0) | SMALLINT NOT NULL | Virtual Scroll Row Number |