PSOPTIONS

index back

PeopleTools System Options

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

PeopleSoft Field NameField TypeColumn TypeDescription
MULTIJOBCharacter(1)VARCHAR2(1) NOT NULLMultiple Jobs Allowed

Y/N Table Edit

Default: N

SYSTEMTYPECharacter(3)VARCHAR2(3) NOT NULLSystem 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
SHORTNAMECharacter(15)VARCHAR2(15) NOT NULLField Short Name
LONGNAMECharacter(30)VARCHAR2(30) NOT NULLLong Name
MULTICOMPANYCharacter(1)VARCHAR2(1) NOT NULLMulti-Company Organization

Y/N Table Edit

Default: N

LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values

Default: ENG

HELP_CONTEXT_LASTNumber(10,0)DECIMAL(10) NOT NULLLast Help Context # Used
MULTICURRENCYCharacter(1)VARCHAR2(1) NOT NULLMulti-Currency

Y/N Table Edit

Default: N

GRANT_ACCESSCharacter(1)VARCHAR2(1) NOT NULLGrant Access

Y/N Table Edit

Default: Y

STATS_GATHERCharacter(1)VARCHAR2(1) NOT NULLGather Statistics Globally

Y/N Table Edit

Default: N

STATS_TABLECharacter(1)VARCHAR2(1) NOT NULLGather Statistics for Table

Y/N Table Edit

Default: N

STATS_TIMERNumber(10,0)DECIMAL(10) NOT NULLWrite Interval

Default: 300

STATS_STARTDateTime(26)TIMESTAMP NOT NULLStart Time For Stats Gathering
STATS_STOPDateTime(26)TIMESTAMP NOT NULLStop Time For Stats Gathering
NVSUSEBUSUNITCharacter(1)VARCHAR2(1) NOT NULLUse Business Unit in nVision

Y/N Table Edit

Default: Y

BACKGRNDDISCINTNumber(5,0)INTEGER NOT NULLBackground Disconnect Interval

Default: 0

CHGCTL_USE_HISTORYCharacter(1)VARCHAR2(1) NOT NULLUse Change Control History

Y/N Table Edit

Default: N

CHGCTL_USE_LOCKINGCharacter(1)VARCHAR2(1) NOT NULLUse Change Control Locking

Y/N Table Edit

Default: N

TRANS_CHG_LASTUPDCharacter(1)VARCHAR2(1) NOT NULLLast translation change

Y/N Table Edit

Default: N

DBLENGTHTYPECharacter(1)VARCHAR2(1) NOT NULLDatabase Length check type
D=DB2 EBCDIC Multi-Byte
M=Multi-Byte Database
N=Other Types

Default: N

TEMPTBLINSTANCESNumber(4,0)SMALLINT NOT NULLTemp Table Instances (Total)
TEMPINSTANCEBATCHNumber(4,0)SMALLINT NOT NULLTemp Table Instances (Batch)
TEMPINSTANCEONLINENumber(4,0)SMALLINT NOT NULLTemp Table Instances (Online)
AEOPTTRCCharacter(1)VARCHAR2(1) NOT NULLAllow DB Optimizer Trace

Y/N Table Edit

APMSGMAXMSGSIZENumber(10,0)DECIMAL(10) NOT NULLThis field is used by Application Messaging on the PSOPTIONS table. It is the upper limit for the physical application message size.

Default: 1000000

MAXCHUNKSIZENumber(10,0)DECIMAL(10) NOT NULLMaximum Attachment Chunk Size

Default: 28000

IBMAXNBRSEGMENTSNumber(4,0)SMALLINT NOT NULLMaximum Number of Segments per Message

Default: 10

BSE_TIMEZONECharacter(9)VARCHAR2(9) NOT NULLBase Time Zone

Prompt Table: PSTIMEZONE
Set Control Field: TIMEZONE

CASEINSSEARCHCharacter(1)VARCHAR2(1) NOT NULLCase Insensitive seach option in PSOPTIONS
N=Off
S=On - CaseSensitive Default On
Y=On - CaseSensitive Default Off

Default: Y

STYLESHEETNAMECharacter(30)VARCHAR2(30) NOT NULLStyle Sheet Name (see PSSTYLSHEETDEFN).

Prompt Table: PSSTYLESHEET_VW

ICLIENTURLCharacter(254)VARCHAR2(254) NOT NULLIA Server URL
LICENSE_CODECharacter(64)VARCHAR2(64) NOT NULLLicense Code
LICENSE_GROUPCharacter(50)VARCHAR2(50) NOT NULLLicense Group
TIMEOUTMINUTESNumber(5,0)INTEGER NOT NULLTime out minutes
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

Prompt Table: PSOPRDEFN

AUTHTOKENTYPECharacter(1)VARCHAR2(1) NOT NULLHolds a character code that indicate the method an app server uses to issue single-signon authentication tokens.
C=Use Certificate
P=User Password
COLLATION_TYPECharacter(3)VARCHAR2(3) NOT NULLCollation 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

PLATCOMPATCharacter(1)VARCHAR2(1) NOT NULLPlatform Compatibility mode setting

Y/N Table Edit

Default: N

DB2ALLCCSIDOKCharacter(1)VARCHAR2(1) NOT NULLAllow NT batch when CCSID<>37

Y/N Table Edit

Default: N

COMMITLIMITNumber(10,0)DECIMAL(10) NOT NULLUpgrade Project Commit Limit

Default: 50

PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID

Default: PT_BRANDING

APPCLASSIDCharacter(30)VARCHAR2(30) NOT NULLApplication Class ID

Default: BrandingBase

USETREELOCKINGCharacter(1)VARCHAR2(1) NOT NULLUse Tree Update Reservation

Y/N Table Edit

Default: N

TREEINACTIVITY_PERNumber(3,0)SMALLINT NOT NULLMax Tree Inactivity Period,min

Default: 20

GUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
NVSUSESECREPRQSTCharacter(1)VARCHAR2(1) NOT NULLUse Secure Rep Rqst in nVision

Y/N Table Edit

Default: Y

ICEURLCharacter(254)VARCHAR2(254) NOT NULLURL to ICE
MAINTLOG_VALIDCharacter(1)VARCHAR2(1) NOT NULLMAINTLOG_VALID

Y/N Table Edit

SAVEERRORISFATALCharacter(1)VARCHAR2(1) NOT NULLSave Error is Fatal

Y/N Table Edit

Default: N

PCODEWIPCharacter(1)VARCHAR2(1) NOT NULLPeopleCode Work-In-Progress
F1URLLong Character(1300)VARCHAR2(1300)F1 Help URL
CTRLF1URLLong Character(1300)VARCHAR2(1300)Ctrl-F1 Help URL
PSSDWENABLEDCharacter(1)VARCHAR2(1) NOT NULLShadowing Enabled
PTENABLESWITCHUSERCharacter(1)VARCHAR2(1) NOT NULLEnable Switch User
A=All
S=Some
Z=None

Default: A

PTSVBTNFOCUSCharacter(1)VARCHAR2(1) NOT NULLSet Focus on Save Button

Y/N Table Edit

Default: N

PTNEWSAVEWARNINGCharacter(1)VARCHAR2(1) NOT NULLNew Save Warning

Y/N Table Edit

Default: Y

WSRPDISPMODECharacter(1)VARCHAR2(1) NOT NULLWSRP Display Mode
N=Force New Window
P=Display as Portlet
R=Replace Existing Window
MAXSRCHNumber(9,0)DECIMAL(9) NOT NULLMax rows in search results
DFLTSEARCHNumber(9,0)DECIMAL(9) NOT NULLDefault rows in search results
PTDFLTSESSEARCHNumber(9,0)DECIMAL(9) NOT NULLDefault rows in SES results

Default: 50

SCROLLABLEGRIDCharacter(1)VARCHAR2(1) NOT NULLDefault grids to scrollable

Y/N Table Edit

PT_TDE_ENCRYPT_ALGCharacter(29)VARCHAR2(29) NOT NULLDatabase Encryption Algorithm
PT_USE_FTPLIBCharacter(1)VARCHAR2(1) NOT NULLUse FTP Library

Default: Y

PRJCOMMITNumber(8,0)INTEGER NOT NULLCommit interval Copy from File

Default: 100

PT_ALIGN_RTCharacter(1)VARCHAR2(1) NOT NULLRight Align Field Labels
N=Left Align
Y=Right Align

Default: N

HEADERPAGENAMECharacter(18)VARCHAR2(18) NOT NULLHeader Page Name

Prompt Table: PANEL_VW

SEARCHRESPAGENAMECharacter(18)VARCHAR2(18) NOT NULLSearch Page Name

Default: PTS_NUI_SEARCH

Prompt Table: PANEL_VW

FOOTERPAGENAMECharacter(18)VARCHAR2(18) NOT NULLFooter Page Name

Prompt Table: PANEL_VW

SIDEPAGENAMECharacter(18)VARCHAR2(18) NOT NULLSide Page Name

Prompt Table: PANEL_VW

PROMPTPAGENAMECharacter(18)VARCHAR2(18) NOT NULLPrompt Page Name

Prompt Table: PANEL_VW

LAYOUTSTYLENAMECharacter(30)VARCHAR2(30) NOT NULLDefault Style Sheet Name

Prompt Table: PSSTYLESHEET_VW

THEMESTYLENAMECharacter(30)VARCHAR2(30) NOT NULLTheme StyleSheet Name

Prompt Table: PSSTYLESHEET_VW

THEMESTYLETYPECharacter(4)VARCHAR2(4) NOT NULLTheme Style Type
CLAS=Classic (DarkBlue)
SWAN=Swan (PT8.52 default)
TANG=Tangerine (PT8.53 default)

Default: CLAS

PTBRANDTHEMECharacter(30)VARCHAR2(30) NOT NULLDefault Branding Theme
PTCUSTOMTABCharacter(30)VARCHAR2(30) NOT NULLDefault Custom Tabs
PTRAFLATMENUCharacter(1)VARCHAR2(1) NOT NULLFlatten Related Action Folder

Y/N Table Edit

PTRAFLATTHRESHOLDNumber(3,0)SMALLINT NOT NULLThreshold
PTPG_MAXROWSSigned Number(5,0)DECIMAL(4) NOT NULLMax Rows in Pivot Grids

Default: 100

PTENCRYPTADSPRJFLECharacter(1)VARCHAR2(1) NOT NULLOption for encrypt ADS project files

Y/N Table Edit

Default: Y

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