EP_SUBWRTVW_LNG

(SQL View)
 Index Back

Sub-Competency Results Writer

Sub-Competency Results Writer - Used as writing helper when updating the results in a performance review. Uses various character identifiers to pass gender specific pronouns to tailor the sentences to an individual.

SELECT COMPETENCY , EP_SUB_ID , REVIEW_RATING ,LANGUAGE_CD , 'W' , EP_RESULTS_WRITER FROM PS_EP_SUBWRT_LANG

  • Related Language Record for EP_SUB_WRT_VW

  • Parent record: EP_SUB_PROF_TBL

    • # 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