SCC_GE_RC_MAIN2

(SQL Table)
 Index Back

Eval Management Maintenance 2

Evaluation Management System. Child Run Control record for the Create/Maintain Evaluations process. Stores the Update Actions to be performed on an Evaluation.

  • Parent record: SCC_GE_RC_MAIN1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 SCC_GE_EVAL_CATGRY Character(10) VARCHAR2(10) NOT NULL Evaluation Category

    Prompt Table: SCC_GE_CATEGORY

    4 SCC_GE_EVALUATN_CD Character(10) VARCHAR2(10) NOT NULL Evaluation Code

    Prompt Table: SCC_GE_EC_DEFN

    5 SCC_GE_MAINT_ACKEY Number(3,0) SMALLINT NOT NULL Maintenance Action Key
    6 SCC_GE_MAINT_ACTN Character(4) VARCHAR2(4) NOT NULL Update Action
    0001=Add Evaluator
    0002=Remove Evaluator
    0003=Add Component
    0004=Remove Component
    0005=Reassign Evaluator
    0006=Assign Scheme Administrator
    0007=Assign Committee Administrator
    7 SCC_GE_MAINT_SEQ Number(3,0) SMALLINT NOT NULL Sequence
    8 SCC_GE_SCHEME_TYPE Character(1) VARCHAR2(1) NOT NULL Scheme Type
    1=Auto-Calculated
    2=Committee
    3=Individual Evaluator
    9 SCC_GE_SCHEME_NAME Character(10) VARCHAR2(10) NOT NULL Scheme Name

    Prompt Table: %EDITTABLE10

    10 SCC_GE_COMMITTEE Character(6) VARCHAR2(6) NOT NULL Committee Code

    Prompt Table: SCC_GE_CMSC_CMT

    11 SCC_GE_EVALUATOR Character(11) VARCHAR2(11) NOT NULL Evaluator ID

    Prompt Table: %EDITTABLE2

    12 SCC_GE_EVALUATOR2 Character(11) VARCHAR2(11) NOT NULL New Evaluator

    Prompt Table: %EDITTABLE2

    13 COMMITTEE_ROLE Character(4) VARCHAR2(4) NOT NULL Committee Role
    ACAD=Academic Member of Committee
    ADMN=Administrative Support
    CHAI=Chair of Committee
    COCH=Co-Chair of Committee
    MMBF=Member of Committee
    MMBR=Administrator of Committee
    STAF=Staff member of Committee
    STDN=Student Member of Committee

    Prompt Table: COMMIT_ROLE_TBL

    14 SCC_GE_PROC_ORDER Number(3,0) SMALLINT NOT NULL Processing Order
    15 SCC_GE_RATING_COMP Character(10) VARCHAR2(10) NOT NULL Rating Component

    Prompt Table: SCC_GE_RTNG_CMP

    16 SCC_GE_SCHEM_ADMIN Character(11) VARCHAR2(11) NOT NULL Scheme Administrator

    Prompt Table: PEOPLE_SRCH

    17 SCC_GE_COMM_ADMIN Character(11) VARCHAR2(11) NOT NULL Committee Administrator

    Prompt Table: PEOPLE_SRCH