PC_TM_EMP_VW (SQL View)	Index Back
Project Team Member Empl View View of assigned members (employees) in project team. Shows the project role that is relevant as of the current date. Though an employee can have multiple roles in the team, at any given time, the employee has just one role.

PC_TM_EMP_VW

(SQL View)

Project Team Member Empl View

View of assigned members (employees) in project team. Shows the project role that is relevant as of the current date. Though an employee can have multiple roles in the team, at any given time, the employee has just one role.

SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.TEAM_MEMBER , PD.NAME , PT.SOURCE_REQ , PT.EMAILID FROM PS_PROJECT_TEAM PT , PS_PERSONAL_DATA PD WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND PD.EMPLID = PT.TEAM_MEMBER

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

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 SOURCE_REQ Character(25) VARCHAR2(25) NOT NULL Source Requirement ID

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

#	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	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member Prompt Table: PC_TEAM_SUMR_VW
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	SOURCE_REQ	Character(25)	VARCHAR2(25) NOT NULL	Source Requirement ID
6	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address