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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19