STRINGS_LNG_TBL

(SQL Table)
Index Back

Strings Table Related Lang

  • Related Language Record for STRINGS_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROGRAM_ID Character(8) VARCHAR2(8) NOT NULL Program ID
    2 STRING_ID Character(18) VARCHAR2(18) NOT NULL String ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 STR_LBLTYPE Character(1) VARCHAR2(1) NOT NULL String Source
    1=Text
    2=Field Shortname
    3=Field Longname
    5 DEFAULT_LABEL Number(1,0) SMALLINT NOT NULL DEFAULT_LABEL identifys default Field Label of DB Field.
    6 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    7 STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text
    8 COL_WIDTH Number(3,0) SMALLINT NOT NULL Column Width