SEL_LABEL_ID_VW

index back

Displays TRANSLATED label IDs

Record used in the Translate Strings page.
SELECT DISTINCT A.FIELDNAME ,A.LANGUAGE_CD , A.LABEL_ID , A.LONGNAME , A.SHORTNAME , B.DEFAULT_LABEL FROM PSDBFLDLABLLANG A , PSDBFLDLABL B WHERE A.FIELDNAME = B.FIELDNAME AND A.LABEL_ID = B.LABEL_ID

PeopleSoft Field Name Field Type Column Type Description
STRING_ID Character(18) VARCHAR2(18) NOT NULL String ID
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values

Default: LANG_STRINGS_VW.LANGUAGE_CD

LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
DEFAULT_LABEL Number(1,0) SMALLINT NOT NULL DEFAULT_LABEL identifys default Field Label of DB Field.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19