AEREQUESTTBL

index back

AE Request Table


PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

Prompt Table: OPRDEFN_TLS_VW

RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).

Prompt Table: PSAEAPPLDEFN

CURTEMPINSTANCENumber(4,0)SMALLINT NOT NULLTemp Table Instance
PROCESS_FREQUENCYCharacter(1)VARCHAR2(1) NOT NULLProcess Frequency
A=Always Process
N=Don't Run
O=Process Once

Default: O

AE_PROCESS_STATUSCharacter(1)VARCHAR2(1) NOT NULLProcess Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now

Default: N

PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
PROCESS_ORIGCharacter(1)VARCHAR2(1) NOT NULLProcess Origin
N=Other Source
P=Process Scheduler

Default: N

LAST_RUN_DTMDateTime(26)TIMESTAMPLast Run On
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
ASOF_DTDate(10)DATEAs of Date
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19