PSAESTEPDEFN

index back

AE Step Definition


PeopleSoft Field Name Field Type Column Type Description
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
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
AE_ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL Status
A=Active
I=Inactive

Default: A

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
AE_DO_APPL_ID Character(12) VARCHAR2(12) NOT NULL Do Application

Default: PSAEAPPLDEFN.AE_APPLID

Prompt Table: PSAEAPPLDEFN

AE_DYNAMIC_DO Character(1) VARCHAR2(1) NOT NULL Dynamic DO

Y/N Table Edit

Default: N

AE_PC_ON_FALSE Character(1) VARCHAR2(1) NOT NULL AE OnFalse PeopleCode action
AE_ON_NOROWS Character(1) VARCHAR2(1) NOT NULL App Engine no rows action
DESCR Character(30) VARCHAR2(30) NOT NULL Description
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
AE_MESSAGE_SET_FLD Character(18) VARCHAR2(18) NOT NULL Message set fieldname
AE_MESSAGE_NBR_FLD Character(18) VARCHAR2(18) NOT NULL Message set number fieldname
AE_COMMIT_FREQ Number(10,0) DECIMAL(10) NOT NULL Commit frequency (looping)
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19