PROJ_PC_TEAM_VW (SQL View)	Index Back
PC Project Team View The view provides an easy to use on-line prompt for the project table by team member (employee).

PROJ_PC_TEAM_VW

(SQL View)

PC Project Team View

The view provides an easy to use on-line prompt for the project table by team member (employee).

SELECT EMPLID , BUSINESS_UNIT , PROJECT_ID , DESCR FROM PS_PERSON E , PS_PROJECT P WHERE P.EFF_STATUS = 'A' AND ( P.ENFORCE IN ('N','E') OR EXISTS ( SELECT 'X' FROM PS_PROJECT_TEAM_VW TEAM WHERE P.BUSINESS_UNIT = TEAM.BUSINESS_UNIT AND P.PROJECT_ID = TEAM.PROJECT_ID AND E.EMPLID = TEAM.TEAM_MEMBER ) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 HMCF_PC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Chartfield Project Costing Business Unit

3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	HMCF_PC_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Chartfield Project Costing Business Unit
3	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description