AE_SECTION_TBL

index back

Application Sections


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

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19