COMPETENCY_TYPS (SQL View)	Index Back
Competency Types This table allows you to define the competency types for each competency. A competency can have none, one, or more than 1 competency type. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM.

COMPETENCY_TYPS

(SQL View)

Competency Types

This table allows you to define the competency types for each competency. A competency can have none, one, or more than 1 competency type. Release 9 Job Profile Managment (JPM): Table became a view to JPM data. Ownership of table transferred from HR Core Objects to JPM.

SELECT %Substring(JPM_CAT_ITEM_ID,1,8) ,%Substring(JPM_CAT_GROUP,1,6) FROM PS_JPM_CAT_GMEMB WHERE JPM_CAT_TYPE = 'COMPETENCY' AND JPM_CAT_GROUP_TYPE = 'COMP TYPE'

Parent record: COMPETENCY_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

2 CM_TYPE Character(6) VARCHAR2(6) NOT NULL Competency Type
Prompt Table: CM_TYPE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency
2	CM_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Competency Type Prompt Table: CM_TYPE_TBL