AE_REQUEST

index back

AE Request


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

Prompt Table: PSOPRDEFN

RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
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

GOTO_PROCESS_STAT Character(1) VARCHAR2(1) NOT NULL Go To Process Status
LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On
AE_PRODUCT Character(2) VARCHAR2(2) NOT NULL Product
AE=PS/AE
AM=PS/AM
AP=PS/AP
AR=PS/AR
BI=PS/BI
EO=PS/EO
EX=PS/EX
FS=PS/FS
GL=PS/GL
HR=PS/HR
IN=PS/IN
OM=PS/OM
PC=PS/PC
PO=PS/PO
TR=PS/TR
AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application

Prompt Table: AE_APPL_TBL

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20