PNLFIELD_VW

Platform	View Text
Default	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	Description
PNLNAME	Page Name Prompt Table: PSPNLDEFN_VW
PNLFLDID	Page Field ID
FIELDNUM	Field Number
FIELDTYPE	Field Type
LBLTYPE	Label Type 0=None 1=Text 2=RFT Short 3=RFT Long
LBLTEXT	Label Text
FIELDUSE	Panel Field Use
RECNAME	Record (Table) Name Prompt Table: PSRECDEFN
FIELDNAME	Field Name Prompt Table: PSDBFIELD

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010