PSOPTIONS |
index back |
|---|---|
PeopleTools System Options |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| MULTIJOB | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Jobs Allowed
Y/N Table Edit Default: N |
| 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 |
| SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |
| LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| MULTICOMPANY | Character(1) | VARCHAR2(1) NOT NULL |
Multi-Company Organization
Y/N Table Edit Default: N |
| LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
translate values
Default: ENG |
| HELP_CONTEXT_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last Help Context # Used |
| MULTICURRENCY | Character(1) | VARCHAR2(1) NOT NULL |
Multi-Currency
Y/N Table Edit Default: N |
| GRANT_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Grant Access
Y/N Table Edit Default: Y |
| STATS_GATHER | Character(1) | VARCHAR2(1) NOT NULL |
Gather Statistics Globally
Y/N Table Edit Default: N |
| STATS_TABLE | Character(1) | VARCHAR2(1) NOT NULL |
Gather Statistics for Table
Y/N Table Edit Default: N |
| STATS_TIMER | Number(10,0) | DECIMAL(10) NOT NULL |
Write Interval
Default: 300 |
| STATS_START | DateTime(26) | TIMESTAMP NOT NULL | Start Time For Stats Gathering |
| STATS_STOP | DateTime(26) | TIMESTAMP NOT NULL | Stop Time For Stats Gathering |
| NVSUSEBUSUNIT | Character(1) | VARCHAR2(1) NOT NULL |
Use Business Unit in nVision
Y/N Table Edit Default: Y |
| BACKGRNDDISCINT | Number(5,0) | INTEGER NOT NULL |
Background Disconnect Interval
Default: 0 |
| CHGCTL_USE_HISTORY | Character(1) | VARCHAR2(1) NOT NULL |
Use Change Control History
Y/N Table Edit Default: N |
| CHGCTL_USE_LOCKING | Character(1) | VARCHAR2(1) NOT NULL |
Use Change Control Locking
Y/N Table Edit Default: N |
| TRANS_CHG_LASTUPD | Character(1) | VARCHAR2(1) NOT NULL |
Last translation change
Y/N Table Edit Default: N |
| DBLENGTHTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Database Length check type
D=DB2 EBCDIC Multi-Byte M=Multi-Byte Database N=Other Types Default: N |
| TEMPTBLINSTANCES | Number(4,0) | SMALLINT NOT NULL | Temp Table Instances (Total) |
| TEMPINSTANCEBATCH | Number(4,0) | SMALLINT NOT NULL | Temp Table Instances (Batch) |
| TEMPINSTANCEONLINE | Number(4,0) | SMALLINT NOT NULL | Temp Table Instances (Online) |
| AEOPTTRC | Character(1) | VARCHAR2(1) NOT NULL |
Allow DB Optimizer Trace
Y/N Table Edit |
| 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: 1000000 |
| MAXCHUNKSIZE | Number(10,0) | DECIMAL(10) NOT NULL |
Maximum Attachment Chunk Size
Default: 28000 |
| IBMAXNBRSEGMENTS | Number(4,0) | SMALLINT NOT NULL |
Maximum Number of Segments per Message
Default: 10 |
| BSE_TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL |
Base Time Zone
Prompt Table:
PSTIMEZONE
|
| 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: Y |
| STYLESHEETNAME | Character(30) | VARCHAR2(30) NOT NULL |
Style Sheet Name (see PSSTYLSHEETDEFN).
Prompt Table: PSSTYLESHEET_VW |
| ICLIENTURL | Character(254) | VARCHAR2(254) NOT NULL | IA Server URL |
| LICENSE_CODE | Character(64) | VARCHAR2(64) NOT NULL | License Code |
| LICENSE_GROUP | Character(50) | VARCHAR2(50) NOT NULL | License Group |
| TIMEOUTMINUTES | Number(5,0) | INTEGER NOT NULL | Time out minutes |
| OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| 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 |
| 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: 000 |
| PLATCOMPAT | Character(1) | VARCHAR2(1) NOT NULL |
Platform Compatibility mode setting
Y/N Table Edit Default: N |
| DB2ALLCCSIDOK | Character(1) | VARCHAR2(1) NOT NULL |
Allow NT batch when CCSID<>37
Y/N Table Edit Default: N |
| COMMITLIMIT | Number(10,0) | DECIMAL(10) NOT NULL |
Upgrade Project Commit Limit
Default: 50 |
| PACKAGEROOT | Character(30) | VARCHAR2(30) NOT NULL |
Root Package ID
Default: PT_BRANDING |
| APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Default: BrandingBase |
| USETREELOCKING | Character(1) | VARCHAR2(1) NOT NULL |
Use Tree Update Reservation
Y/N Table Edit Default: N |
| TREEINACTIVITY_PER | Number(3,0) | SMALLINT NOT NULL |
Max Tree Inactivity Period,min
Default: 20 |
| GUID | Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |
| NVSUSESECREPRQST | Character(1) | VARCHAR2(1) NOT NULL |
Use Secure Rep Rqst in nVision
Y/N Table Edit Default: Y |
| ICEURL | Character(254) | VARCHAR2(254) NOT NULL | URL to ICE |
| MAINTLOG_VALID | Character(1) | VARCHAR2(1) NOT NULL |
MAINTLOG_VALID
Y/N Table Edit |
| SAVEERRORISFATAL | Character(1) | VARCHAR2(1) NOT NULL |
Save Error is Fatal
Y/N Table Edit Default: N |
| PCODEWIP | Character(1) | VARCHAR2(1) NOT NULL | PeopleCode Work-In-Progress |
| F1URL | Long Character(1300) | VARCHAR2(1300) | F1 Help URL |
| CTRLF1URL | Long Character(1300) | VARCHAR2(1300) | Ctrl-F1 Help URL |
| PSSDWENABLED | Character(1) | VARCHAR2(1) NOT NULL | Shadowing Enabled |
| PTENABLESWITCHUSER | Character(1) | VARCHAR2(1) NOT NULL |
Enable Switch User
A=All S=Some Z=None Default: A |
| PTSVBTNFOCUS | Character(1) | VARCHAR2(1) NOT NULL |
Set Focus on Save Button
Y/N Table Edit Default: N |
| PTNEWSAVEWARNING | Character(1) | VARCHAR2(1) NOT NULL |
New Save Warning
Y/N Table Edit Default: Y |
| WSRPDISPMODE | Character(1) | VARCHAR2(1) NOT NULL |
WSRP Display Mode
N=Force New Window P=Display as Portlet R=Replace Existing Window |
| MAXSRCH | Number(9,0) | DECIMAL(9) NOT NULL | Max rows in search results |
| DFLTSEARCH | Number(9,0) | DECIMAL(9) NOT NULL | Default rows in search results |
| PTDFLTSESSEARCH | Number(9,0) | DECIMAL(9) NOT NULL |
Default rows in ES results
Default: 50 |
| SCROLLABLEGRID | Character(1) | VARCHAR2(1) NOT NULL |
Default grids to scrollable
Y/N Table Edit |
| PT_TDE_ENCRYPT_ALG | Character(29) | VARCHAR2(29) NOT NULL | Database Encryption Algorithm |
| PT_USE_FTPLIB | Character(1) | VARCHAR2(1) NOT NULL |
Use FTP Library
Default: Y |
| PRJCOMMIT | Number(8,0) | INTEGER NOT NULL |
Copy Commit Interval
Default: 100 |
| PT_ALIGN_RT | Character(1) | VARCHAR2(1) NOT NULL |
Right Align Field Labels
N=Left Align Y=Right Align Default: N |
| HEADERPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Header Page Name
Prompt Table: PANEL_VW |
| SEARCHRESPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Search Page Name
Default: PTS_NUI_SEARCH Prompt Table: PANEL_VW |
| FOOTERPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Footer Page Name
Prompt Table: PANEL_VW |
| SIDEPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Side Page Name
Prompt Table: PANEL_VW |
| PROMPTPAGENAME | Character(18) | VARCHAR2(18) NOT NULL |
Prompt Page Name
Prompt Table: PANEL_VW |
| LAYOUTSTYLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Layout StyleSheet Name
Prompt Table: PSSTYLESHEET_VW |
| THEMESTYLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Theme StyleSheet Name
Prompt Table: PSSTYLESHEET_VW |
| 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: CLAS |
| PTBRANDTHEME | Character(30) | VARCHAR2(30) NOT NULL | Default Branding Theme |
| PTCUSTOMTAB | Character(30) | VARCHAR2(30) NOT NULL | Default Custom Tabs |
| PTRAFLATMENU | Character(1) | VARCHAR2(1) NOT NULL |
Flatten Related Action Folder
Y/N Table Edit |
| PTRAFLATTHRESHOLD | Number(3,0) | SMALLINT NOT NULL | Threshold |
| PTPG_MAXROWS | Signed Number(5,0) | DECIMAL(4) NOT NULL |
Max Rows in Pivot Grids
Default: 100 |
| PTENCRYPTADSPRJFLE | Character(1) | VARCHAR2(1) NOT NULL |
Option for encrypt ADS project files
Y/N Table Edit Default: Y |
| PTENCADSPRJCOMPAT | Character(1) | VARCHAR2(1) NOT NULL |
Encrypt ADS project with compatible mode (using 3DES algorithm)
Y/N Table Edit Default: N |
| PTMINHASHTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Minimum Hashing Type
0=NOHASH 10=SHA1 20=SHA256 Default: 20 |
| PTSTUBSUBPAGE | Character(18) | VARCHAR2(18) NOT NULL | Default Embedded Stub Subpage. Fluid subpage proxy to the configured embedded subpage. |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |