AE_STMT_B_TMP |
index back |
|---|---|
AE Statement Chunk Temp Table |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 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 |
| AE_APPL_ID |
Character(8) | VARCHAR2(8) NOT NULL | Application |
| AE_SECTION |
Character(8) | VARCHAR2(8) NOT NULL | Section |
| 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 |
| EFFDT |
Date(10) | DATE NOT NULL | 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_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| AE_STMT_SEG | Character(254) | VARCHAR2(254) NOT NULL | AE Statement Segment |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |