XREF_PANEL_VW

(SQL View)
Index Back

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.)