MACHINENAMEPROCESSIDSTFLSRVREGDTTMY/N Table Edit
Y/N Table Edit
A=Available
I=Idle
K=Marked for Restart
L=Loading
R=Registered
X=Executing
Default: 0
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |