EO_AE_SECTN_VW

(SQL View)
Index Back

EO AE $ Section View


SELECT AE_PRODUCT , AE_APPL_ID , AE_SECTION , DB_PLATFORM , EFFDT , EFF_STATUS , DESCR , AE_STMT_CHUNK_SIZE , AE_AUTO_COMMIT , AE_SECTION_TYPE FROM PS_AE_SECTION_TBL WHERE AE_PRODUCT = 'EO' AND AE_APPL_ID = 'CURRENCY' and AE_SECTION IN ('$ALLKEYS', '$AUDIT' ,'$CNVFROM' ,'$CNVSL0' ,'$CNVSL1' ,'$CNVSL2' ,'$CNVSL3' ,'$CNVSL4' ,'$CNVSL5' ,'$CNVSL6' ,'$CNVSL7' ,'$CNVSL8' ,'$CNVSL9' ,'$CNVSL10' ,'$CNVSL11' ,'$CNVSL12' ,'$CNVSL13' ,'$CNVSL14' ,'$CNVSL15' ,'$CNVWHRE' ,'$CNVWH0' ,'$CNVWH1' ,'$CNVWH2' ,'$CNVWH3' ,'$CNVWH4' ,'$CNVWH5' ,'$CNVWH6' ,'$CNVWH7' ,'$CNVWH8' ,'$CNVWH9' ,'$CNVWH10' ,'$CNVWH11' ,'$CNVWH12' ,'$CNVWH13' ,'$CNVWH14' ,'$CNVWH15' ,'$COMP10A' ,'$COMP2A' ,'$COMP3A' ,'$COMP4A' ,'$COMP5A' ,'$COMP6A' ,'$COMP7A' ,'$COMP8A' ,'$COMP9A' ,'$EFFDTS1' ,'$EFFDTS2' ,'$EFFDTW1' ,'$EFFDTW2' ,'$EFFDTWO' ,'$FROM' ,'$GROUPBY' ,'$RCNFROM' ,'$RCNSLCT' ,'$RCNWHR' ,'$RECORD' ,'$SELECT1' ,'$WHERE1') AND DB_PLATFORM = ' ' AND EFFDT = %DATEIN('1900-01-01')

# 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 AE_ASOF_EFFDT Date(10) DATE Effdt Override
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