EP_OLD_REVW_VW

(SQL View)
 Index Back

Old "Salary Planning" Reviews

This view is used in the ePerformance Management GetAllReviews() function to return information about "obsolete Salary Planning" reviews in the newer ePerformance format.

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.REVIEW_FROM_DT ,A.REVIEW_THRU_DT ,A.REVIEW_TYPE ,A.RATING_SCALE ,A.REVIEW_RATING ,A.TOTAL_EE_POINTS ,A.EMPL_REVW_STATUS ,A.RES_RVW_BAND_CD ,A.FINAL_RVW_BAND_CD ,A.GB_GROUP_ID ,A.GVT_OPM_RATING ,A.FP_REV_RATING ,B.REVW_SCALE_TYPE ,B.RATING_MODEL ,C.SETID_SALARY ,C.REG_REGION FROM PS_EMPLOYEE_REVIEW A , PS_REVW_SCALE_TBL B , PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_JOB C1 WHERE C1.EMPLID = C.EMPLID AND C1.EMPL_RCD = C.EMPL_RCD AND C1.EFFDT <= A.EFFDT) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_JOB C2 WHERE C2.EMPLID = C.EMPLID AND C2.EMPL_RCD = C.EMPL_RCD AND C2.EFFDT = C.EFFDT) AND B.RATING_SCALE = A.RATING_SCALE AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_REVW_SCALE_TBL B1 WHERE B1.RATING_SCALE = B.RATING_SCALE AND B1.EFFDT <= A.EFFDT) AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EMPLOYEE_REVIEW A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD AND A1.REVIEW_FROM_DT = A.REVIEW_FROM_DT AND A1.REVIEW_THRU_DT = A.REVIEW_THRU_DT AND A1.REVIEW_TYPE = A.REVIEW_TYPE)

  • Parent record: PER_ORG_ASGN_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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 REVIEW_FROM_DT Date(10) DATE Review Period From
    5 REVIEW_THRU_DT Date(10) DATE Review Period To
    6 REVIEW_TYPE Character(1) VARCHAR2(1) NOT NULL Review Type
    A=Self Assesssment
    B=Both
    E=Employee Feedback
    I=Initial Rating
    M=Interim Rating
    O=Official Rating
    P=Performance
    R=Adjustment Result
    S=Salary

    Default Value: S

    7 RATING_SCALE Character(4) VARCHAR2(4) NOT NULL Rating Scale
    8 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
    9 TOTAL_EE_POINTS Number(3,0) SMALLINT NOT NULL Total Review Points
    10 EMPL_REVW_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Review Status
    A=Approved
    I=Ineligible
    N=No Increase
    P=Proposed
    R=Processed

    Default Value: P

    11 RES_RVW_BAND_CD Character(1) VARCHAR2(1) NOT NULL Resulting Review Band
    12 FINAL_RVW_BAND_CD Character(1) VARCHAR2(1) NOT NULL Final Review Band
    13 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    14 GVT_OPM_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating
    1=Level I
    2=Level II
    3=Level III
    4=Level IV
    5=Level V
    X=Not Rated
    Z=Exclusion
    15 FP_REV_RATING Number(6,2) DECIMAL(5,2) NOT NULL Rating
    16 REVW_SCALE_TYPE Character(1) VARCHAR2(1) NOT NULL Review Scale Type
    A=Average
    R=Review Band
    S=Summation
    17 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
    18 SETID_1 Character(5) VARCHAR2(5) NOT NULL Setid used to build the Template for entering Bulk Positive Input
    19 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region