index back


This view contains default longname and shortname from PSDBFLDLABLLANG table.
SELECT a.fieldname ,a.language_cd ,a.longname , a.shortname FROM PSDBFLDLABLLANG a ,psdbfldlabl b WHERE a.fieldname = b.fieldname AND a.label_id = b.label_id AND b.default_label = 1

  • Related language record for PSDBFLDLABL_VW
  • PeopleSoft Field Name Field Type Column Type Description
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20