PSOPTIONS(SQL Table) |
Index Back |
|---|---|
PeopleTools System OptionsThis is a single row table containing PeopleTools system options chosen. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MULTIJOB | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Jobs Allowed
Y/N Table Edit Default Value: N |
| 2 | SYSTEMTYPE | Character(3) | VARCHAR2(3) NOT NULL |
System Type
CNV=Conversion Database DEV=Development Database DMO=Demo Database INT=Integration Test Database PAR=Parallel Test Database PRD=Production Database SND=Sandbox Database STG=Stage Database STS=System Test Database TRN=Training Database UAT=User Acceptance Test Database UND=Undefined Database |
| 3 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |
| 4 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 5 | MULTICOMPANY | Character(1) | VARCHAR2(1) NOT NULL |
Multi-Company Organization
Y/N Table Edit Default Value: N |
| 6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
Default Value: ENG |
| 7 | HELP_CONTEXT_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last Help Context # Used |
| 8 | MULTICURRENCY | Character(1) | VARCHAR2(1) NOT NULL |
Multi-Currency
Y/N Table Edit Default Value: N |
| 9 | GRANT_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Grant Access
Y/N Table Edit Default Value: Y |
| 10 | STATS_GATHER | Character(1) | VARCHAR2(1) NOT NULL |
Gather Statistics Globally
Y/N Table Edit Default Value: N |
| 11 | STATS_TABLE | Character(1) | VARCHAR2(1) NOT NULL |
Gather Statistics for Table
Y/N Table Edit Default Value: N |
| 12 | STATS_TIMER | Number(10,0) | DECIMAL(10) NOT NULL |
Write Interval
Default Value: 300 |
| 13 | STATS_START | DateTime(26) | TIMESTAMP NOT NULL | Start Time For Stats Gathering |
| 14 | STATS_STOP | DateTime(26) | TIMESTAMP NOT NULL | Stop Time For Stats Gathering |
| 15 | NVSUSEBUSUNIT | Character(1) | VARCHAR2(1) NOT NULL |
Use Business Unit in nVision
Y/N Table Edit Default Value: Y |
| 16 | BACKGRNDDISCINT | Number(5,0) | INTEGER NOT NULL |
Background Disconnect Interval
Default Value: 0 |
| 17 | CHGCTL_USE_HISTORY | Character(1) | VARCHAR2(1) NOT NULL |
Use Change Control History
Y/N Table Edit Default Value: N |
| 18 | CHGCTL_USE_LOCKING | Character(1) | VARCHAR2(1) NOT NULL |
Use Change Control Locking
Y/N Table Edit Default Value: N |
| 19 | TRANS_CHG_LASTUPD | Character(1) | VARCHAR2(1) NOT NULL |
Last translation change
Y/N Table Edit Default Value: N |
| 20 | DBLENGTHTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Database Length check type
D=DB2 EBCDIC Multi-Byte M=Multi-Byte Database N=Other Types Default Value: N |
| 21 | TEMPTBLINSTANCES | Number(4,0) | SMALLINT NOT NULL | Temp Table Instances (Total) |
| 22 | TEMPINSTANCEBATCH | Number(4,0) | SMALLINT NOT NULL | Temp Table Instances (Batch) |
| 23 | TEMPINSTANCEONLINE | Number(4,0) | SMALLINT NOT NULL | Temp Table Instances (Online) |
| 24 | AEOPTTRC | Character(1) | VARCHAR2(1) NOT NULL |
Allow DB Optimizer Trace
Y/N Table Edit |
| 25 | APMSGMAXMSGSIZE | Number(10,0) | DECIMAL(10) NOT NULL |
This field is used by Application Messaging on the PSOPTIONS table. It is the upper limit for the physical application message size.
Default Value: 1000000 |
| 26 | MAXCHUNKSIZE | Number(10,0) | DECIMAL(10) NOT NULL |
Maximum Attachment Chunk Size
Default Value: 28000 |
| 27 | IBMAXNBRSEGMENTS | Number(4,0) | SMALLINT NOT NULL |
Maximum Number of Segments per Message
Default Value: 10 |
| 28 | BSE_TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL |
Base Time Zone
Prompt Table:
PSTIMEZONE
|
| 29 | CASEINSSEARCH | Character(1) | VARCHAR2(1) NOT NULL |
Case Insensitive seach option in PSOPTIONS
N=Off S=On - CaseSensitive Default On Y=On - CaseSensitive Default Off Default Value: Y |
| 30 | STYLESHEETNAME | Character(30) | VARCHAR2(30) NOT NULL |
Style Sheet Name (see PSSTYLSHEETDEFN).
Prompt Table: PSSTYLESHEET_VW |
| 31 | ICLIENTURL | Character(254) | VARCHAR2(254) NOT NULL | IA Server URL |
| 32 | LICENSE_CODE | Character(64) | VARCHAR2(64) NOT NULL | License Code |
| 33 | LICENSE_GROUP | Character(50) | VARCHAR2(50) NOT NULL | License Group |
| 34 | TIMEOUTMINUTES | Number(5,0) | INTEGER NOT NULL | Time out minutes |
| 35 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN_SRCH |
| 36 | AUTHTOKENTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Holds a character code that indicate the method an app server uses to issue single-signon authentication tokens.
C=Use Certificate P=User Password |
| 37 | COLLATION_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Collation Type Information
000=Binary Sorting B00=Latin1 (Default) B01=Canadian French (General) B02=Danish (General) B03=Dutch (General) B04=Spanish (General) B05=French (General) B06=German (General) B07=Italian (General) B08=Japanese (General) B09=Portuguese (General) B10=Swedish (General) B11=Simplified Chinese (General) B12=Traditional Chinese (General) B13=Danish (Linguistic) B14=Dutch (Linguistic) B15=Spanish (Linguistic) B16=French (Linguistic) B17=German (Linguistic) B18=Italian (Linguistic) B19=Portuguese (Linguistic) B20=Swedish (Linguistic) B21=Japanese (Linguistic) B22=English Default Value: 000 |
| 38 | PLATCOMPAT | Character(1) | VARCHAR2(1) NOT NULL |
Platform Compatibility mode setting
Y/N Table Edit Default Value: N |
| 39 | DB2ALLCCSIDOK | Character(1) | VARCHAR2(1) NOT NULL |
Allow NT batch when CCSID<>37
Y/N Table Edit Default Value: N |
| 40 | COMMITLIMIT | Number(10,0) | DECIMAL(10) NOT NULL |
Upgrade Project Commit Limit
Default Value: 50 |
| 41 | PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Default Value: PT_BRANDING |
| 42 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Default Value: BrandingBase |
| 43 | USETREELOCKING | Character(1) | VARCHAR2(1) NOT NULL |
Use Tree Update Reservation
Y/N Table Edit Default Value: N |
| 44 | TREEINACTIVITY_PER | Number(3,0) | SMALLINT NOT NULL |
Max Tree Inactivity Period,min
Default Value: 20 |
| 45 | GUID | Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| 46 | NVSUSESECREPRQST | Character(1) | VARCHAR2(1) NOT NULL |
Use Secure Rep Rqst in nVision
Y/N Table Edit Default Value: Y |
| 47 | ICEURL | Character(254) | VARCHAR2(254) NOT NULL | URL to ICE |
| 48 | MAINTLOG_VALID | Character(1) | VARCHAR2(1) NOT NULL |
MAINTLOG_VALID
Y/N Table Edit |
| 49 | SAVEERRORISFATAL | Character(1) | VARCHAR2(1) NOT NULL |
Save Error is Fatal
Y/N Table Edit Default Value: N |
| 50 | PCODEWIP | Character(1) | VARCHAR2(1) NOT NULL | PeopleCode Work-In-Progress |
| 51 | F1URL | Long Character(1300) | VARCHAR2(1300) | F1 Help URL |
| 52 | CTRLF1URL | Long Character(1300) | VARCHAR2(1300) | Ctrl-F1 Help URL |
| 53 | PSSDWENABLED | Character(1) | VARCHAR2(1) NOT NULL | Shadowing Enabled |
| 54 | PTENABLESWITCHUSER | Character(1) | VARCHAR2(1) NOT NULL |
Enable Switch User
A=All S=Some Z=None Default Value: A |
| 55 | PTSVBTNFOCUS | Character(1) | VARCHAR2(1) NOT NULL |
Set Focus on Save Button
Y/N Table Edit Default Value: N |
| 56 | PTNEWSAVEWARNING | Character(1) | VARCHAR2(1) NOT NULL |
New Save Warning
Y/N Table Edit Default Value: Y |
| 57 | WSRPDISPMODE | Character(1) | VARCHAR2(1) NOT NULL |
WSRP Display Mode
N=Force New Window P=Display as Portlet R=Replace Existing Window |
| 58 | MAXSRCH | Number(9,0) | DECIMAL(9) NOT NULL | Max rows in search results |
| 59 | DFLTSEARCH | Number(9,0) | DECIMAL(9) NOT NULL | Default rows in search results |
| 60 | PTDFLTSESSEARCH | Number(9,0) | DECIMAL(9) NOT NULL |
Max rows in G Search
Default Value: 50 |
| 61 | SCROLLABLEGRID | Character(1) | VARCHAR2(1) NOT NULL |
Default grids to scrollable
Y/N Table Edit |
| 62 | PT_TDE_ENCRYPT_ALG | Character(29) | VARCHAR2(29) NOT NULL | Database Encryption Algorithm |
| 63 | PT_USE_FTPLIB | Character(1) | VARCHAR2(1) NOT NULL |
Use FTP Library
Default Value: Y |
| 64 | PRJCOMMIT | Number(8,0) | INTEGER NOT NULL |
Copy Commit Interval
Default Value: 100 |
| 65 | PT_ALIGN_RT | Character(1) | VARCHAR2(1) NOT NULL |
Right Align Field Labels
N=Left Align Y=Right Align Default Value: N |
| 66 | HEADERPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Header Page Name
Prompt Table: PANEL_VW |
| 67 | SEARCHRESPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Pivot Grid Search Page Name
Default Value: PTS_NUI_SEARCH Prompt Table: PANEL_VW |
| 68 | FOOTERPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Footer Page Name
Prompt Table: PANEL_VW |
| 69 | SIDEPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Side Page Name
Prompt Table: PANEL_VW |
| 70 | PROMPTPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Prompt Page Name
Prompt Table: PANEL_VW |
| 71 | LAYOUTSTYLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Layout StyleSheet Name
Prompt Table: PSSTYLESHEET_VW |
| 72 | THEMESTYLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Theme StyleSheet Name
Prompt Table: PSSTYLESHEET_VW |
| 73 | THEMESTYLETYPE | Character(4) | VARCHAR2(4) NOT NULL |
Theme Style Type
CLAS=Classic (DarkBlue) CPP8=Classic Plus Pre 858 PTCP=Classic Plus SWAN=Swan (PT8.52 default) TANG=Tangerine (PT8.53 default) Default Value: CLAS |
| 74 | PTBRANDTHEME | Character(30) | VARCHAR2(30) NOT NULL | Default Branding Theme |
| 75 | PTCUSTOMTAB | Character(30) | VARCHAR2(30) NOT NULL | Default Custom Tabs |
| 76 | PTRAFLATMENU | Character(1) | VARCHAR2(1) NOT NULL |
Flatten Related Action Folder
Y/N Table Edit |
| 77 | PTRAFLATTHRESHOLD | Number(3,0) | SMALLINT NOT NULL | Threshold |
| 78 | PTPG_MAXROWS | Signed Number(5,0) | DECIMAL(4) NOT NULL |
Max Rows in Pivot Grids
Default Value: 100 |
| 79 | PTENCRYPTADSPRJFLE | Character(1) | VARCHAR2(1) NOT NULL |
Option for encrypt ADS project files
Y/N Table Edit Default Value: Y |
| 80 | PTENCADSPRJCOMPAT | Character(1) | VARCHAR2(1) NOT NULL |
Encrypt ADS project with compatible mode (using 3DES algorithm)
Y/N Table Edit Default Value: N |
| 81 | PTMINHASHTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Minimum Hashing Type
0=NOHASH 10=SHA1 20=SHA256 Default Value: 20 |
| 82 | PTSTUBSUBPAGE | Character(18) | VARCHAR2(18) NOT NULL | Default Embedded Stub Subpage. Fluid subpage proxy to the configured embedded subpage. |
| 83 | PTS_CLASSICSRCHPG | Character(18) | VARCHAR2(18) NOT NULL | Classic Search Page |
| 84 | PTS_FLUIDSRCHPAGE | Character(18) | VARCHAR2(18) NOT NULL | Fluid Search Page |
| 85 | PTS_MAXRECENTSRCH | Number(3,0) | SMALLINT NOT NULL | Max Recent Searches |
| 86 | PTS_MAXSAVEDSEARCH | Number(3,0) | SMALLINT NOT NULL | Max Saved Searches |
| 87 | PTS_RCNTSRCHFRMT | Character(3) | VARCHAR2(3) NOT NULL |
Recent Search Name Display Format
LBL=Label value OPR=Label operator value Default Value: LBL |