PSOPTIONS

index back

PeopleTools System Options

This is a single row table containing PeopleTools system options chosen.

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
Set Control Field: TIMEZONE

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 SES 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 Commit interval Copy from File

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 Default Style Sheet 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)
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

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19