EP_SUBDTIP_LANG

(SQL View)
 Index Back

Sub-Competency Dev Tip Lang Vw


SELECT COMPETENCY , EP_SUB_ID , REVIEW_RATING , LANGUAGE_CD , 'D' , EP_DEV_TIP_DESCR FROM PS_EP_SUB_DEV_LANG

  • Related Language Record for EP_SUBDEVTIP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 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
    6 EP_SUGGEST_RESULT Long Character CLOB Suggested Results Test