SCC_GE_CATGYLVW

(SQL View)
 Index Back

Eval Management Ctgry PSel LVW

Evaluation Management System Related Language View for Population Selection Application Context.

SELECT A.SCC_GE_EVAL_CATGRY ,B.LANGUAGE_CD ,B.SCC_GE_DESCR FROM PS_SCC_GE_CATEGORY A , PS_SCC_GE_CTGY_LNG B WHERE A.SCC_GE_EVAL_CATGRY = B.SCC_GE_EVAL_CATGRY UNION ALL SELECT X.FIELDVALUE , Y.LANGUAGE_CD , X.XLATLONGNAME FROM PSXLATITEM X , PSXLATITEMLANG Y WHERE X.FIELDNAME = 'SCC_GE_ALL_CATEGRY' AND X.FIELDVALUE = 'ALL' AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn) AND X.EFF_STATUS='A' AND Y.FIELDNAME = X.FIELDNAME AND Y.FIELDVALUE = X.FIELDVALUE AND Y.EFFDT = X.EFFDT AND EXISTS ( SELECT 'X' FROM PS_SCC_GE_CTGY_LNG Z WHERE Z.LANGUAGE_CD = Y.LANGUAGE_CD )

  • Related Language Record for SCC_GE_CATGRYVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_GE_EVAL_CATGRY Character(10) VARCHAR2(10) NOT NULL Evaluation Category
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 SCC_GE_DESCR Character(50) VARCHAR2(50) NOT NULL Description