PSSTATEFULSRV

index back

PeopleSoft Field NameField TypeColumn TypeDescription
MACHINENAMECharacter(30)VARCHAR2(30) NOT NULLMachine Name
PROCESSIDSigned Number(11,0)DECIMAL(10) NOT NULLProcess Identifier
STFLSRVREGDTTMDateTime(26)TIMESTAMP NOT NULLRegistration Date and Time
PROBINSTHOSTTYPECharacter(16)VARCHAR2(16) NOT NULLAnalytic Engine Type
STFLSRVRMTACCESSCharacter(1)VARCHAR2(1) NOT NULLRemote Access Allowed

Y/N Table Edit

STFLSRVACCEPTINGCharacter(1)VARCHAR2(1) NOT NULLAccepting Requests

Y/N Table Edit

STFLSRVSTATECharacter(1)VARCHAR2(1) NOT NULLServer state
A=Available
I=Idle
K=Marked for Restart
L=Loading
R=Registered
X=Executing
PROBINSTCharacter(20)VARCHAR2(20) NOT NULLOptimization Problem Instance
STFLSRVOPENUIDCharacter(30)VARCHAR2(30) NOT NULLOpened User ID
STFLSRVOPENDTTMDateTime(26)TIMESTAMPTime Opened
STFLSRVCURRENTOPCharacter(20)VARCHAR2(20) NOT NULLCurrent Operation
STFLSRVLASTOPUIDCharacter(30)VARCHAR2(30) NOT NULLLast operation User ID
STFLSRVLASTOPDTTMDateTime(26)TIMESTAMPStateful server last operation
DOMAINCharacter(50)VARCHAR2(50) NOT NULLDomain
PORT_NUMNumber(5,0)INTEGER NOT NULLPort Number
STFLSRVIDNumber(4,0)SMALLINT NOT NULLAnalytic server ID
STFLSRVTIMEOUTNumber(6,0)INTEGER NOT NULLTimeout

Default: 0

MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19