SCC_GE_CM_INFO

(SQL Table)
 Index Back

Eval Management Eval Committee

Evaluation Management System Evaluation Committee Table. Stores the Committees in the Committee Scheme for the Evaluation Instance.

  • Parent record: SCC_GE_CM_SCHEM

    • # 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_EVAL_STATUS Character(6) VARCHAR2(6) NOT NULL Evaluation Status

    Prompt Table: SCC_GE_EC_STAT

    5 SCC_GE_EVAL_DT Date(10) DATE Status Date
    6 SCC_GE_RECOMMENDTN Character(10) VARCHAR2(10) NOT NULL Recommendation Value

    Prompt Table: SCC_GE_CMSC_RCM

    7 OVERALL_RATING Number(6,2) DECIMAL(5,2) NOT NULL Overall Rating
    8 SCC_GE_OVERALL_RTG Number(12,3) DECIMAL(11,3) NOT NULL Overall Rating
    9 SCC_GE_CMPLTD_DTTM DateTime(26) TIMESTAMP Completed Date
    10 SCC_GE_CMPLT_OPRID Character(30) VARCHAR2(30) NOT NULL Completed By
    11 SCC_GE_COMM_ADMIN Character(11) VARCHAR2(11) NOT NULL Committee Administrator

    Prompt Table: PEOPLE_SRCH

    12 SCC_NTFREQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
    13 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    14 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    15 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    16 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    17 SCC_GE_COMMENTS Long Character CLOB Comments