PSPNLDEFN(SQL Table) |
Index Back |
|---|---|
Panel DefinitionPlease remove HELPCONTEXTNUM the next time this record is modified. This will require coding changes that remove it from caching, data structures and SQL statments. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Panel Name | |
| 2 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 3 | PNLTYPE | Number(1,0) | SMALLINT NOT NULL | Panel Type |
| 4 | FIELDCOUNT | Number(4,0) | SMALLINT NOT NULL | Field Count |
| 5 | MAXPNLFLDID | Number(4,0) | SMALLINT NOT NULL | Maximum Page Field ID |
| 6 | GRIDHORZ | Number(4,0) | SMALLINT NOT NULL | Grid - Horizontal |
| 7 | GRIDVERT | Number(4,0) | SMALLINT NOT NULL | Grid - Vertical |
| 8 | HELPCONTEXTNUM | Number(10,0) | DECIMAL(10) NOT NULL | Help Context Number |
| 9 | PANELTOP | Number(4,0) | SMALLINT NOT NULL | Panel Top |
| 10 | PANELLEFT | Number(4,0) | SMALLINT NOT NULL | Panel Left |
| 11 | PANELRIGHT | Number(4,0) | SMALLINT NOT NULL | Panel Right |
| 12 | PANELBOTTOM | Number(4,0) | SMALLINT NOT NULL | Panel Bottom |
| 13 | PNLSTYLE | Character(30) | VARCHAR2(30) NOT NULL |
Panel Style Name
Prompt Table: PSSTYLEDEFN |
| 14 | STYLESHEETNAME | Character(30) | VARCHAR2(30) NOT NULL | Style Sheet Name (see PSSTYLSHEETDEFN). |
| 15 | FFSTYLESHEETNAME | Character(30) | VARCHAR2(30) NOT NULL | Style Sheet Name |
| 16 | PNLUSE | Number(5,0) | INTEGER NOT NULL | Panel Use |
| 17 | DEFERPROC | Number(1,0) | SMALLINT NOT NULL | Deferred Processing mode |
| 18 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 19 | POPUPMENU | Character(30) | VARCHAR2(30) NOT NULL | Popup Menu |
| 20 | LICENSE_CODE | Character(64) | VARCHAR2(64) NOT NULL | License Code |
| 21 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 22 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 23 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 24 | FFSTYLEDESKTOP | Character(100) | VARCHAR2(100) NOT NULL | Desktop Free Form Style |
| 25 | FFSTYLEPHONE | Character(100) | VARCHAR2(100) NOT NULL | Phone Free Form Style |
| 26 | FFSTYLETABLET | Character(100) | VARCHAR2(100) NOT NULL | Tablet Free Form Style |
| 27 | PNLUSETEMP | Number(5,0) | INTEGER NOT NULL | Panel Use |
| 28 | FFSTYLEMEDIUM | Character(100) | VARCHAR2(100) NOT NULL | Free Form Style for Medium FF |
| 29 | FFSTYLEEXLARGE | Character(100) | VARCHAR2(100) NOT NULL | Free Form Style Extra Large |
| 30 | DESCRLONG | Long Character | CLOB | Long Description |