| # |
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 NOT NULL |
Effective Date
Default Value: %date
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 7 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 8 |
AE_STMT_CHUNK_SIZE |
Number(3,0) |
SMALLINT NOT NULL |
Statement Chunk Size
Default Value: 200
|
| 9 |
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 Value: N
|
| 10 |
AE_SECTION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Section Type
C=Critical Database Updates
P=Preparation Only
Default Value: P
|