GVT_PIP_RVW_VW

(SQL View)
 Index Back

EE Perf Reviews VW for PIP

GVT_PIP_RVW_VW is used in the PIP process so that all of an employee's reviews can be seen while processing the PIP.

select emplid ,EMPL_RCD ,effdt ,next_review_dt ,review_from_dt ,review_thru_dt ,review_type ,rating_scale ,review_rating ,gvt_opm_rating from PS_EMPLOYEE_REVIEW

  • 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

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 EFFDT Date(10) DATE Effective Date
    4 NEXT_REVIEW_DT Date(10) DATE Next Review Date
    5 REVIEW_FROM_DT Date(10) DATE Review Period From
    6 REVIEW_THRU_DT Date(10) DATE Review Period To
    7 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
    8 RATING_SCALE Character(4) VARCHAR2(4) NOT NULL Rating Scale

    Prompt Table: REVW_SCALE_TBL

    9 REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL Review Rating

    Prompt Table: REVW_RATING_TBL

    10 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