AEONLINEINST - Application Engine Online Inst

AEONLINEINST	index back
Application Engine Online Inst

This record is used to track the temp table instance numbers utilized by the online environment and to ensure there is no dual usages

PeopleSoft Field Name Field Type Column Type Description

CURTEMPINSTANCE Number(4,0) SMALLINT NOT NULL Temp Table Instance

AE_LOCK_CNT Number(15,0) DECIMAL(15) NOT NULL Number of Locks Issued
Default: 0

PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

PT_AE_SHARED Character(1) VARCHAR2(1) NOT NULL Temp Table Shared
Default: E

PT_AE_DUMMY1 Character(30) VARCHAR2(30) NOT NULL AE Dummy Field1

PT_AE_DUMMY2 Character(30) VARCHAR2(30) NOT NULL AE Dummy Field2

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20

PeopleSoft Field Name	Field Type	Column Type	Description
CURTEMPINSTANCE	Number(4,0)	SMALLINT NOT NULL	Temp Table Instance
AE_LOCK_CNT	Number(15,0)	DECIMAL(15) NOT NULL	Number of Locks Issued Default: 0
PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
PT_AE_SHARED	Character(1)	VARCHAR2(1) NOT NULL	Temp Table Shared Default: E
PT_AE_DUMMY1	Character(30)	VARCHAR2(30) NOT NULL	AE Dummy Field1
PT_AE_DUMMY2	Character(30)	VARCHAR2(30) NOT NULL	AE Dummy Field2