APPR_INST_VW

index back

Approval Instance Log View


select appr_instance, appr_step, appr_path, appr_inst_status, dttm_stamp, roleuser, busprocname, appr_rule_set from ps_appr_inst_log

PeopleSoft Field NameField TypeColumn TypeDescription
APPR_INSTANCENumber(9,0)DECIMAL(9) NOT NULLUnique number for each runtime occurrence of a virtual approver process
APPR_STEPCharacter(3)VARCHAR2(3) NOT NULLApproval 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_PATHCharacter(3)VARCHAR2(3) NOT NULLApproval Path
A=Approval Path A
B=Approval Path B
C=Approval Path C
D=Approval Path D
E=Approval Path E
APPR_INST_STATUSCharacter(1)VARCHAR2(1) NOT NULLApproval Instance Status
A=Approved
D=Denied
I=Initiated
N=Not Applicable
P=Pending
R=Recycle
S=Skipped
DTTM_STAMPDateTime(26)TIMESTAMPSpecifies 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.
ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
APPR_RULE_SETCharacter(30)VARCHAR2(30) NOT NULLApproval Rule Set
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19