COMPETENCY_TBLX

(SQL Table)
Index Back

Back up of Competencies Table

This table is used to setup all Competencies organized by the following general categories: Ability, Knowledge and Skill and the more specific categories: Salary Planning and NVQ Unit For each Competency, the user can specify a Rating Model with associated Rating Values, as certain Competencies might be measured differently.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

Default Value: COMPETENCY_TBL.DESCR

4 CM_CATEGORY Character(1) VARCHAR2(1) NOT NULL Competency Category
A=Ability
K=Knowledge
N=NVQ - Unit
O=Other
S=Skill
5 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

Default Value: PSCM

Prompt Table: CM_RATING_VW

6 UNIT_TITLE Character(70) VARCHAR2(70) NOT NULL Unit Title
7 EP_CONTENT_SRC Character(1) VARCHAR2(1) NOT NULL Content provider source
C=Customer Defined
D=DDI
L=Lominger
P=PDI

Default Value: C

8 EP_DESCR254 Long Character(1325) VARCHAR2(1325) 1325 character description field used in ePerformance
9 DESCRLONG Long Character CLOB Long Description