COMPETENCY_TBL

(SQL View)
 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. 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(A.JPM_CAT_ITEM_ID,1,8) ,%Substring(A.JPM_DESCR90,1,30) ,A.DESCRSHORT ,CASE A.JPM_CAT_TYPE WHEN 'COMPETENCY' THEN A.CM_CATEGORY ELSE 'N' END ,A.RATING_MODEL ,%Substring(A.JPM_DESCR90,1,70) ,%Substring(A.JPM_CAT_ITEM_SRC,1,1) ,A.JPM_TEXT1325_1 ,A.DESCRLONG FROM PS_JPM_CAT_ITEMS A WHERE A.JPM_CAT_TYPE IN ('COMPETENCY','NVQ UNIT') AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_JPM_CAT_ITEMS X WHERE A.JPM_CAT_TYPE = X.JPM_CAT_TYPE AND A.JPM_CAT_ITEM_ID = X.JPM_CAT_ITEM_ID AND X.EFFDT <= %CurrentDateIn)

  • Related Language Record: COMPETENCY_LANG

  • Parent Record Of CM_COMP_TYPE_VW CM_RATDESCR_LNG CM_RATING_DESCR COMPETENCY_TYPS EP_SUB_COMP_TBL

    • # 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