| 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
Default: %date
|
| EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default: A
|
| DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| AE_STMT_CHUNK_SIZE |
Number(3,0) |
SMALLINT NOT NULL |
Statement Chunk Size
Default: 250
|
| AE_AUTO_COMMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Commit after each step
M=Auto Commit Conditionally
N=No Auto commit
Y=Commit after each STEP
Y/N Table Edit
Default: N
|
| AE_SECTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Section Type
C=Critical Database Updates
P=Preparation Only
Default: P
|