CM_TEAM_MTCH_AD (SQL View)	Index Back
Team Accomplishments - Detail This view selects those team members by Accomplishment that have that particular accomplishment.

CM_TEAM_MTCH_AD

(SQL View)

Team Accomplishments - Detail

This view selects those team members by Accomplishment that have that particular accomplishment.

SELECT A.TEAM_CODE , B.ACCOMPLISHMENT , B.EMPLID FROM PS_EE_TEAM_DEFN A , PS_JPM_NO_COMP_VW B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEAM_CODE Character(4) VARCHAR2(4) NOT NULL Team code

2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEAM_CODE	Character(4)	VARCHAR2(4) NOT NULL	Team code
2	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID