EP_COMP_DEV_VW

(SQL View)
 Index Back

Competency Dev Tip View

Competency Development Tips - Used to provide helpful tips for a level of proficiency for a competency. These tips are designed to further enhance or improve a competency.

SELECT A.COMPETENCY , A.REVIEW_RATING , A.EP_DEV_TIP_ID , B.EP_DEV_TIP_TITLE , B.EP_DEV_TIP_DESCR FROM PS_EP_COMP_DEV_TBL A , PS_EP_DEV_TIP_TBL B WHERE A.EP_DEV_TIP_ID = B.EP_DEV_TIP_ID

  • Related Language Record: EP_CMP_DEV_LANG

  • Parent record: CM_RATING_DESCR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
    2 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

    Prompt Table: REVW_RATING_TBL

    3 EP_DEV_TIP_ID Character(8) VARCHAR2(8) NOT NULL Development tip id

    Prompt Table: EP_DEV_TIP_TBL

    4 EP_DEV_TIP_TITLE Character(60) VARCHAR2(60) NOT NULL Development tip title
    5 EP_DEV_TIP_DESCR Long Character CLOB Development Tip long description field.