SCC_GE_SCHM_VW

(SQL View)
 Index Back

Eval Management Scheme View

Evaluation Management System Scheme View. Returns Committee or Individual Evaluator Scheme Names for a Category and Scheme Type.

SELECT '2' ,A.SCC_GE_EVAL_CATGRY ,A.SCC_GE_COMM_SCHEME ,A.EFFDT ,A.EFF_STATUS ,A.SCC_GE_DESCR ,A.SCC_GE_DESCRSHORT ,A.SCC_GE_RTNG_SCHEME ,' ' ,A.SCC_GE_SCHEM_ADMIN ,A.SCC_ROW_ADD_OPRID ,A.SCC_ROW_ADD_DTTM ,A.SCC_ROW_UPD_OPRID ,A.SCC_ROW_UPD_DTTM FROM PS_SCC_GE_CMSC_DEF A UNION ALL SELECT '3' ,B.SCC_GE_EVAL_CATGRY ,B.SCC_GE_IE_SCHEME ,B.EFFDT ,B.EFF_STATUS ,B.SCC_GE_DESCR ,B.SCC_GE_DESCRSHORT ,B.SCC_GE_RTNG_SCHEME ,B.SCC_GE_ASSIGN_OPTN ,B.SCC_GE_SCHEM_ADMIN ,B.SCC_ROW_ADD_OPRID ,B.SCC_ROW_ADD_DTTM ,B.SCC_ROW_UPD_OPRID ,B.SCC_ROW_UPD_DTTM FROM PS_SCC_GE_IESC_DEF B

  • Related Language Record: SCC_GE_SCHM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_GE_SCHEME_TYPE Character(1) VARCHAR2(1) NOT NULL Scheme Type
    1=Auto-Calculated
    2=Committee
    3=Individual Evaluator
    2 SCC_GE_EVAL_CATGRY Character(10) VARCHAR2(10) NOT NULL Evaluation Category

    Prompt Table: SCC_GE_CATEGORY

    3 SCC_GE_SCHEME_NAME Character(10) VARCHAR2(10) NOT NULL Scheme Name
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    6 SCC_GE_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    7 SCC_GE_DESCRSHORT Character(25) VARCHAR2(25) NOT NULL Short Description
    8 SCC_GE_RTNG_SCHEME Character(10) VARCHAR2(10) NOT NULL Rating Scheme

    Prompt Table: SCC_GE_RTNG_VW2

    9 SCC_GE_ASSIGN_OPTN Character(1) VARCHAR2(1) NOT NULL Assign Evaluators By
    1=ID
    10 SCC_GE_SCHEM_ADMIN Character(11) VARCHAR2(11) NOT NULL Scheme Administrator
    11 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    12 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    13 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    14 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time