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 NameField TypeColumn TypeDescription
PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).

Prompt Table: PSPNLDEFN_VW

PNLFLDIDNumber(4,0)SMALLINT NOT NULLPage Field ID
FIELDNUMNumber(4,0)SMALLINT NOT NULLField Number
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
LBLTYPENumber(1,0)SMALLINT NOT NULLLabel Type
0=None
1=Text
2=RFT Short
3=RFT Long
LBLTEXTCharacter(60)VARCHAR2(60) NOT NULLLabel Text
FIELDUSENumber(10,0)DECIMAL(10) NOT NULLPanel Field Use
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

Prompt Table: PSDBFIELD

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