AE_STMT_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AE_PRODUCT	Character(2)	VARCHAR2(2) NOT NULL	Product 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
2	AE_APPL_ID	Character(8)	VARCHAR2(8) NOT NULL	Application
3	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
4	DB_PLATFORM	Character(1)	VARCHAR2(1) NOT NULL	Database 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
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=Call Section D=Do Select H=Do When M=Log Message N=Do Until P=PeopleCode S=SQL U=Update/Insert/Delete W=Do While X=XSLT Default Value: U
8	AE_REUSE_STMT	Character(1)	VARCHAR2(1) NOT NULL	Re-Use Statement N=Normal S=Save Stmt Y=Use Binds Y/N Table Edit Default Value: N
9	AE_USE_CURSOR	Number(1,0)	SMALLINT NOT NULL	Use Cursor
10	AE_ADJUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Adjust Status A=Accept Suggested Adjustments D=&Discard Adjustment M=Accept Manual Adjustments X=Exclude from Adjust function
11	AE_STMT	Long Character(8192)	CLOB NOT NULL	Statement