AETEMPTBLMGR

(SQL Table)
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 PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 CURTEMPINSTANCE Number(4,0) SMALLINT NOT NULL Temp Table Instance
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
7 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time
8 AE_DISABLE_RESTART Character(1) VARCHAR2(1) NOT NULL Disable Restart
9 AE_DEDICATED Number(1,0) SMALLINT NOT NULL Dedicated Temp Table Instance
10 AE_TRUNCATED Number(1,0) SMALLINT NOT NULL Truncated?