PSPNLGRPDEFN(SQL Table) |
Index Back |
|---|---|
Panel Group Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | Component Name | |
| 2 | 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 |