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 | PNLNAME | 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 |