PORTAL_IDX_VW

(SQL View)
 Index Back

SELECT X.FIELDVALUE , X.XLATLONGNAME FROM PSLANGUAGES A , PSXLATITEM X WHERE A.INSTALLED = 1 AND X.FIELDNAME = 'LANGUAGE_CD' AND A.LANGUAGE_CD = X.FIELDVALUE

  • Related Language Record: PORTAL_IDXLG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name