AE_TOOLS_SAV_VW (SQL View)	Index Back
AE Statement Table

AE_TOOLS_SAV_VW

(SQL View)

AE Statement Table

SELECT AE_PRODUCT, AE_APPL_ID, AE_SECTION, DB_PLATFORM, EFFDT, AE_STEP, AE_STMT_TYPE, AE_REUSE_STMT, AE_USE_CURSOR, AE_ADJUST_STATUS, AE_STMT FROM PS_AE_STMT_TBL

# 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

#	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