CM_TEAM_MATCH_A (SQL View)	Index Back
Team Accomplishments - View This view counts the number of team members that have a particular accomplishment.

CM_TEAM_MATCH_A

(SQL View)

Team Accomplishments - View

This view counts the number of team members that have a particular accomplishment.

SELECT A.TEAM_CODE , B.JPM_JP_TYPE , B.JPM_CAT_TYPE , B.ACCOMPLISHMENT , COUNT(*) FROM PS_EE_TEAM_DEFN A , PS_JPM_NO_COMP_VW B WHERE A.EMPLID = B.EMPLID GROUP BY a.team_code, B.JPM_JP_TYPE, B.JPM_CAT_TYPE, b.accomplishment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CM_PER_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type

3 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

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

5 EE_COUNT Number(3,0) SMALLINT NOT NULL Employee Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEAM_CODE	Character(4)	VARCHAR2(4) NOT NULL	Team code
2	CM_PER_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
3	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile.
4	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment
5	EE_COUNT	Number(3,0)	SMALLINT NOT NULL	Employee Count