APPR_VA2_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 | APPR_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Approval Action
A=Approve D=Deny R=Recycle |
| 4 | APPR_STEP | Character(3) | VARCHAR2(3) NOT NULL |
Approval Step
1=Approval Step 1 2=Approval Step 2 3=Approval Step 3 4=Approval Step 4 5=Approval Step 5 6=Approval Step 6 7=Approval Step 7 8=Approval Step 8 9=Approval Step 9 |
| 5 | APPR_PATH | Character(3) | VARCHAR2(3) NOT NULL |
Approval Path
A=Approval Path A B=Approval Path B C=Approval Path C D=Approval Path D E=Approval Path E |
| 6 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 7 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 8 | APPR_AMT_SW | Character(1) | VARCHAR2(1) NOT NULL | Approval Amount Switch |
| 9 | APPR_FLD_SW | Character(1) | VARCHAR2(1) NOT NULL | Route Control |
| 10 | APPR_QTY_SW | Character(1) | VARCHAR2(1) NOT NULL | Approval Quantity Switch |
| 11 | APPR_SKIP_SW | Character(1) | VARCHAR2(1) NOT NULL | Approval Skip Switch |
| 12 | MAX_CREDIT_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Credit Amount 1 |
| 13 | MAX_DEBIT_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Maximum Debit Amount 1 |
| 14 | AMT1_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Amount 1 Panelfield |
| 15 | AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 16 | FROM_QTY1 | Number(7,2) | DECIMAL(6,2) NOT NULL | From Qty 1 |
| 17 | TO_QTY1 | Number(7,2) | DECIMAL(6,2) NOT NULL | To Qty1 |
| 18 | QTY1_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Qty1 Panelfield |
| 19 | QTY1 | Number(7,2) | DECIMAL(6,2) NOT NULL | Quantity 1 |
| 20 | FLD1_FIELDVALUE | Character(30) | VARCHAR2(30) NOT NULL | Field 1 Field Value |
| 21 | FLD1_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Field 1 Panelfield |
| 22 | FLD2_FIELDVALUE | Character(30) | VARCHAR2(30) NOT NULL | Field 2 Field Value |
| 23 | FLD2_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Field 2 Panelfield |
| 24 | APPR_INST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Instance Status
A=Approved D=Denied I=Initiated N=Not Applicable P=Pending R=Recycle S=Skipped |
| 25 | APPR_WF_ERR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Workflow/Error Switch
B=Both E=Error Message M=Message Only W=Workflow |
| 26 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 27 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 28 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 29 | DENY_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Deny Event |
| 30 | RECYCLE_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Recyle Event Name |
| 31 | MAX_CREDIT_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Credit 2 |
| 32 | MAX_CREDIT_AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Credit 3 |
| 33 | MAX_CREDIT_AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Credit 4 |
| 34 | MAX_CREDIT_AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Credit 5 |
| 35 | MAX_DEBIT_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Debit 2 |
| 36 | MAX_DEBIT_AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Debit 3 |
| 37 | MAX_DEBIT_AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Debit 4 |
| 38 | MAX_DEBIT_AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Max Debit 5 |
| 39 | AMT2_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Amount 2 Panelfield |
| 40 | AMT3_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Amount 3 Panelfield |
| 41 | AMT4_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Amount 4 Panelfield |
| 42 | AMT5_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Amount 5 Panlefield |
| 43 | AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 44 | AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 45 | AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 46 | AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Used in Virtual Approver to store the various rule amounts that go on each approval step |
| 47 | FROM_QTY2 | Number(7,2) | DECIMAL(6,2) NOT NULL | From Qty 2 |
| 48 | FROM_QTY3 | Number(7,2) | DECIMAL(6,2) NOT NULL | From Qty 3 |
| 49 | FROM_QTY4 | Number(7,2) | DECIMAL(6,2) NOT NULL | From Qty 4 |
| 50 | FROM_QTY5 | Number(7,2) | DECIMAL(6,2) NOT NULL | From Qty 5 |
| 51 | TO_QTY2 | Number(7,2) | DECIMAL(6,2) NOT NULL | To Qty2 |
| 52 | TO_QTY3 | Number(7,2) | DECIMAL(6,2) NOT NULL | To Qty3 |
| 53 | TO_QTY4 | Number(7,2) | DECIMAL(6,2) NOT NULL | To Qty4 |
| 54 | TO_QTY5 | Number(7,2) | DECIMAL(6,2) NOT NULL | To Qty5 |
| 55 | QTY2_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Qty2 Field |
| 56 | QTY3_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Qty3 Field |
| 57 | QTY4_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Qty4 Field |
| 58 | QTY5_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Qty5 Field |
| 59 | QTY2 | Number(7,2) | DECIMAL(6,2) NOT NULL | Quantity 2 |
| 60 | QTY3 | Number(7,2) | DECIMAL(6,2) NOT NULL | Quantity 3 |
| 61 | QTY4 | Number(7,2) | DECIMAL(6,2) NOT NULL | Quantity 4 |
| 62 | QTY5 | Number(7,2) | DECIMAL(6,2) NOT NULL | Quantity 5 |
| 63 | FLD1 | Character(100) | VARCHAR2(100) NOT NULL | Field 1 |
| 64 | FLD2 | Character(100) | VARCHAR2(100) NOT NULL | Field 2 |
| 65 | FLD3 | Character(100) | VARCHAR2(100) NOT NULL | Field 3 |
| 66 | FLD4 | Character(100) | VARCHAR2(100) NOT NULL | Field 4 |
| 67 | FLD5 | Character(100) | VARCHAR2(100) NOT NULL | Field 5 |
| 68 | FLD3_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Field 3 |
| 69 | FLD4_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Field 4 |
| 70 | FLD5_PNLFIELD | Character(35) | VARCHAR2(35) NOT NULL | Field 5 |
| 71 | RTE_CNTL_TYPE1 | Character(30) | VARCHAR2(30) NOT NULL | Appr Field Type 1 |
| 72 | RTE_CNTL_TYPE2 | Character(30) | VARCHAR2(30) NOT NULL | Appr Field Type 2 |
| 73 | RTE_CNTL_TYPE3 | Character(30) | VARCHAR2(30) NOT NULL | Appr Field Type 3 |
| 74 | RTE_CNTL_TYPE4 | Character(30) | VARCHAR2(30) NOT NULL | Appr Field Type 4 |
| 75 | RTE_CNTL_TYPE5 | Character(30) | VARCHAR2(30) NOT NULL | Appr Field Type 5 |
| 76 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 77 | DENY_ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Deny Activity Name |
| 78 | RECYCLE_ACTIVITY | Character(30) | VARCHAR2(30) NOT NULL | Recycle Activity Name |