AE_STEP_TBL

index back

Section Steps


PeopleSoft Field Name Field Type Column Type Description
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
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
DB_PLATFORM Character(1) VARCHAR2(1) NOT NULL Database Platform
0=DB2/MVS
1=SQLBase
2=Oracle
3=SQL Server
4=DB2/UNIX
5=Rdb
6=Informix
7=DB2/400
8=Sybase SQLServer
9=Microsoft SQLServer
EFFDT Date(10) DATE Effective Date
AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
AE_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default: A

AE_STEP_TYPE Character(1) VARCHAR2(1) NOT NULL Step Type
C=COBOL Program
D=Do Section
M=Mass Change
P=Peoplecode
S=SQL Statement

Default: S

PROGRAM_NAME Character(8) VARCHAR2(8) NOT NULL Program Name
AE_ABEND_ACTION Character(1) VARCHAR2(1) NOT NULL On False Return
A=Abort Application
B=Break
I=Ignore Error
S=Suppress Error

Default: A

AE_COMMIT_AFTER Character(1) VARCHAR2(1) NOT NULL Commit After
D=Default Action
N=Later
Y=After this Step

Default: D

AE_DO_SECTION Character(8) VARCHAR2(8) NOT NULL Do Section

Prompt Table: AE_SECTION_VW

AE_SQL_UPDATE Character(1) VARCHAR2(1) NOT NULL Edit SQL

Y/N Table Edit

Default: N

AE_SQL_SELECT Character(1) VARCHAR2(1) NOT NULL SELECT Present

Y/N Table Edit

Default: N

AE_DO_WHEN Character(1) VARCHAR2(1) NOT NULL When

Y/N Table Edit

Default: N

AE_DO_WHILE Character(1) VARCHAR2(1) NOT NULL While

Y/N Table Edit

Default: N

AE_DO_UNTIL Character(1) VARCHAR2(1) NOT NULL Until

Y/N Table Edit

Default: N

AE_DO_SELECT Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default: N

AE_SELECT_END_DO Character(1) VARCHAR2(1) NOT NULL Select ends the Do

Y/N Table Edit

Default: N

AE_DO_SELECT_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Do Select
F=Select and Fetch
R=Re-Select

Default: F

MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition

Prompt Table: MC_DEFN

AE_DO_PRODUCT Character(2) VARCHAR2(2) NOT NULL Do Product

Prompt Table: AE_DO_PROD_VW

AE_DO_APPLID Character(8) VARCHAR2(8) NOT NULL Do Application

Prompt Table: AE_DO_APPL_VW

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