AE_TEMPUSE_VW - Temporary Table implementation

AE_TEMPUSE_VW	index back
Temporary Table implementation

Tracks all Temporay Table names and how many instances have been requested and by how many programs.

SELECT A.RECNAME , COUNT(*) , SUM(B.TEMPTBLINSTANCES) FROM PSAEAPPLTEMPTBL A , PSAEAPPLDEFN B WHERE B.AE_APPLID = A.AE_APPLID GROUP BY A.RECNAME

PeopleSoft Field Name Field Type Column Type Description

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

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

TOTAL_COUNT Number(7,0) INTEGER NOT NULL Total Count

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
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
AE_APPL_CNT	Number(5,0)	INTEGER NOT NULL	Used to represent how many AE applications use a particular Temporary Table
TOTAL_COUNT	Number(7,0)	INTEGER NOT NULL	Total Count