XREF_PANEL_VW (SQL View)	Index Back
Records used on panels

XREF_PANEL_VW

(SQL View)

Records used on panels

SELECT recname , pnlname , fieldname , lbltype FROM PSPNLFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).

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

4 LBLTYPE_CHAR Character(1) VARCHAR2(1) NOT NULL Label Type
0=None
1=Text
2=RFT Short
3=RFT Long
4=Xlat Short
5=Xlat Long
6=Image
7=Message Catalog (Not Impl.)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Panel Name (see PSPNLDEFN).
3	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
4	LBLTYPE_CHAR	Character(1)	VARCHAR2(1) NOT NULL	Label Type 0=None 1=Text 2=RFT Short 3=RFT Long 4=Xlat Short 5=Xlat Long 6=Image 7=Message Catalog (Not Impl.)