AE_REQUEST

index back

AE Request


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

Prompt Table: PSOPRDEFN

RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
REQUEST_NBRNumber(4,0)SMALLINT NOT NULLRequest Number
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

GOTO_PROCESS_STATCharacter(1)VARCHAR2(1) NOT NULLGo To Process Status
LAST_RUN_DTMDateTime(26)TIMESTAMPLast Run On
AE_PRODUCTCharacter(2)VARCHAR2(2) NOT NULLProduct
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_IDCharacter(8)VARCHAR2(8) NOT NULLApplication

Prompt Table: AE_APPL_TBL

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19