PST_PNLFIELDS(SQL Table) |
Index Back |
|---|---|
Upgrader Panel Work |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SRC_TGT | Character(1) | VARCHAR2(1) NOT NULL | Source/Target Indicator |
| 2 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 3 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 4 | EDITSIZE | Number(5,0) | INTEGER NOT NULL | Currently Not Used |
| 5 | DSPLFORMAT | Number(10,0) | DECIMAL(10) NOT NULL | Display Format |
| 6 | FIELDLEFT | Number(4,0) | SMALLINT NOT NULL | Field Left |
| 7 | FIELDTOP | Number(4,0) | SMALLINT NOT NULL | Field Top |
| 8 | FIELDRIGHT | Number(4,0) | SMALLINT NOT NULL | Field Right |
| 9 | FIELDBOTTOM | Number(4,0) | SMALLINT NOT NULL | Field Bottom |
| 10 | EDITLBLLEFT | Number(4,0) | SMALLINT NOT NULL | Edit Label Left |
| 11 | EDITLBLTOP | Number(4,0) | SMALLINT NOT NULL | Edit Label Top |
| 12 | EDITLBLRIGHT | Number(4,0) | SMALLINT NOT NULL | Edit Label Right |
| 13 | EDITLBLBOTTOM | Number(4,0) | SMALLINT NOT NULL | Edit Label Bottom |
| 14 | DSPLFILL | Character(1) | VARCHAR2(1) NOT NULL | Display Fill Character |
| 15 | LBLTYPE | Number(1,0) | SMALLINT NOT NULL | Label Type |
| 16 | LBLLOC | Number(1,0) | SMALLINT NOT NULL | Label Location |
| 17 | LBLPADSIZE | Number(5,0) | INTEGER NOT NULL | Currently Not Used |
| 18 | LBLTEXT | Character(60) | VARCHAR2(60) NOT NULL | Label Text |
| 19 | FIELDUSE | Number(10,0) | DECIMAL(10) NOT NULL | Panel Field Use |
| 20 | OCCURSLEVEL | Number(1,0) | SMALLINT NOT NULL | Occurs level |
| 21 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 22 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD |
| 23 | ONVALUE | Character(4) | VARCHAR2(4) NOT NULL |
On Value
Prompt Table: XLATTABLE_VW |
| 24 | OFFVALUE | Character(4) | VARCHAR2(4) NOT NULL |
Off Value
Prompt Table: XLATTABLE_VW |
| 25 | ASSOCFIELDNUM | Number(4,0) | SMALLINT NOT NULL | Associated Field Number |
| 26 | OCCURSCOUNT1 | Number(2,0) | SMALLINT NOT NULL | Occurs Count First Level |
| 27 | OCCURSOFFSET1 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset First Level |
| 28 | OCCURSCOUNT2 | Number(2,0) | SMALLINT NOT NULL | Occurs Count Second Level |
| 29 | OCCURSOFFSET2 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset Second Level |
| 30 | OCCURSCOUNT3 | Number(2,0) | SMALLINT NOT NULL | Occurs Count Third Level |
| 31 | OCCURSOFFSET3 | Number(4,0) | SMALLINT NOT NULL | Occurs Offset Third Level |
| 32 | HELPCONTEXTNUM | Number(10,0) | DECIMAL(10) NOT NULL | Help Context Number |
| 33 | SUBPNLNAME | Character(18) | VARCHAR2(18) NOT NULL |
SubPanel Name
Prompt Table: PSPNLDEFN_VW |
| 34 | SUBPNLVER | Number(10,0) | DECIMAL(10) NOT NULL | SubPanel Version Number |
| 35 | FIELDSTYLE | Character(30) | VARCHAR2(30) NOT NULL |
Field Style Name
Prompt Table: PSSTYLEDEFN |
| 36 | LABELSTYLE | Character(30) | VARCHAR2(30) NOT NULL |
Label Style Name
Prompt Table: PSSTYLEDEFN |
| 37 | FIELDSIZETYPE | Number(1,0) | SMALLINT NOT NULL | Field Size Type |
| 38 | LABELSIZETYPE | Number(1,0) | SMALLINT NOT NULL | Label Position |
| 39 | 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 |
| 40 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PRCSTYPE_VW |
| 41 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Prompt Table: PRCSDEFN |
| 42 | PROMPTFIELD | Character(18) | VARCHAR2(18) NOT NULL | Dropdown Prompt Field |
| 43 | FORMATFAMILY | Character(15) | VARCHAR2(15) NOT NULL | Format Family Name (see PSFMTDEFN). |
| 44 | DISPFMTNAME | Character(15) | VARCHAR2(15) NOT NULL | Display Format Name (see PSFMTITEM). |
| 45 | POPUPMENU | Character(30) | VARCHAR2(30) NOT NULL | Popup Menu |
| 46 | TREECTRLID | Number(3,0) | SMALLINT NOT NULL | Tree Control ID |
| 47 | TREECTRLTYPE | Number(3,0) | SMALLINT NOT NULL | Tree Control Type |
| 48 | MULTIRECTREE | Number(3,0) | SMALLINT NOT NULL | Multi Record Tree |
| 49 | NODECOUNT | Number(3,0) | SMALLINT NOT NULL | Node Count |
| 50 | GRDCOLUMNCOUNT | Number(3,0) | SMALLINT NOT NULL | Grid Column Count |
| 51 | GRDSHOWCOLHDG | Number(3,0) | SMALLINT NOT NULL | Grid Show Column Heading |
| 52 | GRDSHOWROWHDG | Number(3,0) | SMALLINT NOT NULL | Grid Show Row Heading |
| 53 | GRDCOLHDGSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Column Heading Style |
| 54 | GRDODDROWSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Odd Row Style |
| 55 | GRDEVENROWSTYLE | Character(30) | VARCHAR2(30) NOT NULL | Grid Even Row Style |
| 56 | GRDLBLMSGSET | Number(3,0) | SMALLINT NOT NULL | Grid Label Message Set |
| 57 | GRDLBLMSGNUM | Number(3,0) | SMALLINT NOT NULL | Grid Label Message Number |
| 58 | GRDLBLALIGN | Number(3,0) | SMALLINT NOT NULL | Grid Label Alignment |
| 59 | GRDACTTYPE | Number(3,0) | SMALLINT NOT NULL | Grid Action Type |
| 60 | GRDACTRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Grid Action Record Name |
| 61 | GRDACTFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Grid Action Field Name |
| 62 | GRDACTPNLNAME | Character(18) | VARCHAR2(18) NOT NULL | Grid Action Panel Name |