AE_TOOLS_CHK_VW

index back

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 NameField TypeColumn TypeDescription
AE_PRODUCTCharacter(2)VARCHAR2(2) NOT NULLProduct
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
AE_APPL_IDCharacter(8)VARCHAR2(8) NOT NULLApplication
AE_SECTIONCharacter(8)VARCHAR2(8) NOT NULLSection
DB_PLATFORMCharacter(1)VARCHAR2(1) NOT NULLDatabase 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
EFFDTDate(10)DATEEffective Date
AE_STEPCharacter(8)VARCHAR2(8) NOT NULLName
AE_STMT_TYPECharacter(1)VARCHAR2(1) NOT NULLType
C=Comments
D=Do Select
H=Do When
N=Do Until
S=Select
U=Update/Insert/Delete
W=Do While

Default: U

AE_REUSE_STMTCharacter(1)VARCHAR2(1) NOT NULLRe-Use Statement
N=Normal
S=Save Stmt
Y=Use Binds

Y/N Table Edit

Default: N

AE_USE_CURSORNumber(1,0)SMALLINT NOT NULLUse Cursor
AE_ADJUST_STATUSCharacter(1)VARCHAR2(1) NOT NULLAdjust Status
A=Accept Suggested Adjustments
D=&Discard Adjustment
M=Accept Manual Adjustments
X=Exclude from Adjust function
AE_STMTLong Character(8192)CLOB NOT NULLStatement
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19