CM_TEAM_MATCH_D (SQL View)	Index Back
Team Competencies - Detail This view selects those team members by Competency that have the particular competency at a particular proficiency.

CM_TEAM_MATCH_D

(SQL View)

Team Competencies - Detail

This view selects those team members by Competency that have the particular competency at a particular proficiency.

SELECT A.OPRID , B.TEAM_CODE , A.COMPETENCY , A.EMPLID , A.REVIEW_POINTS FROM PS_CM_COMP_MATCH A , PS_EE_TEAM_DEFN B WHERE A.EMPLID = B.EMPLID AND A.SEARCH_TYPE = 'M'

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	Review Points