PORTAL_IDXLG_VW

(SQL View)
Index Back

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

  • Related Language Record for PORTAL_IDX_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name