MACHINENAMEPROCESSIDPTATREGDTTMY/N Table Edit
Y/N Table Edit
A=Available
I=Idle
L=Loading
R=Registered
T=Terminating
X=Executing
Default: 0
PSANALYTICREG |
index back |
|---|---|
Analytic Tools Engine Registry |
| 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 |
| PTATREGDTTM |
DateTime(26) | TIMESTAMP NOT NULL | Registration Date and Time |
| PTATENGINETYPE | Character(16) | VARCHAR2(16) NOT NULL | Analytic Engine Type |
| PTATRMTACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Remote Access Allowed
Y/N Table Edit |
| PTATACCEPTING | Character(1) | VARCHAR2(1) NOT NULL |
Accepting Requests
Y/N Table Edit |
| PTATSTATE | Character(1) | VARCHAR2(1) NOT NULL |
State
A=Available I=Idle L=Loading R=Registered T=Terminating X=Executing |
| PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| PTATLOADEDBY | Character(30) | VARCHAR2(30) NOT NULL | Loaded by User ID |
| PTATLOADEDDTTM | DateTime(26) | TIMESTAMP | Time Loaded |
| PTATLASTOP | Character(20) | VARCHAR2(20) NOT NULL | Latest Operation |
| PTATLASTOPBY | Character(30) | VARCHAR2(30) NOT NULL | Latest Operation by User ID |
| PTATLASTOPSTART | DateTime(26) | TIMESTAMP | Latest Operation Start Time |
| PTATLASTOPEND | DateTime(26) | TIMESTAMP | Latest Operation End Time |
| DOMAIN | Character(50) | VARCHAR2(50) NOT NULL | Domain |
| PORT_NUM | Number(5,0) | INTEGER NOT NULL | Port Number |
| PTATTUXSRVID | Number(4,0) | SMALLINT NOT NULL | Tuxedo Server ID |
| PTATTIMEOUT | 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 |