EP_CMPDTIP_LANG

(SQL View)
 Index Back

Competency Dev Tip Lang Vw


SELECT COMPETENCY , REVIEW_RATING , LANGUAGE_CD ,'D' , EP_DEV_TIP_DESCR FROM PS_EP_CMP_DEV_LANG

  • Related Language Record for EP_CMPDEVTIP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EP_WRT_SRC Character(1) VARCHAR2(1) NOT NULL Tip Source
    C=Other Evaluators' Comments
    D=Development Tips
    P=Performance Notes
    S=Suggested Results
    W=Results Writer
    5 EP_SUGGEST_RESULT Long Character CLOB Suggested Results Test