PSSTATEFULSRV

(SQL Table)
 Index Back

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

Y/N Table Edit

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

Y/N Table Edit

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

Default Value: 0

18 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).