PSANALYTICREG

(SQL Table)
Index Back

Analytic Tools Engine Registry

# 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 PTATREGDTTM DateTime(26) TIMESTAMP NOT NULL Registration Date and Time
4 PTATENGINETYPE Character(16) VARCHAR2(16) NOT NULL Analytic Engine Type
5 PTATRMTACCESS Character(1) VARCHAR2(1) NOT NULL Remote Access Allowed

Y/N Table Edit

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

Y/N Table Edit

7 PTATSTATE Character(1) VARCHAR2(1) NOT NULL State
A=Available
I=Idle
L=Loading
R=Registered
T=Terminating
X=Executing
8 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
9 PTATLOADEDBY Character(30) VARCHAR2(30) NOT NULL Loaded by User ID
10 PTATLOADEDDTTM DateTime(26) TIMESTAMP Time Loaded
11 PTATLASTOP Character(20) VARCHAR2(20) NOT NULL Latest Operation
12 PTATLASTOPBY Character(30) VARCHAR2(30) NOT NULL Latest Operation by User ID
13 PTATLASTOPSTART DateTime(26) TIMESTAMP Latest Operation Start Time
14 PTATLASTOPEND DateTime(26) TIMESTAMP Latest Operation End Time
15 DOMAIN Character(50) VARCHAR2(50) NOT NULL Domain
16 PORT_NUM Number(5,0) INTEGER NOT NULL Port Number
17 PTATTUXSRVID Number(4,0) SMALLINT NOT NULL Tuxedo Server ID
18 PTATTIMEOUT Number(6,0) INTEGER NOT NULL Timeout

Default Value: 0

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