PSSTATEFULSRV

index back

PeopleSoft Field Name Field Type Column Type Description
MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier
STFLSRVREGDTTM DateTime(26) TIMESTAMP NOT NULL Registration Date and Time
PROBINSTHOSTTYPE Character(16) VARCHAR2(16) NOT NULL Analytic Engine Type
STFLSRVRMTACCESS Character(1) VARCHAR2(1) NOT NULL Remote Access Allowed

Y/N Table Edit

STFLSRVACCEPTING Character(1) VARCHAR2(1) NOT NULL Accepting Requests

Y/N Table Edit

STFLSRVSTATE Character(1) VARCHAR2(1) NOT NULL Server state
A=Available
I=Idle
K=Marked for Restart
L=Loading
R=Registered
X=Executing
PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
STFLSRVOPENUID Character(30) VARCHAR2(30) NOT NULL Opened User ID
STFLSRVOPENDTTM DateTime(26) TIMESTAMP Time Opened
STFLSRVCURRENTOP Character(20) VARCHAR2(20) NOT NULL Current Operation
STFLSRVLASTOPUID Character(30) VARCHAR2(30) NOT NULL Last operation User ID
STFLSRVLASTOPDTTM DateTime(26) TIMESTAMP Stateful server last operation
DOMAIN Character(50) VARCHAR2(50) NOT NULL Domain
PORT_NUM Number(5,0) INTEGER NOT NULL Port Number
STFLSRVID Number(4,0) SMALLINT NOT NULL Analytic server ID
STFLSRVTIMEOUT Number(6,0) INTEGER NOT NULL Timeout

Default: 0

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