AE_TEMPUSE2_VW (SQL View)	Index Back
Temporary Table implementation Tracks all Temporay Table names and how many instances have been requested for a particular AE programs.

AE_TEMPUSE2_VW

(SQL View)

Temporary Table implementation

Tracks all Temporay Table names and how many instances have been requested for a particular AE programs.

SELECT A.RECNAME , B.AE_APPLID , 1 , B.TEMPTBLINSTANCES FROM PSAEAPPLTEMPTBL A , PSAEAPPLDEFN B WHERE B.AE_APPLID = A.AE_APPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

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

3 AE_APPL_CNT Number(5,0) INTEGER NOT NULL Used to represent how many AE applications use a particular Temporary Table

4 TEMPTBLINSTANCES Number(4,0) SMALLINT NOT NULL Temp Table Instances (Total)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
3	AE_APPL_CNT	Number(5,0)	INTEGER NOT NULL	Used to represent how many AE applications use a particular Temporary Table
4	TEMPTBLINSTANCES	Number(4,0)	SMALLINT NOT NULL	Temp Table Instances (Total)