PNLFIELD_VW

index back

Panel Field Translation View


SELECT A.PNLNAME , A.PNLFLDID , A.FIELDNUM , A.FIELDTYPE , A.LBLTYPE , A.LBLTEXT , A.FIELDUSE , A.RECNAME , A.FIELDNAME FROM PSPNLFIELD A WHERE A.FIELDTYPE IN (0,2,4,5,6,7,8,12) AND A.LBLTYPE = 1 AND (A.LBLTEXT <> '' OR A.LBLTEXT <> ' ')

PeopleSoft Field Name Field Type Column Type Description
PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

Prompt Table: PSPNLDEFN_VW

PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
LBLTYPE Number(1,0) SMALLINT NOT NULL Label Type
0=None
1=Text
2=RFT Short
3=RFT Long
LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSDBFIELD

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19