index back

DBField Label Table

PSDBFLDLABL contains Field Labels for DBField. FIELDNAME represents DBField name. LABEL_ID is an unique ID of Field Label. LONGNAME and SHORTNAME are actual names used in a panel. DEFAULT_LABEL indicates the default Field Label.

PeopleSoft Field Name Field Type Column Type Description
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
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 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20