EP_CMP_DEV_LANG

(SQL View)
 Index Back

Competency Dev Tip Lang Vw

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.LANGUAGE_CD , B.EP_DEV_TIP_TITLE , B.EP_DEV_TIP_DESCR FROM PS_EP_COMP_DEV_TBL A , PS_EP_DEV_TIP_LANG B WHERE A.EP_DEV_TIP_ID = B.EP_DEV_TIP_ID

  • Related Language Record for EP_COMP_DEV_VW

  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EP_DEV_TIP_TITLE Character(60) VARCHAR2(60) NOT NULL Development tip title
    6 EP_DEV_TIP_DESCR Long Character CLOB Development Tip long description field.