GP_AESQL_VW (SQL View)	Index Back
AE SQL Statements View combining PSAESTMTDEFN and PSSQLTEXTDEFN

GP_AESQL_VW

(SQL View)

AE SQL Statements

View combining PSAESTMTDEFN and PSSQLTEXTDEFN

SELECT AE_APPLID ,AE.AE_SECTION ,AE.MARKET ,AE.DBTYPE ,AE.EFFDT ,AE_STEP ,AE_STMT_TYPE ,AE_REUSE_STMT ,AE_DO_SELECT_TYPE ,AE.SQLID ,AE.DESCR ,AE.DESCRLONG ,TD.SQLTYPE ,TD.SEQNUM ,TD.SQLTEXT FROM PSAESTMTDEFN AE , PSSQLTEXTDEFN TD WHERE AE.SQLID=TD.SQLID AND AE.MARKET=TD.MARKET AND AE.DBTYPE=TD.DBTYPE AND AE.EFFDT=TD.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

2 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

3 MARKET Character(3) VARCHAR2(3) NOT NULL Market

4 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

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

8 AE_REUSE_STMT Character(1) VARCHAR2(1) NOT NULL Re-Use Statement
N=Normal
S=Save Stmt
Y=Use Binds
Default Value: N

9 AE_DO_SELECT_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Do Select
F=Select and Fetch
R=Re-Select

10 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)

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

12 DESCRLONG Long Character CLOB Long Description

13 SQLTYPE Character(1) VARCHAR2(1) NOT NULL SQL Object type
0=SQL Object referenced from elsewhere
1=Application Engine Step
2=SQL View
5=Queries for DDDAUDIT and SYSAUDIT
6= Application Engine Step XSLT

14 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

15 SQLTEXT Long Character(14000) CLOB SQL Statement Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
2	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
3	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
4	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
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
8	AE_REUSE_STMT	Character(1)	VARCHAR2(1) NOT NULL	Re-Use Statement N=Normal S=Save Stmt Y=Use Binds Default Value: N
9	AE_DO_SELECT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Do Select F=Select and Fetch R=Re-Select
10	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)
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	DESCRLONG	Long Character	CLOB	Long Description
13	SQLTYPE	Character(1)	VARCHAR2(1) NOT NULL	SQL Object type 0=SQL Object referenced from elsewhere 1=Application Engine Step 2=SQL View 5=Queries for DDDAUDIT and SYSAUDIT 6= Application Engine Step XSLT
14	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
15	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text