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 - this field is brought over from HRMS
    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 Category
    A=Ability
    K=Knowledge
    N=NVQ - Unit
    O=Other
    S=Skill

    Default Value: S

    5 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL RATING_MODEL field used in the HCM/ CRM sync Application Messages.

    Prompt Table: RATING_MDACT_VW

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