GB_XLAT_FLD_LNG

(SQL View)
 Index Back

GB Xlat Fields View

This view returns all the fields that are defined as Xlat

SELECT B.LANGUAGE_CD , A.FIELDNAME FROM PSDBFIELD A , PSXLATITEMLANG B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDTYPE = 0 AND A.LENGTH <= 4 AND %EffdtCheck(PSXLATITEMLANG, B, %CurrentDateIn)

  • Related Language Record for GB_XLAT_FLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).