PV_GHP_PSTS_VW1 (SQL View)	Index Back
eProcurement analysis PO status : Number of Pos

PV_GHP_PSTS_VW1

(SQL View)

eProcurement analysis

PO status : Number of Pos

SELECT PO_STATUS , COUNT(*) FROM PS_PO_HDR GROUP BY PO_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
Default Value: I

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled Default Value: I
2	NUM_RECORDS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Records