LANG_STRINGS_VW

index back

Retrieves translated strings

Record used in the Translate Strings page.
SELECT PROGRAM_ID , STRING_ID , LANGUAGE_CD , STR_LBLTYPE , DEFAULT_LABEL , LABEL_ID , STRING_TEXT , COL_WIDTH FROM PS_STRINGS_LNG_TBL

PeopleSoft Field Name Field Type Column Type Description
PROGRAM_ID Character(8) VARCHAR2(8) NOT NULL Program ID
STRING_ID Character(18) VARCHAR2(18) NOT NULL String ID
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
STR_LBLTYPE Character(1) VARCHAR2(1) NOT NULL String Source
1=Text
2=Field Shortname
3=Field Longname
DEFAULT_LABEL Number(1,0) SMALLINT NOT NULL DEFAULT_LABEL identifys default Field Label of DB Field.
LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

Prompt Table: SEL_LABEL_ID_VW

STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text
COL_WIDTH Number(3,0) SMALLINT NOT NULL Column Width

Default: BASE_STRINGS_VW.COL_WIDTH

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19