SCC_GE_EVALUATN

(SQL Table)
 Index Back

Eval Management Evaluation

Evaluation Management System Evaluation Table. This is the root table for an Evaluation Instance.

  • Parent Record Of SCC_GE_ATCH SCC_GE_CM_SCHEM SCC_GE_CM_SCHVW SCC_GE_EVAL_CMP SCC_GE_IE_SCHEM SCC_GE_IE_SCHVW SCC_GE_SCHORDVW SCC_GE_STU_EVAL SCC_GE_XRF_APPL SCC_GE_XRF_DEMO SCC_GE_XRF_THES

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

    Prompt Table: SCC_GE_EC_DEFN

    3 SCC_GE_EVAL_NBR Number(3,0) SMALLINT NOT NULL Evaluation Code Sequence
    4 SCC_GE_EVAL_CATGRY Character(10) VARCHAR2(10) NOT NULL Evaluation Category

    Default Value: SCC_GE_EC_DEFN.SCC_GE_EVAL_CATGRY

    Prompt Table: SCC_GE_CATEGORY

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

    Default Value: SCC_GE_EC_DEFN.SCC_GE_RTNG_SCHEME

    Prompt Table: SCC_GE_RTNG_VW1

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

    Default Value: SCC_GE_EC_DEFN.SCC_GE_ASSIGN_CD

    Prompt Table: SCC_GE_EC_STAT

    7 SCC_GE_EVAL_DT Date(10) DATE Status Date

    Default Value: %date

    8 SCC_GE_RECOMMENDTN Character(10) VARCHAR2(10) NOT NULL Recommendation Value

    Prompt Table: SCC_GE_EC_RECMD

    9 SCC_GE_RECMD_PRIZE Character(6) VARCHAR2(6) NOT NULL Recommendation Prize
    10 OVERALL_RATING Number(6,2) DECIMAL(5,2) NOT NULL Overall Rating
    11 SCC_GE_OVERALL_RTG Number(12,3) DECIMAL(11,3) NOT NULL Overall Rating
    12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    13 SCC_GE_SETUP_DT Date(10) DATE Evaluation Setup EFFDT

    Default Value: %date

    14 SCC_GE_CMPLTD_DTTM DateTime(26) TIMESTAMP Completed Date
    15 SCC_GE_CMPLT_OPRID Character(30) VARCHAR2(30) NOT NULL Completed By
    16 SCC_GE_ADMIN_USER Character(11) VARCHAR2(11) NOT NULL Administrator

    Prompt Table: PEOPLE_SRCH

    17 SCC_NTFREQ_ID Number(16,0) DECIMAL(16) NOT NULL Notification ID
    18 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    19 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    20 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    21 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    22 SCC_GE_EARLY_DECSN Character(1) VARCHAR2(1) NOT NULL Early Result Flag

    Y/N Table Edit

    Default Value: N

    23 SCC_GE_EARLY_REASN Character(4) VARCHAR2(4) NOT NULL Early Result Reason
    0001=Early Result Rule
    0002=Early Result Admin
    24 SCC_GE_COMMENTS Long Character CLOB Comments