PSAESTMTDEFN

index back

AE Statement Defn


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_STMT_TYPECharacter(1)VARCHAR2(1) NOT NULLType
C=Comments
D=Do Select
H=Do When
N=Do Until
S=Select
U=Update/Insert/Delete
W=Do While
AE_REUSE_STMTCharacter(1)VARCHAR2(1) NOT NULLRe-Use Statement
N=Normal
S=Save Stmt
Y=Use Binds

Default: N

AE_DO_SELECT_TYPECharacter(1)VARCHAR2(1) NOT NULLType of Do Select
F=Select and Fetch
R=Re-Select
SQLIDCharacter(30)VARCHAR2(30) NOT NULLSQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
  • DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19