AEONLINEINST (SQL Table)	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

AEONLINEINST

(SQL Table)

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 PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

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

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

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