AE_TEMPUSE2_VW

index back

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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
AE_APPL_CNTNumber(5,0)INTEGER NOT NULLUsed to represent how many AE applications use a particular Temporary Table
TEMPTBLINSTANCESNumber(4,0)SMALLINT NOT NULLTemp Table Instances (Total)
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19