HR_GSS_PG_EP_VW

(SQL View)
 Index Back

GSS PG Performance Appraisal

Current performance appraisal rating used in simplyfied analytic for GSS.

SELECT APPR.EP_APPRAISAL_ID , APPR.EP_RATING , APPR.EMPLID , APPR.EMPL_RCD , RATE.DESCR FROM PS_EP_APPR APPR , PS_REVW_RATING_TBL RATE , PS_EP_DEFAULT EPDFLT WHERE APPR.EP_REVIEW_STATUS = 'CO' AND APPR.EP_REVIEW_TYPE = EPDFLT.EP_REVIEW_TYPE AND EPDFLT.EP_TRANSACTION_NM = 'M' AND APPR.PERIOD_END_DT =( SELECT MAX(A1.PERIOD_END_DT) FROM PS_EP_APPR A1 WHERE APPR.EMPLID = A1.EMPLID AND APPR.EMPL_RCD = A1.EMPL_RCD AND APPR.EP_REVIEW_STATUS = A1.EP_REVIEW_STATUS AND APPR.EP_REVIEW_TYPE = A1.EP_REVIEW_TYPE ) AND RATE.RATING_MODEL = APPR.RATING_MODEL AND RATE.REVIEW_RATING = APPR.REVIEW_RATING AND RATE.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_REVW_RATING_TBL D WHERE D.RATING_MODEL = RATE.RATING_MODEL AND D.REVIEW_RATING = RATE.REVIEW_RATING AND D.EFFDT <= %CurrentDateIn)

  • Related Language Record: HR_GSS_PG_EP_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EP_APPRAISAL_ID Number(8,0) INTEGER NOT NULL Document ID
    2 EP_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description