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