IT_SRCH_FILL_LG

(SQL View)
 Index Back

Lang View


SELECT A.SEARCH_NAME , A.FIELDNUM , B.LANGUAGE_CD , B.LONGNAME FROM %Table(IT_SEARCH_01) A , %Table(PSDBFLDLABLLANG) B WHERE A.FIELDNAME = B.FIELDNAME AND A.LABEL_ID = B.LABEL_ID AND A.ACTIVE_STATUS = 'A'

  • Related Language Record for IT_SEARCH_FILL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SEARCH_NAME Character(30) VARCHAR2(30) NOT NULL Search Name
    2 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label