AE_STMT_TBL_TMP(SQL Table) |
Index Back |
---|---|
AE Statement Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
2 | AE_APPL_ID | Character(8) | VARCHAR2(8) NOT NULL | Application |
3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
4 | 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 |
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 Default Value: U |