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 NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
CURTEMPINSTANCENumber(4,0)SMALLINT NOT NULLTemp Table Instance
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
RUN_DTTMDateTime(26)TIMESTAMPRun Date and Time
AE_DISABLE_RESTARTCharacter(1)VARCHAR2(1) NOT NULLDisable Restart
AE_DEDICATEDNumber(1,0)SMALLINT NOT NULLDedicated Temp Table Instance
AE_TRUNCATEDNumber(1,0)SMALLINT NOT NULLTruncated?
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19