SCC_GE_CMSC_DEF

(SQL Table)
 Index Back

Eval Management Committee Schm

Evaluation Management System Committee Scheme Definition Table.

  • Related Language Record: SCC_GE_CMSC_LNG

  • Parent Record Of SCC_GE_CMSCLLNG SCC_GE_CMSC_CMT SCC_GE_CMSC_LNK SCC_GE_CMSC_RCM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_GE_EVAL_CATGRY Character(10) VARCHAR2(10) NOT NULL Evaluation Category

    Prompt Table: SCC_GE_CATEGORY

    2 SCC_GE_COMM_SCHEME Character(10) VARCHAR2(10) NOT NULL Committee Scheme
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 SCC_GE_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    6 SCC_GE_DESCRSHORT Character(25) VARCHAR2(25) NOT NULL Short Description

    Default Value: SCC_GE_CMSC_DEF.SCC_GE_DESCR

    7 SCC_GE_RTNG_SCHEME Character(10) VARCHAR2(10) NOT NULL Rating Scheme

    Prompt Table: SCC_GE_RTNG_VW2

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

    Prompt Table: PEOPLE_SRCH

    9 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    10 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    11 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    12 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    13 SCC_GE_EVAL_OVERVW Character(1) VARCHAR2(1) NOT NULL Evaluation Overview
    1=Show All
    2=Show Completed
    3=Do Not Show

    Default Value: 3