AE_RUN_CONTROL

(SQL Table)
Index Back

AE Run Control

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AE_THREAD Number(3,0) SMALLINT NOT NULL Thread
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
6 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
7 AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application
8 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
9 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
10 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time
11 AE_RTNCD Number(5,0) INTEGER NOT NULL Return Code
12 AE_CRITICAL_PHASE Character(1) VARCHAR2(1) NOT NULL Critical

Y/N Table Edit

Default Value: N

13 AE_RUN_DATA_1 Character(250) VARCHAR2(250) NOT NULL Run Data 1
14 AE_RUN_DATA_2 Character(250) VARCHAR2(250) NOT NULL Run Data 2
15 AE_RUN_DATA_3 Character(250) VARCHAR2(250) NOT NULL Run Data 3