PSDBFLDLABL_V

index back

Translation view

This view is used by TRANSLATE_MPGITEM and should not be changed.
SELECT A.FIELDNAME , A.LABEL_ID , A.LONGNAME , A.SHORTNAME , A.DEFAULT_LABEL FROM PSDBFLDLABL A , PSMPCONTDEV B WHERE B.BCITEMNAME = A.FIELDNAME

  • Related language record: PSDBFLDLABLLG_V
  • PeopleSoft Field Name Field Type Column Type Description
    BCITEMNAME Character(30) VARCHAR2(30) NOT NULL BC Item Logical Name
    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