COMPETENCY_TBL

(SQL Table)
 Index Back

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.

  • Related Language Record: COMPETENCY_LANG

  • Parent Record Of COMPETENCY_TYPS

    • # 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 RS_CATEGORY Character(1) VARCHAR2(1) NOT NULL Competency Category
    A=Ability
    K=Knowledge
    N=NVQ - Unit
    O=Other
    P=Salary Planning
    S=Skill
    5 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model

    Default Value: PSCM

    Prompt Table: RATING_MDL_TBL

    6 UNIT_TITLE Character(70) VARCHAR2(70) NOT NULL Unit Title
    7 DESCRLONG Long Character CLOB Long Description