FO_APP_CM_EVALS

(SQL Table)
 Index Back

Applicant Evaluation

APP_CM_EVALS identifies each competency evaluation of your applicants. 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.

  • Parent record: APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 APPLID Character(11) VARCHAR2(11) NOT NULL External Job Applicant ID
    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

    Default Value: S

    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
    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