SCC_GE_EC_SCHEM

(SQL Table)
 Index Back

Eval Management Eval Cd Scheme

Evaluation Management System Evaluation Code Associated Schemes table. Stores the Committee and Individual Evaluator Schemes used by the Evaluation Code.

  • Parent record: SCC_GE_EC_DEFN

    • # 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_EVALUATN_CD Character(10) VARCHAR2(10) NOT NULL Evaluation Code

    Prompt Table: SCC_GE_EC_DEFN

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SCC_GE_SCHEME_TYPE Character(1) VARCHAR2(1) NOT NULL Scheme Type
    1=Auto-Calculated
    2=Committee
    3=Individual Evaluator
    5 SCC_GE_SCHEME_NAME Character(10) VARCHAR2(10) NOT NULL Scheme Name

    Prompt Table: SCC_GE_SCHM_VW

    6 SCC_GE_SCHEME_CALC Character(1) VARCHAR2(1) NOT NULL Calculate Option
    1=On-going
    2=When Complete

    Default Value: 1

    7 SCC_GE_PROC_ORDER Number(3,0) SMALLINT NOT NULL Processing Order
    8 SCC_GE_SCHEM_ADMIN Character(11) VARCHAR2(11) NOT NULL Scheme Administrator

    Prompt Table: PEOPLE_SRCH

    9 SCC_GE_PROP_RESULT Character(1) VARCHAR2(1) NOT NULL Propagate results to scheme

    Y/N Table Edit

    Default Value: N

    10 SCC_GE_NOTIFY_OPTN Character(1) VARCHAR2(1) NOT NULL Notification Option
    1=Never
    2=Always

    Default Value: 1

    11 SCC_GE_DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Days
    12 SCC_GE_REMIND_DAYS Number(3,0) SMALLINT NOT NULL Reminder frequency (days)
    13 SCC_GE_1ST_NTF_TMP Character(40) VARCHAR2(40) NOT NULL First Notification Template

    Prompt Table: SCC_GE_NTFTM_VW

    14 SCC_GE_RMD_NTF_TMP Character(40) VARCHAR2(40) NOT NULL Reminder Notification Template

    Prompt Table: SCC_GE_NTFTM_VW

    15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    19 SCC_GE_REMIND_OPTN Character(1) VARCHAR2(1) NOT NULL Reminders Option
    1=No Reminders
    2=Send Reminders
    3=One per Evaluation Code
    4=One per Evaluator

    Default Value: 1

    20 SCC_GE_TM_NTF_OPTN Character(1) VARCHAR2(1) NOT NULL Timeout Notification Option
    1=Do not send Notification
    2=Send Notification

    Default Value: 1

    21 SCC_GE_TM_TMPL_EVA Character(40) VARCHAR2(40) NOT NULL Evaluation Admin Template

    Prompt Table: SCC_GE_NTFTM_VW

    22 SCC_GE_TM_TMPL_ADM Character(40) VARCHAR2(40) NOT NULL Parent Admin Template

    Prompt Table: SCC_GE_NTFTM_VW

    23 SCC_GE_TM_TMPL_EVL Character(40) VARCHAR2(40) NOT NULL Timed Out User Template

    Prompt Table: SCC_GE_NTFTM_VW

    24 SCC_GE_TM_TMPL_OTH Character(40) VARCHAR2(40) NOT NULL Other ID Template

    Prompt Table: SCC_GE_NTFTM_VW

    25 SCC_GE_TM_OTHER_ID Character(11) VARCHAR2(11) NOT NULL Other ID to Notify

    Prompt Table: PEOPLE_SRCH