PSTEMPTBLCNTVW - Application Engine Build cntl

PSTEMPTBLCNTVW	index back
Application Engine Build cntl

This record(view) is used by the build process to determine how many instances of a particular temp table are needed.

SELECT A.RECNAME , SUM(B.TEMPTBLINSTANCES) FROM PSAEAPPLTEMPTBL A , PSAEAPPLDEFN B WHERE A.AE_APPLID = B.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).

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

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).
TEMPTBLINSTANCES	Number(4,0)	SMALLINT NOT NULL	Temp Table Instances (Total)