STRINGS_LBL_VW

index back

DBField Label View for Strings

This view is used by the Strings Table to provide a list of labels for a particular field when the RFT Long or RFT Short labels are used to derive the text of a string
SELECT A.FIELDNAME, A.LABEL_ID, A.LONGNAME, A.SHORTNAME, A.DEFAULT_LABEL FROM PSDBFLDLABL A

PeopleSoft Field Name Field Type Column Type Description
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.
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