CM_TEAM_MATCH (SQL View)	Index Back
Team Competencies - View This view counts the number of team members that have a particular competency at a particular proficiency.

CM_TEAM_MATCH

(SQL View)

Team Competencies - View

This view counts the number of team members that have a particular competency at a particular proficiency.

SELECT A.OPRID , B.TEAM_CODE , A.JPM_JP_TYPE , A.COMPETENCY , A.REVIEW_POINTS , COUNT(*) FROM PS_CM_COMP_MATCH A , PS_EE_TEAM_DEFN B WHERE A.EMPLID = B.EMPLID AND A.SEARCH_TYPE = 'M' GROUP BY A.OPRID, B.TEAM_CODE, A.JPM_JP_TYPE, A.COMPETENCY, A.REVIEW_POINTS

# 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_CODE Character(4) VARCHAR2(4) NOT NULL Team code

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

4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
Prompt Table: COMPETENCY_TBL

5 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points

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

#	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_CODE	Character(4)	VARCHAR2(4) NOT NULL	Team code
3	CM_PER_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type
4	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency Prompt Table: COMPETENCY_TBL
5	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
6	EE_COUNT	Number(3,0)	SMALLINT NOT NULL	Employee Count