AE_STEP_TBL

index back

Section Steps


PeopleSoft Field NameField TypeColumn TypeDescription
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
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
DB_PLATFORMCharacter(1)VARCHAR2(1) NOT NULLDatabase 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
EFFDTDate(10)DATEEffective Date
AE_STEPCharacter(8)VARCHAR2(8) NOT NULLName
AE_SEQ_NUMNumber(3,0)SMALLINT NOT NULLSequence
EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive

Default: A

AE_STEP_TYPECharacter(1)VARCHAR2(1) NOT NULLStep Type
C=COBOL Program
D=Do Section
M=Mass Change
P=Peoplecode
S=SQL Statement

Default: S

PROGRAM_NAMECharacter(8)VARCHAR2(8) NOT NULLProgram Name
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

Prompt Table: AE_SECTION_VW

AE_SQL_UPDATECharacter(1)VARCHAR2(1) NOT NULLEdit SQL

Y/N Table Edit

Default: N

AE_SQL_SELECTCharacter(1)VARCHAR2(1) NOT NULLSELECT Present

Y/N Table Edit

Default: N

AE_DO_WHENCharacter(1)VARCHAR2(1) NOT NULLWhen

Y/N Table Edit

Default: N

AE_DO_WHILECharacter(1)VARCHAR2(1) NOT NULLWhile

Y/N Table Edit

Default: N

AE_DO_UNTILCharacter(1)VARCHAR2(1) NOT NULLUntil

Y/N Table Edit

Default: N

AE_DO_SELECTCharacter(1)VARCHAR2(1) NOT NULLSelect

Y/N Table Edit

Default: N

AE_SELECT_END_DOCharacter(1)VARCHAR2(1) NOT NULLSelect ends the Do

Y/N Table Edit

Default: N

AE_DO_SELECT_TYPECharacter(1)VARCHAR2(1) NOT NULLType of Do Select
F=Select and Fetch
R=Re-Select

Default: F

MC_DEFN_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Definition

Prompt Table: MC_DEFN

AE_DO_PRODUCTCharacter(2)VARCHAR2(2) NOT NULLDo Product

Prompt Table: AE_DO_PROD_VW

AE_DO_APPLIDCharacter(8)VARCHAR2(8) NOT NULLDo Application

Prompt Table: AE_DO_APPL_VW

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