PSAESTMTDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
2	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
3	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
4	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
5	EFFDT	Date(10)	DATE	Effective Date
6	AE_STEP	Character(8)	VARCHAR2(8) NOT NULL	Name
7	AE_STMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type C=Comments D=Do Select H=Do When N=Do Until S=Select U=Update/Insert/Delete W=Do While
8	AE_REUSE_STMT	Character(1)	VARCHAR2(1) NOT NULL	Re-Use Statement N=Normal S=Save Stmt Y=Use Binds Default Value: N
9	AE_DO_SELECT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Do Select F=Select and Fetch R=Re-Select
10	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL 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)
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	DESCRLONG	Long Character	CLOB	Long Description