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.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.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 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
Prompt Table: COMPETENCY_TBL

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

5 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	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency Prompt Table: COMPETENCY_TBL
4	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points
5	EE_COUNT	Number(3,0)	SMALLINT NOT NULL	Employee Count