SCC_GE_EC_DEFN

(SQL Table)
 Index Back

Eval Management Eval Code Defn

Evaluation Management System Evaluation Code Definition table.

  • Related Language Record: SCC_GE_ECDF_LNG

  • Parent Record Of SCC_GE_EC_LINK SCC_GE_EC_RECMD SCC_GE_EC_SCHEM SCC_GE_EC_STAT SCC_GE_ELNK_LNG

    • # 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
    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_EC_DEFN.SCC_GE_DESCR

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

    Prompt Table: SCC_GE_RTNG_VW1

    8 SCC_GE_ASSIGN_CD Character(6) VARCHAR2(6) NOT NULL Assignment Status Code

    Prompt Table: SCC_GE_STAT_CD
    Set Control Field: SCC_GE_EVAL_STATUS

    9 SCC_GE_FINAL_CD Character(6) VARCHAR2(6) NOT NULL Final Status Code

    Prompt Table: SCC_GE_STAT_CD
    Set Control Field: SCC_GE_EVAL_STATUS

    10 SCC_GE_HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Status Code

    Prompt Table: SCC_GE_STAT_CD
    Set Control Field: SCC_GE_EVAL_STATUS

    11 SCC_GE_ADMIN_USER Character(11) VARCHAR2(11) NOT NULL Administrator

    Prompt Table: PEOPLE_SRCH

    12 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    13 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFIELDDB

    14 SCC_SL_LOV_CONTEXT Character(25) VARCHAR2(25) NOT NULL LOV Context

    Prompt Table: SCC_GE_LOV_CTXT

    15 SCC_GE_USE_WRKFLOW Character(1) VARCHAR2(1) NOT NULL Use Workflow Processing

    Y/N Table Edit

    Default Value: N

    16 SCC_GE_WRKFLW_OPTN Character(1) VARCHAR2(1) NOT NULL Start Workflow Processing

    Y/N Table Edit

    Default Value: N

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

    Default Value: 1

    18 SCC_GE_DUE_DAYS Number(3,0) SMALLINT NOT NULL Due Days
    19 SCC_GE_REMIND_DAYS Number(3,0) SMALLINT NOT NULL Reminder frequency (days)
    20 SCC_GE_1ST_NTF_TMP Character(40) VARCHAR2(40) NOT NULL First Notification Template

    Prompt Table: SCC_GE_NTFTM_VW

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

    Prompt Table: SCC_GE_NTFTM_VW

    22 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    23 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    24 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    25 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    26 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

    27 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

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

    Prompt Table: SCC_GE_NTFTM_VW

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

    Prompt Table: SCC_GE_NTFTM_VW

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

    Prompt Table: PEOPLE_SRCH

    31 SCC_GE_RTSC_WK_OPT Character(1) VARCHAR2(1) NOT NULL Calculated Scheme Option
    1=Do Not Hold Workflow
    2=Hold Workflow

    Default Value: 1

    32 SCC_GE_EARLY_RULE Character(40) VARCHAR2(40) NOT NULL Early Result Rule

    Prompt Table: SCC_GE_RULE_VW3

    33 SCC_GE_COMMENTS Long Character CLOB Comments