PSOPTIONS

(SQL Table)
 Index Back

PeopleTools System Options

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

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 Max rows in Prompts

Default Value: 100

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

88 PTS_SS_MAXRSLTCNT Number(9,0) DECIMAL(9) NOT NULL Max rows in Search

Default Value: 100

89 PTS_KW_MAXRSLTCNT Number(9,0) DECIMAL(9) NOT NULL Max rows in KW Search

Default Value: 50