AE_SECTION_TBL(SQL Table) |
Index Back |
---|---|
Application Sections |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 | Character(8) | VARCHAR2(8) NOT NULL | Application | |
3 | Character(8) | VARCHAR2(8) NOT NULL | Section | |
4 | 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 | 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: 250 |
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 |