PC_ETC_PSTAT_VW (SQL View)	Index Back
Project Status count view This view is used in the ETC Analytic to show the count of each project status.

PC_ETC_PSTAT_VW

(SQL View)

Project Status count view

This view is used in the ETC Analytic to show the count of each project status.

SELECT OPRID , PROJECT_STATUS , COUNT(*) FROM PS_PC_ETC_TAO GROUP BY OPRID , PROJECT_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed

3 NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	PROJECT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Project Status B=Budgeted C=Closed H=Hold O=Open P=Proposed
3	NUMROWS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Rows fetched.