RS_EVALUATIONS

(SQL Table)
 Index Back

Person Competency Evaluation

CM_EVALUATIONS identifies each competency evaluation of your employees, applicants, or contractors. The evaluation is identified by an assigned EVALUATION_ID. Also, each evaluation has an EVALUATION_TYPE, an optional REVIEWER_ID, and a flag to identify whether or not the evaluation is active.

  • Related Language Record: RS_EVALUAT_LNG

  • Parent record: PERSONAL_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID

    Default Value: 01

    3 EVALUATION_TYPE Character(1) VARCHAR2(1) NOT NULL Evaluation Type
    A=Approved
    B=Subordinate
    C=Customer
    E=Exec Comm
    M=Mentor
    P=Peer
    R=Supervisor
    S=Self
    4 REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

    Prompt Table: PERSONAL_DATA

    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 REVIEWER_APPRVD Character(1) VARCHAR2(1) NOT NULL Reviewer is Approved

    Y/N Table Edit

    Default Value: N

    7 REVIEW_DT Date(10) DATE Review Date

    Default Value: %date

    8 REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Review Status
    P=Pending Review
    R=Reviewed
    U=Unreviewed
    W=Sent to Workflow

    Y/N Table Edit

    Default Value: Y