SCC_GE_SCHM_LVW

(SQL View)
 Index Back

Eval Management Scheme LVw

Evaluation Management System Committee and Individual Evaluator Scheme Related Language View.

SELECT '2' ,A.SCC_GE_EVAL_CATGRY ,A.SCC_GE_COMM_SCHEME ,Y.LANGUAGE_CD ,A.EFFDT ,Y.SCC_GE_DESCR ,Y.SCC_GE_DESCRSHORT FROM PS_SCC_GE_CMSC_DEF A , PS_SCC_GE_CMSC_LNG Y WHERE A.SCC_GE_EVAL_CATGRY = Y.SCC_GE_EVAL_CATGRY AND A.SCC_GE_COMM_SCHEME = Y.SCC_GE_COMM_SCHEME AND A.EFFDT = Y.EFFDT UNION ALL SELECT '3' ,B.SCC_GE_EVAL_CATGRY ,B.SCC_GE_IE_SCHEME ,Z.LANGUAGE_CD ,B.EFFDT ,Z.SCC_GE_DESCR ,Z.SCC_GE_DESCRSHORT FROM PS_SCC_GE_IESC_DEF B , PS_SCC_GE_IESC_LNG Z WHERE B.SCC_GE_EVAL_CATGRY = Z.SCC_GE_EVAL_CATGRY AND B.SCC_GE_IE_SCHEME = Z.SCC_GE_IE_SCHEME AND B.EFFDT = Z.EFFDT

  • Related Language Record for SCC_GE_SCHM_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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