PSPNLGRPDEFN(SQL Table) |
Index Back |
---|---|
Panel Group Definition |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
2 | MARKET | Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: GBL |
3 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
4 | ACTIONS | Number(4,0) | SMALLINT NOT NULL | Actions |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | ADDSRCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Additional Search Record Name |
7 | SEARCHRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Search Record Name |
8 | SEARCHPNLNAME | Character(18) | VARCHAR2(18) NOT NULL | Search Panel Name |
9 | LOADLOC | Number(3,0) | SMALLINT NOT NULL | Panel Group Load Location |
10 | SAVELOC | Number(3,0) | SMALLINT NOT NULL | Panel Group Save Locatin |
11 | DISABLESAVE | Number(1,0) | SMALLINT NOT NULL | Disable Saving Panel |
12 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
13 | 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. |
14 | 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. |
15 | PRIMARYACTION | Number(3,0) | SMALLINT NOT NULL | Main action for internet panel |
16 | DFLTACTION | Number(5,0) | INTEGER NOT NULL | Default srch action-internet |
17 | DFLTSRCHTYPE | Number(3,0) | SMALLINT NOT NULL | Dflt Srch Type |
18 | DEFERPROC | Number(1,0) | SMALLINT NOT NULL | Deferred Processing mode |
19 | EXPENTRYPROC | Number(1,0) | SMALLINT NOT NULL | Expert Entry Processing Mode |
20 | REQSECURESSL | Number(1,0) | SMALLINT NOT NULL | Require Secure Protocol (SSL) |
21 | INCLNAVIGATION | Number(1,0) | SMALLINT NOT NULL | Include in Navigation |
22 | FORCESEARCH | Number(1,0) | SMALLINT NOT NULL | Force Search Processing |
23 | ALLOWACTMODESEL | Number(1,0) | SMALLINT NOT NULL | Allow Action Mode Selection |
24 | PNLNAVFLAGS | Number(4,0) | SMALLINT NOT NULL | multi-Panel Navigation flags |
25 | TBARBTNS | Number(10,0) | DECIMAL(10) NOT NULL | Enabled Toolbar Buttons |
26 | SHOWTBAR | Number(2,0) | SMALLINT NOT NULL | show internet toolbar |
27 | ADDLINKMSGSET | Number(5,0) | INTEGER NOT NULL | New Action Msg Set |
28 | ADDLINKMSGNUM | Number(5,0) | INTEGER NOT NULL | New Action Msg Num |
29 | SRCHLINKMSGSET | Number(5,0) | INTEGER NOT NULL | Srch Action Msg Set |
30 | SRCHLINKMSGNUM | Number(5,0) | INTEGER NOT NULL | Srch Action Msg Num |
31 | SRCHTEXTMSGSET | Number(5,0) | INTEGER NOT NULL | Srch Results Msg Set |
32 | SRCHTEXTMSGNUM | Number(5,0) | INTEGER NOT NULL | Srch Results Msg Num |
33 | WSRPCOMPLIANT | Number(1,0) | SMALLINT NOT NULL | WSRP Compliant |
34 | FLUIDMODE | Number(1,0) | SMALLINT NOT NULL | Fluid Mode |
35 | LAYOUTMODE | Number(1,0) | SMALLINT NOT NULL | Layout Mode |
36 | INCFOOTER | Number(1,0) | SMALLINT NOT NULL | Include Footer Page |
37 | INCSIDE | Number(1,0) | SMALLINT NOT NULL | Include Side Page |
38 | INCHEADER | Number(1,0) | SMALLINT NOT NULL | Include Header Page |
39 | INCSEARCH | Number(3,0) | SMALLINT NOT NULL | Include Search Page |
40 | SMALLFFOPT | Number(1,0) | SMALLINT NOT NULL | Display on Small Form Factor |
41 | COMP_TYPE | Number(3,0) | SMALLINT NOT NULL | Component Type |
42 | PNLGRPUSE | Number(10,0) | DECIMAL(10) NOT NULL | Panel Group flags |
43 | DESCRLONG | Long Character | CLOB | Long Description |