PCMP_DEVCOMP_VW

(SQL View)
 Index Back

Prof Comp Dev Competencies

Used in the Professional Compliance module. View of Competencies used in the professional compliance process.

SELECT A.SETID ,A.COMPETENCY ,B.DESCR FROM PS_PCMP_DEV_COMP A ,PS_COMPETENCY_TBL B WHERE B.COMPETENCY=A.COMPETENCY

  • Related Language Record: PCMP_DVCOMVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_18

    2 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    3 PCMP_DEV_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Development description.