| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 WEBPROFILENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Profile Name
|
| VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| DEFAULTSCHEME |
Character(10) |
VARCHAR2(10) NOT NULL |
Protocol
H=http
S=https
|
| PORTALUSEHTTP |
Character(1) |
VARCHAR2(1) NOT NULL |
PIA use HTTP Same Server
Y/N Table Edit
Default: N
|
| RELATIVEURL |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Relative URLs
Y/N Table Edit
Default: Y
|
| PTENABLEDOMAINCOMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Domain Compare
Y/N Table Edit
Default: Y
|
| SESSIONTIMEOUT |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Inactivity Logout
|
| BYPASSSIGNON |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Public Access
Y/N Table Edit
Default: N
|
| DEFAULTUSERID |
Character(30) |
VARCHAR2(30) NOT NULL |
Public User ID
Prompt Table:
PSOPRDEFN_VW
|
| DEFAULTPWD |
Character(30) |
VARCHAR2(30) NOT NULL |
Public User Password
|
| MAXSAVEDSTATE |
Number(2,0) |
SMALLINT NOT NULL |
Number of States Supported
|
| ENABLENEWWINDOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable New Window
Y/N Table Edit
Default: Y
|
| ENABLEPRINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Print
Y/N Table Edit
|
| ENABLEPROCESSWAIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Processing Message
Y/N Table Edit
Default: Y
|
| SAVECONFIRMDISPLAY |
Number(8,0) |
INTEGER NOT NULL |
Save Confirmation Display Time
|
| SINGLETHREADNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Thread Netscape
Y/N Table Edit
Default: N
|
| THREADDELAY |
Number(4,0) |
SMALLINT NOT NULL |
Single Thread Delay
|
| SSLREQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Secured Access Only
Y/N Table Edit
Default: N
|
| USESECURECOOKIESSL |
Character(1) |
VARCHAR2(1) NOT NULL |
Secure Cookie with SSL
Y/N Table Edit
Default: Y
|
| USERIDCOOKIEAGE |
Number(4,0) |
SMALLINT NOT NULL |
Days to Auto Fill User ID
|
| COMPRESSRESPONSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compress Responses
Y/N Table Edit
Default: Y
|
| ENABLEBROWSERCACHE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cache Generated HTML
Y/N Table Edit
Default: Y
|
| COMPRESSCACHEFILES |
Character(1) |
VARCHAR2(1) NOT NULL |
Compress Response References
Y/N Table Edit
Default: N
|
| PORTALCACHEOBJECTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cache Portal Objects
Y/N Table Edit
Default: Y
|
| PORTALCACHESTALE |
Number(8,0) |
INTEGER NOT NULL |
Cache Stale Interval
|
| PORTALUSECACHEPROX |
Character(1) |
VARCHAR2(1) NOT NULL |
Cache Proxied JavaScripts
Y/N Table Edit
Default: Y
|
| ENABLENOVERSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Image/CSS (no Versioning)
Y/N Table Edit
Default: N
|
| ENABLETRACE |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Trace Link at Signon
Y/N Table Edit
Default: N
|
| ENABLEDEBUGDUMPFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Write Dump File
Y/N Table Edit
Default: N
|
| CONNECTINFO |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Connection & Sys Info
Y/N Table Edit
Default: N
|
| TESTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate HTML for Testing
Y/N Table Edit
Default: N
|
| DEBUGSHOWLAYOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Layout
Y/N Table Edit
Default: N
|
| DEBUGINLINESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Show StyleSheet Inline HTML
Y/N Table Edit
Default: N
|
| DEBUGINLINEJS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Unminified JavaScript
Y/N Table Edit
Default: N
|
| DEBUGOVERLAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Overlapping Fields
Y/N Table Edit
Default: N
|
| DEBUGSAVEFILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create File from PIA HTML Page
Y/N Table Edit
Default: N
|
| AUTHTOKENDOMAIN |
Character(254) |
VARCHAR2(254) NOT NULL |
Authentication Domain
|
| PSWEBSERVERNAME |
Character(254) |
VARCHAR2(254) NOT NULL |
Web Server Name
|
| DEFAULTPORT |
Number(8,0) |
INTEGER NOT NULL |
Web Server Port
|
| RPS |
Character(254) |
VARCHAR2(254) NOT NULL |
Reverse Proxy Server List
|
| HELPURL |
Character(254) |
VARCHAR2(254) NOT NULL |
Help URL
|
| SIGNONTRACEPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Enable Trace Page
|
| IMAGEDIRPHYS |
Character(30) |
VARCHAR2(30) NOT NULL |
Image Directory
|
| IMAGEDIRWEB |
Character(30) |
VARCHAR2(30) NOT NULL |
Image Web Directory
|
| CSSDIRPHYS |
Character(30) |
VARCHAR2(30) NOT NULL |
CSS Directory
|
| CSSDIRWEB |
Character(30) |
VARCHAR2(30) NOT NULL |
CSS Web Directory
|
| JSDIRPHYS |
Character(30) |
VARCHAR2(30) NOT NULL |
JavaScript Directory
|
| JSDIRWEB |
Character(30) |
VARCHAR2(30) NOT NULL |
JavaScript Web Directory
|
| CHARTDIRPHYS |
Character(30) |
VARCHAR2(30) NOT NULL |
Chart Directory
|
| CHARTDIRWEB |
Character(30) |
VARCHAR2(30) NOT NULL |
Chart Web Directory
|
| PHYSICALPATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Non-standard Base Path
|
| SIGNONPAGE |
Character(60) |
VARCHAR2(60) NOT NULL |
Signon Page
|
| SIGNONERRORPAGE |
Character(60) |
VARCHAR2(60) NOT NULL |
Signon Error Page
|
| LOGOUTPAGE |
Character(60) |
VARCHAR2(60) NOT NULL |
Logout Page
|
| STARTPAGE |
Character(60) |
VARCHAR2(60) NOT NULL |
Start Page
|
| EXPIREPAGECONTNAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Expire Page Content Name
|
| EXCEPTIONPAGE |
Character(60) |
VARCHAR2(60) NOT NULL |
Exception Page
|
| STARTPAGESCRIPT |
Character(254) |
VARCHAR2(254) NOT NULL |
Start Page Script
|
| WARNINGTIMEOUT |
Signed Number(9,0) |
DECIMAL(8) NOT NULL |
Inactivity Warning
|
| TIMEOUTWARNSCRIPT |
Character(254) |
VARCHAR2(254) NOT NULL |
Timeout Warning Script
|
| EXPIREPAGE |
Character(60) |
VARCHAR2(60) NOT NULL |
Expire Page
|
| SIGNONRESULTDOCPAG |
Character(30) |
VARCHAR2(30) NOT NULL |
Signon Result Doc Page
|
| COOKIEREQUIREDPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Cookies Required Page
|
| PASSWORDEXPIREDPAG |
Character(30) |
VARCHAR2(30) NOT NULL |
Password Expired Page
|
| PASSWORDWARNPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Password Warning Page
|
| USERPROFILEPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
User Profile Page
|
| AUTHTOKENABLEPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Auth Token Enable Page
|
| CHGPWDONEXPIRE |
Character(65) |
VARCHAR2(65) NOT NULL |
Change Password On Expire
|
| CHGPWDONWARN |
Character(65) |
VARCHAR2(65) NOT NULL |
Change Password On Warning
|
| SSLREQUIREDPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
SSL Required Page
|
| DEFAULTXMLLINKUSER |
Character(30) |
VARCHAR2(30) NOT NULL |
XML Link User ID
Prompt Table:
PSOPRDEFN_VW
|
| DEFAULTXMLLINKPWD |
Character(30) |
VARCHAR2(30) NOT NULL |
XML Link Password
|
| XMLLNKHTTPSAMSERV |
Character(1) |
VARCHAR2(1) NOT NULL |
XML Link Use HTTP Same Server
Y/N Table Edit
Default: Y
|
| SIGNONSESSION |
Character(1) |
VARCHAR2(1) NOT NULL |
New Session Upon Signon
Y/N Table Edit
Default: Y
|
| CACHEPURGEALLHITCT |
Number(8,0) |
INTEGER NOT NULL |
Cache Purge All Hit Count
|
| CACHEPURGESTALEINT |
Number(8,0) |
INTEGER NOT NULL |
Cache Purge Stale Interval
|
| CACHETARGETCONTENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cache Target Content
Y/N Table Edit
Default: Y
|
| PORTALCACHEHPBROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Cache Homepage
Y/N Table Edit
Default: Y
|
| PORTALHPSTALEINT |
Number(8,0) |
INTEGER NOT NULL |
Homepage Stale Interval
|
| ENABLEREPORTREPOS |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Report Repository
Y/N Table Edit
Default: Y
|
| REPORTREPOSITORYPT |
Character(254) |
VARCHAR2(254) NOT NULL |
Report Repository Path
|
| COMPRESSREPORTOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Compress Report Output
Y/N Table Edit
Default: Y
|
| COMPRESSREPORTNS |
Character(1) |
VARCHAR2(1) NOT NULL |
Compress Report Netscape
Y/N Table Edit
Default: N
|
| MCFAUTHFAILUREPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
MCF Auth Failure Page
|
| COMPRESSMIMETYPES |
Character(254) |
VARCHAR2(254) NOT NULL |
Compress Mime Types
|
| TUXNETDISTIMEOUT |
Number(8,0) |
INTEGER NOT NULL |
Disconnect Timeout
|
| TUXEDOSENDTIMEOUT |
Number(8,0) |
INTEGER NOT NULL |
Send Timeout
|
| TUXEDORCVTIMEOUT |
Number(8,0) |
INTEGER NOT NULL |
Receive Timeout
|
| PUBLICSESSTIMEOUT |
Number(8,0) |
INTEGER NOT NULL |
HTTP Session Inactivity
|
| PPMTRACE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace Monitoring Server
Y/N Table Edit
Default: N
|
| PAGELETERRORPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Pagelet Error Page
|
| PORTALDTLERRPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Detail Error Page
|
| PORTALTRGTERRPAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Target Error Page
|
| BROWSERID_LAST |
Number(9,0) |
DECIMAL(9) NOT NULL |
Last Browser ID
|
| EFFECTIVEIMMEDIATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Profile takes effect upon save
|
| ENABLEPPMAGENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable PPM Agent
Y/N Table Edit
Default: Y
|
| COMPRESSQUERY |
Character(1) |
VARCHAR2(1) NOT NULL |
Compress Query
Y/N Table Edit
Default: Y
|
| PPMMONITORBUFFSIZE |
Number(8,0) |
INTEGER NOT NULL |
PPM Monitor Buffer Size
|
| ALLOWUNREGCONTENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Unregistered Content
Y/N Table Edit
Default: Y
|
| AUTHUSERHTTPINTRVL |
Number(8,0) |
INTEGER NOT NULL |
HTTP Session Inactivity
|
| VIEWFILETTL |
Number(8,0) |
INTEGER NOT NULL |
View File Time to Live
|
| STATUSBLOCKTIMEOUT |
Number(8,0) |
INTEGER NOT NULL |
State Discard Interval
|
| TRACEPPMAGENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Trace PPM Agent
Y/N Table Edit
Default: N
|
| CACHEMENUONWEBSRVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cache Menu on Web Server
Y/N Table Edit
Default: N
|
| PT_CACHE_SEARCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Caching
Y/N Table Edit
Default: Y
|
| PT_CACHE_SEARCH_WS |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Caching on Web Server
Y/N Table Edit
Default: Y
|
| LANGUAGESUPPORT |
Long Character |
CLOB |
Language Support
|
| PTXFODOMAINCOMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Domain Compare
Y/N Table Edit
Default: Y
|
| PTXFOON |
Character(1) |
VARCHAR2(1) NOT NULL |
Frame Control
Y/N Table Edit
Default: Y
|
| PTXFOSITELIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Authorized Sites
Y/N Table Edit
Default: Y
|
| PTTOKENDOMAINCOMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Domain Compare
Y/N Table Edit
Default: N
|