GENL_EVAL_CMP

(SQL Table)
 Index Back

General Evaluation Components

For each person, this table contains all the rating components for the selected rating scheme, for each member of the committee associated with a specific General Evaluation.

  • Related Language Record: GENL_EVAL_LANG

  • Parent record: GENL_EVAL_SCHEM

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

    Prompt Table: PEOPLE_SRCH

    2 EVALUATION_CODE Character(10) VARCHAR2(10) NOT NULL Evaluation Code

    Prompt Table: EVALUATION_TBL

    3 GENL_EVAL_NBR Number(3,0) SMALLINT NOT NULL Evaluation Number

    Prompt Table: GENL_EVALUATION

    4 COMMITTEE_ID Character(6) VARCHAR2(6) NOT NULL Committee

    Prompt Table: GENL_EVAL_COM

    5 EVALUATOR_ID Character(11) VARCHAR2(11) NOT NULL Evaluator ID

    Prompt Table: GENL_EVAL_MEMBR

    6 RATING_SCHEME Character(10) VARCHAR2(10) NOT NULL Rating Scheme

    Prompt Table: GENL_EVAL_SCHEM

    7 RATING_CMP Character(5) VARCHAR2(5) NOT NULL Rating Component

    Prompt Table: RATING_CMP_TBL

    8 RATING_CMP_TYPE Character(4) VARCHAR2(4) NOT NULL Component Type
    CUML=Cumulative
    INDV=Individual
    9 RATING_VALUE Number(3,0) SMALLINT NOT NULL Rating Value

    Prompt Table: RATING_VAL_TBL

    10 DESCR254A Character(254) VARCHAR2(254) NOT NULL Long Description