PSTEMPTBLCNTVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 TEMPTBLINSTANCES Number(4,0) SMALLINT NOT NULL Temp Table Instances (Total)