PSAESTEPDEFN

index back

AE Step Definition


PeopleSoft Field NameField TypeColumn TypeDescription
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
DBTYPECharacter(1)VARCHAR2(1) NOT NULLDatabase Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
EFFDTDate(10)DATEEffective Date
AE_STEPCharacter(8)VARCHAR2(8) NOT NULLName
AE_SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
AE_ACTIVE_STATUSCharacter(1)VARCHAR2(1) NOT NULLStatus
A=Active
I=Inactive

Default: A

AE_ABEND_ACTIONCharacter(1)VARCHAR2(1) NOT NULLOn False Return
A=Abort Application
B=Break
I=Ignore Error
S=Suppress Error

Default: A

AE_COMMIT_AFTERCharacter(1)VARCHAR2(1) NOT NULLCommit After
D=Default Action
N=Later
Y=After this Step

Default: D

AE_DO_SECTIONCharacter(8)VARCHAR2(8) NOT NULLDo Section
AE_DO_APPL_IDCharacter(12)VARCHAR2(12) NOT NULLDo Application

Default: PSAEAPPLDEFN.AE_APPLID

Prompt Table: PSAEAPPLDEFN

AE_DYNAMIC_DOCharacter(1)VARCHAR2(1) NOT NULLDynamic DO

Y/N Table Edit

Default: N

AE_PC_ON_FALSECharacter(1)VARCHAR2(1) NOT NULLAE OnFalse PeopleCode action
AE_ON_NOROWSCharacter(1)VARCHAR2(1) NOT NULLApp Engine no rows action
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
AE_MESSAGE_SET_FLDCharacter(18)VARCHAR2(18) NOT NULLMessage set fieldname
AE_MESSAGE_NBR_FLDCharacter(18)VARCHAR2(18) NOT NULLMessage set number fieldname
AE_COMMIT_FREQNumber(10,0)DECIMAL(10) NOT NULLCommit frequency (looping)
DESCRLONGLong CharacterCLOBLong Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19