COMPETENCY_VW

(SQL View)
 Index Back

Competencies View

Competencies view - View used as Competencies prompt edit.

SELECT A.COMPETENCY ,A.DESCR ,A.DESCRSHORT ,A.CM_CATEGORY ,A.RATING_MODEL ,%subrec(NVQ_COMP_SBR,A) ,A.EP_CONTENT_SRC ,A.EP_DESCR254 ,A.DESCRLONG FROM PS_COMPETENCY_TBL A

  • Related Language Record: COMPTNCYVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency Code
    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 CLOB 1325 character description field used in ePerformance
    9 DESCRLONG Long Character CLOB Long Description