PSAESTMTDEFN

index back

AE Statement Defn


PeopleSoft Field Name Field Type Column Type Description
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
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
EFFDT Date(10) DATE Effective Date
AE_STEP Character(8) VARCHAR2(8) NOT NULL Name
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
AE_REUSE_STMT Character(1) VARCHAR2(1) NOT NULL Re-Use Statement
N=Normal
S=Save Stmt
Y=Use Binds

Default: N

AE_DO_SELECT_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Do Select
F=Select and Fetch
R=Re-Select
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)
  • DESCR Character(30) VARCHAR2(30) NOT NULL Description
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19