COMPETENCY_TYPS (SQL Table)	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.

COMPETENCY_TYPS

(SQL Table)

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.

Parent record: COMPETENCY_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency - this field is brought over from HRMS

2 RB_CM_TYPE Character(6) VARCHAR2(6) NOT NULL RB_CM_TYPE field used in the HCM/ CRM sync Application Messages for Competency.
Prompt Table: CM_TYPE_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency - this field is brought over from HRMS
2	RB_CM_TYPE	Character(6)	VARCHAR2(6) NOT NULL	RB_CM_TYPE field used in the HCM/ CRM sync Application Messages for Competency. Prompt Table: CM_TYPE_TBL