APPR_VA2_WRK

index back

Virtual Approver Output Scroll


PeopleSoft Field Name Field Type Column Type Description
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
APPR_ACTION Character(1) VARCHAR2(1) NOT NULL Approval Action
A=Approve
D=Deny
R=Recycle
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
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
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
APPR_AMT_SW Character(1) VARCHAR2(1) NOT NULL Approval Amount Switch
APPR_FLD_SW Character(1) VARCHAR2(1) NOT NULL Route Control
APPR_QTY_SW Character(1) VARCHAR2(1) NOT NULL Approval Quantity Switch
APPR_SKIP_SW Character(1) VARCHAR2(1) NOT NULL Approval Skip Switch
MAX_CREDIT_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Credit Amount 1
MAX_DEBIT_AMT1 Signed Number(28,3) DECIMAL(26,3) NOT NULL Maximum Debit Amount 1
AMT1_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Amount 1 Panelfield
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
FROM_QTY1 Number(7,2) DECIMAL(6,2) NOT NULL From Qty 1
TO_QTY1 Number(7,2) DECIMAL(6,2) NOT NULL To Qty1
QTY1_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Qty1 Panelfield
QTY1 Number(7,2) DECIMAL(6,2) NOT NULL Quantity 1
FLD1_FIELDVALUE Character(30) VARCHAR2(30) NOT NULL Field 1 Field Value
FLD1_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Field 1 Panelfield
FLD2_FIELDVALUE Character(30) VARCHAR2(30) NOT NULL Field 2 Field Value
FLD2_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Field 2 Panelfield
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
APPR_WF_ERR_SW Character(1) VARCHAR2(1) NOT NULL Workflow/Error Switch
B=Both
E=Error Message
M=Message Only
W=Workflow
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow
DENY_EVENTNAME Character(30) VARCHAR2(30) NOT NULL Deny Event
RECYCLE_EVENTNAME Character(30) VARCHAR2(30) NOT NULL Recyle Event Name
MAX_CREDIT_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Credit 2
MAX_CREDIT_AMT3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Credit 3
MAX_CREDIT_AMT4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Credit 4
MAX_CREDIT_AMT5 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Credit 5
MAX_DEBIT_AMT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Debit 2
MAX_DEBIT_AMT3 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Debit 3
MAX_DEBIT_AMT4 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Debit 4
MAX_DEBIT_AMT5 Signed Number(28,3) DECIMAL(26,3) NOT NULL Max Debit 5
AMT2_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Amount 2 Panelfield
AMT3_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Amount 3 Panelfield
AMT4_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Amount 4 Panelfield
AMT5_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Amount 5 Panlefield
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
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
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
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
FROM_QTY2 Number(7,2) DECIMAL(6,2) NOT NULL From Qty 2
FROM_QTY3 Number(7,2) DECIMAL(6,2) NOT NULL From Qty 3
FROM_QTY4 Number(7,2) DECIMAL(6,2) NOT NULL From Qty 4
FROM_QTY5 Number(7,2) DECIMAL(6,2) NOT NULL From Qty 5
TO_QTY2 Number(7,2) DECIMAL(6,2) NOT NULL To Qty2
TO_QTY3 Number(7,2) DECIMAL(6,2) NOT NULL To Qty3
TO_QTY4 Number(7,2) DECIMAL(6,2) NOT NULL To Qty4
TO_QTY5 Number(7,2) DECIMAL(6,2) NOT NULL To Qty5
QTY2_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Qty2 Field
QTY3_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Qty3 Field
QTY4_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Qty4 Field
QTY5_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Qty5 Field
QTY2 Number(7,2) DECIMAL(6,2) NOT NULL Quantity 2
QTY3 Number(7,2) DECIMAL(6,2) NOT NULL Quantity 3
QTY4 Number(7,2) DECIMAL(6,2) NOT NULL Quantity 4
QTY5 Number(7,2) DECIMAL(6,2) NOT NULL Quantity 5
FLD1 Character(100) VARCHAR2(100) NOT NULL Field 1
FLD2 Character(100) VARCHAR2(100) NOT NULL Field 2
FLD3 Character(100) VARCHAR2(100) NOT NULL Field 3
FLD4 Character(100) VARCHAR2(100) NOT NULL Field 4
FLD5 Character(100) VARCHAR2(100) NOT NULL Field 5
FLD3_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Field 3
FLD4_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Field 4
FLD5_PNLFIELD Character(35) VARCHAR2(35) NOT NULL Field 5
RTE_CNTL_TYPE1 Character(30) VARCHAR2(30) NOT NULL Appr Field Type 1
RTE_CNTL_TYPE2 Character(30) VARCHAR2(30) NOT NULL Appr Field Type 2
RTE_CNTL_TYPE3 Character(30) VARCHAR2(30) NOT NULL Appr Field Type 3
RTE_CNTL_TYPE4 Character(30) VARCHAR2(30) NOT NULL Appr Field Type 4
RTE_CNTL_TYPE5 Character(30) VARCHAR2(30) NOT NULL Appr Field Type 5
ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).
DENY_ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Deny Activity Name
RECYCLE_ACTIVITY Character(30) VARCHAR2(30) NOT NULL Recycle Activity Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19