EP_SUB_DEV_VW

(SQL View)
 Index Back

Sub Competency Dev Tip View

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

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

  • Related Language Record: EP_SUB_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 EP_SUB_ID Character(12) VARCHAR2(12) NOT NULL Sub-Item unique identifier
    3 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

    Prompt Table: REVW_RATING_TBL

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

    Prompt Table: EP_DEV_TIP_TBL

    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.