PC_TEAM_TOT_VW (SQL View)	Index Back
Number of Project Team Members View that shows the total number of team members (assigned and not assigned) per project. This view does not take team active date into consideration. It's number of team members past and present.

PC_TEAM_TOT_VW

(SQL View)

Number of Project Team Members

View that shows the total number of team members (assigned and not assigned) per project. This view does not take team active date into consideration. It's number of team members past and present.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , COUNT(*) FROM PS_PROJECT_TEAM PT WHERE PT.TEAM_MEMBER_CLASS = 'L' GROUP BY PT.BUSINESS_UNIT, PT.PROJECT_ID

Parent record: PROJECT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT_VW

3 PC_NUM_TEAM_MEMS Number(5,0) INTEGER NOT NULL Number of Team Members

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_VW
3	PC_NUM_TEAM_MEMS	Number(5,0)	INTEGER NOT NULL	Number of Team Members