BASE_STRINGS_VW

index back

Retrieves base lang strings

Record used in the Translate Strings page
SELECT PROGRAM_ID , STRING_ID , LABEL_ID , STR_LBLTYPE , DEFAULT_LABEL , STRING_TEXT , COL_WIDTH FROM PS_STRINGS_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
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: STRINGS_LBL_VW

STR_LBLTYPE Character(1) VARCHAR2(1) NOT NULL String Source
1=Text
2=Field Shortname
3=Field Longname

Default: 1

DEFAULT_LABEL Number(1,0) SMALLINT NOT NULL DEFAULT_LABEL identifys default Field Label of DB Field.
STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text
COL_WIDTH Number(3,0) SMALLINT NOT NULL Column Width
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19