PST_PNLFIELDS |
index back |
|---|---|
Upgrader Panel Work |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| SRC_TGT | Character(1) | VARCHAR2(1) NOT NULL | Source/Target Indicator |
| FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101) |
| EDITSIZE | Number(5,0) | INTEGER NOT NULL | Currently Not Used |
| DSPLFORMAT | Number(10,0) | DECIMAL(10) NOT NULL | Display Format |
| FIELDLEFT | Number(4,0) | SMALLINT NOT NULL | Field Left |
| FIELDTOP | Number(4,0) | SMALLINT NOT NULL | Field Top |
| FIELDRIGHT | Number(4,0) | SMALLINT NOT NULL | Field Right |
| FIELDBOTTOM | Number(4,0) | SMALLINT NOT NULL | Field Bottom |
| EDITLBLLEFT | Number(4,0) | SMALLINT NOT NULL | Edit Label Left |
| EDITLBLTOP | Number(4,0) | SMALLINT NOT NULL | Edit Label Top |
| EDITLBLRIGHT | Number(4,0) | SMALLINT NOT NULL | Edit Label Right |
| EDITLBLBOTTOM | Number(4,0) | SMALLINT NOT NULL | Edit Label Bottom |
| DSPLFILL | Character(1) | VARCHAR2(1) NOT NULL | Display Fill Character |
| LBLTYPE | Number(1,0) | SMALLINT NOT NULL |
Label Type
0=None 1=Text 2=RFT Short 3=RFT Long |
| LBLLOC | Number(1,0) | SMALLINT NOT NULL | Label Location |
| LBLPADSIZE | Number(5,0) | INTEGER NOT NULL | Currently Not Used |
| LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| FIELDUSE | Number(10,0) | DECIMAL(10) NOT NULL | Panel Field Use |
| OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
| RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD |
| ONVALUE | Character(4) | VARCHAR2(4) NOT NULL |
On Value
Prompt Table: XLATTABLE_VW |
| OFFVALUE | Character(4) | VARCHAR2(4) NOT NULL |
Off Value
Prompt Table: XLATTABLE_VW |
| ASSOCFIELDNUM | Number(4,0) | SMALLINT NOT NULL | Associated Field Number |
| OCCURSCOUNT1 | Number(2,0) | SMALLINT NOT NULL | Occurs Count First Level |
| OCCURSOFFSET1 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset First Level |
| OCCURSCOUNT2 | Number(2,0) | SMALLINT NOT NULL | Occurs Count Second Level |
| OCCURSOFFSET2 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset Second Level |
| OCCURSCOUNT3 | Number(2,0) | SMALLINT NOT NULL | Occurs Count Third Level |
| OCCURSOFFSET3 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset Third Level |
| HELPCONTEXTNUM | Number(10,0) | DECIMAL(10) NOT NULL | Help Context Number |
| SUBPNLNAME | Character(18) | VARCHAR2(18) NOT NULL |
SubPanel Name
Prompt Table: PSPNLDEFN_VW |
| SUBPNLVER | Number(10,0) | DECIMAL(10) NOT NULL | SubPanel Version Number |
| FIELDSTYLE | Character(30) | VARCHAR2(30) NOT NULL |
Field Style Name
Prompt Table: PSSTYLEDEFN |
| LABELSTYLE | Character(30) | VARCHAR2(30) NOT NULL |
Label Style Name
Prompt Table: PSSTYLEDEFN |
| FIELDSIZETYPE | Number(1,0) | SMALLINT NOT NULL | Field Size Type |
| LABELSIZETYPE | Number(1,0) | SMALLINT NOT NULL | Label Position |
| IMAGE_FMT | Number(2,0) | SMALLINT NOT NULL |
Image FormatOnly set for FIELDTYPE of Images and Attachments.
1=BMP - Bitmaps 2=CUT - HALO Image 3=DIB - Bitmaps 4=EPS - Postscript 5=GIF - Graphics Int Format 6=JPG - JPEG 7=PCT - Macintosh 8=PCX - Zsoft 9=RLE - Bitmaps 10=TGA - Targa 16=Attachment |
| PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PRCSTYPE_VW |
| PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Prompt Table: PRCSDEFN |
| PROMPTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Dropdown Prompt Field |
| FORMATFAMILY | Character(15) | VARCHAR2(15) NOT NULL | Format Family Name (see PSFMTDEFN). |
| DISPFMTNAME | Character(15) | VARCHAR2(15) NOT NULL | Display Format Name (see PSFMTITEM). |
| POPUPMENU | Character(30) | VARCHAR2(30) NOT NULL | Popup Menu |
| TREECTRLID | Number(3,0) | SMALLINT NOT NULL | Tree Control ID |
| TREECTRLTYPE | Number(3,0) | SMALLINT NOT NULL | Tree Control Type |
| MULTIRECTREE | Number(3,0) | SMALLINT NOT NULL | Multi Record Tree |
| NODECOUNT | Number(3,0) | SMALLINT NOT NULL | Node Count |
| GRDCOLUMNCOUNT | Number(3,0) | SMALLINT NOT NULL | Grid Column Count |
| GRDSHOWCOLHDG | Number(3,0) | SMALLINT NOT NULL | Grid Show Column Heading |
| GRDSHOWROWHDG | Number(3,0) | SMALLINT NOT NULL | Grid Show Row Heading |
| GRDCOLHDGSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Column Heading Style |
| GRDODDROWSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Odd Row Style |
| GRDEVENROWSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Even Row Style |
| GRDLBLMSGSET | Number(3,0) | SMALLINT NOT NULL | Grid Label Message Set |
| GRDLBLMSGNUM | Number(3,0) | SMALLINT NOT NULL | Grid Label Message Number |
| GRDLBLALIGN | Number(3,0) | SMALLINT NOT NULL | Grid Label Alignment |
| GRDACTTYPE | Number(3,0) | SMALLINT NOT NULL | Grid Action Type |
| GRDACTRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Grid Action Record Name |
| GRDACTFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Grid Action Field Name |
| GRDACTPNLNAME | Character(18) | VARCHAR2(18) NOT NULL | Grid Action Panel Name |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |