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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19