PV_APPMG_SC_VW

(SQL View)
Index Back

Approve Requisition Submit Con

Approve Requisition Submit Confirmation Action View

SELECT FIELDVALUE FROM PSXLATITEM WHERE FIELDNAME = 'PV_APP_ACT_STS' AND FIELDVALUE IN ('A','D','B','H')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PV_APP_ACT_STS Character(4) VARCHAR2(4) NOT NULL Action/Status
A=Approve
A1=Approved
B=Pushback
B1=Pushed Back
D=Deny
D1=Denied
H=Hold
H1=On Hold
P=Pending
P1=See Lines
X=Cancelled