AE_STMT_TBL_TMP

(SQL Table)
Index Back

AE Statement Table

# 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