CM_MATCH_TYPES (SQL Table)	Index Back
Comp Eval Types for Matching CM_MATCH_TYPES stores, for each operator id, the types of competency evaluations that should be used to match a person to a role or that should be used in the competency searches.

CM_MATCH_TYPES

(SQL Table)

Comp Eval Types for Matching

CM_MATCH_TYPES stores, for each operator id, the types of competency evaluations that should be used to match a person to a role or that should be used in the competency searches.

Parent record: CM_MATCH

# 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 SEARCH_TYPE Character(1) VARCHAR2(1) NOT NULL Search Type
M=Role/Person
S=Competency Search
Default Value: M

3 EVALUATION_TYPE Character(1) VARCHAR2(1) NOT NULL Evaluation Type
A=Approved/Official
B=Subordinate
C=Customer
E=Executive Committee
L=Learning
M=Mentor
P=Peer
R=Supervisor/Manager
S=Self

#	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	SEARCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Search Type M=Role/Person S=Competency Search Default Value: M
3	EVALUATION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Evaluation Type A=Approved/Official B=Subordinate C=Customer E=Executive Committee L=Learning M=Mentor P=Peer R=Supervisor/Manager S=Self