APPR_INST_LOG

(SQL Table)
Index Back

Approval Instance Log

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 APPR_INSTANCE Number(9,0) DECIMAL(9) NOT NULL Unique number for each runtime occurrence of a virtual approver process
2 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
3 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
4 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
5 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.
6 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
7 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
8 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set