AE_TEMPLOCK2_VW

index back

Tebl Tbl Locks by Pgm & Tbl

Tracks how many Temporary Table instances are locked by AE_APPLID and table name
SELECT RECNAME , AE_APPLID , COUNT(*) FROM PS_AETEMPTBLMGR WHERE CURTEMPINSTANCE > 0 GROUP BY RECNAME , 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).
TEMPTBLINSTLOCKSNumber(4,0)SMALLINT NOT NULLUsed to track how many instances of a particular temporary table are locked/in use at the moment.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19