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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
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