PSOPTIONS

Return to Index

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

PeopleSoft Field NameDescription
MULTIJOBMultiple Jobs Allowed

Y/N Table Edit

Default: N

SYSTEMTYPESystem 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
SHORTNAMEField Short Name
LONGNAMELong Name
MULTICOMPANYMulti-Company Organization

Y/N Table Edit

Default: N

LANGUAGE_CDLanguage Code translate values

Default: ENG

HELP_CONTEXT_LASTLast Help Context # Used
MULTICURRENCYMulti-Currency

Y/N Table Edit

Default: N

GRANT_ACCESSGrant Access

Y/N Table Edit

Default: Y

STATS_GATHERGather Statistics Globally

Y/N Table Edit

Default: N

STATS_TABLEGather Statistics for Table

Y/N Table Edit

Default: N

STATS_TIMERWrite Interval

Default: 300

STATS_STARTStart Time For Stats Gathering
STATS_STOPStop Time For Stats Gathering
NVSUSEBUSUNITUse Business Unit in nVision

Y/N Table Edit

Default: Y

BACKGRNDDISCINTBackground Disconnect Interval

Default: 0

CHGCTL_USE_HISTORYUse Change Control History

Y/N Table Edit

Default: N

CHGCTL_USE_LOCKINGUse Change Control Locking

Y/N Table Edit

Default: N

TRANS_CHG_LASTUPDLast translation change

Y/N Table Edit

Default: N

DBLENGTHTYPEDatabase Length check type
D=DB2 EBCDIC Multi-Byte
M=Multi-Byte Database
N=Other Types (default)
TEMPTBLINSTANCESTemp Table Instances (Total)
TEMPINSTANCEBATCHTemp Table Instances (Batch)
TEMPINSTANCEONLINETemp Table Instances (Online)
AEOPTTRCAllow DB Optimizer Trace

Y/N Table Edit

APMSGMAXMSGSIZEThis field is used by Application Messaging on the PSOPTIONS table. It is the upper limit for the physical application message size.

Default: 1000000

MAXCHUNKSIZEMaximum Attachment Chunk Size

Default: 28000

BSE_TIMEZONEBase Time Zone

Prompt Table: PSTIMEZONE
Set Control Field: TIMEZONE

CASEINSSEARCHCase Insensitive seach option in PSOPTIONS

Y/N Table Edit

Default: Y

STYLESHEETNAMEStyle Sheet Name

Prompt Table: PSSTYLESHEET_VW

ICLIENTURLIA Server URL
LICENSE_CODELicense Code
LICENSE_GROUPLicense Group
TIMEOUTMINUTESTime out minutes
OPRIDA user's ID

Prompt Table: PSOPRDEFN

AUTHTOKENTYPEHolds a character code that indicate the method an app server uses to issue single-signon authentication tokens.
C=Use Certificate
P=User Password
COLLATION_TYPECollation Type Information
000=Binary Sorting (default)
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
PLATCOMPATPlatform Compatibility mode setting

Y/N Table Edit

Default: N

DB2ALLCCSIDOKAllow NT batch when CCSID<>37

Y/N Table Edit

Default: N

COMMITLIMITUpgrade Project Commit Limit

Default: 50

PACKAGEROOTRoot Package ID

Default: PT_BRANDING

APPCLASSIDApplication Class ID

Default: BrandingBase

USETREELOCKINGUse Tree Update Reservation

Y/N Table Edit

Default: N

TREEINACTIVITY_PERMax Tree Inactivity Period,min

Default: 20

GUIDUnique Identifier
NVSUSESECREPRQSTUse Secure Rep Rqst in nVision

Y/N Table Edit

Default: Y

ICEURLURL to ICE
MAINTLOG_VALIDMAINTLOG_VALID

Y/N Table Edit

SAVEERRORISFATALSave Error is Fatal

Y/N Table Edit

Default: N

PCODEWIPPeopleCode Work-In-Progress
F1URLF1 Help URL
CTRLF1URLCtrl-F1 Help URL
PSSDWENABLEDShadowing Enabled
PTENABLESWITCHUSEREnable Switch User
A=All (default)
S=Some
Z=None
PTSVBTNFOCUSSet Focus on Save Button

Y/N Table Edit

Default: N

WSRPDISPMODEWSRP Display Mode
N=Force New Window (inactive)
P=Display as Portlet
R=Replace Existing Window

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010