PV_GHP_RSTS_VW1

(SQL View)
 Index Back

eProcurement analysis

Req status : Number of Req

SELECT REQ_STATUS , COUNT(*) FROM PS_REQ_HDR GROUP BY REQ_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQ_STATUS Character(4) VARCHAR2(4) NOT NULL Req status
A=Approved
C=Complete
D=Denied
I=Initial
LA=Line Approved
O=Open
P=Pending Approval
V=Preview
X=Canceled

Default Value: REQUESTOR_TBL.REQ_STATUS

2 NUM_RECORDS Number(15,0) DECIMAL(15) NOT NULL Number of Records