EP_SUB_WRT_VW

(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 , 'W' , EP_RESULTS_WRITER FROM PS_EP_SUB_WRT_TBL

  • Related Language Record: EP_SUBWRTVW_LNG

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