JPM_CSC_EPRF_LV

(SQL View)
 Index Back

JPM Compare - ePerf Data

Related Language record for JPM_CSC_EPRF_VW.

SELECT A.EMPLID , A.EMPL_RCD , C.LANGUAGE_CD , C.DESCR FROM PS_EP_APPR A , PS_REVW_RATING_LNG C WHERE A.PERIOD_END_DT = ( SELECT MAX(B.PERIOD_END_DT) FROM PS_EP_APPR B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EP_REVIEW_TYPE = A.EP_REVIEW_TYPE AND B.EP_REVIEW_STATUS = 'CO' ) AND C.RATING_MODEL = A.RATING_MODEL AND C.REVIEW_RATING = A.REVIEW_RATING AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_REVW_RATING_TBL D WHERE D.RATING_MODEL = C.RATING_MODEL AND D.REVIEW_RATING = C.REVIEW_RATING AND D.EFFDT <= %CurrentDateIn) AND A.EP_REVIEW_STATUS = 'CO' AND A.EP_REVIEW_TYPE = ( SELECT B.EP_REVIEW_TYPE FROM PS_EP_DEFAULT B WHERE EP_TRANSACTION_NM = 'M')

  • Related Language Record for JPM_CSC_EPRF_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description