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 NameField TypeColumn TypeDescription
PROGRAM_IDCharacter(8)VARCHAR2(8) NOT NULLProgram ID
STRING_IDCharacter(18)VARCHAR2(18) NOT NULLString ID
LABEL_IDCharacter(18)VARCHAR2(18) NOT NULLLABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.

Prompt Table: STRINGS_LBL_VW

STR_LBLTYPECharacter(1)VARCHAR2(1) NOT NULLString Source
1=Text
2=Field Shortname
3=Field Longname

Default: 1

DEFAULT_LABELNumber(1,0)SMALLINT NOT NULLDEFAULT_LABEL identifys default Field Label of DB Field.
STRING_TEXTCharacter(100)VARCHAR2(100) NOT NULLString Text
COL_WIDTHNumber(3,0)SMALLINT NOT NULLColumn Width
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19