AETEMPTBLMGR

index back

Application Engine Temptbl use

This record is process related. As each process is initiated a record is placed in this table to prevent overlapping processing

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
CURTEMPINSTANCE Number(4,0) SMALLINT NOT NULL Temp Table Instance
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time
AE_DISABLE_RESTART Character(1) VARCHAR2(1) NOT NULL Disable Restart
AE_DEDICATED Number(1,0) SMALLINT NOT NULL Dedicated Temp Table Instance
AE_TRUNCATED Number(1,0) SMALLINT NOT NULL Truncated?
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19