PC_TEAM_UNQ_VW (SQL View)	Index Back
Project Team member View of unique Project Team members except resource status in (cancelled, rejected).

PC_TEAM_UNQ_VW

(SQL View)

Project Team member

View of unique Project Team members except resource status in (cancelled, rejected).

SELECT DISTINCT PT.OPRID , PT.TEAM_MEMBER , PT.PERSON_NAME , PT.EMAILID , PT.PHONE FROM PS_PC_PROJ_TEAM_VW PT WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E'

# 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 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
Prompt Table: PROJECT_TEAM_VW

3 PERSON_NAME Character(100) VARCHAR2(100) NOT NULL Name

4 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

5 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	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	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member Prompt Table: PROJECT_TEAM_VW
3	PERSON_NAME	Character(100)	VARCHAR2(100) NOT NULL	Name
4	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
5	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone