AEREQUESTTBL

index back

AE Request Table


PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRDEFN_TLS_VW

RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

Prompt Table: PSAEAPPLDEFN

CURTEMPINSTANCE Number(4,0) SMALLINT NOT NULL Temp Table Instance
PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default: O

AE_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now

Default: N

PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

Default: N

LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
ASOF_DT Date(10) DATE As of Date
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19