index back

Approval Instance Log

PeopleSoft Field Name Field Type Column Type Description
APPR_INSTANCE Number(9,0) DECIMAL(9) NOT NULL Unique number for each runtime occurrence of a virtual approver process
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
APPR_INST_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Instance Status
N=Not Applicable
DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20