AE_APPLIDAE_SECTIONAE_SEQ_NUM0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
TL_WORK_REF_VW(SQL View) |
Index Back |
|---|---|
Work Table reference view...View against AE definition tables to aid in listing references to a given record or show the steps and SQL statements referencing a given work table. |
| SELECT S.AE_APPLID , S.AE_SECTION , S.AE_SEQ_NUM , S.AE_STEP , S.DBTYPE , SQ.SQLTEXT FROM PSAESTEPDEFN S , PSAESTMTDEFN ST , PSSQLTEXTDEFN SQ WHERE S.AE_APPLID = ST.AE_APPLID AND S.AE_SECTION = ST.AE_SECTION AND S.AE_STEP = ST.AE_STEP AND S.DBTYPE = ST.DBTYPE AND SQ.SQLID = ST.SQLID |
| # | 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 | AE_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | AE_STEP | Character(8) | VARCHAR2(8) NOT NULL | Name |
| 5 | 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 |
| 6 | SQLTEXT | Long Character(14000) | CLOB | SQL Statement Text |