PSWEBPROFILE

index back

Web Profile


PeopleSoft Field NameField TypeColumn TypeDescription
WEBPROFILENAMECharacter(30)VARCHAR2(30) NOT NULLProfile Name
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
DEFAULTSCHEMECharacter(10)VARCHAR2(10) NOT NULLProtocol
H=http
S=https
PORTALUSEHTTPCharacter(1)VARCHAR2(1) NOT NULLPIA use HTTP Same Server

Y/N Table Edit

Default: N

RELATIVEURLCharacter(1)VARCHAR2(1) NOT NULLGenerate Relative URLs

Y/N Table Edit

Default: Y

SESSIONTIMEOUTSigned Number(9,0)DECIMAL(8) NOT NULLInactivity Logout
BYPASSSIGNONCharacter(1)VARCHAR2(1) NOT NULLAllow Public Access

Y/N Table Edit

Default: N

DEFAULTUSERIDCharacter(30)VARCHAR2(30) NOT NULLPublic User ID

Prompt Table: PSOPRDEFN_VW

DEFAULTPWDCharacter(30)VARCHAR2(30) NOT NULLPublic User Password
MAXSAVEDSTATENumber(2,0)SMALLINT NOT NULLNumber of States Supported
ENABLENEWWINDOWCharacter(1)VARCHAR2(1) NOT NULLEnable New Window

Y/N Table Edit

Default: Y

ENABLEPRINTCharacter(1)VARCHAR2(1) NOT NULLEnable Print

Y/N Table Edit

ENABLEPROCESSWAITCharacter(1)VARCHAR2(1) NOT NULLEnable Processing Message

Y/N Table Edit

Default: Y

SAVECONFIRMDISPLAYNumber(8,0)INTEGER NOT NULLSave Confirmation Display Time
SINGLETHREADNSCharacter(1)VARCHAR2(1) NOT NULLSingle Thread Netscape

Y/N Table Edit

Default: N

THREADDELAYNumber(4,0)SMALLINT NOT NULLSingle Thread Delay
SSLREQUIREDCharacter(1)VARCHAR2(1) NOT NULLSecured Access Only

Y/N Table Edit

Default: N

USESECURECOOKIESSLCharacter(1)VARCHAR2(1) NOT NULLSecure Cookie with SSL

Y/N Table Edit

Default: Y

USERIDCOOKIEAGENumber(4,0)SMALLINT NOT NULLDays to Auto Fill User ID
COMPRESSRESPONSECharacter(1)VARCHAR2(1) NOT NULLCompress Responses

Y/N Table Edit

Default: Y

ENABLEBROWSERCACHECharacter(1)VARCHAR2(1) NOT NULLCache Generated HTML

Y/N Table Edit

Default: Y

COMPRESSCACHEFILESCharacter(1)VARCHAR2(1) NOT NULLCompress Response References

Y/N Table Edit

Default: N

PORTALCACHEOBJECTSCharacter(1)VARCHAR2(1) NOT NULLCache Portal Objects

Y/N Table Edit

Default: Y

PORTALCACHESTALENumber(8,0)INTEGER NOT NULLCache Stale Interval
PORTALUSECACHEPROXCharacter(1)VARCHAR2(1) NOT NULLCache Proxied JavaScripts

Y/N Table Edit

Default: Y

ENABLENOVERSIONCharacter(1)VARCHAR2(1) NOT NULLCopy Image/CSS (no Versioning)

Y/N Table Edit

Default: N

ENABLETRACECharacter(1)VARCHAR2(1) NOT NULLShow Trace Link at Signon

Y/N Table Edit

Default: N

ENABLEDEBUGDUMPFLCharacter(1)VARCHAR2(1) NOT NULLWrite Dump File

Y/N Table Edit

Default: N

CONNECTINFOCharacter(1)VARCHAR2(1) NOT NULLShow Connection & Sys Info

Y/N Table Edit

Default: N

TESTINGCharacter(1)VARCHAR2(1) NOT NULLGenerate HTML for Testing

Y/N Table Edit

Default: N

DEBUGSHOWLAYOUTCharacter(1)VARCHAR2(1) NOT NULLShow Layout

Y/N Table Edit

Default: N

DEBUGINLINESSCharacter(1)VARCHAR2(1) NOT NULLShow StyleSheet Inline HTML

Y/N Table Edit

Default: N

DEBUGINLINEJSCharacter(1)VARCHAR2(1) NOT NULLUse Unminified JavaScript

Y/N Table Edit

Default: N

DEBUGOVERLAPCharacter(1)VARCHAR2(1) NOT NULLShow Overlapping Fields

Y/N Table Edit

Default: N

DEBUGSAVEFILECharacter(1)VARCHAR2(1) NOT NULLCreate File from PIA HTML Page

Y/N Table Edit

Default: N

AUTHTOKENDOMAINCharacter(254)VARCHAR2(254) NOT NULLAuthentication Domain
PSWEBSERVERNAMECharacter(254)VARCHAR2(254) NOT NULLWeb Server Name
DEFAULTPORTNumber(8,0)INTEGER NOT NULLWeb Server Port
RPSCharacter(254)VARCHAR2(254) NOT NULLReverse Proxy Server List
HELPURLCharacter(254)VARCHAR2(254) NOT NULLHelp URL
SIGNONTRACEPAGECharacter(30)VARCHAR2(30) NOT NULLEnable Trace Page
IMAGEDIRPHYSCharacter(30)VARCHAR2(30) NOT NULLImage Directory
IMAGEDIRWEBCharacter(30)VARCHAR2(30) NOT NULLImage Web Directory
CSSDIRPHYSCharacter(30)VARCHAR2(30) NOT NULLCSS Directory
CSSDIRWEBCharacter(30)VARCHAR2(30) NOT NULLCSS Web Directory
JSDIRPHYSCharacter(30)VARCHAR2(30) NOT NULLJavaScript Directory
JSDIRWEBCharacter(30)VARCHAR2(30) NOT NULLJavaScript Web Directory
CHARTDIRPHYSCharacter(30)VARCHAR2(30) NOT NULLChart Directory
CHARTDIRWEBCharacter(30)VARCHAR2(30) NOT NULLChart Web Directory
PHYSICALPATHCharacter(254)VARCHAR2(254) NOT NULLNon-standard Base Path
SIGNONPAGECharacter(60)VARCHAR2(60) NOT NULLSignon Page
SIGNONERRORPAGECharacter(60)VARCHAR2(60) NOT NULLSignon Error Page
LOGOUTPAGECharacter(60)VARCHAR2(60) NOT NULLLogout Page
STARTPAGECharacter(60)VARCHAR2(60) NOT NULLStart Page
EXPIREPAGECONTNAMECharacter(60)VARCHAR2(60) NOT NULLExpire Page Content Name
EXCEPTIONPAGECharacter(60)VARCHAR2(60) NOT NULLException Page
STARTPAGESCRIPTCharacter(254)VARCHAR2(254) NOT NULLStart Page Script
WARNINGTIMEOUTSigned Number(9,0)DECIMAL(8) NOT NULLInactivity Warning
TIMEOUTWARNSCRIPTCharacter(254)VARCHAR2(254) NOT NULLTimeout Warning Script
EXPIREPAGECharacter(60)VARCHAR2(60) NOT NULLExpire Page
SIGNONRESULTDOCPAGCharacter(30)VARCHAR2(30) NOT NULLSignon Result Doc Page
COOKIEREQUIREDPAGECharacter(30)VARCHAR2(30) NOT NULLCookies Required Page
PASSWORDEXPIREDPAGCharacter(30)VARCHAR2(30) NOT NULLPassword Expired Page
PASSWORDWARNPAGECharacter(30)VARCHAR2(30) NOT NULLPassword Warning Page
USERPROFILEPAGECharacter(30)VARCHAR2(30) NOT NULLUser Profile Page
AUTHTOKENABLEPAGECharacter(30)VARCHAR2(30) NOT NULLAuth Token Enable Page
CHGPWDONEXPIRECharacter(65)VARCHAR2(65) NOT NULLChange Password On Expire
CHGPWDONWARNCharacter(65)VARCHAR2(65) NOT NULLChange Password On Warning
SSLREQUIREDPAGECharacter(30)VARCHAR2(30) NOT NULLSSL Required Page
DEFAULTXMLLINKUSERCharacter(30)VARCHAR2(30) NOT NULLXML Link User ID

Prompt Table: PSOPRDEFN_VW

DEFAULTXMLLINKPWDCharacter(30)VARCHAR2(30) NOT NULLXML Link Password
XMLLNKHTTPSAMSERVCharacter(1)VARCHAR2(1) NOT NULLXML Link Use HTTP Same Server

Y/N Table Edit

Default: Y

SIGNONSESSIONCharacter(1)VARCHAR2(1) NOT NULLNew Session Upon Signon

Y/N Table Edit

Default: Y

CACHEPURGEALLHITCTNumber(8,0)INTEGER NOT NULLCache Purge All Hit Count
CACHEPURGESTALEINTNumber(8,0)INTEGER NOT NULLCache Purge Stale Interval
CACHETARGETCONTENTCharacter(1)VARCHAR2(1) NOT NULLCache Target Content

Y/N Table Edit

Default: Y

PORTALCACHEHPBROWCharacter(1)VARCHAR2(1) NOT NULLCache Homepage

Y/N Table Edit

Default: Y

PORTALHPSTALEINTNumber(8,0)INTEGER NOT NULLHomepage Stale Interval
ENABLEREPORTREPOSCharacter(1)VARCHAR2(1) NOT NULLEnable Report Repository

Y/N Table Edit

Default: Y

REPORTREPOSITORYPTCharacter(254)VARCHAR2(254) NOT NULLReport Repository Path
COMPRESSREPORTOUTCharacter(1)VARCHAR2(1) NOT NULLCompress Report Output

Y/N Table Edit

Default: Y

COMPRESSREPORTNSCharacter(1)VARCHAR2(1) NOT NULLCompress Report Netscape

Y/N Table Edit

Default: N

MCFAUTHFAILUREPAGECharacter(30)VARCHAR2(30) NOT NULLMCF Auth Failure Page
COMPRESSMIMETYPESCharacter(254)VARCHAR2(254) NOT NULLCompress Mime Types
TUXNETDISTIMEOUTNumber(8,0)INTEGER NOT NULLDisconnect Timeout
TUXEDOSENDTIMEOUTNumber(8,0)INTEGER NOT NULLSend Timeout
TUXEDORCVTIMEOUTNumber(8,0)INTEGER NOT NULLReceive Timeout
PUBLICSESSTIMEOUTNumber(8,0)INTEGER NOT NULLHTTP Session Inactivity
PPMTRACECharacter(1)VARCHAR2(1) NOT NULLTrace Monitoring Server

Y/N Table Edit

Default: N

PAGELETERRORPAGECharacter(30)VARCHAR2(30) NOT NULLPagelet Error Page
PORTALDTLERRPAGECharacter(30)VARCHAR2(30) NOT NULLPortal Detail Error Page
PORTALTRGTERRPAGECharacter(30)VARCHAR2(30) NOT NULLPortal Target Error Page
BROWSERID_LASTNumber(9,0)DECIMAL(9) NOT NULLLast Browser ID
EFFECTIVEIMMEDIATECharacter(1)VARCHAR2(1) NOT NULLProfile takes effect upon save
ENABLEPPMAGENTCharacter(1)VARCHAR2(1) NOT NULLEnable PPM Agent

Y/N Table Edit

Default: Y

COMPRESSQUERYCharacter(1)VARCHAR2(1) NOT NULLCompress Query

Y/N Table Edit

Default: Y

PPMMONITORBUFFSIZENumber(8,0)INTEGER NOT NULLPPM Monitor Buffer Size
ALLOWUNREGCONTENTCharacter(1)VARCHAR2(1) NOT NULLAllow Unregistered Content

Y/N Table Edit

Default: Y

AUTHUSERHTTPINTRVLNumber(8,0)INTEGER NOT NULLHTTP Session Inactivity
VIEWFILETTLNumber(8,0)INTEGER NOT NULLView File Time to Live
STATUSBLOCKTIMEOUTNumber(8,0)INTEGER NOT NULLState Discard Interval
TRACEPPMAGENTCharacter(1)VARCHAR2(1) NOT NULLTrace PPM Agent

Y/N Table Edit

Default: N

CACHEMENUONWEBSRVRCharacter(1)VARCHAR2(1) NOT NULLCache Menu on Web Server

Y/N Table Edit

Default: N

PT_CACHE_SEARCHCharacter(1)VARCHAR2(1) NOT NULLEnable Caching

Y/N Table Edit

Default: Y

PT_CACHE_SEARCH_WSCharacter(1)VARCHAR2(1) NOT NULLEnable Caching on Web Server

Y/N Table Edit

Default: Y

LANGUAGESUPPORTLong CharacterCLOBLanguage Support
DISABLEFLUIDCharacter(1)VARCHAR2(1) NOT NULLDisable Fluid Mode

Y/N Table Edit

PTOVERIDEFLUIDFORDCharacter(1)VARCHAR2(1) NOT NULLDisable Fluid On Desktop

Y/N Table Edit

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