PC_ETC_PTYPE_VW

(SQL View)
Index Back

Project Type count view

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

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

# 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_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
3 NUMROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.