Co-Operative PeopleTools Table Reference

PSAESTMTDEFN	Return to Index

This table contains one row per Application Engine statement, although the SQL statement itself is stored in PSSQLDEFN.

PeopleSoft Field Name Description
AE_APPLID Program Name
AE_SECTION Section
MARKET Market translate values
DBTYPE Database Type
0=SQLBase (inactive)
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase (inactive)
6=Sybase
7=Microsoft
8=DB2/400 (inactive)
EFFDT Effective Date
AE_STEP Name
AE_STMT_TYPE Type
C=Comments
D=Do Select
H=Do When
N=Do Until
S=Select
U=Update/Insert/Delete
W=Do While
AE_REUSE_STMT Re-Use Statement
N=Normal (default)
S=Save Stmt
Y=Use Binds
AE_DO_SELECT_TYPE Type of Do Select
F=Select and Fetch
R=Re-Select
SQLID SQL Object Identifier
DESCR Description
DESCRLONG Long Description
Author: PeopleTools
Return to Index © Go-Faster Consultancy Ltd. Last updated 24 July 2010

PeopleSoft Field Name	Description
AE_APPLID	Program Name
AE_SECTION	Section
MARKET	Market translate values
DBTYPE	Database Type 0=SQLBase (inactive) 1=DB2 2=Oracle 3=Informix 4=DB2/UNIX 5=AllBase (inactive) 6=Sybase 7=Microsoft 8=DB2/400 (inactive)
EFFDT	Effective Date
AE_STEP	Name
AE_STMT_TYPE	Type C=Comments D=Do Select H=Do When N=Do Until S=Select U=Update/Insert/Delete W=Do While
AE_REUSE_STMT	Re-Use Statement N=Normal (default) S=Save Stmt Y=Use Binds
AE_DO_SELECT_TYPE	Type of Do Select F=Select and Fetch R=Re-Select
SQLID	SQL Object Identifier
DESCR	Description
DESCRLONG	Long Description

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd. Last updated 24 July 2010

PSAESTMTDEFN