SCC_GE_CM_EVLTR

(SQL Table)
 Index Back

Eval Management CM Evaluator

Evaluation Management System Evaluation Committee Evaluator Table.

  • Parent record: SCC_GE_CM_INFO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_GE_INSTANCE_ID Number(16,0) DECIMAL(16) NOT NULL Evaluation Instance
    2 SCC_GE_COMM_SCHEME Character(10) VARCHAR2(10) NOT NULL Committee Scheme

    Prompt Table: SCC_GE_EC_CM_SC

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

    Prompt Table: SCC_GE_COMM_DEF

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

    Prompt Table: %EDITTABLE2

    5 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

    6 SCC_GE_EVAL_STATUS Character(6) VARCHAR2(6) NOT NULL Evaluation Status

    Prompt Table: SCC_GE_EC_STAT

    7 SCC_GE_EVAL_DT Date(10) DATE Status Date
    8 SCC_GE_RECOMMENDTN Character(10) VARCHAR2(10) NOT NULL Recommendation Value

    Prompt Table: SCC_GE_CMSC_RCM

    9 OVERALL_RATING Number(6,2) DECIMAL(5,2) NOT NULL Overall Rating
    10 SCC_GE_OVERALL_RTG Number(12,3) DECIMAL(11,3) NOT NULL Overall Rating
    11 SCC_GE_CMPLTD_DTTM DateTime(26) TIMESTAMP Completed Date
    12 SCC_GE_CMPLT_OPRID Character(30) VARCHAR2(30) NOT NULL Completed By
    13 SCC_NTFREQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
    14 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    15 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    16 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    17 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    18 SCC_GE_COMMENTS Long Character CLOB Comments